mmdrezaAverage per day
    Updated 2023-04-27
    with tab as (
    select block_timestamp::date as date,
    count (distinct tx_hash) as Sales_Count,
    count (distinct buyer_address) as Buyers_Count,
    count (distinct seller_address) as Sellers_Count,
    sum (price_usd) as Total_USD_Volume,
    avg (price_usd) as Average_USD_Volume,
    min (price_usd) as Min_USD_Volume,
    max (price_usd) as Max_USD_Volume,
    sum (total_usd_volume) over (order by date) as Cumulative_Volume,
    sum (sales_count) over (order by date) as Cumulative_Sales_Count
    from optimism.core.ez_nft_sales
    where nft_address = lower('0x2831Aa51DE4E3bB318Cf01eAcd8a7FdbB440ac3A')
    and price_usd > 0
    group by 1)

    select avg (sales_count),avg (buyers_count),avg (sellers_count), avg (total_usd_volume)
    from tab
    Run a query to Download Data