TOTAL_DEPOSITS | TOTAL_WITHDRAWALS | NET_STAKED | NET_SAVUSD_STAKED | |
|---|---|---|---|---|
1 | 9026730.10386442 | 1187783.00484152 | 7838947.0990229 | 7712437.59617576 |
feyikemiNet totals
Updated 2025-03-24
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
›
⌄
WITH deposits AS (
SELECT
SUM(DECODED_LOG:"assets"/1e18) AS total_deposits,
SUM(DECODED_LOG:"shares"/1e18) AS Total_savusd
FROM avalanche.core.ez_decoded_event_logs
WHERE contract_address = '0x06d47f3fb376649c3a9dafe069b3d6e35572219e'
AND EVENT_NAME = 'Deposit'
AND TX_SUCCEEDED = 'TRUE'
),
withdrawals AS (
SELECT
SUM(DECODED_LOG:"assets"/1e18) AS total_withdrawals,
SUM(DECODED_LOG:"shares"/1e18) AS Total_savusd_with
FROM avalanche.core.ez_decoded_event_logs
WHERE contract_address = '0x06d47f3fb376649c3a9dafe069b3d6e35572219e'
AND EVENT_NAME = 'Withdraw'
AND TX_SUCCEEDED = 'TRUE'
)
SELECT
d.total_deposits,
w.total_withdrawals,
(d.total_deposits - COALESCE(w.total_withdrawals, 0)) AS net_staked,
(d.total_savUSD - COALESCE(w.total_savusd_with, 0)) AS net_savusd_staked,
FROM deposits d
LEFT JOIN withdrawals w ON 1=1
Last run: 2 months ago
1
70B
5s