select

TX_HASH

,AMOUNT_USD

,ORIGIN_FROM_ADDRESS

,SYMBOL

from arbitrum.core.ez_token_transfers

where CONTRACT_ADDRESS=lower('0x912ce59144191c1204e64559fe8253a0e49e6548')

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

and SYMBOL='ARB'),

tab2 as (

select TX_HASH

,TO_ADDRESS

from arbitrum.core.fact_transactions

where BLOCK_TIMESTAMP::date>='2023-03-23'),

tab3 as (

select ADDRESS

,PROJECT_NAME

,LABEL_TYPE

from crosschain.core.address_labels

),

tab4 as (

select BLOCK_TIMESTAMP::date as date

,TX_HASH

,AMOUNT_USD

,ORIGIN_FROM_ADDRESS

,SYMBOL

from optimism.core.ez_token_transfers

where CONTRACT_ADDRESS=lower('0x4200000000000000000000000000000000000042')

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

and SYMBOL='OP'),

tab5 as (

select TX_HASH

,TO_ADDRESS

from optimism.core.fact_transactions

where BLOCK_TIMESTAMP::date>='2023-03-23'),