select BLOCK_TIMESTAMP::date as date

,ORIGIN_FROM_ADDRESS

,SYMBOL

,AMOUNT

,AMOUNT_USD

,ORIGIN_TO_ADDRESS

from arbitrum.core.ez_token_transfers

where CONTRACT_ADDRESS=lower('0x912ce59144191c1204e64559fe8253a0e49e6548')

and BLOCK_TIMESTAMP::date>='2023-03-23'

and SYMBOL='ARB'

and ORIGIN_FROM_ADDRESS=TO_ADDRESS),

tab2 as (

select ADDRESS

,PROJECT_NAME

,LABEL_TYPE

from crosschain.core.address_labels

where LABEL_TYPE='dex'),

tab3 as (

select BLOCK_TIMESTAMP::date as date

,ORIGIN_FROM_ADDRESS

,SYMBOL

,AMOUNT

,AMOUNT_USD

,ORIGIN_TO_ADDRESS

from optimism.core.ez_token_transfers

where CONTRACT_ADDRESS=lower('0x4200000000000000000000000000000000000042')

and BLOCK_TIMESTAMP::date>='2023-03-23'

and SYMBOL='OP'

and ORIGIN_FROM_ADDRESS=FROM_ADDRESS),

tab4 as (

select ADDRESS

,PROJECT_NAME

,LABEL_TYPE

from crosschain.core.address_labels

where LABEL_TYPE='dex')