select

block_timestamp,

tx_hash,

livequery.utils.udf_hex_to_int(data) / power(10, 18) as wai_amt

from blast.core.fact_event_logs

where true

-- and tx_hash = '0xe5b4c51f62b1b415b27f6a780ed39adca67627553240653877478d82d0357e81'

and contract_address = '0x129ed667bf8c065fe5f66c9b44b7cb0126d85cc3'

and origin_to_address = '0xb5662b15bb74ba1878623a98f9b13e1be7f66e0e'

select date_trunc('day', block_timestamp) as date_time, sum(wai_amt*0.06907) as usd_claimed, count(*) as no_claims

from claim_activities

group by 1