alirsAPA-03
    Updated 2022-11-30
    SELECT block_timestamp::date as date
    ,count(DISTINCT tx_hash) AS Number_of_Claims
    ,count(DISTINCT to_address) AS Number_of_Users
    ,sum(raw_amount / pow(10, 18)) AS ACX_Volume
    ,125000000 - ACX_Volume AS unclaimed_Volume
    ,(ACX_Volume / 125000000) * 100 AS claimed_Ratio
    ,(unclaimed_Volume / 125000000) * 100 AS unclaimed_Ratio
    ,sum (Number_of_Users) over (order by date) as Cum_Claim_Count
    ,sum (ACX_volume) over (order by date) as Cum_ACX_Volume
    FROM ethereum.core.ez_token_transfers
    WHERE contract_address = '0x44108f0223a3c3028f5fe7aec7f9bb2e66bef82f'
    AND from_address = '0xe50b2ceac4f60e840ae513924033e753e2366487'
    group by DATE
    order by DATE

    Run a query to Download Data