MLDZMNENI18
Updated 2023-01-04
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
distinct BUYER_ADDRESS as buyer,
count(distinct tx_hash) as sale_no,
sum(PRICE) as volume,
sum(price_usd) as volume_usd,
row_number() over (order by volume_usd desc) as rank1
from ethereum.core.ez_nft_sales
where BLOCK_TIMESTAMP between '2022-01-01' and '2023-01-01'
and price_usd>0
group by 1 having volume_usd is not null
order by 4 desc limit 10
Run a query to Download Data