with bridge_txns as (

select

BLOCK_TIMESTAMP :: date date,

TX_HASH,

SENDER,

RECEIVER,

SOURCE_CHAIN_NAME,

DESTINATION_CHAIN_NAME,

TOKEN_ADDRESS,

AMOUNT_UNADJ,

direction,

from

aptos.defi.fact_bridge_activity

where PLATFORM = 'wormhole'

AND

BLOCK_TIMESTAMP :: date >= '2024-01-01'

),

prices as (

select

date_trunc(day, HOUR) :: date date,

TOKEN_ADDRESS,

SYMBOL,

DECIMALS,

median (PRICE) price

from

aptos.price.ez_prices_hourly

where

DECIMALS is not NULL

and date_trunc(day, HOUR) :: date >= '2024-01-01'

group by

1,

2,

3,

4