Token-to-Token VWAP | Ethereum EVM Blockchain Data

Overview

Dataset ID: 0405
Table: blockdb_evm.b0405_token_to_token_vwap_v1
Description: Volume-weighted average price (1m..1d) per pool and token pair direction, anchored to first/last on-chain events in the bucket.
Primary key: (pool_uid, token_in, token_out, bucket_start, bucket_seconds)
API: POST /evm/prices/spot/crypto/vwap

Column	Type	Description
`chain_id`	`BIGINT`	EVM chain identifier; see Chain.
`pool_uid`	`BYTEA`	Pool identifier; FK → `b0211_liquidity_pools_v1.pool_uid`.
`exchange_id`	`INTEGER`	Exchange identifier.
`type_id`	`INTEGER`	Pool type identifier.
`first_block_number`	`BIGINT`	First contributing event block.
`first_block_time`	`TIMESTAMPTZ`	First contributing event time.
`first_tx_index`	`INTEGER`	First contributing `tx_index`.
`first_log_index`	`INTEGER`	First contributing `log_index`.
`last_block_number`	`BIGINT`	Last contributing event block.
`last_block_time`	`TIMESTAMPTZ`	Last contributing event time.
`last_tx_index`	`INTEGER`	Last contributing `tx_index`.
`last_log_index`	`INTEGER`	Last contributing `log_index`.
`bucket_start`	`TIMESTAMPTZ`	Inclusive UTC bucket start.
`bucket_seconds`	`INTEGER`	Bucket size: `60`, `300`, `900`, `1800`, `3600`, `14400`, or `86400`.
`token_in`	`BYTEA`	Input token (20B).
`token_out`	`BYTEA`	Output token (20B).
`price_vwap`	`NUMERIC(78,18)`	VWAP: token_out per 1 token_in, decimals-adjusted.
`total_volume_in`	`NUMERIC(78,18)`	Total traded token_in in bucket.
`total_volume_out`	`NUMERIC(78,18)`	Total received token_out in bucket.
`trade_count`	`BIGINT`	Number of swaps in the bucket.
`_tracing_id`	`BYTEA`	Unique BlockDB tracing id for the row (`uq_b0405_token_to_token_vwap_v1_tracing_id`).
`_created_at`	`TIMESTAMPTZ`	Record creation time.
`_updated_at`	`TIMESTAMPTZ`	Record last update time.

OHLC bars for the same directional pairs.

USD VWAP derived from token-to-token VWAP via stablecoin anchoring.