select
Top 20 ORIGIN_FROM_ADDRESS as Claimers,
sum(EVENT_INPUTS:value/pow(10,18)) as "$APE Claimed"
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 between '2022-03-01' and '2022-03-31'
group by 1
order by 2 desc