KingTigerMafia-7mwRZbPopular NFT transaction volume
    Updated 2022-08-10
    WITH genesiskami AS (
    SELECT block_timestamp::date AS date, COUNT(DISTINCT tx_hash) AS tx_count
    FROM optimism.core.ez_nft_sales
    WHERE date >= '2022-07-01' AND nft_address = '0xb91b2276bd5a98994bf1f496e3886f688f8d4581'
    GROUP BY 1
    ORDER BY 1 ASC
    ), mirror AS (
    SELECT block_timestamp::date AS date, COUNT(DISTINCT tx_hash) AS tx_count
    FROM optimism.core.ez_nft_sales
    WHERE date >= '2022-07-01' AND nft_address = '0xa95579592078783b409803ddc75bb402c217a924'
    GROUP BY 1
    ORDER BY 1 ASC
    )
    SELECT m.date, SUM(m.tx_count) as mirror_count, SUM(g.tx_count) as genesiskami_count
    FROM mirror m FULL OUTER JOIN genesiskami g on m.date = g.date
    GROUP BY 1
    ORDER BY 1 ASC
    -- 0xb91b2276bd5a98994bf1f496e3886f688f8d4581 genesiskami
    -- 0xa95579592078783b409803ddc75bb402c217a924 mirror wnft optimism collective: hello world


    Run a query to Download Data