DEX Token Prices
Thedex_token_prices_hourly contains hourly price data of tokens derived from swaps performed on decentralized exchanges.
As records are only populated when a token is traded on a dex, the prices are sparse records. To forward fill them into a dense price table, you may use this sample
Table Columns
| Column Name | Description | Type |
|---|---|---|
| timestamp | Hourly timestamp of the token price. | timestamp_ntz |
| token_mint | The contract address of the token | varchar |
| price | USD Price of the token calculated. | float |
| median_price | Median price of the token. | float |
| is_imputed | Whether the price data is imputed: true or false. | boolean |
| usd_trading_volume | USD volume of the trade to calculate the price data. | float |
| unique_id | Unique ID attached to the derived price data. | varchar |
| _created_at | Timestamp of entry creation. | timestamp_ntz |
| _updated_at | Timestamp of entry update. | timestamp_ntz |