kind: DatasetSnapshot
version: 1
content:
  name: ca.bankofcanada.exchange-rates.daily
  kind: Root
  metadata:
    - kind: SetPollingSource
      fetch:
        kind: Url
        url: https://www.bankofcanada.ca/valet/observations/group/FX_RATES_DAILY/csv?start_date=2017-01-03
      prepare:
        - kind: pipe
          command:
            - sed
            - -e
            - 1,/OBSERVATIONS/d
      read:
        kind: Csv
        header: true
        schema:
          - date TIMESTAMP
          - fxaudcad DECIMAL(18,10)
          - fxbrlcad DECIMAL(18,10)
          - fxcnycad DECIMAL(18,10)
          - fxeurcad DECIMAL(18,10)
          - fxhkdcad DECIMAL(18,10)
          - fxinrcad DECIMAL(18,10)
          - fxidrcad DECIMAL(18,10)
          - fxjpycad DECIMAL(18,10)
          - fxmyrcad DECIMAL(18,10)
          - fxmxncad DECIMAL(18,10)
          - fxnzdcad DECIMAL(18,10)
          - fxnokcad DECIMAL(18,10)
          - fxpencad DECIMAL(18,10)
          - fxrubcad DECIMAL(18,10)
          - fxsarcad DECIMAL(18,10)
          - fxsgdcad DECIMAL(18,10)
          - fxzarcad DECIMAL(18,10)
          - fxkrwcad DECIMAL(18,10)
          - fxsekcad DECIMAL(18,10)
          - fxchfcad DECIMAL(18,10)
          - fxtwdcad DECIMAL(18,10)
          - fxthbcad DECIMAL(18,10)
          - fxtrycad DECIMAL(18,10)
          - fxgbpcad DECIMAL(18,10)
          - fxusdcad DECIMAL(18,10)
          - fxvndcad DECIMAL(18,10)
      merge:
        kind: Ledger
        primaryKey:
          - date
    - kind: SetVocab
      eventTimeColumn: date