zakkisyedKelpDAO Depositors: User Personas
    Updated 2024-06-05
    WITH lending_users AS (
    SELECT DISTINCT depositor
    FROM ethereum.defi.ez_lending_deposits
    WHERE token_address = lower('0xA1290d69c65A6Fe4DF752f95823fae25cB99e5A7')
    ),

    borrowing_users AS (
    SELECT DISTINCT borrower
    FROM ethereum.defi.ez_lending_borrows
    WHERE token_address = lower('0xA1290d69c65A6Fe4DF752f95823fae25cB99e5A7')
    LIMIT 10
    ),

    bridge_users AS (
    SELECT DISTINCT sender
    FROM ethereum.defi.ez_bridge_activity
    WHERE token_address = lower('0xA1290d69c65A6Fe4DF752f95823fae25cB99e5A7')
    LIMIT 10
    ),

    LP_contracts AS (
    SELECT DISTINCT pool_address, platform
    FROM ethereum.defi.dim_dex_liquidity_pools
    WHERE platform LIKE '%rsETH%'
    UNION
    SELECT LOWER('0x58AAdFB1Afac0ad7fca1148f3cdE6aEDF5236B6D') AS pool_address, 'Balancer' AS platform
    UNION
    SELECT LOWER('0xba12222222228d8ba445958a75a0704d566bf2c8') AS pool_address, 'Balancer' AS platform
    UNION
    SELECT LOWER('0x6b4740722e46048874d84306B2877600ABCea3Ae') AS pool_address, 'Pendle' AS platform
    UNION
    SELECT LOWER('0x445d25a1c31445fb29e65d12da8e0eea38174176') AS pool_address, 'Pendle' AS platform
    UNION
    SELECT LOWER('0x730A5E2AcEbccAA5e9095723B3CB862739DA793c') AS pool_address, 'Pendle' AS platform
    UNION
    SELECT LOWER('0xf047ab4c75cebf0eb9ed34ae2c186f3611aeafa6') AS pool_address, 'Zircuit' AS platform
    QueryRunArchived: QueryRun has been archived