flipside

    Untitled Query
    messariUntitled Query
    Updated 2023-01-27
    with swap_tx as ( select min(BLOCK_TIMESTAMP::date) as date, trader
    from osmosis.core.fact_swaps
    group by 2)
    ,
    acitve_user as ( select trader, count(DISTINCT(tx_id)) as total_tx
    from osmosis.core.fact_swaps
    where BLOCK_TIMESTAMP >= CURRENT_DATE - 385
    group by 1
    having total_tx > 15)


    select 'New Users' as type, date, count(DISTINCT(trader)) as total_user
    from swap_tx
    where date >= CURRENT_DATE - 385
    group by 1,2
    Run a query to Download Data