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;