Documentation Index
Fetch the complete documentation index at: https://docs.blockdb.io/llms.txt
Use this file to discover all available pages before exploring further.
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
- 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. |
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. |
_parent_tracing_ids | BYTEA[] | Tracing IDs of contributing swap prints. NULL by default (disabled) — the bucket is fully reconstructible from (pool_uid, token_in, token_out, first_block_number..last_block_number). Enable only when full per-row audit trail is required; can be large (thousands of entries per bar). |
_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.