with claims as

(select

DISTINCT TO_ADDRESS

from optimism.core.ez_token_transfers

where

ORIGIN_FUNCTION_SIGNATURE = '0xb69d1a08'

and CONTRACT_ADDRESS = '0xef4461891dfb3ac8572ccf7c794664a8dd927945'

and ORIGIN_TO_ADDRESS = '0x4ee97a759aaca2edf9c1445223b6cd17c2ed3fb4'

and FROM_ADDRESS = '0xa86ca428512d0a18828898d2e656e9eb1b6ba6e7'),

t0 as (

SELECT FROM_ADDRESS,BLOCK_TIMESTAMP::date as date

from arbitrum.core.fact_transactions

where

FROM_ADDRESS in (select TO_ADDRESS from claims)

and nonce = 0

UNION

SELECT FROM_ADDRESS, BLOCK_TIMESTAMP::date as date

from avalanche.core.fact_transactions

where

FROM_ADDRESS in (select TO_ADDRESS from claims)

and nonce = 0

UNION