MLDZMNENI1
    Updated 2023-01-04
    select
    date_trunc('year',BLOCK_TIMESTAMP) as date,
    count(distinct tx_hash) as sale_no,
    count(distinct BUYER_ADDRESS) as buyer_no,
    count(distinct SELLER_ADDRESS) as seller_no,
    count(distinct TOKENID) as no_nfts,
    sum(PRICE) as volume,
    sum(price_usd) as volume_usd,
    sale_no/buyer_no as average_buyer,
    sum(buyer_no) over (order by date) as cum_buyers,
    sum(sale_no) over (order by date) as cum_sale,
    sum(volume_usd) over (order by date) as cum_volume
    from ethereum.core.ez_nft_sales
    group by 1
    Run a query to Download Data