alirsBAAS-01-top 10
    Updated 2022-12-08

    select --block_timestamp::date as Date,
    origin_from_address,
    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 ount"
    -- ,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 1
    order by "Claimed APE Volume" desc
    limit 10


    Run a query to Download Data