flipside

    Top pairs
    AzinTop pairs
    Updated 7 days ago
    SELECT
    SUM(COALESCE(AMOUNT_IN_USD,AMOUNT_OUT_USD)) AS Volume
    , CONCAT (SYMBOL_IN , '=>' , SYMBOL_OUT) AS Pair
    FROM
    kaia.defi.ez_dex_swaps
    WHERE
    BLOCK_TIMESTAMP > current_date - 30
    AND
    COALESCE(AMOUNT_IN_USD,AMOUNT_OUT_USD) IS NOT NULL
    GROUP BY 2
    HAVING Volume > 10000
    ORDER BY Volume DESC


    Last run: 7 days ago
    VOLUME
    PAIR
    1
    		7005530.33BORA=>WKLAY
    2
    		6639205.83WKLAY=>BORA
    3
    		5799816.85USD₮=>WKLAY
    4
    		5544279.19WKLAY=>USD₮
    5
    		5419824.04USDT=>WKLAY
    6
    		5370186.82WKLAY=>USDT
    7
    		2687398.35WKLAY=>stKAIA
    8
    		2222759.53stKAIA=>WKLAY
    9
    		2133265.88GRND=>WKLAY
    10
    		1794853.06WKLAY=>GRND
    11
    		1021049MBX=>WKLAY
    12
    		988825.59WKLAY=>MBX
    13
    		791318.62KRWO=>WKLAY
    14
    		716921.32WKLAY=>oXRP
    15
    		716397.52WKLAY=>KRWO
    16
    		597884.71oXRP=>WKLAY
    17
    		434359.67WETH=>WKLAY
    18
    		369519.09AZIT=>WKLAY
    19
    		352795.91WKLAY=>WETH
    20
    		350032.63WKLAY=>AZIT
    52
    1KB
    9s