Prices
Daily token prices combining CoinGecko data and DEX VWAP calculations across 6 chains.
7 tables — one per chain, plus a DEX-only price table for Tempo.
| Table | Chain |
|---|---|
agent.ethereum_prices_day | Ethereum |
agent.base_prices_day | Base |
agent.arbitrum_prices_day | Arbitrum |
agent.tron_prices_day | Tron |
agent.hyperevm_prices_day | HyperEVM |
agent.tempo_prices_day | Tempo (different schema, see below) |
agent.tempo_prices_dex | Tempo (DEX-derived, includes volume + trade count) |
Schema
Engine: MergeTree | Partition: toYYYYMM(block_date) | ORDER BY: contract_address, block_date
| Column | Type | Description |
|---|---|---|
block_date | Date | UTC date |
blockchain | String | Chain name |
contract_address | String | Lowercase hex. Zero address for native token. |
decimals | Int64 | Token decimals |
symbol | String | Token symbol. May be null for unregistered tokens. |
price | Float64 | USD price |
volume_usd | Float64 | Trading volume in USD |
source | String | 'coingecko' or 'dex_vwap' |
Tempo Prices Schema
The two Tempo tables use a simpler schema (no blockchain column) and ReplacingMergeTree — query with FINAL. Tempo tokens are USD stablecoins, so prices hover near $1.
| Column | Type | Description |
|---|---|---|
block_date | Date | UTC date |
contract_address | String | TIP-20 token contract |
symbol | String | Token symbol |
decimals | UInt8 | Token decimals |
price | Float64 | USD price |
volume_usd | Float64 | tempo_prices_dex only — daily DEX volume |
trade_count | UInt32 | tempo_prices_dex only — daily DEX trade count |
source | String | Price source |
Good to Know
- Prefer CoinGecko when both sources exist. DEX VWAP fills gaps for tokens CoinGecko doesn't list.
- WETH (
0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2) is the ETH price proxy on Ethereum. - CoinGecko prices are hourly snapshots — no intraday precision.
- DEX VWAP can be skewed by low-liquidity pools or wash trading.
- New tokens may have no price for the first few days.