headitmanagerMagic Eden - number of unique wallets
    Updated 2022-03-19
    SELECT month(block_timestamp) as tdate , count(distinct instruction:accounts[0])
    FROM solana.nfts
    WHERE date(block_timestamp) >= '2022-01-01'
    AND instruction:programId in('MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8','M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    AND array_size(inner_instruction:instructions) > 2
    group by tdate



    Run a query to Download Data