barbodMagic Eden Volume Trends
    Updated 2022-03-19
    with prices as (
    select tx_id ,
    ( zeroifnull(inner_instruction:instructions[0]:parsed:info:lamports/POW(10,9))+
    zeroifnull(inner_instruction:instructions[1]:parsed:info:lamports/POW(10,9))+
    zeroifnull(inner_instruction:instructions[2]:parsed:info:lamports/POW(10,9))+
    zeroifnull(inner_instruction:instructions[3]:parsed:info:lamports/POW(10,9))+
    zeroifnull(inner_instruction:instructions[4]:parsed:info:lamports/POW(10,9))
    ) as price
    from solana.nfts
    where instruction:programId in ('MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8','M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    and date(block_timestamp) >= '2022-01-01'
    AND array_size(inner_instruction:instructions) > 2
    and succeeded = true
    )
    select block_timestamp::date as date ,
    sum (price) as Volume,
    count (p.tx_id) as transactions
    from solana.nfts n join prices p
    on n.tx_id = p.tx_id
    group by 1
    Run a query to Download Data