SELECT

origin_from_address,

amount,

amount_usd,

'Polygon' AS chain

FROM polygon.core.ez_token_transfers

WHERE

to_address = '0xc8a8ce0ab010e499ca57477ac031358febcbbf17'

AND origin_function_signature = '0x413aaa60'

SELECT

chain,

CASE

WHEN amount < 500 THEN '< 500'

WHEN amount >= 500 AND amount < 1000 THEN '500 - 999'

WHEN amount >= 1000 AND amount < 5000 THEN '1000 - 4999'

WHEN amount >= 5000 AND amount < 10000 THEN '5000 - 9999'

WHEN amount >= 10000 THEN '>= 10000'

END AS amount_range,

COUNT(DISTINCT origin_from_address) AS Stakers_count,

SUM(amount) AS total_amount,

SUM(amount_usd) AS total_amount_usd

FROM PolyOrder

GROUP BY chain, amount_range

ORDER BY chain, amount_range;