select
date_trunc('hour',BLOCK_TIMESTAMP) as date,
sum(EVENT_INPUTS:value/pow(10,18)) as "$APE Claimed",
avg(EVENT_INPUTS:value/pow(10,18)) as "Avg $APE Claimed",
count(distinct ORIGIN_FROM_ADDRESS) as "# Claimer"
from ethereum.core.fact_event_logs
where
origin_function_signature = '0x48c54b9d'
and
origin_to_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'
and
event_name = 'Transfer'
and
tx_status = 'SUCCESS'
and
BLOCK_TIMESTAMP like '%2022-03-17%'
group by 1