superflyUntitled Query
Updated 2022-10-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select count (distinct tx_hash) as Sales_Count,
count (distinct buyer_address) as Buyers_Count,
count (distinct seller_address) as Sellers_Count,
count (distinct nft_address) as Collections_Count,
count (distinct tokenid) as Tokens_Count,
sum (price_usd) as Total_USD_Volume,
avg (price_usd) as Average_USD_Volume,
median (price_usd) as Median_USD_Volume,
min (price_usd) as Min_USD_Volume,
max (price_usd) as Max_USD_Volume
from optimism.core.ez_nft_sales
where nft_address = '0x52782699900DF91B58eCD618e77847C5774dCD2e'
and price_usd > 0
Run a query to Download Data