zakkisyedKelpDAO Depositors: User Personas
Updated 2024-06-05
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
›
⌄
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