select

date_trunc(day, HOUR)::date as date,

TOKEN_ADDRESS,

symbol,

avg(PRICE) as Avg_Price

from crosschain.price.ez_hourly_token_prices

group by 1,2,3

select

symbol,

sum(AMOUNT * avg_Price) as Bridge_Amounts,

from axelar.defi.ez_bridge_squid a join price b on date_trunc(day, a.BLOCK_TIMESTAMP)::date = b.date and a.TOKEN_ADDRESS = b.TOKEN_ADDRESS

group by 1