osmosis.price Table: dim_prices Type: View
Contains token prices in USD for assets that can be traded on the Osmosis Zone and Frontier.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| RECORDED_AT | TIMESTAMP_NTZ | The time, including the day and hour, that the price of the token corresponds to. |
| SYMBOL | TEXT | The token’s symbol |
| CURRENCY | TEXT | |
| PRICE | FLOAT | The price of the token in USD. |
| TOTAL_SUPPLY | TEXT | The total circulating supply of the token |
| VOLUME_24H | TEXT | |
| PROVIDER | TEXT | Where the price is sourced from. Prices sourced from the swaps table may have outliers for hours with low swap volume. |
| DIM_PRICES_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |