Updated 2023-07-27
    with
    a as (
    select
    ORIGIN_FROM_ADDRESS as claimer ,
    RAW_AMOUNT/pow(10,DECIMALS) as volume ,
    AMOUNT_USD as USD ,
    BLOCK_TIMESTAMP ,
    TX_HASH
    from ethereum.core.ez_token_transfers
    where
    ORIGIN_TO_ADDRESS ='0x090e53c44e8a9b6b1bca800e881455b921aec420' and
    CONTRACT_ADDRESS = '0xcafe001067cdef266afb7eb5a286dcfd277f3de5' and
    ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'
    )
    select
    sum(volume) as PSP ,'Claimed PSP' as title from a group by 2
    union
    select (149840000 - sum(volume)) as PSP ,'Remaining PSP' as title from a group by 2
    union
    select 149840000 as PSP ,'PSP Airdrop Allocation' as title from a

    Run a query to Download Data