Skip to main content
Schema: 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 NameData TypeDescription
HOURTIMESTAMP_NTZThe hour at which the token price was recorded on this EVM blockchain.
ASSET_ISSUERTEXTThe account address of the original asset issuer that created the asset.
ASSET_CODETEXTThe 4 or 12 character code representation of the asset on the network.
ASSET_IDNUMBERThe 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.
PRICEFLOATThe token price for a given hour on this EVM blockchain.
SYMBOLTEXTThe symbol of the asset.
DECIMALSNUMBERThe number of decimals for the token contract on this EVM blockchain.
BLOCKCHAINTEXTThe Blockchain, Network, or Platform for this asset.
IS_NATIVEBOOLEANA flag indicating assets native to this EVM blockchain.
IS_VERIFIEDBOOLEANA flag indicating if the asset has been verified by the Flipside team.
IS_IMPUTEDBOOLEANA 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_DEPRECATEDBOOLEANA flag indicating if the asset is deprecated or no longer supported by the provider.
EZ_PRICES_HOURLY_IDTEXTUnique primary key for the dimension table, used as the main identifier for each record.
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when this record was inserted.
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when this record was last modified.