Skip to main content
3 tables in this category.

​
Tables

View NameDatabaseSourceORDER BY
agent.ethereum_prices_dayagentprices_ethereum.daycontract_address, block_date
agent.base_prices_dayagentprices_base.daycontract_address, block_date
agent.arbitrum_prices_dayagentprices_arbitrum.daycontract_address, block_date
  • agent.arbitrum_dex_trades
  • agent.base_dex_trades
  • agent.ethereum_dex_trades
  • agent.ethereum_erc20

​
Sample Queries

​
1. ETH daily price for the last 30 days

SELECT block_date, price
FROM agent.ethereum_prices_day
WHERE symbol = 'WETH'
  AND block_date >= today() - 30
ORDER BY block_date

​
Table Schemas

​
agent.ethereum_prices_day

Daily token prices combining CoinGecko hourly snapshots and DEX VWAP calculations. One row per (contract_address, block_date, source). Prefer source=‘coingecko’ when available. Engine: MergeTree | Partition: toYYYYMM(block_date) | ORDER BY: contract_address, block_date
ColumnTypeDescription
block_dateDateUTC block date
blockchainStringBlockchain network name
contract_addressStringToken contract address (lowercase hex). Zero address for native token.
decimalsInt64Token decimals (from erc20 metadata). Needed when converting raw amounts.
symbolStringToken symbol. May be null for unregistered tokens.
priceFloat64USD price. CoinGecko source is hourly snapshot; DEX VWAP is volume-weighted from on-chain swaps.
volume_usdFloat64Trading volume in USD
sourceString’coingecko’ or ‘dex_vwap’. Prefer coingecko for stable reference; dex_vwap fills gaps.
  • Use argMax(price, source = ‘coingecko’) to prefer CoinGecko over DEX VWAP when both exist
  • JOIN on (contract_address, block_date) for daily valuations
  • WETH contract (0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2) is the ETH price proxy on Ethereum
  • Coverage gaps exist for illiquid/new tokens — always handle NULL prices
  • CoinGecko prices are hourly snapshots, not tick-level — intraday precision is limited
  • DEX VWAP can be skewed by low-liquidity pools or wash trading
  • New tokens may have no price for the first few days after deployment
  • Stablecoins may show slight depegs in CoinGecko data during volatility

​
agent.base_prices_day

Daily token prices combining CoinGecko hourly snapshots and DEX VWAP calculations. One row per (contract_address, block_date, source). Prefer source=‘coingecko’ when available. Engine: MergeTree | Partition: toYYYYMM(block_date) | ORDER BY: contract_address, block_date
ColumnTypeDescription
block_dateDateUTC block date
blockchainStringBlockchain network name
contract_addressStringToken contract address (lowercase hex). Zero address for native token.
decimalsInt64Token decimals (from erc20 metadata). Needed when converting raw amounts.
symbolStringToken symbol. May be null for unregistered tokens.
priceNullable(Float64)USD price. CoinGecko source is hourly snapshot; DEX VWAP is volume-weighted from on-chain swaps.
volume_usdFloat64Trading volume in USD
sourceString’coingecko’ or ‘dex_vwap’. Prefer coingecko for stable reference; dex_vwap fills gaps.
  • Use argMax(price, source = ‘coingecko’) to prefer CoinGecko over DEX VWAP when both exist
  • JOIN on (contract_address, block_date) for daily valuations
  • WETH contract (0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2) is the ETH price proxy on Ethereum
  • Coverage gaps exist for illiquid/new tokens — always handle NULL prices
  • CoinGecko prices are hourly snapshots, not tick-level — intraday precision is limited
  • DEX VWAP can be skewed by low-liquidity pools or wash trading
  • New tokens may have no price for the first few days after deployment
  • Stablecoins may show slight depegs in CoinGecko data during volatility

​
agent.arbitrum_prices_day

Daily token prices combining CoinGecko hourly snapshots and DEX VWAP calculations. One row per (contract_address, block_date, source). Prefer source=‘coingecko’ when available. Engine: MergeTree | Partition: toYYYYMM(block_date) | ORDER BY: contract_address, block_date
ColumnTypeDescription
block_dateDateUTC block date
blockchainStringBlockchain network name
contract_addressStringToken contract address (lowercase hex). Zero address for native token.
decimalsInt64Token decimals (from erc20 metadata). Needed when converting raw amounts.
symbolStringToken symbol. May be null for unregistered tokens.
priceNullable(Float64)USD price. CoinGecko source is hourly snapshot; DEX VWAP is volume-weighted from on-chain swaps.
volume_usdFloat64Trading volume in USD
sourceString’coingecko’ or ‘dex_vwap’. Prefer coingecko for stable reference; dex_vwap fills gaps.
  • Use argMax(price, source = ‘coingecko’) to prefer CoinGecko over DEX VWAP when both exist
  • JOIN on (contract_address, block_date) for daily valuations
  • WETH contract (0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2) is the ETH price proxy on Ethereum
  • Coverage gaps exist for illiquid/new tokens — always handle NULL prices
  • CoinGecko prices are hourly snapshots, not tick-level — intraday precision is limited
  • DEX VWAP can be skewed by low-liquidity pools or wash trading
  • New tokens may have no price for the first few days after deployment
  • Stablecoins may show slight depegs in CoinGecko data during volatility