mooolmUntitled Query
Updated 2023-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select case when NFT_ADDRESS=lower('0x231d3559aa848Bf10366fB9868590F01d34bF240') then 'Valhalla'
end as nft,
count (distinct tx_hash) as total_sales,
count (distinct buyer_address) as total_buyer,
count (distinct seller_address) as total_seller,
count (distinct tokenid) as total_token,
sum (price_usd) as total_usd_vol,
avg (price_usd) as avg_usd_vol,
min (price_usd) as min_usd_vol,
max (price_usd) as max_usd_vol
from ethereum.core.ez_nft_sales
where NFT_ADDRESS=lower('0x231d3559aa848Bf10366fB9868590F01d34bF240')
and price_usd > 0
group by 1
Run a query to Download Data