2844SOL opensea vs magic eden
Updated 2022-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select marketplace, count(purchaser) as N_sales, sum(sales_amount) as V_sales_sol, count(distinct purchaser) as N_buyers
from Solana.fact_nft_sales
where marketplace like 'magic%'
and block_timestamp >= '2022-04-06'
and SUCCEEDED = 'TRUE'
group by marketplace
UNION
select 'Opensea' as Marketplace,
count(INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:source) as N_sales,
count(distinct INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:source) as N_buyers,
sum(INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:lamports / pow(10,9)) as V_sales_sol
FROM solana.fact_transactions
where INSTRUCTIONS[0]:programId = 'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk'
and block_timestamp >= '2022-04-06'
and instructions[0]:accounts[0] = inner_instructions[0]:instructions[0]:parsed:info:source
group by marketplace
Run a query to Download Data