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