MahrooUntitled Query
    Updated 2022-10-19
    with DAU as
    (select distinct tx_from as user,
    count(*) as trades
    from osmosis.core.fact_transactions
    where block_timestamp like '2022%'
    group by 1
    having count(*) >= 146
    )

    select count(distinct trader),
    count(*),
    count(distinct pool_ids)
    from osmosis.core.fact_swaps s
    left outer join osmosis.core.dim_labels d ON
    d.address = s.to_currency
    where block_timestamp like '2022%'
    and trader in (select user from DAU)
    Run a query to Download Data