SELECT DISTINCT(origin_from_address) as staker

FROM ethereum.core.ez_token_transfers

WHERE

from_address = '0x0000000000000000000000000000000000000000'

and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

GROUP BY 1

),

swaps AS (

SELECT origin_from_address

, SUM(amount_in) AS eth_sent

, SUM(amount_out) AS steth_received

FROM ethereum.core.ez_dex_swaps

WHERE token_out = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

AND token_in = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

AND origin_from_address IN (SELECT * FROM stakers)

GROUP BY 1

),

staker_stats AS (

SELECT origin_from_address AS staker

, (steth_received - eth_sent) AS net_gain

, CASE

WHEN net_gain > 5 THEN 'Gained > 5 stETH'

WHEN net_gain <= 5 AND net_gain > 1 THEN 'Gained 1 to 5 stETH'

WHEN net_gain <= 1 AND net_gain > 0.5 THEN 'Gained 0.5 to 1 stETH'

WHEN net_gain <= 0.5 AND net_gain > 0.1 THEN 'Gained 0.1 to 0.5 stETH'

WHEN net_gain <= 0.1 AND net_gain > 0.01 THEN 'Gained 0.01 to 0.1 stETH'

WHEN net_gain <= 0.01 AND net_gain >= -0.01 THEN 'Neutral'

WHEN net_gain < -0.01 AND net_gain >= -0.1 THEN 'Lost 0.01 to 0.1 stETH'

WHEN net_gain < -0.1 AND net_gain >= -0.5 THEN 'Lost 0.1 to 0.5 stETH'

WHEN net_gain < -0.5 AND net_gain >= -1 THEN 'Lost 0.5 to 1 stETH'

WHEN net_gain < -1 AND net_gain >= -5 THEN 'Lost 1 to 5 stETH'

WHEN net_gain < -5 THEN 'Lost > 5 stETH'

END AS type

, CASE

WHEN net_gain > 5 THEN 1