Ez Prices Hourly

price.ez_prices_hourly

Schema: sei.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	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.
IS_VERIFIED	BOOLEAN	Boolean indicating Flipside team verification of the asset. TRUE for manually verified assets with validated metadata.

Example: true | | 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. |