xeejsgr478Untitled Query
Updated 2022-11-22
9
1
2
3
4
5
6
7
8
›
⌄
select count(DISTINCT tx_hash) as "total sale",count(DISTINCT SELLER_ADDRESS)as "unique seller",
avg(price_usd) as "avg price",
count(DISTINCT buyer_address) as "unique buyer",
sum(PRICE_USD) as "total volume sale",
count(DISTINCT tokenid) as "total nft sale"
from ethereum.core.ez_nft_sales
where PROJECT_NAME = 'lazy lions'
and event_type = 'sale'
Run a query to Download Data