Skip to main content
Schema: monad.price Table: ez_prices_hourly Type: View

What

This curated table provides reliable hourly price data for tokens and native assets across EVM blockchains. It combines multiple data sources with quality checks to ensure accurate, consistent pricing for DeFi analytics, portfolio valuations, and historical analysis.

Key Use Cases

  • Ca

Columns

Column NameData TypeDescription
BLOCKCHAINTEXTThe blockchain network where the asset exists. Lowercase …
DECIMALSTEXTNumber of decimal places for the token. Most ERC-20 token…
EZ_PRICES_HOURLY_IDTEXTPrimary key - unique identifier for each row ensuring dat…
HOURTIMESTAMP_NTZUTC timestamp truncated to the hour for price recording. …
INSERTED_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the record was first added to the Flip…
IS_DEPRECATEDBOOLEANFlag indicating if the asset is no longer actively suppor…
IS_IMPUTEDBOOLEANBoolean flag indicating if the price was forward-filled d…
IS_NATIVEBOOLEANBoolean indicating if the asset is the blockchain’s nativ…
IS_VERIFIEDBOOLEANBoolean indicating Flipside team verification of the asse…
MODIFIED_TIMESTAMPTIMESTAMP_NTZUTC timestamp of the most recent update to this record.
… | | PRICE | FLOAT | USD price of one whole token unit at the recorded hour. … | | SYMBOL | TEXT | Token ticker symbol as commonly recognized. Usually 3-5 u… | | TOKEN_ADDRESS | TEXT | Contract address of the token on the blockchain. NULL for… |