Skip to main content
Schema: monad.defi Table: dim_stablecoins Type: Dimension Table

What

This table provides a dimensional view of verified stablecoins across EVM-compatible blockchains. It consolidates stablecoin metadata from various sources to create a unified reference table for identifying and analyzing stablecoin tokens.

Key Use Cases

  • Identifying stablecoin tokens

Columns

Column NameData TypeDescription
CONTRACT_ADDRESSTEXTThe unique smart contract address of the stablecoin token…
DECIMALSTEXTThe number of decimal places used by the token contract.
DIM_STABLECOINS_IDTEXTPrimary key - unique identifier for each row ensuring dat…
INSERTED_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the record was first added to the Flip…
IS_VERIFIEDBOOLEANIndicates whether the stablecoin is verified by the Flips…
LABELTEXTA combined display label containing both symbol and name…
MODIFIED_TIMESTAMPTIMESTAMP_NTZUTC timestamp of the most recent update to this record.
… | | NAME | TEXT | The full name of the stablecoin token. Example: ‘USD Coin’ | | SYMBOL | TEXT | The symbol identifier for the stablecoin token. Example:… |