Unit Zero Labsmaple-2
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
›
⌄
-- Maple Finance TVL Tracking System
-- This query tracks TVL for Maple Finance pools on Ethereum with a more accurate approach
-- by properly handling the flow of funds across pool components
-- Pool configuration (same as original)
WITH pool_config AS (
SELECT * FROM (
VALUES
-- Pool Name, Pool Address, Pool Manager, Fixed Term Loan Manager, Open Term Loan Manager, Withdrawal Manager, Token Address, Token Symbol, Decimals
('AQRU Pool', '0xe9d33286f0E37f517B1204aA6dA085564414996d', '0xA9c908Ee077eE26B52137FfF714150C7Eb69E160', '0xd05998A1940294E3E49f99DBB13fe20A3483F5Ae', '0x483082e93635ef280bc5E9f65575A7ff288aBA33', '0x515f77Fc8E1473591a89181a2Cf6CD0AAf3f932d', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', 'USDC', 6),
('Cash Management USDC', '0xfe119e9C24ab79F1bDd5dd884B86Ceea2eE75D92', '0x219654A61a0BC394055652986BE403fa14405Bb8', '0xf4d4a5270aa834A2a77011526447fDF1e227018f', '0xfAB269CB4Ab4D33A61e1648114f6147742F5eeCC', '0x447dcEa1d616f792645ed6E71bC32955A0dBcbAa', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', 'USDC', 6),
('Blue Chip Secured Lending USDC', '0xc1dD3F011290F212227170F0D02F511EBF57E433', '0x5eE9587Bf5f4ccceEEd87B0216a31EBb513fAC25', '0x91582bDFEF0Bf36Fc326A4aB9b59aAcD61c105fF', '0xdC9b93A8A336fe5dc9DB97616eA2118000d70fc0', '0xf18066Db3A9590C401e1841598ad90663B4C6d23', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', 'USDC', 6),
('High Yield Corporate Loan USDC', '0x6174A27160f4D7885Db4FFeD1C0b5fbD66c87F3a', '0x81525e55ccfec06f11f1Fdeaf446652c4eC2064F', '0xEca9d2C5f81DD50DCe7493104467dC33362a436F', '0x2638802a78D6a97d0041CC7B52fb9A80994424cd', '0xEb7B1e9C750190214cDFbbAf0ABE398A5e47D230', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', 'USDC', 6),
('High Yield Corporate Loan WETH', '0xCCBc525ED9d85Ad8325b7b6C4C6A79f5566dEa3B', '0xed8b578A01f3CD65488fC19D37E2285eF934e54A', '0xc82095C002E726e4b3C8c26eE769b44C772ef9f7', '0xe3AAC29001c769FAfCef0df072ca396e310ed13b', '0x58A534945f357aa0d2fb56b8BDf7dfA1073bd7a1', '0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2', 'WETH', 18),
('High Yield Secured Lending USDC', '0xC39a5A616F0ad1Ff45077FA2dE3f79ab8eb8b8B9', '0x9ceF7d1D390A4811bBa1BC40A53B40a506C33B19', '0x78a13c2f24dF55feeF7f8C895396cf1DD21Cf56f', '0xb50D675f3C6D18ce5cCAc691354f92aFebD1675E', '0x8A665131e796203a5232527fac441480e02fbB7F', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', 'USDC', 6),
('Maple Lend+Long USDC1', '0x37154b07d58cD736a09ED93CED06613A06F93081', '0x9Aeb8e5EA0e4035fc681cBe1f03A351BBEc253df', '0x5ad7130cC75b617D45cB908245c2D3D3507F054E', '0x56EF41693F69D422A88Cc6492888a1bd41923d33', '0x98c0d6Cd8aF6274801de98aead27dC9ef03c6Ab2', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', 'USDC', 6),
('Maple Lend+Long USDC2', '0xC9c9BAB51B02b4E60a828a09803305772Ae1D2eB', '0x036F141111E370cB9c4Fcc734BBd89D44478cb79', '0x09f533dB668811D50707692812A2eed6B0836922', '0x9aB77dbd4197C532F9c9f30a7E83A710E03da70a', '0xc512E614Ac4d0d4FF9e548F4caD8dfE63B8a36C1', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', 'USDC', 6),
('Syrup USDC', '0x80ac24aA929eaF5013f6436cdA2a7ba190f5Cc0b', '0x7aD5fFa5fdF509E30186F4609c2f6269f4B6158F', '0x4A1c3F0D9aD0b3f9dA085bEBfc22dEA54263371b', '0x6ACEb4caBa81Fa6a8065059f3A944fb066A10fAc', '0x1bc47a0Dd0FdaB96E9eF982fdf1F34DC6207cfE3', '0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48', 'USDC', 6),
('Syrup USDT', '0x356B8d89c1e1239Cbbb9dE4815c39A1474d5BA7D', '0x0cdA32E08B48bFDDbc7eE96B44b09cf286F9E21a', '0xC17aa0Cb662bC4787bB16bD3Bc13d0d88eB7aBDd', '0x616022E54324eF9c13B99c229Dac8ea69AF4FAFf', '0x86eBDf902d800F2a82038290B6DBb2A5eE29eB8C', '0xdAC17F958D2ee523a2206206994597C13D831ec7', 'USDT', 6)
) AS t(pool_name, pool_address, pool_manager, fixed_term_loan_manager, open_term_loan_manager, withdrawal_manager, token_address, token_symbol, decimals)
),
-- Add strategy contracts where available (same as original)
pool_strategies AS (
SELECT * FROM (
VALUES
-- Pool Name, Aave Strategy, Sky Strategy
('High Yield Secured Lending USDC', '0x87Aa770f610679DFC2553FB95fAc1B4d996BA1cd', '0xe3eE1b26AF5396Cec45c8C3b4c4FD5136A2455CC'),
('Maple Lend+Long USDC1', '0x36C2C86a929E72afb23235d5E91e50809CBfA2Ae', '0xb390AeA520885b02af36EC3c96f79b3Bb81C5807'),
('Maple Lend+Long USDC2', '0xd6E084eF7f48653cB4F9D5a2679aE7B4974C7058', '0x34E7014E2Ef62C2F3Cc8c8c25Ac0110E2aA33B00'),
('Syrup USDC', '0x560B3A85Af1cEF113BB60105d0Cf21e1d05F91d4', '0x859C9980931fa0A63765fD8EF2e29918Af5b038C'),
('Syrup USDT', '0x2b817B822B0ddd4597a92dBEd1bD0a6796CA37E0', NULL)
) AS t(pool_name, aave_strategy, sky_strategy)
),
-- Pool related addresses consolidated
Run a query to Download Data