headitmanagerMagic Eden - 5NFT
Updated 2022-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT sum(inner_instruction:instructions[0]:parsed:info:lamports/POW(10,9)
+ inner_instruction:instructions[1]:parsed:info:lamports/POW(10,9)
+ inner_instruction:instructions[2]:parsed:info:lamports/POW(10,9)
+ inner_instruction:instructions[3]:parsed:info:lamports/POW(10,9)
+ COALESCE (inner_instruction:instructions[4]:parsed:info:lamports/POW(10,9), 0)) AS sales_price ,INSTRUCTION:accounts[1] as nft
FROM solana.nfts
WHERE date(block_timestamp) >= '2022-01-01'
AND instruction:programId in('MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8','M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
AND array_size(inner_instruction:instructions) > 2 and (inner_instruction:instructions[0]:parsed:info:lamports/POW(10,9)
+ inner_instruction:instructions[1]:parsed:info:lamports/POW(10,9)
+ inner_instruction:instructions[2]:parsed:info:lamports/POW(10,9)
+ inner_instruction:instructions[3]:parsed:info:lamports/POW(10,9)
+ COALESCE (inner_instruction:instructions[4]:parsed:info:lamports/POW(10,9), 0)) is not null
group by nft
order by sales_price DESC
limit 5
Run a query to Download Data