select

hour :: date as date,

token_address,

avg(price) as avg_price

from

crosschain.price.ez_hourly_token_prices

group by

1,

2

),

mid as (

select

BLOCK_TIMESTAMP,

TX_HASH,

AMOUNT,

SENDER,

TOKEN_ADDRESS,

TOKEN_SYMBOL,

concat(SOURCE_CHAIN, ' -> ', destination_chain) as path

from

axelar.defi.ez_bridge_squid

where

amount is not null

union

all

select

BLOCK_TIMESTAMP,

TX_HASH,

AMOUNT,

SENDER,

TOKEN_ADDRESS,

TOKEN_SYMBOL,

concat(SOURCE_CHAIN, ' -> ', destination_chain) as path

from

axelar.defi.ez_bridge_satellite