-- Filter mints for Magic Eden-associated projects since January 2024

SELECT

NFT_TO_ADDRESS AS wallet_address,

PROJECT_NAME,

BLOCK_TIMESTAMP,

MINT_PRICE_ETH,

MINT_PRICE_USD,

NFT_COUNT

FROM

ethereum.nft.ez_nft_mints

WHERE

PROJECT_NAME IN (

'DeGods',

'y00ts',

'Famous Fox Federation',

'SMB Gen2',

'Mad Lads'

) -- Magic Eden collections

AND BLOCK_TIMESTAMP >= '2024-01-01' -- Starting from January 2024

),

summary AS (

-- Summarize minting activity by wallet

SELECT

wallet_address,

COUNT(DISTINCT PROJECT_NAME) AS distinct_projects_minted,

SUM(NFT_COUNT) AS total_nfts_minted,

SUM(MINT_PRICE_ETH) AS total_eth_spent,

SUM(MINT_PRICE_USD) AS total_usd_spent

FROM

magic_eden_mints

GROUP BY

wallet_address

) -- Retrieve wallets meeting eligibility criteria

wallet_address,