STAKE_TXNS | TOTAL_STAKERS | TOTAL_STAKED_AVUSD | TOTAL_SAVUSD_SUPPLIED | AVG_STAKED_PER_USER | AVG_STAKED_PER_TXN | |
|---|---|---|---|---|---|---|
1 | 446 | 251 | 9026730.10386442 | 8877386.96456024 | 35963.068142886 | 20239.305165615 |
feyikemiStake totals
Updated 2025-03-24
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
COUNT(DISTINCT TX_HASH) AS Stake_txns,
COUNT(DISTINCT DECODED_LOG:"sender") AS Total_stakers,
SUM(DECODED_LOG:"assets"/1e18) AS Total_Staked_avUSD,
SUM(DECODED_LOG:"shares"/1e18) AS Total_savusd_supplied,
SUM(DECODED_LOG:"assets"/1e18) / COUNT(DISTINCT DECODED_LOG:"sender") AS Avg_Staked_Per_User,
SUM(DECODED_LOG:"assets"/1e18) / COUNT(DISTINCT TX_HASH) AS Avg_Staked_Per_Txn
FROM avalanche.core.ez_decoded_event_logs
WHERE CONTRACT_ADDRESS = '0x06d47f3fb376649c3a9dafe069b3d6e35572219e'
AND EVENT_NAME = 'Deposit'
AND TX_SUCCEEDED = 'TRUE'
Last run: 2 months ago
1
77B
4s