SELECT

TRUNC(block_timestamp, 'hour') AS hourly,

tx_hash,

sender,

amount,

source_chain,

destination_chain,

token_address AS token,

TOKEN_SYMBOL AS token_name

FROM

axelar.defi.ez_bridge_satellite

WHERE

token_symbol IN ('USDT', 'axlUSDT', 'USDC', 'BUSD', 'FRAX', 'sFRAX', 'axlDAI', 'axlUSDC', 'EUROC', 'axlUSDT')

),

token_price_data AS (

SELECT

hour,

token_address,

AVG(price) AS avg_price

FROM

crosschain.price.ez_hourly_token_prices

WHERE

token_address IN (SELECT token FROM token_bridge_data)

GROUP BY

1, 2

),

processed_data AS (

SELECT

hourly,

tx_hash,

sender,

amount,

amount * avg_price AS amount_usd,

COALESCE(amount * avg_price, amount) AS volume_usd,

token,