Prices

A price is one USD figure at one moment, held at two grains. Token prices are the rows of metrics.tokens_prices_daily and metrics.tokens_prices_hourly, one per token contract on one chain. Asset prices are the price column on metrics.assets_daily, one per curated asset, which belongs to the asset rather than to any single deployment. Every column is documented at Tokens ▸ Prices and Assets ▸ Metrics.

Sample queries

The hourly table holds twenty-four rows per token per day. Bound timestamp in every query against it, and prefer the daily table when joining to other daily tables.

One asset, every chain
Asset against deployment
Pricing an event

Read one asset’s daily price on every chain it is deployed on. dimensions.asset_tokens names the deployments, and the token table carries a price per deployment.

select
    prices.timestamp,
    deployments.chain_id,
    prices.price
from `metrics.tokens_prices_daily` as prices
join `dimensions.asset_tokens` as deployments
    using (token_id)
where deployments.asset_id = 'usdc'
  and prices.timestamp >= timestamp('2026-07-01')
order by prices.timestamp, deployments.chain_id

Compare an asset’s own price with the price of one deployment. The asset price belongs to the asset; the token price belongs to one contract on one chain.

select
    assets.timestamp,
    assets.price as asset_price,
    tokens.price as token_price
from `metrics.assets_daily` as assets
join `metrics.tokens_prices_daily` as tokens
    on tokens.timestamp = assets.timestamp
    and tokens.token_id = '0xdac17f958d2ee523a2206206994597c13d831ec7-ethereum'
where assets.asset_id = 'usdt'
  and assets.timestamp >= timestamp('2026-07-01')
order by assets.timestamp

Price a transfer at the hour it happened. The hourly table matches an event to the top of its hour.

select
    transfers.block_timestamp,
    transfers.transaction_hash,
    cast(transfers.value_raw as bignumeric) / pow(10, tokens.decimals) * prices.price as amount_usd
from `facts.token_transfers` as transfers
join `dimensions.tokens` as tokens
    using (token_id)
join `metrics.tokens_prices_hourly` as prices
    on prices.token_id = transfers.token_id
    and prices.timestamp = timestamp_trunc(transfers.block_timestamp, hour)
where transfers.token_id = '0xdac17f958d2ee523a2206206994597c13d831ec7-ethereum'
  and transfers.block_timestamp >= timestamp('2026-08-20')
  and transfers.block_timestamp < timestamp('2026-08-21')
order by amount_usd desc
limit 20

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Sample queries

​Sample queries

Sample queries