par_rnUntitled Query
Updated 2023-01-25
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('day',block_timestamp) as date,
marketplace,
count(DISTINCT tx_id) as sales,
count(DISTINCT purchaser) as purchasers,
count(DISTINCT seller) as sellers,
sum(sales_amount) as volume,
rank() over (partition by date order by sales desc) as r
from solana.core.fact_nft_sales
where date>= '2022-10-01'
and succeeded = TRUE
group by 1,2
qualify r <= 5
Run a query to Download Data