afonsosolana nft sales
Updated 2023-04-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
block_timestamp::date as day,
iff(year(day) = 2022, 'Before Christmas', 'After Christmas') as timespan,
count(distinct tx_id) as sales_count,
count(distinct purchaser) as purchasers_count,
sum(sales_amount) as total_sales_volume,
avg(sales_amount) as average_sales_amount,
median(sales_amount) as median_sales_amount,
sum(purchasers_count) over (order by day asc) as cumulative_purchasers_count,
sum(sales_count) over (order by day asc) as cumulative_sales_count,
sum(total_sales_volume) over (order by day asc) as cumulative_sales_volume
from solana.core.fact_nft_sales
left outer join solana.core.dim_nft_metadata
on solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint
where day between date('2023-01-01') - interval '2 weeks' and date('2023-01-01') + interval '2 weeks'
group by day, timespan
order by day
Run a query to Download Data