nsa2000Top 10 Protocols To Interact With Strado
Updated 2022-09-21
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
›
⌄
-- 0x7ed6390f38d554b8518ef30b925b46972e768af8 csmatic
-- 0xfa68fb4628dff1028cfec22b4162fccd0d45efb6 maticx
-- 0x3a58a54c066fdc0f2d55fc9c89f0415c92ebf3c4 stmatic
select
case
when origin_to_address = '0x617dee16b86534a5d792a4d7a62fb491b544111e' then 'Kyberswap Meta Aggregator'
when origin_to_address = '0xa5e0829caced8ffdd4de3c43696c57f7d7a678ff' then 'QuickSwap'
when origin_to_address = '0x540a9f99bb730631bf243a34b19fd00ba8cf315c' then 'Beefy Swap'
when origin_to_address = '0x8829adf1a9a7face44c8fab3bc454f93f330e492' then 'Beefy Vault (quickswap stmatic-matic)'
when origin_to_address = '0xfb6fe7802ba9290ef8b00ca16af4bc26eb663a28' then 'Curve Finance'
when origin_to_address = '0xba12222222228d8ba445958a75a0704d566bf2c8' then 'Balancer'
when origin_to_address = '0xe0570ddfca69e5e90d83ea04bb33824d3bbe6a85' then 'Beefy Vault (curve stmatic-matic)'
when origin_to_address = '0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45' then 'Uniswap V3 Router'
else concat(left(origin_to_address, 5), '...', right(origin_to_address,5))
-- else origin_to_address
end as label,
count(distinct origin_from_address) as total
from
polygon.core.fact_event_logs
where
contract_address = '0xfa68fb4628dff1028cfec22b4162fccd0d45efb6'
and
origin_to_address != '0xfa68fb4628dff1028cfec22b4162fccd0d45efb6'
group by 1 order by 2 desc limit 10
Run a query to Download Data