with kaito_claims as

SELECT to_address, sum(amount) as allocation

FROM base.core.ez_token_transfers

WHERE 1=1

and from_address = lower('0xeB7d383B0c77EA0Bed28b42D0C288F9071Bd8a7a') and symbol = 'KAITO'

and block_timestamp > '2025-02-19'

GROUP BY to_address

, labelled_data as

select k.*, ens.ens_domain, coalesce(ens.EXPIRED, 'FALSE') as ens_status, parse_json(farc.verified_addresses)[0] as address, farc.display_name from kaito_claims k

left join ethereum.ens.ez_ens_domains ens

on k.to_address=ens.set_address

left join external.farcaster.dim_profile_with_addresses farc

on k.to_address=address

where 1=1

and to_address!='0x0000000000000000000000000000000000000000'

qualify(row_number() over (partition by k.to_address order by LAST_REGISTERED_BLOCK desc)=1)

select

coalesce(ld.display_name, ld.ens_domain, 'Name unavailable') as kaito_claimer_name,

ld.to_address as kaito_claimer_address,

ld.allocation,

bal.ROLLING_BAL_ROUND as current_balance,

100*(1-(ld.allocation-current_balance)/(ld.allocation)) as percentage_held

from labelled_data ld

inner join $query('8b1f2dda-f258-4f48-b87b-7b1c59a98e5a') bal

on ld.to_address=bal.user

and ld.to_address=lower('0x2c3C48dcFA3875b5D181033A5ffFe1584270462a')

order by ld.allocation desc