greyswancollections
Updated 2023-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select
date_trunc('week', block_timestamp) as week,
label as collection,
count (distinct purchaser),
count (distinct seller),
count (TX_ID) as sales,
sum (SALES_AMOUNT) as volume
from
solana.nft.fact_nft_sales
left join solana.core.dim_labels on mint = address
where
succeeded = true
and block_timestamp > current_date - 60
group by
label,
date_trunc('week', block_timestamp)
order by
date_trunc('week', block_timestamp) desc,
count (distinct purchaser) desc,
count (distinct seller) desc
Run a query to Download Data