binhachon4. [Elite] Paradrop Airdrop Assessment - Claim stats
    Updated 2021-12-21
    with psp_airdrop as (
    select
    distinct tx_id,
    block_timestamp,
    to_address,
    amount/1e18 as airdrop_amount
    from
    ethereum.udm_events
    where origin_function_signature = '0x2e7ba6ef' -- Claim function
    and from_address = '0x090e53c44e8a9b6b1bca800e881455b921aec420' -- PSP airdrop contract
    and event_type = 'erc20_transfer'
    and contract_address = '0xcafe001067cdef266afb7eb5a286dcfd277f3de5' --PSP contract address
    )
    select date_trunc('day', block_timestamp) as blocktime, sum(airdrop_amount) as claimed_amount, count(to_address) as number_of_claimers
    from psp_airdrop
    group by blocktime
    Run a query to Download Data