adriaparcerisasAvalanche Sushiswap swap pairs
Updated 2022-08-04
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
info as (
select
distinct event_inputs:pair as pair_address,
event_inputs:token0 as address_in,
event_inputs:token1 as address_out,
case when address_in='0x6c7b8dc81ae49ea793998a0c784db9bc05981a3c' then 'Only Graded Coin' --18
when address_in='0x93eb4003a17119cbc3704dfd2cf218b5f2837fc6' then 'CRYPTOWINX' --9
when address_in='0x061900514d805c1722be288c090985d29370972d' then 'SAITAMA' --9
when address_in='0x5de95b9e4c2b0fcbc225c797b45a84c4f8499f1a' then 'LoveCoin' --18
when address_in='0x47afacadc6773dc4b8177bc7ac3dd96383800380' then 'Covenant' --18
when address_in='0x47536f17f4ff30e64a96a7555826b8f9e66ec468' then 'Curve DAO Token' --18
when address_in='0x2597dc2c0cfaeb1d6e02d365658e6e31cfc9cff0' then 'AVAX Land' --18
when address_in='0x27c272d56a043d57e1c8c86a974052103774bdbf' then 'Geden' --18
when address_in='0x959b88966fc5b261df8359961357d34f4ee27b4a' then 'Universe' --18
when address_in='0x8031c44b96ec8c9b66ab16c2c164e8deeb361a3f' then 'Lira' --18
when address_in='0xf8eb54c65eb9ade9b7c5e41b76058d284ebff472' then 'Persia' --18
when address_in='0xfd46f44a5ad3227a7325b695b6ea1aa549862309' then 'Lira' --18
else z.address_name end as token_in,
case when address_out='0x6c7b8dc81ae49ea793998a0c784db9bc05981a3c' then 'Only Graded Coin' --18
when address_out='0x93eb4003a17119cbc3704dfd2cf218b5f2837fc6' then 'CRYPTOWINX' --9
when address_out='0x061900514d805c1722be288c090985d29370972d' then 'SAITAMA' --9
when address_out='0x5de95b9e4c2b0fcbc225c797b45a84c4f8499f1a' then 'LoveCoin' --18
when address_out='0x47afacadc6773dc4b8177bc7ac3dd96383800380' then 'Covenant' --18
when address_out='0x47536f17f4ff30e64a96a7555826b8f9e66ec468' then 'Curve DAO Token' --18
when address_out='0x2597dc2c0cfaeb1d6e02d365658e6e31cfc9cff0' then 'AVAX Land' --18
when address_out='0x27c272d56a043d57e1c8c86a974052103774bdbf' then 'Geden' --18
when address_out='0x959b88966fc5b261df8359961357d34f4ee27b4a' then 'Universe' --18
when address_out='0x8031c44b96ec8c9b66ab16c2c164e8deeb361a3f' then 'Lira' --18
when address_out='0xf8eb54c65eb9ade9b7c5e41b76058d284ebff472' then 'Persia' --18
when address_out='0xfd46f44a5ad3227a7325b695b6ea1aa549862309' then 'Lira' --18
else zz.address_name end as token_out,
concat(token_in,'-',token_out) as swap_pair,
case when token_in = 'usd coin' then 6
when token_in in ('ampleforth: ampl token','CRYPTOWINX','SAITAMA') then 9
else 18 end as token_in_decimals,
Run a query to Download Data