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