mlhtvl and symbol
Updated 2022-07-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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