Token Prices OHLC 1 min-1 day | EVM Blockchain Data

Overview

Dataset ID: 0404
Table: blockdb_evm.b0404_token_to_token_prices_ohlc_v1
Description: Time-bucketed OHLC bars (1m..1d) per pool and token pair direction.
Primary key: (bucket_start, bucket_seconds, pool_uid, token_in, token_out)
API: POST /evm/prices/spot/crypto/ohlc
CSV Sample: Download
JSON Sample: Download

Column	Type	Description
`pool_uid`	`BYTEA`	Pool identifier; FK → `b0211_liquidity_pools_v1.pool_uid`.
`exchange_id`	`INTEGER`	Exchange identifier.
`type_id`	`INTEGER`	Pool type identifier.
`bucket_start`	`TIMESTAMPTZ`	Inclusive UTC bucket start.
`bucket_end`	`TIMESTAMPTZ`	Exclusive UTC bucket end; equals `bucket_start + bucket_seconds`.
`bucket_seconds`	`INTEGER`	`60`, `300`, `900`, `1800`, `3600`, `14400`, or `86400`.
`token_in`	`BYTEA`	Input token (20B); FK → `b0201_erc20_tokens_v1`.
`token_out`	`BYTEA`	Output token (20B); FK → `b0201_erc20_tokens_v1`.
`open`	`NUMERIC(78,18)`	Opening price (token_out per 1 token_in, decimals-adjusted).
`high`	`NUMERIC(78,18)`	High price in bucket.
`low`	`NUMERIC(78,18)`	Low price in bucket.
`close`	`NUMERIC(78,18)`	Closing price in bucket.
`volume_in_raw`	`NUMERIC(78,0)`	Sum of raw UInt256 `amountIn` values (`0` for carry-forward buckets).
`volume_in`	`NUMERIC(78,18)`	Decimal-adjusted `token_in` volume; `NULL` if decimals unknown.
`volume_out_raw`	`NUMERIC(78,0)`	Sum of raw UInt256 `amountOut` values (`0` for carry-forward buckets).
`volume_out`	`NUMERIC(78,18)`	Decimal-adjusted `token_out` volume; `NULL` if decimals unknown.
`trades_count`	`BIGINT`	Trade count in bucket.
`_tracing_id`	`BYTEA`	BlockDB tracing ID; unique.
`_parent_tracing_ids`	`BYTEA[]`	Tracing IDs of contributing swap prints; optional.
`_created_at`	`TIMESTAMPTZ`	Record creation time.
`_updated_at`	`TIMESTAMPTZ`	Record last update time.

Volume-weighted benchmarks at matching intervals.

Per-swap executions that aggregate into OHLC.