SELECT to_address as claimer

from arbitrum.core.ez_token_transfers

where CONTRACT_ADDRESS LIKE lower('0x6985884C4392D348587B19cb9eAAf157F13271cd')

AND from_address LIKE lower('0xd6b6a6701303B5Ea36fa0eDf7389b562d8F894DB')

and block_timestamp <= '2024-09-20 20:30:00.000'),

r2claimers as (

select origin_from_address

from arbitrum.core.ez_decoded_event_logs

where CONTRACT_ADDRESS = '0x6985884c4392d348587b19cb9eaaf157f13271cd'

and decoded_log:from ='0xd6b6a6701303b5ea36fa0edf7389b562d8f894db'

and origin_to_address = '0xb09f16f625b363875e39ada56c03682088471523'

and block_timestamp > '2024-09-20 20:30:00.000'),

t1 as (

select distinct address

from arbitrum.core.dim_labels

where address_name ilike '%layerzero%' or address_name ilike '%layer zero%'

or address_name ilike '%stargate%'

union all

select distinct address

from avalanche.core.dim_labels

where address_name ilike '%layerzero%' or address_name ilike '%layer zero%'

or address_name ilike '%stargate%'

or address_name ilike '%dexalot%'

union all

select distinct address

from base.core.dim_labels

where address_name ilike '%layerzero%' or address_name ilike '%layer zero%'

or address_name ilike '%stargate%'