CryptoIcicleSolend TVL Tracking - Pool Type - TVL
Updated 2022-08-25
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
›
⌄
-- Solend TVL Tracking
-- On August 17th, Solend announced their permissionless pools, where anyone can now create a pool. How has this influenced user behavior on Solend so far compared to prior user activity? How many users have used a permissionless pool?
-- Payout 3.37 SOL
-- Grand Prize 10.11 SOL
-- Payout Network Solana
-- Level Advanced
-- Difficulty Elite
-- On August 17th, Solend announced their permissionless pools, where anyone can now create a pool.
-- https://twitter.com/solendprotocol/status/1560003756736925696
-- How has this influenced user behavior on Solend so far compared to prior user activity?
-- How many users have used a permissionless pool?
-- What is the % of TVL contributed from isolated and permissionless pools, against the main pool over time?
-- What is the amount/% of TVL that comes from PDAs/integrations or DAOs/Realm addresses, instead of normal signers?
-- Overall how healthy does Solend appear as a protocol nd is it gaining traction in the Solana ecosystem?
-- SQL Credit: https://app.flipsidecrypto.com/velocity/queries/7f2d7e38-e9cc-4c20-99fd-dd39eaa52fed
with
solana_swaps AS (
SELECT
SWAP_PROGRAM ,BLOCK_TIMESTAMP ,BLOCK_ID ,TX_ID ,SUCCEEDED ,SWAPPER ,
SWAP_FROM_AMOUNT ,
SWAP_FROM_MINT,
a.address_name as from_asset,
SWAP_TO_AMOUNT,
SWAP_TO_MINT,
b.address_name as to_asset,
SWAP_TO_AMOUNT/SWAP_FROM_AMOUNT as ratio
FROM solana.core.fact_swaps
LEFT JOIN solana.core.dim_labels a ON SWAP_FROM_MINT = a.address
LEFT JOIN solana.core.dim_labels b ON SWAP_TO_MINT = b.address
WHERE SUCCEEDED = 'TRUE' AND block_timestamp >= '{{ start_date }}'
),
stables AS (
SELECT
Run a query to Download Data