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.
- Primary key:
(bucket_start, bucket_seconds, pool_uid, token_in, token_out) - API: POST /evm/prices/spot/crypto/vwap
- CSV Sample: Download
- JSON Sample: Download
Sample Viewer
Columns
| 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. |
price_vwap | NUMERIC(78,18) | VWAP (token_out per 1 token_in, decimals-adjusted); NULL if undefined. |
total_volume_in_raw | NUMERIC(78,0) | Sum of raw UInt256 amountIn values. |
total_volume_in | NUMERIC(78,18) | Decimal-adjusted token_in volume; NULL if decimals unknown. |
total_volume_out_raw | NUMERIC(78,0) | Sum of raw UInt256 amountOut values. |
total_volume_out | NUMERIC(78,18) | Decimal-adjusted token_out volume; NULL if decimals unknown. |
trade_count | BIGINT | Number of swaps in the 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. |
Related datasets
Token-to-Token OHLC
OHLC bars for the same directional pairs.
Token-to-USD VWAP
USD VWAP derived from token-to-token VWAP via stablecoin anchoring.