alirsBAAS-01-Weekly
    Updated 2022-12-08

    select DATE_TRUNC('week', block_timestamp) AS DATE,
    count (distinct tx_hash) as "Number of Claims",
    count (distinct origin_from_address) as"Number of Users",
    sum (event_inputs:value/pow(10,18)) as "Claimed APE Volume",
    150000000 - "Claimed APE Volume" AS "APE unclaimed Volume"
    ,("Claimed APE Volume" / 150000000) * 100 AS "APE claimed Ratio"
    ,( "APE unclaimed Volume" / 150000000) * 100 AS "APE unclaimed Ratio"
    ,sum ("Number of Users") over (order by Date) as "Cumulative APE Claim Count"
    ,sum ("Claimed APE Volume") over (order by Date) as "Cumulative Claimed APE Volume"
    from ethereum.core.fact_event_logs
    where origin_to_address = '0x025c6da5bd0e6a5dd1350fda9e3b6a614b205a1f'
    and tx_status = 'SUCCESS'
    and event_name = 'Transfer'
    and origin_function_signature = '0x48c54b9d'
    group by date
    order by date


    Run a query to Download Data