Updated 2022-12-10
    with
    liquid_staking_platform_cte as (
    select
    value:platform platform
    , value:contract_address contract_address
    from table(flatten(input => parse_json(
    '
    [
    {
    "platform": "Lido",
    "contract_address": "0xae7ab96520de3a18e5e111b5eaab095312d7fe84"
    },
    {
    "platform": "Ankr",
    "contract_address": "0x84db6ee82b7cf3b47e8f19270abde5718b936670"
    },
    {
    "platform": "Rocket Pool",
    "contract_address": "0x4d05e3d48a938db4b7a9a59a802d5b45011bde58"
    },
    {
    "platform": "Rocket Pool",
    "contract_address": "0x2cac916b2a963bf162f076c0a8a4a8200bcfbfb4"
    }
    ]
    '
    )))
    )
    , liquidity_token_minted_cte as ( -- liquidity tokens minted transaction
    select
    distinct tx_hash
    from ethereum.core.ez_token_transfers
    where 1=1
    and from_address = '0x0000000000000000000000000000000000000000'
    )
    , liquid_staking_eth_cte as (
    Run a query to Download Data