DMONTH | LABEL | Total Stake | TOTAL_STAKE_USD | Validators | Wallets | STAKE_GROWTH | |
|---|---|---|---|---|---|---|---|
1 | 2023-09-01 00:00:00.000 | ETH | 27229933.8486933 | 53937824482.284 | 850935 | 195097 | 3.5 |
2 | 2023-10-01 00:00:00.000 | ETH | 28005983.2851556 | 55475045194.0959 | 875187 | 196822 | 2.8 |
3 | 2023-11-01 00:00:00.000 | ETH | 28690576.9666645 | 56831107755.2497 | 896581 | 199645 | 2.4 |
4 | 2023-12-01 00:00:00.000 | ETH | 28990309.8295109 | 57424827102.407 | 905947 | 203071 | 1 |
5 | 2024-01-01 00:00:00.000 | ETH | 29600023.8751929 | 58632565959.3252 | 925001 | 211752 | 2.1 |
6 | 2024-02-01 00:00:00.000 | ETH | 31378149.7042775 | 62154727981.8079 | 980567 | 222539 | 6 |
7 | 2024-03-01 00:00:00.000 | ETH | 32141663.8983349 | 63667118530.299 | 1004427 | 230521 | 2.4 |
8 | 2024-04-01 00:00:00.000 | ETH | 32561128.7863625 | 64498006465.3426 | 1017535 | 229475 | 1.3 |
9 | 2024-05-01 00:00:00.000 | ETH | 32703222.4623253 | 64779469644.6771 | 1021976 | 229398 | 0.4 |
10 | 2024-06-01 00:00:00.000 | ETH | 33283551.4606934 | 65929001767.2995 | 1040111 | 229433 | 1.8 |
11 | 2024-07-01 00:00:00.000 | ETH | 34076676.6357212 | 67500046585.8745 | 1064896 | 228264 | 2.4 |
12 | 2024-08-01 00:00:00.000 | ETH | 34326648.0408533 | 67995197027.6834 | 1072708 | 226327 | 0.7 |
13 | 2024-09-01 00:00:00.000 | ETH | 34648912.5393151 | 68633547677.0639 | 1082779 | 225527 | 0.9 |
Flipside TeamI - 1a MoM Overview ETH
Updated 2025-03-20
999
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
›
⌄
-- forked from I - 1a MoM Overview Stats @ https://flipsidecrypto.xyz/studio/queries/3ae92ef4-6907-4341-a149-7f87fa5575ed
with eth_stats as (
---------------------------- GENERATE SAMPLE SPACE ---------------------------------
with wallets as (
SELECT
DISTINCT wallet
from (
SELECT DISTINCT COALESCE(WITHDRAWAL_ADDRESS, 'empty') as wallet
FROM ethereum.beacon_chain.ez_deposits
WHERE 1=1
--AND WITHDRAWAL_ADDRESS = '0x15dace490e3bee63ba9c2695ea6d29a78360dd96'
UNION ALL
SELECT DISTINCT COALESCE(WITHDRAWAL_ADDRESS, 'empty') as wallet
FROM ethereum.beacon_chain.ez_withdrawals
WHERE 1=1
)
)
,
dates as (
SELECT
DISTINCT date_trunc('month', date_day) as dmonth
from crosschain.core.dim_dates
WHERE 1=1
AND date_day BETWEEN '2020-11-01' AND CURRENT_DATE
)
,
sample_space as (
SELECT
dmonth
, wallet
, NULL as eth_staked
from dates
Last run: about 1 month ago
13
1KB
93s