flipside

    Solend TVL Tracking - Pool Type - Borrowing
    CryptoIcicleSolend TVL Tracking - Pool Type - Borrowing
    Updated 2022-08-25
    -- 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
    main_pools_Reserve as (
    select column1 AS token, column2 AS Contract
    from ( VALUES
    ('Sol', '8PbodeaosQP19SjYFx855UMqWxH2HynZLdBXmsrbac36')
    ,('USDC','BgxfHJDzm44T7XG68MYKx7YisTjZu73tVovyZSjJMpmw')
    ,('soETH', '3PArRsZQ6SLkr1WERZWyC6AqsajtALMq4C66ZMYz4dKQ')
    ,('BTC','GYzjMCXTDue12eUGKKWAqtF5jcBYNmewr6Db6LaguEaX')
    ,('SRM', '5suXmvdbKQ98VonxGCXqViuWRu8k4zgZRxndYKsH2fJg')
    ,('USDT', '8K9WC8xoh2rtQNY7iEGXtPvfbDCi563SdWhCAhuMP2xE')
    ,('soFTT', '2dC4V23zJxuv521iYQj8c471jrxYLNQFaGS6YPwtTHMd')
    ,('RAY', '9n2exoMQwMTzfw6NFoFFujxYPndWVLtKREJePssrKb36')
    ,('SBR', 'Hthrt4Lab21Yz1Dx9Q4sFW4WVihdBUTtWRQBjPsYHCor')
    ,('MER', '5Sb6wDpweg6mtYksPJ2pfGbSyikrhR8Ut8GszcULQ83A')
    ,('mSOL', 'CCpirWrgNuBVLdkP2haxLTbD6XqEgaYuVXixbbpxUB6')
    ,('ETH', 'CPDiKagfozERtJ33p7HHhEfJERjvfk1VAjMXAFLrvrKP')
    ,('SLND', 'CviGNzD2C9ZCMmjDt5DKCce5cLV4Emrcm3NFvwudBFKA')
    ,('scnSOL', 'DUExYJG5sc1SQdMMdq6LdUYW9ULXbo2fFFTbedywgjNN')
    Run a query to Download Data