sprigithasen22Untitled Query
    Updated 2022-11-27
    select
    trunc(block_timestamp,'day') as date,
    --distinct contract_name as contract,
    count(distinct tx_id) as n_daily_sales,
    sum(event_data:price) as daily_sales_volume,
    count(distinct event_data:seller) as daily_sellers,
    sum(n_daily_sales) over (order by date) as cum_sales,
    sum(daily_sales_volume) over (order by date) as cum_volume_sales,
    sum(daily_sellers) over (order by date) as cum_sellers
    from flow.core.fact_events x
    join flow.core.dim_contract_labels y
    on x.event_contract=y.event_contract
    and contract_name like '%AllDay%'
    group by 1
    order by 1 asc
    --limit 10
    Run a query to Download Data