USER | TRANSACTIONS | VOLUME_NEAR | VOLUME_USD | |
|---|---|---|---|---|
1 | meta-pool-dao-8.near | 22 | 4500000 | 7126046.36181441 |
2 | meta-pool-dao.near | 62 | 4064491 | 8842343.23867067 |
3 | bcc328f40ca071af1b91a6a82a238358f9eeedf2aac0bbf954d01a0bfc8f58f5 | 14 | 3532417 | 9860809.70194881 |
4 | c1f4caf77eb54ec89e2f03097cffbdd35fa4186465ebb4bf90960bf23bb6f2a3 | 2 | 3499999.99937 | 18289678.9499406 |
5 | hugo2.near | 4 | 2315994 | 5961272.18958333 |
6 | conveyor-w-meta-pool.near | 271 | 2151582.68722833 | 22970650.4674531 |
7 | 8f3407b44c610e4fe89acf297367eea009ba3623fa2278a4dd52a8d4f2417bf9 | 1 | 2000000 | 15956541.1796099 |
8 | 8143efad287c6697545e45c64e0789bfe6f5d69bef0910ce476f9314347e386d | 5 | 1573040 | 15979711.8946918 |
9 | goto.near | 84 | 1113978 | 6114273.26961017 |
10 | yaya666.near | 10 | 1080205 | 6243962.67364266 |
Afonso_DiazTop Stakers
Updated 9 days 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
36
›
⌄
with
pricet as (
select
hour::date as date,
avg(price) as price_usd
from near.price.ez_prices_hourly
where symbol = 'NEAR'
group by 1
),
stake_unstake as (
select
tx_hash,
block_timestamp,
'Stake' as action,
receipt_signer_id as user,
action_data:deposit / 1e24 as amount
from
near.core.ez_actions
where
receipt_receiver_id = 'meta-pool.near'
and action_data:method_name = 'deposit_and_stake'
and receipt_succeeded
and tx_succeeded
union all
select
tx_hash,
block_timestamp,
'Unstake' as action,
receipt_signer_id as user,
action_data:args:amount / 1e24 as amount
from
near.core.ez_actions
Last run: 9 days ago
10
693B
145s