Overview
- Dataset ID:
0505 - Table:
blockdb_evm.b0505_token_to_token_cross_pool_vwap_v1 - Description: Cross-venue volume-weighted average price (1m..1d) per token pair direction, aggregated from per-pool VWAP (
b0405) across all pools, fee tiers, and exchanges. Unlikeb0405(which has one bar per pool), this table has one bar per (token pair, bucket) regardless of pool count. Feedsb0605for stablecoin anchoring and USD price derivation. - Primary key:
(token_in, token_out, bucket_start, bucket_seconds) - API: POST /evm/prices/spot/crypto/vwap
- CSV Sample: Download
- JSON Sample: Download
Sample Viewer
Columns
| Column | Type | Description |
|---|---|---|
first_block_number | BIGINT | First contributing event block across all pools. |
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 across all pools. |
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) | Cross-venue VWAP: SUM(total_volume_out) / SUM(total_volume_in) across all contributing pools (token_out per 1 token_in, decimals-adjusted). |
total_volume_in | NUMERIC(78,18) | Total token_in traded across all contributing pools in the bucket. |
total_volume_out | NUMERIC(78,18) | Total token_out received across all contributing pools in the bucket. |
trade_count | BIGINT | Total swaps across all contributing pools. |
pool_count | INTEGER | Distinct pools that contributed to this bucket (liquidity quality signal). |
_tracing_id | BYTEA | Unique BlockDB tracing id for the row. |
_parent_tracing_ids | BYTEA[] | Tracing IDs of contributing b0405 bars. NULL by default (disabled) |
_created_at | TIMESTAMPTZ | Record creation time. |
_updated_at | TIMESTAMPTZ | Record last update time. |
Related datasets
Token-to-Token VWAP (per pool)
Per-pool VWAP source that feeds this cross-pool aggregation.
Token-to-Fiat VWAP
USD VWAP derived from this dataset via stablecoin anchoring.