adriaparcerisasOmosis contracts
    Updated 2022-07-12
    WITH
    contracts as (
    select
    distinct value as contracts, min(block_timestamp) as debut
    --count(distinct tx_id) as counts
    from osmosis.core.fact_swaps , table(flatten(input => pool_ids )) where block_timestamp between '2022-05-01' and CURRENT_DATE-1
    group by 1 order by 2 asc
    --limit 10
    )
    SELECT
    trunc(debut,'day') as date,
    count(distinct contracts) as contract_name,
    sum(contract_name) over (order by date) as cum_contracts
    from contracts
    group by 1
    order by 1 asc
    Run a query to Download Data