SELECT

decoded_log:to AS restaker_address,

SUM(decoded_log:value) / 1e18 AS amount_staked

FROM

ethereum.core.ez_decoded_event_logs

WHERE

contract_address = LOWER('0xfae103dc9cf190ed75350761e95403b7b8afa6c0')

AND event_name = 'Transfer'

AND decoded_log:from = '0x0000000000000000000000000000000000000000'

AND decoded_log:to != '0x0000000000000000000000000000000000000000'

GROUP BY

decoded_log:to

),

trader_categories AS (

SELECT

restaker_address,

amount_staked,

CASE

WHEN amount_staked < 0.001 THEN '< 0.001'

WHEN amount_staked BETWEEN 0.001 AND 0.01 THEN '0.001 - 0.01'

WHEN amount_staked BETWEEN 0.01 AND 0.1 THEN '0.01 - 0.1'

WHEN amount_staked BETWEEN 0.1 AND 0.5 THEN '0.1 - 0.5'

WHEN amount_staked BETWEEN 0.5 AND 1 THEN '0.5 - 1'

WHEN amount_staked BETWEEN 1 AND 5 THEN '1 - 5'

WHEN amount_staked BETWEEN 5 AND 10 THEN '5 - 10'

WHEN amount_staked BETWEEN 10 AND 50 THEN '10 - 50'

WHEN amount_staked BETWEEN 50 AND 100 THEN '50 - 100'

WHEN amount_staked BETWEEN 100 AND 200 THEN '100 - 200'

WHEN amount_staked BETWEEN 200 AND 500 THEN '200 - 500'

WHEN amount_staked BETWEEN 500 AND 1000 THEN '500 - 1000'

WHEN amount_staked BETWEEN 1000 AND 2000 THEN '1000 - 2000'

ELSE '2000+'

END AS staked_category

FROM

restake_data