select ADDRESS

,ADDRESS_NAME

,PROJECT_NAME

from crosschain.core.address_labels

where PROJECT_NAME ilike '%layerzero%'

or ADDRESS_NAME ilike '%layerzero%'),

tab2 as (

select BLOCK_TIMESTAMP::date as date

,AMOUNT_USD

,ORIGIN_FROM_ADDRESS

,TO_ADDRESS

,SYMBOL

,TX_HASH

from arbitrum.core.ez_token_transfers

where date between '{{Start_date}}' and '{{End_date}}'),

tab3 as (

select BLOCK_TIMESTAMP::date as date

,AMOUNT_USD

,ORIGIN_FROM_ADDRESS

,ORIGIN_TO_ADDRESS

,TX_HASH

,'ETH' as SYMBOL

from arbitrum.core.ez_eth_transfers

where date between '{{Start_date}}' and '{{End_date}}'),

tab4 as (

select BLOCK_TIMESTAMP::date as date

,AMOUNT_USD

,ORIGIN_FROM_ADDRESS

,TO_ADDRESS

,SYMBOL

,TX_HASH

from avalanche.core.ez_token_transfers

where date between '{{Start_date}}' and '{{End_date}}'),

tab5 as (

select BLOCK_TIMESTAMP::date as date