flipside

    slimy-amaranth
    m3jislimy-amaranth
    Updated 2025-01-23
    SELECT
    SYMBOL_IN,
    SUM(
    CASE
    WHEN AMOUNT_IN_USD IS NULL THEN AMOUNT_OUT_USD
    ELSE AMOUNT_IN_USD
    END) AS TOTAL_VOLUME_USD
    FROM
    sei.defi.ez_dex_swaps
    WHERE
    SYMBOL_IN ILIKE 'j%'
    OR SYMBOL_OUT ILIKE 'j%';
    GROUP BY 1
    Last run: about 2 months ago
    SYMBOL_IN
    TOTAL_VOLUME_USD
    1
    2
    		JVL43759.68970903
    3
    		WSEI3097.609545686
    4
    		JAJ12953.835902548
    5
    		JPEG889.111416154
    6
    		JEISUS44.269083243
    7
    		JandJ4.252477648
    8
    		JUNODEFI32.517011462
    9
    		jeseipinkman13.474760818
    10
    		JAYNFT36.54115945
    11
    		JELLY452.703372824
    12
    		JAY138.440403971
    13
    		JACK0.6587060159
    14
    		JUJU512.362837007
    15
    		JUJUTSU1098.051281472
    16
    		JTT15.220647684
    17
    		JAPAN93.340718736
    18
    		JBKS0.3791888745
    19
    		JASPER121.33332728
    20
    		JLY575.962783569
    32
    742B
    1s