Madicommon chart
    Updated 2023-04-30
    select
    date_trunc('day', BLOCK_TIMESTAMP) as date,
    count(distinct TX_HASH) as TX_count,
    count(distinct SELLER_ADDRESS) as Sellers,
    count(distinct BUYER_ADDRESS) as Buyers,
    sum(PRICE_USD) as Sum_usd,
    avg(PRICE_USD) as Avg_usd,
    median(PRICE_USD) as median_usd,
    sum(TOTAL_FEES_USD) as TOTAL_FEES_USD,
    sum(Sellers) over (order by date asc rows between unbounded preceding and current row) as cum_sellers,
    sum(Buyers) over (order by date asc rows between unbounded preceding and current row) as cum_buyers,
    sum(Sum_usd) over (order by date asc rows between unbounded preceding and current row) as cum_sum_usd,
    sum(TX_count) over (order by date asc rows between unbounded preceding and current row) as cum_TX,
    Sellers/Buyers as Seller_Buyer_Ratio
    from optimism.core.ez_nft_sales
    where NFT_ADDRESS = lower('0x0deaAc29d8A3d4EbBAAa3eCd3cC97C9deF00f720') and event_type = 'sale'
    group by date


    Run a query to Download Data