Ario$ARKM Supply
    Updated 2023-07-19
    with tab1 as (
    select
    sum(AMOUNT) as Claimed_Amount,
    count(distinct ORIGIN_FROM_ADDRESS) as Claimer
    from ethereum.core.ez_token_transfers
    where from_address = '0x08c7676680f187a31241e83e6d44c03a98adab05'
    and contract_address = '0x6e2a43be0b1d33b726f0ca3b8de60b3482b8b050'
    )
    select
    1000000000 as Total_Supply
    ,30000000 as First_Round_Airdrop
    ,Claimed_Amount
    ,Claimed_Amount / First_Round_Airdrop * 100 as Claimed_Percentage
    ,Claimer
    from tab1


    Run a query to Download Data