bobby_danielContract Types and Creators
    Updated 2025-03-19
    WITH contract_info AS (
    SELECT
    CASE
    WHEN LOWER(name) LIKE '%erc20%' OR decimals IS NOT NULL THEN 'TOKEN'
    WHEN LOWER(name) LIKE '%nft%' OR LOWER(name) LIKE '%erc721%' THEN 'NFT'
    WHEN LOWER(name) LIKE '%swap%' OR LOWER(name) LIKE '%dex%' THEN 'DEX'
    WHEN LOWER(name) LIKE '%bridge%' THEN 'BRIDGE'
    WHEN LOWER(name) LIKE '%game%' OR LOWER(name) LIKE '%play%' THEN 'GAME'
    WHEN LOWER(name) LIKE '%dao%' OR LOWER(name) LIKE '%gov%' THEN 'DAO'
    WHEN LOWER(name) LIKE '%lend%' OR LOWER(name) LIKE '%borrow%' THEN 'LENDING'
    ELSE 'OTHER'
    END as contract_type,
    address,
    creator_address
    FROM monad.testnet.dim_contracts
    WHERE created_block_timestamp >= '2025-02-19 15:00'
    )

    SELECT
    contract_type,
    COUNT(DISTINCT address) AS total_contracts,
    COUNT(DISTINCT creator_address) AS unique_creators,
    ROUND(COUNT(DISTINCT address)::FLOAT / NULLIF(COUNT(DISTINCT creator_address), 0), 2) as avg_contracts_per_creator
    FROM contract_info
    GROUP BY 1
    ORDER BY total_contracts DESC;
    Last run: 2 months ago
    CONTRACT_TYPE
    TOTAL_CONTRACTS
    UNIQUE_CREATORS
    AVG_CONTRACTS_PER_CREATOR
    1
    OTHER682746312035435.67
    1
    32B
    2s