mlhTVL in last 100000 blocks
    Updated 2022-07-06
    with dex as (
    select platform,
    POOL_NAME,
    sum(AMOUNT_IN_USD-AMOUNT_OUT_USD) as TVL

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

    select *
    from dex
    where TVL>100000

    Run a query to Download Data