flipside

    By token pair
    Afonso_DiazBy token pair
    Updated 2025-03-04
    with

    main as (
    select
    tx_id,
    block_timestamp,
    trader as user,
    nvl(amount_in_usd, amount_out_usd) as amount_usd,
    token_in_symbol as symbol_in,
    token_out_symbol as symbol_out
    from
    flow.defi.ez_dex_swaps
    where
    amount_usd <= 1e6
    and platform ilike 'increment%'
    )

    select
    symbol_in || ' -> ' || symbol_out as token_pair,
    count(distinct tx_id) as transactions,
    count(distinct user) as users,
    sum(amount_usd) as total_volume_usd,
    avg(amount_usd) as average_amount_usd
    from
    main
    where
    token_pair is not null
    group by 1
    order by total_volume_usd desc
    Last run: about 2 months ago
    TOKEN_PAIR
    TRANSACTIONS
    USERS
    TOTAL_VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    		USDC -> FLOW694015643733581.07566064533.368725094
    2
    		FLOW -> USDC732915353610699.80137748487.602944143
    3
    		USDC.E -> FLOW20784312116415.427533261012.154676008
    4
    		FLOW -> USDC.E24675031465977.4106331582.661927915
    5
    		FDUST -> FLOW296532053525.33401525617.128106885
    6
    		FLOW -> CEWETH30814937087.63159171112.386762399
    7
    		FLOW -> FDUST94717529906.8443874129.87696742
    8
    		CEWETH -> FLOW33213418732.5610253453.829198349
    9
    		CEWBTC -> FLOW40168304.571807313193.129576914
    10
    		FLOW -> CEWBTC53195553.15947521597.423850442
    11
    		FDUST -> USDC40485110.6855988440.2305949976
    12
    		USDC -> FDUST2504757.9223773780.2032364119
    12
    665B
    3s