TOKEN | STAKE_SIZE_CATEGORY | TRANSACTION_COUNT | TOTAL_STAKED | AVG_STAKE_SIZE | MAX_STAKE_SIZE | MIN_STAKE_SIZE | |
|---|---|---|---|---|---|---|---|
1 | AXS | Large (1k-10k) | 1452 | 4477106.27333395 | 3083.406524335 | 10000 | 1000.00043946 |
2 | AXS | Medium (100-1k) | 5133 | 1539993.9152906 | 300.018296375 | 1000 | 100.000000073 |
3 | AXS | Micro (0-10) | 206522 | 284249.267993169 | 1.376363138 | 10 | 1e-18 |
4 | AXS | Shark (10k-100k) | 267 | 7768595.55011852 | 29095.86348359 | 100000 | 10000.022643755 |
5 | AXS | Small (10-100) | 21670 | 669414.028802389 | 30.891279594 | 100 | 10.000000089 |
6 | AXS | Whale (100k+) | 29 | 4781816.57074418 | 164890.226577386 | 349052.726665661 | 103315.65592 |
Kruys-Collinswarm-white
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 AXS
axs_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 = 'AXS'
GROUP BY ALL
)
)
WHERE rn = 1
),
-- AXS Staking Events
axs_events AS (
SELECT
event_name,
tx_hash,
block_timestamp,
EXTRACT(HOUR FROM block_timestamp) AS hour_of_day,
Last run: 15 days ago
6
486B
5s