flipside

    okx dex platform swapper
    damidezokx dex platform swapper
    Updated 2025-03-10
    WITH okx_aggregator_swaps AS (
    SELECT
    block_timestamp,
    tx_hash,
    origin_from_address AS swapper,
    symbol_in,
    symbol_out,
    platform,
    COALESCE(amount_in_usd, amount_out_usd) AS swap_amount_usd
    FROM avalanche.defi.ez_dex_swaps
    WHERE origin_to_address = '0x1dac23e41fc8ce857e86fd8c1ae5b6121c67d96d'
    AND block_timestamp >= '2024-01-01'
    AND swap_amount_usd is not null
    )
    SELECT platform,
    COUNT(DISTINCT tx_hash) AS tx_count,
    COUNT(DISTINCT swapper) AS unique_swappers,
    SUM(swap_amount_usd) AS volume_usd,
    FROM okx_aggregator_swaps
    GROUP BY platform
    order by unique_swappers desc




    Last run: about 1 month ago
    PLATFORM
    TX_COUNT
    UNIQUE_SWAPPERS
    VOLUME_USD
    1
    		trader-joe-v11904252642459989602.78
    2
    		uniswap-v3654572375344333837.46
    3
    		trader-joe-v26676416572387722833.87
    4
    		pangolin1495368682122494.65
    5
    		pharaoh-v114075271811661645.75
    6
    		sushiswap180513698524.91
    7
    		kyberswap-v21162835110921.29
    8
    		woofi15217898335917.32
    9
    		balancer8644411130562.83
    10
    		curve5663401259766.42
    11
    		gmx3472354588929.98
    12
    		kyberswap-v1957917698.16
    12
    417B
    2s