shadilMagic Eden Volume Trends - hourly volume
    Updated 2022-03-12
    -- Old: MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8
    -- New: M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K

    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 block_timestamp::date between '2022-01-01' and CURRENT_DATE-2
    AND (instruction:programId = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8' or instruction:programId = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    AND array_size(inner_instruction:instructions) > 2
    )

    select EXTRACT(HOUR FROM block_timestamp::time) as time, sum(sales_price) as total_sale
    from secondary_sales
    group by time
    order by time
    Run a query to Download Data