Afonso_DiazUntitled Query
Updated 2023-01-29Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
block_timestamp::date as day,
marketplace,
count(distinct tx_id) as exchange_art_sales_count,
sum(sales_amount) as exchange_art_sales_volume,
avg(sales_amount) as exchange_art_avg_sales_volume,
count(distinct purchaser) as exchange_art_buyers_count,
count(distinct seller) as exchange_art_sellers_count,
sum(exchange_art_sales_count) over(partition by marketplace order by day) as cumulative_exchange_art_sales_count,
sum(exchange_art_sales_volume) over(partition by marketplace order by day) as cumulative_exchange_art_sales_volume,
sum(exchange_art_sellers_count) over(partition by marketplace order by day) as cumulative_exchange_art_sellers_count,
sum(exchange_art_buyers_count) over(partition by marketplace order by day) as cumulative_exchange_art_buyers_count,
avg(exchange_art_sales_volume) over (partition by marketplace order by day rows between 7 preceding and current row) as exchange_art_sales_volume_ma_7
from solana.core.fact_nft_sales
where block_timestamp > current_date - 90
and succeeded = 1
and block_timestamp > current_date - 90
group by 1, 2
order by 1, 2
Run a query to Download Data