TOKEN | STAKE_SIZE_CATEGORY | TRANSACTION_COUNT | TOTAL_STAKED | AVG_STAKE_SIZE | MAX_STAKE_SIZE | MIN_STAKE_SIZE | |
|---|---|---|---|---|---|---|---|
1 | RON | Large (1k-10k) | 7800 | 23826746.6780042 | 3054.711112565 | 10000 | 1000 |
2 | RON | Medium (100-1k) | 30422 | 10475335.7333508 | 344.334223041 | 1000 | 100 |
3 | RON | Micro (0-10) | 110029 | 317915.50456141 | 2.889379205 | 10 | 0 |
4 | RON | Shark (10k-100k) | 1175 | 29950787.7982861 | 25490.032168754 | 100000 | 10000.01 |
5 | RON | Small (10-100) | 81076 | 3119275.44882064 | 38.473474873 | 100 | 10 |
6 | RON | Whale (100k+) | 118 | 34107434.630724 | 289046.056192576 | 2179570 | 100370.063929107 |
Kruys-Collinswarm-white copy
Updated 2025-03-20
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
-- Latest prices for RON
ron_prices AS (
SELECT
token_address,
symbol,
token_price_usd
FROM (
SELECT
token_address,
symbol,
token_price_usd,
ROW_NUMBER() OVER (PARTITION BY token_address ORDER BY date DESC) as rn
FROM (
SELECT
hour::date as date,
token_address,
symbol,
AVG(price) as token_price_usd
FROM
ronin.price.ez_prices_hourly
WHERE
symbol = 'RON'
GROUP BY ALL
)
)
WHERE rn = 1
),
-- RON Staking Events
ron_events AS (
SELECT
event_name,
tx_hash,
block_timestamp,
EXTRACT(HOUR FROM block_timestamp) AS hour_of_day,
Last run: 25 days ago
6
444B
5s