peteer10optimism
Updated 2023-04-14
9
1
2
3
4
5
6
7
›
⌄
select avg(PRICE_USD),avg(TOTAL_FEES_USD) , count(*)/count(distinct BUYER_ADDRESS)
, sum(PRICE_USD) / count(distinct BUYER_ADDRESS) ,
sum(TOTAL_FEES_USD) / count(distinct BUYER_ADDRESS)
,year(block_timestamp::date) as years
from optimism.core.ez_nft_sales
where years in (2022,2023)
group by years
Run a query to Download Data