mlhtvl and symbol
    Updated 2022-07-06
    with dex as (
    select platform,
    POOL_NAME,
    SYMBOL_IN,
    SYMBOL_OUT,
    sum(AMOUNT_IN_USD-AMOUNT_OUT_USD) as TVL,
    sum(AMOUNT_IN_USD) as volume

    from ethereum.core.ez_dex_swaps
    where AMOUNT_IN_USD-AMOUNT_OUT_USD>0
    and BLOCK_NUMBER>14990994
    group by 1,2, 3, 4)

    select POOL_NAME,
    SYMBOL_IN, volume
    from dex
    where TVL>100000

    Run a query to Download Data