LogoLogo
  • Kaiko Knowledge Hub
  • GENERAL
    • 👋Introduction
  • Getting Started
    • BigQuery
    • Google Cloud
    • Azure Blob
    • AWS S3
  • Data Feeds
    • Level 1 Aggregations
      • Trade Count, OHLCV & VWAP
        • VWAP Only
        • OHLCV Only
    • Level 1 Tick-Level
      • All trades
      • Best bids and asks (top of book)
      • Borrows, repayments, liquidations, and withdrawals
    • Level 2 Aggregations
      • Raw order book snapshot
    • Level 2 Tick-Level
      • Bids and asks
      • Mints and burns
      • Interest rates, borrowed and deposited amounts
      • Tokens in a liquidity pool
        • Tokens in a liquidity pool (Uniswap v3)
  • Analytics Solutions
    • Derivatives Risk Indicators
      • Exchange-provided metrics
  • Monitoring Solutions
    • Blockchain Monitoring
      • Ethereum Wallets
      • Bitcoin Wallets
Powered by GitBook
On this page
  • What is this dataset?
  • Update frequencies
  • File structure details

Was this helpful?

Export as PDF
  1. Data Feeds
  2. Level 1 Aggregations

Trade Count, OHLCV & VWAP

What is this dataset?

This dataset offers the trade count, OHLCV and VWAP history for an instrument on an exchange.

Update frequencies

Channel
Update frequency

AWS

New CSV once a day

Azure

New CSV once a day

Google Cloud Platform

New CSV once a day

Snowflake

  • Data refreshes once a day

  • Also available in near real-time

BigQuery

  • Data refreshes once a day

  • Also available in near real-time

File structure details

  • The time granularity that we provide through CSV files is 1min, 5min, 10min, 15min and 30min for monthly grouped CSV files, while 1hour, 4hour and 1day for yearly grouped CSV files.

  • File Name: [kaiko_legacy_slug]_[data_feed_code]_cohlcvwap_[time_granularity]_[date].csv

    • Files are created on a daily basis, but complete as a month or year ends

    • example: bw_btcusdt_perp_cohlcvwap_5m_2023_02.csv, bw_atomusdt_perp_cohlcvwap_1h_2023.csv

  • Cut-off datetime:

    • Monthly grouped files: The mid-night of the last day of the month

    • Yearly grouped files: The mid-night of the last day of the year

  • Column Delimeter: , (comma)

  • Decimal Mark (in numbers): . (dot)

  • There are no column headers in the CSV files, so I will present the columns in order from left to right.

Column
Description
Example

timestamp

The starting timestamp of the time interval, expressed in Unix Timestamp (in milliseconds)

1672531200000

count

Then number of trades. 0 when no trades reported.

321

open

Opening price of interval. null when no trades reported.

0.4935

high

Highest price during interval. null when no trades reported.

0.4951

low

Lowest price during interval. null when no trades reported.

0.4911

close

Closing price of interval. null when no trades reported.

0.4939

volume

Volume traded in interval. 0 when no trades reported.

62.32

price

The volume weighted price during the time interval. null when no trades reported.

0.4945

exchange

BigQuery and Snowflake only

Exchange code.

cbse

instrument BigQBigQuery and Snowflake only

btc-usd

interval BigQuery and Snowflake only

The interval parameter is suffixed with s, m, h or d to specify seconds, minutes, hours or days, respectively.

1h

PreviousLevel 1 AggregationsNextVWAP Only

Last updated 2 months ago

Was this helpful?

See

Instrument code.

Exchange codes
Exchange trading pair codes (instruments)