headitmanagercumulative chart
    Updated 2022-07-11
    with totalcontract as (select count(distinct value)
    from osmosis.core.fact_swaps , table(flatten(input => pool_ids )))
    , top10contract as (select count(*),value
    from osmosis.core.fact_swaps , table(flatten(input => pool_ids ))
    where
    block_timestamp::date > '2022-05-01'
    group by value
    order by count(*) desc
    limit 10)
    , contracts_min_date as (select value, min(block_timestamp::date) as min_date
    from osmosis.core.fact_swaps , table(flatten(input => pool_ids ))
    group by value)

    , cumulative as (select count(*) as count_c , sum(count_c) over (order by min_date) as cumulative_contract ,min_date from contracts_min_date
    where min_date >'2022-05-01'
    group by min_date)

    select * from cumulative


    Run a query to Download Data