Trader JoeAvalanche DEX Volume
Updated 2024-10-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
select
*,
case when protocol in ('woofi swap') then 'WooFi'
when protocol in ('pangolin') then 'Pangolin'
when protocol in ('curve dex','curve') then 'Curve'
when protocol in ('sushiswap v3','sushiswap') then 'SushiSwap'
when protocol in ('joe v2.1','joe v2','trader joe dex') then 'TraderJoe'
else protocol end as protocol_group
from
external.defillama.fact_dex_volume
where
1=1
and chain='avalanche'
and date>='2023-01-01'
and protocol in (
'woofi swap',
'pangolin',
'balancer v2',
'uniswap v3',
'curve dex','curve',
'sushiswap v3','sushiswap',
'wombat exchange',
'joe v2.1','joe v2','trader joe dex',
'pharaoh exchange',
'dexalot',
'hashflow'
)
-- WOO, Dexalot, Pharaorh, Uniswap, Pangolin, Wombat, Curve, Balancer, Hashflow
-- protocol in ('WOOFi Swap','pangolin','Uniswap V3','Curve DEX','Balancer V2','SushiSwap V3','traderjoe','Wombat Exchange','Joe V2.1','Curve','Trader Joe DEX','Pangolin','Joe V2','curve','sushiswap','woofi','Pharaoh Exchange','SushiSwap','WooFi')
/*
select
*,
case when protocol in ('woofi swap') then 'WooFi'