SpiltadavidSolend TVL Tracking 1
Updated 2022-08-22Copy 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
35
36
›
⌄
--Solend TVL Tracking
with
Permissionless_Pools_Reserve as (
select column1 AS token, column2 AS Contract
from ( VALUES
('SOL', '4Uzuzwuh1CAV4y6cg9BeQc6U3GU8dHPSJN6dfjmBwuu8')
,('USDC', '7xW8MBuRgys1bxaS6sLzUdAQhrrfw6QpLmT1ikmEUF1B')
,('CRP', 'CiS2rat4VVCwe8QEVaXm1T5LqbKx6var4mazBrxwg7iE')
,('DUST', 'R1MGtytnkZqHVJFKwG6HzhUuDbhgLorojGRcdyrGoEL')
,('USDC', 'H2d9j9CHZRXUQE2cHpkvnfgg7vMw8ysyALX5dTeT6CQk')
,('SOL', '3csx7zsNWT139JgnvQzL3y3UNqjzdZjQRcfBZJo7X6FP')
,('mSOL', '4S5TTM7Eig5y8zZPCxiw3GEu8zeDDuHNrUrEE6hHz1rc')
,('SLND', 'CxLkG25ybMCUcu5CVtYm9Bn7x9Lcr96wstxAtb53Xrcr')
,('COOL', 'DWmAv5wMun4AHxigbwuJygfmXBBe9WofXAtrMCRJExfb')
)
)
, Pools_mint as (
select column1 AS token, column2 AS Contract
from
( VALUES
('SOL', 'So11111111111111111111111111111111111111112')
,('USDC', 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
,('USDT', 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')
,('CRP', 'DubwWZNWiNGMMeeQHPnMATNj77YZPZSAz2WVR5WjLJqz')
,('mSOL', 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So')
,('SLND', 'SLNDpmoWTVADgEdndyvWzroNL7zSi1dF9PC3xHGtPwp')
,('COOL', 'CooLwkogVDEVCrY3r1Mtcen2H7ejJiW7CSMY7gWDBFNc')
)
)
, Permissionless_Pools_ctoken as (
select
column1 AS token, column2 AS Contract
from ( VALUES
('cSOL (Cropper)', '56YhBhya6Ngt21PCMjxBxQEtomvx3bLhmUvsDW9E6FJp')
,('cUSDC (Cropper)', 'J7FVB8dYfS6NkjmZ8p6KSddPFCqb9dYqxJVAMVj5U1Zv')
,('cCRP (Cropper)', '5ZGPLy13dXa4FoduvVd9XroWvemsuA9nyW7XoDNRYbw4')
Run a query to Download Data