select block_timestamp, tx_hash, concat('0x',substr(TOPICS[1], 27,64)) as address, (ethereum.public.udf_hex_to_int(data)::int)/1e18 as amount from berachain.testnet.fact_event_logs

where topics[0]='0x7cad7fbe1215c486c724bf41124e0ed689d280724381379da844556025c463c1'

and contract_address=lower('0xF1E4A550772faBfc35B28b51eB8d0b6FCd1c4878')

select avg(d_a) from (

select date_trunc('day',block_timestamp), count(distinct address) as d_a from faucet_claimers

group by 1