Skip to main content
Schema: hyperevm.core Table: dim_contracts Type: 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 token properties (decimals, symbols)
  • Tracking contract deployment patterns and trends
  • Finding contracts deployed by specific factories or deployers
  • Filtering protocol-specific data across other tables

​
Important Relationships

  • Join with fact_transactions: Use address = to_address for contract interactions
  • Join with fact_event_logs: Use address = contract_address for contract events
  • Join with ez_token_transfers: Use address = contract_address for token movements

​
Commonly-used Fields

  • address: The deployed contract’s blockchain address (lowercase)
  • name: Human-readable contract name from the name() function
  • symbol: Token/contract symbol from the symbol() function
  • decimals: Number of decimal places for token amounts
  • creator_address: Address that deployed this contract
  • created_block_timestamp: When the contract was created

​
Sample queries

Find All Uniswap V3 Pool Contracts 
SELECT
    address,
    name,
    created_block_number,
    created_block_timestamp,
    creator_address
FROM hyperevm.core.dim_contracts
WHERE creator_address = LOWER('0x1F98431c8aD98523631AE4a59f267346ea31F984') -- Uniswap V3 Factory
ORDER BY created_block_number DESC
LIMIT 100;
Analyze Contract Deployment Trends 
SELECT
    DATE_TRUNC('week', created_block_timestamp) AS week,
    COUNT(*) AS contracts_deployed,
    COUNT(DISTINCT creator_address) AS unique_deployers
FROM hyperevm.core.dim_contracts
WHERE created_block_timestamp >= CURRENT_DATE - 90
GROUP BY 1, 2
ORDER BY 1 DESC, 3 DESC;

​
Columns

Column NameData TypeDescription
ADDRESSTEXTUnique identifier - the deployed contract’s blockchain address.
SYMBOLTEXTToken/contract symbol from the symbol() function.
NAMETEXTHuman-readable contract name from the name() function.
DECIMALSNUMBERNumber of decimal places for token amounts, read directly from the contract code.
CREATED_BLOCK_NUMBERNUMBERBlock number when contract was created.
CREATED_BLOCK_TIMESTAMPTIMESTAMP_NTZTimestamp when contract was created.
CREATED_TX_HASHTEXTTransaction hash of the contract deployment.
CREATOR_ADDRESSTEXTAddress that deployed this contract (transaction from_address).
DIM_CONTRACTS_IDTEXTPrimary key - unique identifier for each row ensuring data integrity.
INSERTED_TIMESTAMPTIMESTAMP_NTZUTC timestamp when the record was first added to the Flipside database.
MODIFIED_TIMESTAMPTIMESTAMP_NTZUTC timestamp of the most recent update to this record.