flipside

    Avg Swap Count per User
    Eman-RazAvg Swap Count per User
    Updated 2025-01-27
    with tab1 as (select trader, count(distinct tx_id) as swap_count
    from flow.defi.ez_dex_swaps
    where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}'
    group by 1)

    select round(avg(swap_count)) as avg
    from tab1
    Last run: 3 months ago
    AVG
    1
    		17
    1
    6B
    1s