sum(eth_value) as total_daily_ETH_staked,

count(distinct from_address) as total_daily_unique_depositors,

avg(eth_value) as daily_avg_distribution_of_ETH_deposits,

median(eth_value) as daily_median_of_ETH_deposits,

max(eth_value) as daily_max_of_ETH_deposits,

min(eth_value) as daily_min_of_ETH_deposits,

case when contract_address=lower('0xC874b064f465bdD6411D45734b56fac750Cda29A') then 'Stakewise'

when contract_address=lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670') then 'stkr'

when contract_address=lower('0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd') then 'Cream'

when contract_address=lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58') then 'Rocket_pool'

when contract_address=lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') then 'Lido'

when contract_address=lower('0x00000000219ab540356cBB839Cbe05303d7705Fa') then 'Direct staking'

end as platform

from ethereum.core.fact_transactions

inner join ethereum_core.fact_event_logs on ethereum.core.fact_transactions.tx_hash=ethereum_core.fact_event_logs.tx_hash

where contract_address in (lower('0xC874b064f465bdD6411D45734b56fac750Cda29A'),

lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670'),

lower('0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd'),

lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58'),

lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84'),

lower('0x00000000219ab540356cBB839Cbe05303d7705Fa')

)

and eth_value>0

and day>= CURRENT_DATE - 25

group by 1, 8