SELECT

HOUR::date as PRICE_TIME,

SYMBOL,

AVG(PRICE) as usd_price

FROM

ethereum.core.fact_hourly_token_prices

GROUP BY 1, 2

UNION ALL

SELECT

RECORDED_AT::date as PRICE_TIME,

SYMBOL,

AVG(PRICE) as usd_price

FROM

osmosis.core.dim_prices

GROUP BY 1, 2

),

bridge_transactions AS

SELECT

'Squid' as BRIDGE, AMOUNT, BLOCK_TIMESTAMP, SENDER, SOURCE_CHAIN, DESTINATION_CHAIN,

TOKEN_SYMBOL, TX_HASH

FROM

axelar.core.ez_squid

UNION ALL

SELECT

'Satellite' as BRIDGE, AMOUNT, BLOCK_TIMESTAMP, SENDER, SOURCE_CHAIN, DESTINATION_CHAIN,

TOKEN_SYMBOL, TX_HASH

FROM

axelar.core.ez_satellite