granadohoMagic Eden total sales volume and number of sales per day since January 1st
    Updated 2022-03-17
    WITH secondary_sales AS (
    SELECT
    block_timestamp,
    block_id,
    blockchain,
    recent_block_hash,
    tx_id,
    mint,
    succeeded,
    pretokenbalances,
    posttokenbalances,
    instruction,
    inner_instruction,
    inner_instruction:instructions[0]:parsed:info:lamports/POW(10,9) as price_0,
    inner_instruction:instructions[1]:parsed:info:lamports/POW(10,9) as price_1,
    inner_instruction:instructions[2]:parsed:info:lamports/POW(10,9) as price_2,
    inner_instruction:instructions[3]:parsed:info:lamports/POW(10,9) as price_3,
    COALESCE (inner_instruction:instructions[4]:parsed:info:lamports/POW(10,9), 0) as price_4,
    (price_0 + price_1 + price_2 + price_3 + price_4) AS sales_price
    FROM solana.nfts
    WHERE date(block_timestamp) >= '2022-01-01'
    AND instruction:programId = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8' or instruction:programId = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K'
    AND array_size(inner_instruction:instructions) > 2
    )

    select
    date(block_timestamp) as date,
    count(distinct tx_id) as num_of_sales,
    sum(sales_price) as sales_volume_in_SOL
    from secondary_sales
    group by 1
    order by 1

    Run a query to Download Data