bobby_daniel3-2 Total Dex Swaps
    Updated 2 days ago
    SELECT
    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')

    Last run: 12 days ago
    SWAP_VOLUME_USD
    SWAPPERS
    SWAPS
    1
    7416298661.1316333014802120
    1
    33B
    493s