Alexay1m
Updated 2022-10-10
9
1
2
3
4
5
6
7
8
9
›
⌄
select date_trunc('month', block_timestamp) as month_, address_name, sum (sales_amount) as volume
from solana.core.fact_nft_sales a
join solana.core.dim_labels b on a.mint=b.address
where (address_name in ('Collectorz Club: The Collectorz','The Suites','the suites token','Laidback Lions','Sports Rewind','stepn - run to earn','Hockey Heroes')
or label like '%stepn%')
and SUCCEEDED = 'TRUE'
and sales_amount > 0
group by month_, address_name
order by month_
Run a query to Download Data