NETDEPOSITVOLUME_24H | NETDEPOSITVOLUME_7D | NETDEPOSITVOLUME_30D | |
|---|---|---|---|
1 | 428557.486439317 | -1444698.87369846 | 198883725.838926 |
ArioNet Deposit in the Last 24h/7D/30D
Updated 2025-03-31
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 Deposit_Volume_24H as (
with Deposit as (
select
tx_id,
block_timestamp,
signers [0] as Depositor,
DECODED_INSTRUCTION:accounts [3] :pubkey :: string as lendingMarketAuthority
from
solana.core.fact_decoded_instructions
where
program_id = 'KLend2g3cP87fffoy8q1mQqGKjrxjC8boSyAYavgmjD'
and event_type = 'depositReserveLiquidityAndObligationCollateral'
and block_timestamp >= current_timestamp - interval '24 hours'
group by
1,
2,
3,
4
),
prices as (
select
date_trunc(day, HOUR) as date,
TOKEN_ADDRESS,
SYMBOL,
avg(PRICE) as price
from
solana.price.ez_prices_hourly
where
date >= current_timestamp - interval '1 day'
group by
1,
2,
3
),
Withdraw as (
select
Last run: 27 days ago
1
55B
1104s