SELECT

Count(DISTINCT origin_from_address) AS no_of_depositors,

Sum(amount) AS total_eth_staked,

Sum(amount_usd) AS total_eth_usd,

Avg(amount) AS average_eth_deposit,

Median(amount) AS median_eth_deposit,

Min(amount) AS min_eth_deposit,

Max(amount) AS max_eth_deposit

FROM ethereum.core.ez_eth_transfers

WHERE eth_to_address IN ('0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd',

'0x49d72e3973900a195a155a46441f0c08179fdb64')

), lido AS

SELECT

sum(EVENT_INPUTS:amount /1e6) AS tot_eth_staked,

tot_eth_staked * 1639 AS tot_eth_usd,

avg(EVENT_INPUTS:amount /1e6) AS average_eth_deposit,

median(EVENT_INPUTS:amount/1e6) AS median_eth_deposit,

min(EVENT_INPUTS:amount /1e6) AS min_eth_deposit,

max(EVENT_INPUTS:amount /1e6) AS max_eth_deposit,

count(DISTINCT origin_from_address) AS no_of_depositors

FROM ethereum.core.fact_event_logs

WHERE contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

AND tx_status = 'SUCCESS'

AND event_name = 'Submitted'

), rocket_pool AS

SELECT

count(DISTINCT from_address) AS no_of_depositors ,

sum(eth_value) AS tot_eth_staked,

tot_eth_staked * 1639 AS total_eth_usd,

min(eth_value) AS min_eth_deposit,