flipside

    Trader count osmosis swaps
    samTrader count osmosis swaps
    Updated 2022-11-15
    select
    'All time trader count' as label,
    count(distinct trader) as trader_count
    from osmosis.core.fact_swaps
    where tx_status = 'SUCCEEDED'

    union all

    select
    'Past 7 days - trader count' as label,
    count(distinct trader) as trader_count
    from osmosis.core.fact_swaps
    where block_timestamp >= CURRENT_DATE - 7
    and tx_status = 'SUCCEEDED'





    Run a query to Download Data