farid-c9j0VMstaking platform 1
    Updated 2022-09-04
    select date_trunc('week', block_timestamp) as week,
    CASE WHEN contract_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393') THEN 'Rocket Pool'
    WHEN contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84') THEN 'Lido'
    WHEN contract_address = lower('0xFe2e637202056d30016725477c5da089Ab0A043A') THEN 'Stakewise'
    WHEN contract_address = lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb') THEN 'Ankr'
    end as platform,
    COUNT (DISTINCT to_address) as "Total Number of Unique Staker",
    sum(raw_amount)/pow(10,18) as "Total Amount of ETH Staked",
    ("Total Amount of ETH Staked"/"Total Number of Unique Staker") as "Average Amount of ETH Staked per Staker",
    avg((raw_amount)/pow(10,18)) as "Avg ETH stake volume",
    min((raw_amount)/pow(10,18)) as "Min ETH stake volume",
    max((raw_amount)/pow(10,18)) as "Max ETH stake volume",
    median((raw_amount)/pow(10,18)) as "Median ETH stake volume"

    from ethereum_core.fact_token_transfers
    where from_address = '0x0000000000000000000000000000000000000000'
    and raw_amount > 0
    and platform is not null
    and block_timestamp >= '2022-01-01'
    group by week,platform
    Run a query to Download Data