WALLET_ADDRESS | NET_STAKED_VOLUME | |
|---|---|---|
1 | 0x0d6a0385a012261d6dcc1742786c8ae0910861e1 | 119383.326324428 |
2 | 0xcf28710273b55f9dd6d19088ed4b994af560266b | 59663 |
3 | 0x7822159ee394d14745cde63a706f965fb73c7ac8 | 50024.872242944 |
4 | 0xd065341029327373f1849bbdcf4fb501ac983163 | 19378.635009472 |
5 | 0x8e77e3dba16c13fc95f67378759bf76e37199111 | 18020.316686861 |
6 | 0x8dee2dce2e3295d8931382d340e7b3566f258a89 | 17411.953791618 |
7 | 0xa1e20c4d993608b8c4d719956edfe595bc42c11e | 16509.033000908 |
8 | 0x715a9de73217cedc17441325ce4aa39694ed2ebb | 9992.771916703 |
9 | 0x102407f67415dcc4068370625ca27f24bb2a03d5 | 7503.730836442 |
10 | 0xeea706cf18d836904007aff8e561c20c09182635 | 5914.715460389 |
11 | 0x8041f0df49b8e39f2f545a7ffe2bbd7cd9b4fc91 | 5242.998832803 |
12 | 0x8e7f29ce5116acda8f19d099feae84104dd77f57 | 5160.565820582 |
13 | 0xfdbbfb0fe2986672af97eca0e797d76a0bbf35c9 | 4498.037057542 |
14 | 0xb286b9c9828979536cef48ded6f89d7adf60b991 | 3530.696628762 |
15 | 0x089fd7a9171b11eb30f4f6a32337cbd66afaa83c | 2400.473653549 |
16 | 0xcaa74debeae8b73de8a894e16ceef7625c69c7ff | 2000.394711291 |
17 | 0x94a8007ac85a0c33cb49108fe1855bb786e38e1a | 499 |
18 | 0xf41b9188b4316a368b11172d1c2dfabb819224fb | 398.850347507 |
19 | 0x85cf9973478262a885c5614e78da49ed111ea973 | 274.983021593 |
20 | 0x0a23bfc441e6f60782fe468d900af1c3119dd808 | 207.489666143 |
Ali3NStakers Leaderboard (Elixir deUSD Staking on Avalanche)
Updated 6 hours ago
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 staket as (
select origin_from_address,
count (distinct tx_hash) as Transactions,
sum (decoded_log:value/1e18) as Volume,
avg (decoded_log:value/1e18) as Average_Volume
from avalanche.core.ez_decoded_event_logs
where origin_to_address = '0x68088c91446c7bea49ea7dbd3b96ce62b272dc96'
and contract_address = '0xb57b25851fe2311cc3fe511c8f10e868932e0680'
and origin_function_signature = '0x6e553f65'
and event_name = 'Transfer'
group by 1),
unstaket as (
select origin_from_address,
count (distinct tx_hash) as Transactions,
sum (decoded_log:value/1e18) as Volume,
avg (decoded_log:value/1e18) as Average_Volume
from avalanche.core.ez_decoded_event_logs
where origin_to_address = '0x68088c91446c7bea49ea7dbd3b96ce62b272dc96'
and contract_address = '0xb57b25851fe2311cc3fe511c8f10e868932e0680'
and origin_function_signature = '0xf2888dbb'
and event_name = 'Transfer'
group by 1)
select coalesce (t1.origin_from_address,t2.origin_from_address) as Wallet_Address,
sum (coalesce (t1.volume,0) - coalesce (t2.volume,0)) as Net_Staked_Volume
from staket t1 full outer join unstaket t2 on t1.origin_froM_address = t2.origin_from_address
group by 1 having net_staked_volume > 0
order by 2 desc
Last run: about 6 hours agoAuto-refreshes every 24 hours
71
4KB
255s