ramishoowUntitled Query
Updated 2022-10-20
9
1
2
3
›
⌄
SELECT date_trunc(day,block_timestamp) as "time", count(DISTINCT tx_hash) as "sales count", sum(price_usd) as "sales volume",
count(DISTINCT seller_address) as "seller count", count(DISTINCT buyer_address) as "buyer count" from optimism.core.ez_nft_sales
where block_timestamp between '2022-09-1' and '2022-10-21' group by 1
Run a query to Download Data