tx_hash,

receiver,

source_chain_name,

PLATFORM,

a.token_address,

name,

amount_unadj,

amount_unadj/pow(10,decimals) as amount_adj

from aptos.defi.fact_bridge_activity a join aptos.core.dim_tokens b on a.token_address = b.token_address

where direction = 'inbound'

and DESTINATION_CHAIN_NAME = 'Aptos')

,

price as ( select hour::date as day,

token_address,

avg(price) as price_usd

from aptos.price.ez_prices_hourly

group by 1,2

UNION all

select hour::date as day,

'0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDD' as token_address,

avg(price) as price_usd

from aptos.price.ez_prices_hourly

where token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC'

group by 1,2

UNION all

select hour::date as day,

'0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::celer_coin_manager::BusdCoin' as token_address,

avg(price) as price_usd

from aptos.price.ez_prices_hourly

where token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC'

group by 1,2

UNION all

select hour::date as day,

'0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::celer_coin_manager::DaiCoin' as token_address,

avg(price) as price_usd