aptos.price Table: ez_prices_hourly Type: View
What
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. |
| SYMBOL | TEXT | The symbol of asset. |
| NAME | TEXT | NAME column |
| DECIMALS | NUMBER | The number of decimals for the asset. May be NULL. |
| PRICE | FLOAT | Closing price of the recorded hour in USD. |
| IS_NATIVE | BOOLEAN | A flag indicating assets native to the respective blockchain. |
| IS_DEPRECATED | BOOLEAN | A flag indicating if the asset is deprecated or no longer supported by the provider. |
| 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_VERIFIED | BOOLEAN | A flag indicating if the asset has been verified by the Flipside team. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp when the row was inserted into the table, representing when the data was first recorded. Data type: Timestamp Example: 2024-01-15 14:30:25.123456 Business Context: Essential for data lineage tracking and insertion timing analysis. Critical for understanding data freshness and processing delays. Enables data quality analysis and processing performance monitoring. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The UTC timestamp when the row was last modified, representing when the data was most recently updated. Data type: Timestamp Example: 2024-01-15 14:30:25.123456 Business Context: Essential for data freshness analysis and update tracking. Critical for understanding data modification patterns and change frequency. Enables data quality monitoring and update performance analysis. |
| EZ_PRICES_HOURLY_ID | TEXT | The unique primary key identifier for each row in the table, ensuring data integrity and uniqueness. Data type: String Example: 0x1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef Business Context: Essential for data integrity and unique row identification. Critical for join operations and data relationship management. Enables precise data retrieval and referential integrity maintenance. |