Hadisehactivity on new collections and old collections
Updated 2022-06-15Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with mint as ( select min(block_timestamp::date) as mint_date ,mint as new_sol_nft
from solana.core.fact_nft_mints
group by 2),
new_sol_nft as ( select date(block_timestamp) as day , count(DISTINCT(tx_id)) as new_activities, sum(sales_amount) as new_volume
from solana.core.fact_nft_sales x join mint y on x.mint = y.new_sol_nft
where mint_date >= '2022-03-01'
group by 1
order by 1),
old_sol_nft as ( select date(block_timestamp) as day_ , count(DISTINCT(tx_id)) as old_activities, sum(sales_amount) as old_volume
from solana.core.fact_nft_sales x join mint y on x.mint = y.new_sol_nft
where mint_date < '2022-03-01'
group by 1
order by 1)
select day_ , new_activities , new_volume, old_activities, old_volume
from old_sol_nft x left join new_sol_nft y on x.day_ = y.day
where day_ > '2022-01-01'
order by 1
Run a query to Download Data