MLDZMNENI18
    Updated 2023-01-04
    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