with airdrop_claimed as(
select
distinct block_timestamp,
to_address,
amount / 1e18 as amount
from
ethereum.udm_events
where
origin_function_signature = '0x76122903'
and contract_address = '0xc18360217d8f7ab5e7c516566761ea12ce7f9d72'
and event_type = 'erc20_transfer'
)
select
date_trunc('day', block_timestamp) as blocktime,
sum(amount) / 25000000 * 100 as percentage_claimed_per_day
from
airdrop_claimed
group by
blocktime