USER | TOTAL_AMOUNT_USD | |
|---|---|---|
1 | 0x8889ff5b6323e71c28c26d2c34b8bb52654f00a6 | 39643449.78 |
2 | 0x653981c41f15f43907d0cf479282a7dbb88a06a3 | 38086609.53 |
3 | 0xf973c06c8964c1650e210c940db65acbf7f2a48d | 20474668.34 |
4 | 0x8b3d19047c35af317a4393483a356762beec69a5 | 18401595.98 |
5 | 0xc5ed2333f8a2c351fca35e5ebadb2a82f5d254c3 | 18173569.3 |
6 | 0x26e0f27f980c96288b168d61cbd602491213332a | 16727308.99 |
7 | 0x8e864d91daeafad8d252e7475edde7726c52bc86 | 12508641.06 |
8 | 0x283beb41eac2b959ba22139e870956faa35b87e5 | 12306578.33 |
9 | 0x68963dc7c28a36fcacb0b39ac2d807b0329b9c69 | 11083539.08 |
10 | 0xb4caaff781251594911cc76aec61cef46ba00894 | 10920519.79 |
11 | 0x316c15213b097854a0c31565a0ec8705f6f9e72b | 10587426.48 |
12 | 0x1dc67adaf9f163c5b1a95043addbdfa1af58e512 | 9246838.9 |
13 | 0xa9497fd9d1dd0d00de1bf988e0e36794848900f9 | 9135414.73 |
14 | 0xcf57e18cbde017a91f549f69cc9bc34336eca814 | 8589070.41 |
15 | 0xf82ab7d84f27d8d2e7a6b2859b3f7835550e14f0 | 8365372.8 |
16 | 0x2f6ca0a98cf8f7d407e98993fd576f70f0faa80b | 8214759.91 |
17 | 0xb0e628709aca79746c0aab113bf83e75da0c144a | 8140750.23 |
18 | 0x6edba4a5dbb3aec671f2e1b16a67fa3a076a2ed8 | 7885786.15 |
19 | 0xc73df1e68fc203f6e4b6270240d6f82a850e8d38 | 7418519 |
20 | 0xe5f119819aef9b7bf041235b3c41f045dc13966d | 6506203.75 |
damidezTop staker
Updated 2025-02-09
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
35
›
⌄
WITH AvaxPrice AS (
SELECT
TRUNC(hour, 'day') AS date,
AVG(price) AS price_usd
FROM avalanche.price.ez_prices_hourly
WHERE token_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
GROUP BY date
),
Events AS (
SELECT
e.block_timestamp,
e.tx_hash,
e.decoded_log:avaxAmount / 1e18 AS amount,
e.decoded_log:user AS user,
e.event_name,
(e.decoded_log:avaxAmount / 1e18) * p.price_usd AS amount_usd
FROM avalanche.core.ez_decoded_event_logs e
LEFT JOIN AvaxPrice p
ON TRUNC(e.block_timestamp, 'day') = p.date
WHERE e.contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
AND e.event_name IN ('Submitted')
AND amount_usd is not null
)
SELECT
user,
ROUND(SUM(amount_usd), 2) AS total_amount_usd
FROM Events
GROUP BY user
ORDER BY total_amount_usd DESC
Limit 100;
Last run: 2 months ago
100
6KB
6s