KaskoazulSolport vs Magic Eden
Updated 2022-04-04
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
34
35
36
›
⌄
with SOLPORT as (
select block_timestamp::date as fecha,
sum(sales_amount) as total_sales,
sum(total_sales) over (order by fecha) as cum_sales,
count(distinct purchaser) as unique_buyers,
sum(unique_buyers) over (order by fecha) as cum_buyers
from solana.fact_nft_sales
where program_id = 'SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj'
and succeeded = 'TRUE'
and fecha >= '2022-03-12'
and fecha < CURRENT_DATE - 1
group by 1
),
MAGIC_EDEN as (
select block_timestamp::date as fecha,
sum(sales_amount) as total_sales,
count(distinct purchaser) as unique_buyers,
sum(unique_buyers) over (order by fecha) as cum_buyers
from solana.fact_nft_sales
where program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K'
and succeeded = 'TRUE'
and fecha >= '2022-03-12'
and fecha < CURRENT_DATE - 1
group by 1
)
select SOLPORT.fecha,
SOLPORT.total_sales as Solport,
SOLPORT.cum_sales as Solport_volume,
SOLPORT.unique_buyers as SP_buyers,
SOLPORT.cum_buyers as SP_cum_buyers,
MAGIC_EDEN.total_sales as Magic_Eden,
MAGIC_EDEN.unique_buyers as ME_buyers,
MAGIC_EDEN.cum_buyers as ME_cum_buyers
from SOLPORT
Run a query to Download Data