mlhUntitled Query
    Updated 2022-11-03
    select trunc(block_timestamp,'day') as date, count(DISTINCT(tx_hash)) as total_tx,
    count(DISTINCT(buyer_address)) as total_buyer, count(DISTINCT(seller_address)) as total_seller,
    count(DISTINCT(tokenid)) as total_nft, sum(price_usd) as volume, avg(price_usd) as avg_volume,
    avg(volume) over (order by date rows between 7 preceding and 0 following) as ma_7_volume,
    min(price_usd) as min_price, max(price_usd) as max_price, median(price_usd) as median_price,
    sum(total_nft) over (order by date asc) as cum_nft
    from ethereum.core.ez_nft_sales
    where nft_address = lower('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')
    group by 1








    Run a query to Download Data