WITH staker_list AS (

SELECT a.origin_from_address AS staker_address,

a.block_timestamp::date AS staking_date,

a.tx_hash,

b.decimals,

to_decimal(GET(a.event_inputs, 'value'))/pow(10, b.decimals) AS staked_eth

FROM ethereum.core.fact_event_logs AS a JOIN ethereum.core.dim_contracts AS b

ON a.origin_to_address = b.address

WHERE origin_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

AND block_timestamp > CURRENT_DATE - 7

AND event_name = 'Transfer'

AND tx_status = 'SUCCESS'

SELECT staker_address, sum(staked_eth) AS eth_staked

FROM staker_list

GROUP BY staker_address

ORDER BY eth_staked DESC