Skip to main content
Schema: monad.core Table: dim_contracts Type: Dimension Table

​
What

This table provides comprehensive metadata for all smart contracts deployed on EVM blockchains. It includes contract names, symbols, decimals, and deployment details read directly from the blockchain.

​
Key Use Cases

  • Identifying contracts by name, symbol, or address
  • Understanding tok

​
Columns

Column NameData TypeDescription
ADDRESSTEXTUnique identifier - the deployed contract’s blockchain ad…
CREATED_BLOCK_NUMBERNUMBERBlock number when contract was created.
Example: 17500000 | | CREATED_BLOCK_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when contract was created. Example: 2023-06-15… | | CREATED_TX_HASH | TEXT | Transaction hash of the contract deployment. Example: ‘0… | | CREATOR_ADDRESS | TEXT | Address that deployed this contract (transaction from_add… | | DECIMALS | TEXT | Number of decimal places for token amounts, read directly… | | DIM_CONTRACTS_ID | TEXT | Primary key - unique identifier for each row ensuring dat… | | INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first added to the Flip… | | MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp of the most recent update to this record. … | | NAME | TEXT | Human-readable contract name from the name() function. E… | | SYMBOL | TEXT | Token/contract symbol from the symbol() function. Exampl… |