DATE | # Deposits | # Withdrawals | # Depositors | # Withdrawers | |
|---|---|---|---|---|---|
1 | 2025-02-15 00:00:00.000 | 14880 | 4603 | 1434 | 1111 |
2 | 2025-03-15 00:00:00.000 | 3796 | 502 | 35 | 26 |
3 | 2025-03-19 00:00:00.000 | 4279 | 1374 | 28 | 32 |
4 | 2025-01-16 00:00:00.000 | 11133 | 6554 | 2091 | 2182 |
5 | 2025-02-26 00:00:00.000 | 10550 | 6144 | 2416 | 1939 |
6 | 2025-03-12 00:00:00.000 | 8404 | 3593 | 38 | 35 |
7 | 2025-03-07 00:00:00.000 | 3852 | 884 | 33 | 54 |
8 | 2025-04-11 00:00:00.000 | 4326 | 80 | 12 | 15 |
9 | 2025-01-15 00:00:00.000 | 11783 | 6216 | 2095 | 1912 |
10 | 2025-03-08 00:00:00.000 | 3839 | 571 | 12 | 26 |
11 | 2025-02-07 00:00:00.000 | 31128 | 8023 | 1644 | 1365 |
12 | 2025-02-11 00:00:00.000 | 31030 | 6554 | 1893 | 1407 |
13 | 2025-02-27 00:00:00.000 | 7460 | 4504 | 1663 | 1415 |
14 | 2025-03-03 00:00:00.000 | 8567 | 4931 | 2041 | 1755 |
15 | 2025-02-23 00:00:00.000 | 2925 | 2700 | 1126 | 879 |
16 | 2025-03-14 00:00:00.000 | 2825 | 1256 | 23 | 51 |
17 | 2025-03-29 00:00:00.000 | 27066 | 2441 | 48 | 60 |
18 | 2025-02-20 00:00:00.000 | 4831 | 3655 | 1555 | 1165 |
19 | 2025-03-27 00:00:00.000 | 16359 | 2364 | 27 | 44 |
20 | 2025-03-01 00:00:00.000 | 5996 | 2353 | 1215 | 933 |
ArioKamino - Deposit/Withtdraw | TXs and Users
Updated 2025-03-31
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
30
31
32
33
›
⌄
select
date_trunc(day, block_timestamp) as date,
count(DISTINCT
case
when event_type = 'depositReserveLiquidityAndObligationCollateral' then tx_id
end
) as "# Deposits",
count(DISTINCT
case
when event_type = 'withdrawObligationCollateralAndRedeemReserveCollateral' then tx_id
end
) as "# Withdrawals",
count(DISTINCT
case
when event_type = 'depositReserveLiquidityAndObligationCollateral' then signers [0]
end
) as "# Depositors",
count(DISTINCT
case
when event_type = 'withdrawObligationCollateralAndRedeemReserveCollateral' then signers [0]
end
) as "# Withdrawers"
from
solana.core.fact_decoded_instructions
where
program_id = 'KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD'
and event_type in (
'depositReserveLiquidityAndObligationCollateral',
'withdrawObligationCollateralAndRedeemReserveCollateral'
)
and block_timestamp >= current_timestamp - interval '{{days}} days'
group by
1
Last run: 16 days ago
91
4KB
4s