aor67nft 6 eth 1
Updated 2022-09-15
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select BLOCK_TIMESTAMP::date date ,count(DISTINCT TX_HASH) as "total sale",
count (DISTINCT BUYER_ADDRESS) as "total buyer",
count (DISTINCT SELLER_ADDRESS) as "total seller",
sum(PRICE_USD) as "total volume (USD)",
avg(PRICE_USD) "average price (USD)"
from ethereum.core.ez_nft_sales
where EVENT_TYPE = 'sale'
and date BETWEEN '2022-03-11' and '2022-09-11'
group by 1
Run a query to Download Data