Ask or search…
K
🟤

Prices

The prices schema is nested under the common database.
The prices schema includes hourly token prices derived from DEX trades as well as prices from centralized exchanges.
Table Name
Description
Use Case
common.prices.token_prices_hourly
Hourly token prices from centralized exchanges from 2017-09-01T00:00:00
Finding historical price data of a token of interest.
common.prices.token_prices_hourly_latest
The latest token prices of tokens from centralized exchanges.
Standardizing token volumes to latest price.
common.prices.dex_token_prices_hourly
Token prices computed from DEX trades.
Finding historical price data of tokens not commonly listed on exchanges.
Last modified 2d ago