SocioAnalyticaAptos DeFi Protocols Specific Info
Updated 2024-12-14
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 parameter_settings as (
select
'{{aptos_defi_protocol}}' as selected_protocol
)
--,
--Aptos High-level Dashboard https://flipsidecrypto.xyz/SocioAnalytica/aptos-high-level-dashboard-T_h9TB
--suggested_dashboards as (
SELECT
protocol,
category,
description,
case when selected_protocol = 'Aries Markets' then '💸'
when selected_protocol = 'Amnis Finance' then '💸'
when selected_protocol = 'Echo Lending' then' '
when selected_protocol = 'Thala LSD' then ' '
when selected_protocol = 'TruStake' then ' '
when selected_protocol = 'Echelon Market' then '💸'
when selected_protocol = 'Cellana Finance' then' '
when selected_protocol = 'Thala CDP' then ' '
when selected_protocol = 'Meso Finance' then '💸'
when selected_protocol = 'LiquidSwap' then '💸'
when selected_protocol = 'ThalaSwap' then ' '
when selected_protocol = 'Superposition' then '💸'
when selected_protocol = 'PancakeSwap AMM' then ' '
when selected_protocol = 'Aptin Finance V2' then '💸'
when selected_protocol = 'Joule Finance' then '💸'
when selected_protocol = 'Ondo Finance' then ' '
else '🤷'
end as points,
case when selected_protocol = 'Aries Markets' then 'https://flipsidecrypto.xyz/Yousefi_1994/aries-markets-lending-dashboard-sAin6h'
when selected_protocol = 'Amnis Finance' then 'https://flipsidecrypto.xyz/BlockTracker/amnis-finance-aptos-staking-JVLg70'
when selected_protocol = 'Echo Lending' then'https://flipsidecrypto.xyz/Sbhn_NP/echo-lending-on-aptos-vI7V1g'
when selected_protocol = 'Thala LSD' then'https://flipsidecrypto.xyz/SocioAnalytica/thala-finance-a-comprehensive-analysis-JQ7NQY?tabIndex=3'
-- when protocol = 'TruStake' then'
when selected_protocol = 'Echelon Market' then 'https://flipsidecrypto.xyz/0xHaM-d/echelon-hub-wVqxu9'
QueryRunArchived: QueryRun has been archived