flipside

    I - 1a MoM Overview Stats
    Flipside TeamI - 1a MoM Overview Stats
    Updated 2025-03-20
    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
    LEFT JOIN wallets on 1=1
    )
    Last run: about 1 month ago
    DMONTH
    LABEL
    TOTAL_STAKE
    TOTAL_STAKE_USD
    VALIDATORS
    WALLETS
    STAKE_GROWTH
    1
    		2023-09-01 00:00:00.000ETH27229933.848693353937824482.2848509351950973.5
    2
    		2023-09-01 00:00:00.000Matic3656782461.72744782208471.0879515974825-1.17
    3
    		2023-10-01 00:00:00.000ETH28005983.285155655475045194.09598751871968222.8
    4
    		2023-10-01 00:00:00.000Matic3639099201.97176778425912.04263816377112-0.48
    5
    		2023-11-01 00:00:00.000ETH28690576.966664556831107755.24978965811996452.4
    6
    		2023-11-01 00:00:00.000Matic3520775002.71619753115631.22580316479029-3.25
    7
    		2023-12-01 00:00:00.000ETH28990309.829510957424827102.4079059472030711
    8
    		2023-12-01 00:00:00.000Matic3449537129.75102737877407.93009116781076-2.02
    9
    		2024-01-01 00:00:00.000ETH29600023.875192958632565959.32519250012117522.1
    10
    		2024-01-01 00:00:00.000Matic3621209555.10204774599205.512315171837984.98
    11
    		2024-02-01 00:00:00.000ETH31378149.704277562154727981.80799805672225396
    12
    		2024-02-01 00:00:00.000Matic3646148030.67033779933700.26274171871030.69
    13
    		2024-03-01 00:00:00.000ETH32141663.898334963667118530.29910044272305212.4
    14
    		2024-03-01 00:00:00.000Matic3603596521.82436770831668.34663717189388-1.17
    15
    		2024-04-01 00:00:00.000ETH32561128.786362564498006465.342610175352294751.3
    16
    		2024-04-01 00:00:00.000Matic3665103710.43907783988437.848453171931661.71
    17
    		2024-05-01 00:00:00.000ETH32703222.462325364779469644.677110219762293980.4
    18
    		2024-05-01 00:00:00.000Matic3631628624.52877776827909.14774717295645-0.91
    19
    		2024-06-01 00:00:00.000ETH33283551.460693465929001767.299510401112294331.8
    20
    		2024-06-01 00:00:00.000Matic3695939807.28423790584470.404401174971761.77
    26
    2KB
    310s