gigiokobaoverseas-orange
    Updated 2025-02-21
    WITH nft_transfers AS (
    SELECT
    el.contract_address,
    el.topic_1 as from_address,
    el.topic_2 as to_address,
    c.name as collection_name,
    c.creator_address,
    COUNT(*) as transfer_count
    FROM monad.testnet.fact_event_logs el
    LEFT JOIN monad.testnet.dim_contracts c
    ON el.contract_address = c.address
    WHERE el.block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())
    -- Filter for ERC-721 Transfer event signature
    AND el.topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    -- Ensure we're looking at NFT transfers (topic_3 should be empty for ERC-721)
    AND el.topic_3 IS NULL
    AND el.tx_succeeded = true
    GROUP BY 1,2,3,4,5
    )
    SELECT
    collection_name,
    creator_address,
    COUNT(*) as total_transfers,
    COUNT(DISTINCT contract_address) as unique_contracts,
    COUNT(DISTINCT from_address) as unique_sellers,
    COUNT(DISTINCT to_address) as unique_buyers
    FROM nft_transfers
    WHERE creator_address IS NOT NULL
    GROUP BY 1,2
    ORDER BY total_transfers DESC
    LIMIT 20;
    Last run: 23 days ago
    COLLECTION_NAME
    CREATOR_ADDRESS
    TOTAL_TRANSFERS
    UNIQUE_CONTRACTS
    UNIQUE_SELLERS
    UNIQUE_BUYERS
    1
    ERC20Test0xd58d857a5d9faa5865ead06a1e99b2cef8dd24d488748423200112000
    2
    0x3e09533c74df2181069a1ec04c425fbca8a76b5030128301160111597
    3
    0xd58d857a5d9faa5865ead06a1e99b2cef8dd24d4132743378160121750
    4
    0xff73ba9e0669d7ead82421ad105bc6d715606ec4363935311435142579
    5
    0xbaaf22d2bc4ac001bbdda7de73d3ae1ba71dfddb273961212343131295
    6
    0x5790bc75e4d09bb7327f21a90d48ce82aad04d5e19652634705176983
    7
    0x60216fb3285595f4643f9f7cddab842e799bd642161766336034387969950
    8
    0x508426ee8cb3154f4b418f6c3b6ca6294d2c043c8272421410868489
    9
    0x7297fb286b8725169a688f555a437d527830839d7632081611327678
    10
    0xbc24a9bcc76a2cd505fa99dea21d4509c9af33886928411369275
    11
    USD Coin0xbaaf22d2bc4ac001bbdda7de73d3ae1ba71dfddb5820911825925866
    12
    0x67a4e43c7ce69e24d495a39c43489bc7070f009b530373276820122975
    13
    0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e429171942032965
    14
    0x13c6badd8e656f29e6e781abe1e86b499a9bef764155921273415543
    15
    Curvance Wrapped Bitcoin0xbaaf22d2bc4ac001bbdda7de73d3ae1ba71dfddb3324611097922269
    16
    0x923d7f0bd128d760b421f7c5af187a56325a9da53149123914515536
    17
    0xc776cbddea014889e8bab4323c894c5c34db214d310622587225191
    18
    0x904d6cef48d78448e332b90f66e23a5aaedc1a47245641901811721
    19
    0x39d2770abcc456f6c6be820705ed966592e0ad96241552272115132
    20
    Curvance interest-bearing USD Coin0xbaaf22d2bc4ac001bbdda7de73d3ae1ba71dfddb174061817402
    20
    1KB
    16s