DEPOSIT_TX | USER_COUNT | DEPOSIT_AMOUNT | WITHDRAW_AMOUNT | NET_AMOUNT | AVG_AMOUNT | PERC_FILLED | LATEST_UPDATE_UTC | |
|---|---|---|---|---|---|---|---|---|
1 | 2276 | 1846 | 3075789.243152 | 202420.624456 | 2873368.618696 | 1262.464243715 | 57.467372374 | 2024-10-16 08:00:07.000 |
h4wkbase total
Updated 8 hours 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
30
31
32
33
34
›
⌄
-- forked from base @ https://flipsidecrypto.xyz/studio/queries/610cf80c-510e-40e7-b1fa-d7ee101b910d
with dbr_lfg as (
select distinct tx_id
from solana.core.fact_events
where program_id = 'DBrLFG4dco1xNC5Aarbt3KEaKaJ5rBYHwysqZoeqsSFE'
and block_timestamp > '2024-10-15'
)
, base as (
select block_timestamp,
case when tx_from = '7od884qfm9vWEdKQALsXZ72xR9hdYedsqmkqHKJwC78G' then 'Withdraw' else 'Deposit' end as type,
case when tx_from = '7od884qfm9vWEdKQALsXZ72xR9hdYedsqmkqHKJwC78G' then tx_to else tx_from end as user_address,
amount,
tx_id
from solana.core.fact_transfers a
-- join dbr_lfg b using (tx_id)
where block_timestamp > '2024-10-15'
and (tx_to = '7od884qfm9vWEdKQALsXZ72xR9hdYedsqmkqHKJwC78G' or tx_from = '7od884qfm9vWEdKQALsXZ72xR9hdYedsqmkqHKJwC78G')
and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and block_id >= 295723843 and block_id <= 295910833
order by block_timestamp desc
)
select
-- type,
count(distinct case when type = 'Deposit' then tx_id else null end) as deposit_tx,
count(distinct case when type = 'Deposit' then user_address else null end) as user_count,
sum(zeroifnull(case when type = 'Deposit' then amount end)) as deposit_amount,
sum(zeroifnull(case when type = 'Withdraw' then amount end)) as withdraw_amount,
deposit_amount - withdraw_amount as net_amount,
net_amount / deposit_tx as avg_amount,
net_amount / 5000000 * 100 as perc_filled,
max(block_timestamp) as latest_update_UTC
from base
Last run: about 8 hours agoAuto-refreshes every 24 hours
1
111B
12s