barbodMagic Eden Volume Trends
Updated 2022-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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