t1 as (

select

BLOCK_TIMESTAMP as claim_date,

TO_ADDRESS as airdropers,

RAW_AMOUNT/1e18 as amount

from arbitrum.core.fact_token_transfers

where contract_address = lower('0x912ce59144191c1204e64559fe8253a0e49e6548')

and FROM_ADDRESS = lower('0x67a24CE4321aB3aF51c2D0a4801c3E111D88C9d9')

),

bridgors as (

SELECT

DISTINCT from_address as user

FROM arbitrum.core.fact_transactions

LEFT outer JOIN arbitrum.core.dim_labels

on address = to_address

WHERE from_address IN (SELECT airdropers FROM t1)

AND block_timestamp > '2023-03-22'

AND block_timestamp < current_date()

AND not project_name LIKE 'arbitrum foundation'

AND label_subtype LIKE 'bridge'

),

transferors as (

select

distinct FROM_ADDRESS as user

from arbitrum.core.fact_token_transfers b

LEFT JOIN arbitrum.core.dim_labels c on c.ADDRESS = b.TO_ADDRESS

where contract_address = lower('0x912ce59144191c1204e64559fe8253a0e49e6548')

and FROM_ADDRESS != lower('0x67a24CE4321aB3aF51c2D0a4801c3E111D88C9d9')

and from_address IN (SELECT airdropers FROM t1)

),

swappers as (

SELECT

distinct ORIGIN_FROM_ADDRESS AS user

FROM arbitrum.core.fact_event_logs

WHERE ORIGIN_FROM_ADDRESS IN (SELECT airdropers FROM t1)