mariya Total number of unique wallets
    Updated 2022-04-17
    WITH diagram1 AS (
    SELECT
    count(distinct(posttokenbalances[0]:owner)) as me_total_wallets
    FROM solana.nfts
    WHERE (program_id = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8' OR program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    AND array_size(inner_instruction:instructions) > 2
    AND block_timestamp >= '2022-04-06'
    ),
    diagram2 AS (
    SELECT
    count(distinct(instruction:accounts[0])) as os_total_wallets
    FROM solana.fact_events
    WHERE index = 7
    AND program_id = 'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk'
    AND block_timestamp >= '2022-04-06'
    )
    SELECT
    'Total unique wallets bought a SOL NFT on OpenSea vs. Magic Eden', os_total_wallets, me_total_wallets
    FROM diagram2 , diagram1
    Run a query to Download Data