Pine Analyticsaverage-cyan copy
    Updated 2025-04-07
    select
    case when swap_from_mint like 'bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1' then swap_to_symbol
    when swap_to_mint like 'bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1' then swap_from_symbol
    else 'Other' end as pair_token,
    sum(
    case when not SWAP_TO_AMOUNT_USD is null then SWAP_TO_AMOUNT_USD
    when not SWAP_FROM_AMOUNT_USD is null then SWAP_FROM_AMOUNT_USD end
    ) as swap_volume_usd,
    count(distinct swapper) as swappers,
    count(distinct tx_id) as swaps
    from solana.defi.ez_dex_swaps
    where (swap_from_mint like 'bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1'
    or swap_to_mint like 'bSo13r4TkiE4KumL71LsHTPpL2euBYLFx6h9HP3piy1')
    and block_timestamp > current_date - 30
    group by 1
    order by 2 desc


    Last run: 17 days ago
    PAIR_TOKEN
    SWAP_VOLUME_USD
    SWAPPERS
    SWAPS
    1
    SOL11309133.14175957148
    2
    JUP2618163.144094111
    3
    JITOSOL554754.935026283
    4
    KMNO274478.2446617754
    5
    VEUR245702.681279898
    6
    VCHF209946.5615114159
    7
    BORG192319.141442809
    8
    SLND187750.121352899
    9
    184717.1814716726
    10
    SAVE84487.29531032
    11
    USDC45241.9547210458
    12
    BONK27070.442497713
    13
    PYTH22691.262325127
    14
    BLZE10310.8777849
    15
    MOTHER6497.78138981
    16
    PYUSD5447.97581519
    17
    $WEN2102.6861922
    18
    DRIFT2041.1360590
    19
    MSOL1612.144236
    20
    ZEX1334.9540564
    37
    847B
    11s