(utils.udf_hex_to_int(substr(data,0,66))::int)/1e18 as amount

from berachain.testnet.fact_event_logs

where ORIGIN_TO_ADDRESS=LOWER('0xd98c56EBbb46aA3a85Cc488c6b24E0d486624D9F')

and topics[0]='0xd8138f8a3f377c5259ca548e70e4c2de94f129f5a11036a15b69513cba2b426a'

and ORIGIN_FUNCTION_SIGNATURE='0x4e71d92d'

order by 1 desc

),

daily_claims as (select date_trunc('day',time) as day, sum(amount) as amount

from claim_data

group by 1

order by 1 desc)

select day, amount, sum(amount) over (order by day) as cumulative

from daily_claims