aleo.price Table: ez_prices_hourly Type: View
A convenience table for determining token prices by address and blockchain, and native asset prices
by symbol and blockchain. This data set is highly curated and contains metadata for one price per
hour per unique asset and blockchain.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| HOUR | TIMESTAMP_NTZ | Hour that the price was recorded at. |
| TOKEN_ADDRESS | TEXT | The specific address representing the asset on a specific platform. This will be NULL if referring to a native asset. The case (upper / lower) may or may not be specified within the dim_asset_metadata table, as this column is raw and not transformed, coming directly from the provider APIs. However, in the ez_ views, it will be lowercase by default for all EVMs. |
| SYMBOL | TEXT | The symbol of asset. |
| NAME | TEXT | |
| DECIMALS | NUMBER | The number of decimals for the asset. May be NULL. |
| PRICE | FLOAT | Closing price of the recorded hour in USD. |
| BLOCKCHAIN | TEXT | The Blockchain, Network, or Platform for this asset. |
| IS_NATIVE | BOOLEAN | A flag indicating assets native to the respective blockchain. |
| IS_IMPUTED | BOOLEAN | A flag indicating if the price was imputed, or derived, from the last arriving record. This is generally used for tokens with low-liquidity or inconsistent reporting. |
| IS_DEPRECATED | BOOLEAN | A flag indicating if the asset is deprecated or no longer supported by the provider. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |
| EZ_PRICES_HOURLY_ID | TEXT | The unique identifier for each row in the table. |