Drsimonn.collections - y
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select date_trunc('year', block_timestamp) as date, address_name as collection_name,
--drsimon,
count(distinct SELLER_ADDRESS) as sellers,
count(distinct BUYER_ADDRESS) as buyers,
--drsimon,
sum(price) as sales_volume_eth ,
sum(price_usd) as sales_volume_usd ,
count(DISTINCT tokenid) as sales
--drsimon,
from optimism.core.ez_nft_sales
join optimism.core.dim_labels
on address = nft_address
--drsimon,
where platform_name like 'quixotic'
--drsimon,
and event_type = 'sale'
--drsimon,
group by 1 , 2
order by 5 desc
Run a query to Download Data