UNSTAKE_TXNS | TOTAL_UNSTAKERS | TOTAL_UNSTAKED_AVUSD | AVG_UNSTAKED_PER_USER | AVG_UNSTAKED_PER_TXN | |
|---|---|---|---|---|---|
1 | 72 | 62 | 1187783.00484152 | 19157.79040067 | 16496.986178354 |
feyikemiUnstake Totals
Updated 2025-03-24
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
COUNT(DISTINCT TX_HASH) AS Unstake_txns,
COUNT(DISTINCT DECODED_LOG:"sender") AS Total_Unstakers,
SUM(DECODED_LOG:"assets"/1e18) AS Total_Unstaked_avUSD,
SUM(DECODED_LOG:"assets"/1e18) / COUNT(DISTINCT DECODED_LOG:"sender") AS Avg_Unstaked_Per_User,
SUM(DECODED_LOG:"assets"/1e18) / COUNT(DISTINCT TX_HASH) AS Avg_Unstaked_Per_Txn
FROM avalanche.core.ez_decoded_event_logs
WHERE CONTRACT_ADDRESS = '0x06d47f3fb376649c3a9dafe069b3d6e35572219e'
AND EVENT_NAME = 'Withdraw'
AND TX_SUCCEEDED = 'TRUE'
Last run: 2 months ago
1
57B
4s