Ali3NCamelot Exchange Swap Pairs (Ordering By Swap Pair Alphabetical)
Updated 2023-06-30
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
›
⌄
with pairs1 as (
select event_inputs:token0 as Token0_Address,
case when token0_address = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' then 'WETH'
when token0_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'DAI'
when token0_address = '0xff970a61a04b1ca14834a43f5de4533ebddb5cc8' then 'USDC'
when token0_address = '0x9277b5e9ff9a94f4af522eb66f4a268756a73a86' then 'KTES222'
when token0_address = '0xe2b9562005c9f8b5c921d6ddb94193521633dcac' then 'KTES4444'
when token0_address = '0x3fda994d9366651c7bf114f83b155452c61087bd' then 'PARALLEL'
when token0_address = '0xa809e08db0b03e43e342b85710c57ec5298e733a' then 'DSX'
when token0_address = '0xc0af0891549a678d3e5588ec1cc99c6713845f7d' then 'TDEF'
when token0_address = '0xe19cfd416bdb40125e9bae583fb9dd5d0bfc0fb8' then 'TKN'
when token0_address = '0x20aa7fcd549d8b3eb96f6540352dfc947903392a' then 'TTAI'
when token0_address = '0x34d0921b435b57f50415806f060dc5326f33938b' then 'CMLT-LP'
when token0_address = '0x686312523854a76d85160c78fdaeecd2a353b31b' then 'BMA'
when token0_address = '0x809a2f07f22be412c24c69185723286d43a33a59' then 'MAKIS'
when token0_address = '0x74ac3746308fee41612a21cb695497124330f8f4' then 'KTEST1'
when token0_address = '0xa4dadeeb8ede703e7a41cee94cfd7d75cf262c2c' then 'RAMEN'
when token0_address = '0x827e2e6efc2ce7f7e14e65c4dc74ff5512cfd565' then 'FCTR'
else coalesce(t4.symbol,t2.address_name) end as Token0_Name,
case when token0_address = '0x9277b5e9ff9a94f4af522eb66f4a268756a73a86' then '18'
when token0_address = '0xc0af0891549a678d3e5588ec1cc99c6713845f7d' then '18'
when token0_address = '0x3fda994d9366651c7bf114f83b155452c61087bd' then '18'
when token0_address = '0xa809e08db0b03e43e342b85710c57ec5298e733a' then '18'
when token0_address = '0x34d0921b435b57f50415806f060dc5326f33938b' then '18'
when token0_address = '0x686312523854a76d85160c78fdaeecd2a353b31b' then '10'
when token0_address = '0x809a2f07f22be412c24c69185723286d43a33a59' then '18'
when token0_address = '0x20aa7fcd549d8b3eb96f6540352dfc947903392a' then '18'
when token0_address = '0x74ac3746308fee41612a21cb695497124330f8f4' then '18'
when token0_address = '0xa4dadeeb8ede703e7a41cee94cfd7d75cf262c2c' then '9'
when token0_address = '0x827e2e6efc2ce7f7e14e65c4dc74ff5512cfd565' then '9'
when token0_address = '0xe19cfd416bdb40125e9bae583fb9dd5d0bfc0fb8' then '18'
when token0_address = '0xe2b9562005c9f8b5c921d6ddb94193521633dcac' then '18'
else t4.decimals end as token0_Decimal,
event_inputs:token1 as Token1_Address,
case when token1_address = '0x82af49447d8a07e3bd95bd0d56f35241523fbab1' then 'WETH'
when token1_address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'DAI'
Run a query to Download Data