hbd1994User Count | Top 10 Protocol to Interact with "csMATIC"
Updated 2022-09-23Copy Reference Fork
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
›
⌄
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'
when origin_to_address = '0x10f4a785f458bc144e3706575924889954946639' then 'Meshswap Swap'
when origin_to_address = '0xa448e9833095ad50693b025c275f48b271ade882' then 'Beefy Vault (Quickswap matix-matic)'
when origin_to_address = '0x00c3e7978ede802d7ce6c6efffb4f05a4a806fd3' then 'Meshswap (Lending & Borrowing)'
when origin_to_address = '0xf2e4209afa4c3c9eaa3fb8e12eed25d8f328171c' then 'Slingshot'
when origin_to_address = '0x2370cb1278c948b606f789d2e5ce0b41e90a756f' then 'Clipper Exchange'
when origin_to_address = '0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31' then 'Metamask Router'
when origin_to_address = '0x1111111254fb6c44bac0bed2854e76f90643097d' then '1inch Router V4'
when origin_to_address = '0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f' then 'Zerion.io'
when origin_to_address = '0xdef1c0ded9bec7f1a1670819833240f027b25eff' then '0x Protocol'
else concat(left(origin_to_address, 5), '...', right(origin_to_address,5))
-- else origin_to_address
end as "Protocol or Platforms Label",
count(distinct origin_from_address) as "User Count Interacted with this Protocols/Platforms",
count(distinct tx_hash) as "Txs Count on each Platform/Protocol"
from
polygon.core.fact_event_logs
where
contract_address = '0x7ed6390f38d554b8518ef30b925b46972e768af8'
and
origin_to_address != '0x7ed6390f38d554b8518ef30b925b46972e768af8'
and
origin_to_address != '0x376b467dff007dd8d3f24404caddff7f72257fe4'
group by 1 order by 2 desc limit 10
Run a query to Download Data