mattkstewHot Contracts on Osmosis 1
    Updated 2022-07-10
    with tab1 as (
    select
    distinct pool_ids[0],
    min(date_trunc('day', block_timestamp)) as date1
    from osmosis.core.fact_swaps
    where block_timestamp > '2022-05-01'
    group by 1
    )

    select
    date1,
    count(*)


    from tab1
    group by 1
    Run a query to Download Data