iboo-jbj2MVopen sea vs magic eden sale amount
Updated 2022-04-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with os as(
select
'OpenSea' as marketplace,
sum(INNER_INSTRUCTION:instructions[0]:parsed:info:lamports/pow(10,9)) as volume,
count(distinct INNER_INSTRUCTION:instructions[0]:parsed:info:source) as users
from solana.fact_events where INSTRUCTION:programId='hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk' -- opensea on Solana
and block_timestamp>='2022-04-06'
and index=0
),
me as (select
'Magic Eden' as marketplace,
sum(sales_amount) as volume,
count(distinct purchaser) as users
from solana.fact_nft_sales where MARKETPLACE='magic eden v2' ---magic eden
and block_timestamp>='2022-04-06'
and SUCCEEDED='TRUE'
)
select * from os
union all
select * from me
Run a query to Download Data