UNSTAKE_FEES_MSOL | START_BLOCK | END_BLOCK | REFRESHED_AT | |
|---|---|---|---|---|
1 | 1.175185051 | 2025-03-01 00:00:00.000 | 2025-04-01 00:00:00.000 | 2025-04-02 13:12:32.216 |
lj1024Liquid unstake fees
Updated 2025-04-02
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
›
⌄
WITH
txns AS (
SELECT
*
FROM
solana.core.fact_transactions
WHERE
SUCCEEDED = TRUE
AND BLOCK_TIMESTAMP between '2025-03-01' and '2025-03-31'
AND CAST(LOG_MESSAGES AS STRING) LIKE '%Program log: treasury_msol_cut%'
)
SELECT
COALESCE(
sum(
post.value:uiTokenAmount:uiAmount::double - pre.value:uiTokenAmount:uiAmount::double
),
0
) as unstake_fees_msol,
date_trunc('month', dateadd('month', -1, CURRENT_DATE)) as start_block,
date_trunc('month', CURRENT_DATE) as end_block,
CURRENT_TIMESTAMP as refreshed_at
FROM
txns,
LATERAL FLATTEN(input => pre_token_balances) pre,
LATERAL FLATTEN(input => post_token_balances) post
WHERE
pre.value:owner::string = '89SrbjbuNyqSqAALKBsKBqMSh463eLvzS4iVWCeArBgB'
AND post.value:owner::string = '89SrbjbuNyqSqAALKBsKBqMSh463eLvzS4iVWCeArBgB'
AND pre.value:mint::string = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
AND post.value:mint::string = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
AND post.value:uiTokenAmount:uiAmount::double > pre.value:uiTokenAmount:uiAmount::double
Last run: 15 days ago
1
93B
885s