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

What

This curated dimensional table provides comprehensive metadata for tokens and native assets across EVM blockchains. It serves as the authoritative source for asset information, with quality checks and verification status to ensure reliability.

Key Use Cases

  • Asset discovery and verifi

Columns

Column NameData TypeDescription
ASSET_IDTEXTUnique identifier for the asset from the price provider. …
BLOCKCHAINTEXTThe blockchain network where the asset exists. Lowercase …
DECIMALSTEXTNumber of decimal places for the token. Most ERC-20 token…
EZ_ASSET_METADATA_IDTEXTPrimary key - unique identifier for each row ensuring dat…
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_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.
… | | NAME | TEXT | Full name of the asset or token. More descriptive than sy… | | 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… |