granadohoMagic Eden total sales volume and number of sales per day since January 1st
Updated 2022-03-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
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