WITH claim_txns AS (

SELECT tx_hash

FROM base.core.fact_event_logs

WHERE contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'

AND ORIGIN_TO_ADDRESS = '0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'

AND ORIGIN_FUNCTION_SIGNATURE = '0x69659658'

AND block_timestamp::date >= '2025-02-20'

GROUP BY 1

),

claimed_amount AS (

SELECT date_trunc(hour, BLOCK_TIMESTAMP) date,

TO_ADDRESS user,

AMOUNT

FROM claim_txns

LEFT JOIN base.core.ez_token_transfers USING (tx_hash)

),

amount_distribution AS (

SELECT

CASE

WHEN amount <= 25 THEN '0-25 $KAITO'

WHEN amount <= 50 THEN '26-50 $KAITO'

WHEN amount <= 100 THEN '51-100 $KAITO'

WHEN amount <= 250 THEN '101-250 $KAITO'

WHEN amount <= 500 THEN '251-500 $KAITO'

WHEN amount <= 1000 THEN '501-1K $KAITO'

ELSE '1K+ $KAITO'

END AS amount_range,

COUNT(DISTINCT user) as number_of_users,

SUM(amount) as total_amount_in_range

FROM claimed_amount

GROUP BY 1

SELECT

amount_range,

number_of_users,