ArioBAYC and Ape Staking - APE hourly in march
    Updated 2022-12-08
    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
    Run a query to Download Data