SELECT

date_trunc('day', hour) AS Time,

symbol,

token_address,

AVG(price) AS usd_price

FROM crosschain.price.ez_prices_hourly

GROUP BY 1,2,3

SELECT

source_chain,

SUM(amount * usd_price) AS amount_bridged

FROM axelar.defi.ez_bridge_satellite x

JOIN axl_price y ON date_trunc('day', x.block_timestamp) = y.Time AND x.token_address = y.token_address

GROUP BY 1

ORDER BY 2 DESC