saeedmznAxelar - 10. Squid DEX Usage - popular dexes total
Updated 2023-04-14
999
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 squid_tx as (select block_timestamp, tx_hash , sender ,amount , source_chain , destination_chain
from axelar.core.ez_squid
-- where tx_hash ='0xb8a6852f7f7149063174ecf8d267c6066f1001eb44f8e654dec2ff8c5cf90daa'
),
polygin_tx as (
select s.block_timestamp date ,
tx_hash ,
sender ,
row_number () over (partition by tx_hash,destination_chain order by date desc) destination_chain_rank ,
destination_chain,
max(s.amount) amount,
case when to_address in
('0xce825fd2ddc0fa50fdcb3248ef82c38e6ffb1925','0x88f3c15523544835ff6c738ddb30995339ad57d6',
'0x7f9121b4f4e040fd066e9dc5c250cf9b4338d5bc','0xc4e595acdd7d12fec385e5da5d43160e8a0bac0e',
'0x9a8b2601760814019b7e6ee0052e25f1c623d1e6','0xd0e5d1fb39b4d572ac2610a29e696d383d3f9b41',
'0xf3eb2f17eafbf35e92c965a954c6e7693187057d','0xde92e7fbe021344ba02d9225792d219d3a2ddd58',
'0x0cdf4195ed44fd661b4df304fb453096671b4099','0xeef611894ceae652979c9d0dae1deb597790c6ee',
'0x369582d2010b6ed950b571f4101e3bb9b554876f','0xa374094527e1673a86de625aa59517c5de346d32',
'0x65752c54d9102bdfd69d351e1838a1be83c924c6','0xcd353f79d9fade311fc3119b841e1f456b54e858',
'0x1366c529a133d4153211410126f12aa4e31aaac5','0xb5a7c572741d77f34d2096f928beb6168f31a621',
'0xadbf1854e5883eb8aa7baf50705338739e558e5b','0xb0e69f24982791dd49e316313fd3a791020b8bf7',
'0x9b5c71936670e9f1f36e63f03384de7e06e60d2a','0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45',
'0x383be588327216586e131e63592a2dc976a16655','0xf69e93771f11aecd8e554aa165c3fe7fd811530c',
'0x604229c960e5cacf2aaeac8be68ac07ba9df81c3','0x67e708986a809acefde16f2417fa5701241e3935',
'0x6e7a5fafcec6bb1e78bae2a1f0b612012bf14827','0x98b9162161164de1ed182a0dfa08f5fbf0f733ca'
)
then 'UniSwap'
when to_address in ('0x0319000133d3ada02600f0875d2cf03d442c3367')
then 'SushiSwap'
when to_address in
('0x034293f21f1cce5908bc605ce5850df2b1059ac0','0xa8eca6cc6fb9f8cfa9d3b17d4997cce79e5110cf',
'0x019011032a7ac3a87ee885b6c08467ac46ad11cd','0x0359001070cf696d5993e0697335157a6f7db289'
)
then 'ApeSwap'
when to_address in
Run a query to Download Data