par_rnDaily Cumulative ETH Staked
    Updated 2022-11-04
    with
    ttl_eth_staked_cte as (
    select
    date
    , sum(amount) over(order by date rows between unbounded preceding and current row) cumulative_amount
    from (
    select
    BLOCK_TIMESTAMP::date date
    , sum(amount) amount
    from ethereum.core.ez_eth_transfers
    where 1=1
    and eth_to_address = '0x00000000219ab540356cbb839cbe05303d7705fa'
    group by 1
    )
    )
    , liquid_staking_platform_cte as (
    select
    value:platform platfrom
    , value:contract_address contract_address
    from table(flatten(input => parse_json(
    '
    [
    {
    "platform": "Lido",
    "contract_address": "0xae7ab96520de3a18e5e111b5eaab095312d7fe84"
    },
    {
    "platform": "Stakewise",
    "contract_address": "0xc874b064f465bdd6411d45734b56fac750cda29a"
    },
    {
    "platform": "Ankr",
    "contract_address": "0x84db6ee82b7cf3b47e8f19270abde5718b936670"
    },
    {
    "platform": "Bifrost",
    Run a query to Download Data