flipside

    Beacon Chain 1
    banterlyticsBeacon Chain 1
    Updated 2023-07-03
    with a as
    (select SLOT_TIMESTAMP, sum(WITHDRAWAL_AMOUNT) as withdrawn from ethereum.beacon_chain.fact_withdrawals
    group by SLOT_TIMESTAMP
    )

    select *, sum(withdrawn) over (order by SLOT_TIMESTAMP asc rows between unbounded preceding and current row) as cumulative_withdrawn
    from a
    order by 1 DESC

    --select * from ethereum.beacon_chain.fact_withdrawals

    Run a query to Download Data