Ario$ARKM Volume and Claimer Overtime
    Updated 2023-07-19
    select
    date_trunc(hour, block_timestamp) as Hour,
    sum(AMOUNT) as "Claimed $ARKM",
    count(distinct ORIGIN_FROM_ADDRESS) as Claimer,
    sum("Claimed $ARKM") over(order by Hour) as Cum_Claimed_Amount,
    Cum_Claimed_Amount/30000000 * 100 as "% Claimed"
    from ethereum.core.ez_token_transfers
    where from_address = '0x08c7676680f187a31241e83e6d44c03a98adab05'
    and contract_address = '0x6e2a43be0b1d33b726f0ca3b8de60b3482b8b050'
    group by 1
    Run a query to Download Data