stellar.price Table: ez_prices_hourly Type: Base Table
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 | The hour at which the token price was recorded on this EVM blockchain. |
| ASSET_ISSUER | TEXT | The account address of the original asset issuer that created the asset. |
| ASSET_CODE | TEXT | The 4 or 12 character code representation of the asset on the network. |
| ASSET_ID | NUMBER | The Farm Hash encoding of Asset Code + Asset Issuer + Asset Type. This field is optimized for cross table joins since integer joins are less expensive than the original asset id components. |
| PRICE | FLOAT | The token price for a given hour on this EVM blockchain. |
| SYMBOL | TEXT | The symbol of the asset. |
| DECIMALS | NUMBER | The number of decimals for the token contract on this EVM blockchain. |
| BLOCKCHAIN | TEXT | The Blockchain, Network, or Platform for this asset. |
| IS_NATIVE | BOOLEAN | A flag indicating assets native to this EVM blockchain. |
| IS_VERIFIED | BOOLEAN | A flag indicating if the asset has been verified by the Flipside team. |
| 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. |
| EZ_PRICES_HOURLY_ID | TEXT | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |