WITH claims as (
SELECT
event_inputs:value / POW(10,6) as PTaUSDC_claimed,
ROUND(event_inputs:value / POW(10,6)) as rounded_PTaUSDC_claimed,
*
FROM ethereum.core.fact_event_logs
WHERE origin_to_address = '0xb9a179dca5a7bf5f8b9e088437b3a85ebb495efe'
AND contract_address = '0xdd4d117723c257cee402285d3acf218e9a8236e1'
AND event_name = 'Transfer'
AND tx_status = 'SUCCESS'
AND date(block_timestamp) > CURRENT_DATE - 61
)
SELECT
rounded_PTaUSDC_claimed,
COUNT(1) as number_of_claims
FROM claims
GROUP BY rounded_PTaUSDC_claimed