MONTH | LENDING_MARKET | WALLET_ADDRESS | |
|---|---|---|---|
1 | 2024-01-01 00:00:00.000 | Kamino Finance | 101221 |
2 | 2024-01-01 00:00:00.000 | MarginFi | 122543 |
3 | 2024-02-01 00:00:00.000 | MarginFi | 141300 |
4 | 2024-02-01 00:00:00.000 | Kamino Finance | 166799 |
5 | 2024-03-01 00:00:00.000 | MarginFi | 90279 |
6 | 2024-03-01 00:00:00.000 | Kamino Finance | 132313 |
7 | 2024-04-01 00:00:00.000 | MarginFi | 48882 |
8 | 2024-04-01 00:00:00.000 | Kamino Finance | 64110 |
9 | 2024-05-01 00:00:00.000 | MarginFi | 32488 |
10 | 2024-05-01 00:00:00.000 | Kamino Finance | 44109 |
11 | 2024-06-01 00:00:00.000 | MarginFi | 20458 |
12 | 2024-06-01 00:00:00.000 | Kamino Finance | 27867 |
13 | 2024-07-01 00:00:00.000 | MarginFi | 14769 |
14 | 2024-07-01 00:00:00.000 | Kamino Finance | 23493 |
15 | 2024-08-01 00:00:00.000 | MarginFi | 14911 |
16 | 2024-08-01 00:00:00.000 | Kamino Finance | 26382 |
17 | 2024-09-01 00:00:00.000 | MarginFi | 9431 |
18 | 2024-09-01 00:00:00.000 | Kamino Finance | 18743 |
19 | 2024-10-01 00:00:00.000 | MarginFi | 12001 |
20 | 2024-10-01 00:00:00.000 | Kamino Finance | 25841 |
banbannardNumber of Lending Protocol Interacted - MarginFi
Updated 5 days ago
99
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
›
⌄
-- forked from Number of Lending Protocol Interacted 2 @ https://flipsidecrypto.xyz/edit/queries/e193380d-4f86-4584-9b36-dae966a15a54
-- forked from Number of Lending Protocol Interacted @ https://flipsidecrypto.xyz/edit/queries/0ce973ff-2c9e-4c68-b6a8-694834ff95af
WITH base AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS month,
CASE
WHEN program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA' THEN 'MarginFi'
WHEN program_id IN ('KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD', '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc') THEN 'Kamino Finance'
WHEN program_id = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo' THEN 'Solend'
END AS lending_market,
count(distinct(signers[0])) AS wallet_address
FROM solana.core.ez_events_decoded
WHERE succeeded = 'TRUE'
AND program_id IN ('MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA', 'KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD', '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc', 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo')
and block_timestamp >= '2024-01-01'
and block_timestamp::date <= date_trunc('month', current_date) - interval '1 day'
--AND block_timestamp::date <= '{{end_date}}'
and event_type ilike '%deposit%'
group by 1,2
)
select *
from base
where lending_market in ('MarginFi', 'Kamino Finance', 'Solend')
order by 1 asc, wallet_address asc
Last run: 5 days ago
34
2KB
464s