CASE WHEN contract_address = '0xae78736cd615f374d3085123a210448e74fc6393' THEN 'Rocket Pool'

WHEN contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' THEN 'Lido'

ELSE '' end as platform,

COUNT (DISTINCT to_address) as n_depositor,

sum(raw_amount)/pow(10,18) as amnt_staked,

max(raw_amount)/pow(10,18) as max_amnt_staked,

min(raw_amount)/pow(10,18) as min_amnt_staked,

avg(raw_amount)/pow(10,18) as avg_amnt_staked,

median(raw_amount)/pow(10,18) as median_amnt_staked

FROM ethereum_core.fact_token_transfers

WHERE from_address = '0x0000000000000000000000000000000000000000'

AND raw_amount > 0

AND platform != ''

GROUP by platform