SpiltadavidSolend TVL Tracking 1
    Updated 2022-08-22
    --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