💲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.
All prices data are in USD denomination.
| Table Name | Description | Use Case |
|---|---|---|
common.prices.token_prices_hourly | Hourly token prices from centralized exchanges from | 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 updated