select date_trunc('h',block_hour) as day,

avg(price_usd) as USDPrice

from algorand.defi.ez_price_pool_balances

where asset_id = '0'

group by 1),

Algorand as (

SELECT

date_trunc('h',block_timestamp) as date,

usdprice as NativeToken_USD_Price,

amount as transfer_volume

FROM algorand.core.ez_transfer t1 join algopricet t2 on t1.block_timestamp::date = t2.DAY

where ASSET_NAME LIKE 'USDC'),

ethpricet as (

select date_trunc('h',hour) as day,

avg (price) as USDPrice

from ethereum.core.fact_hourly_token_prices

where symbol = 'WETH'

group by 1),

Arbitrum as (

SELECT

date_trunc('h',block_timestamp) as date,

USDPrice as NativeToken_USD_Price,

raw_amount/power(10,6) as transfer_volume

FROM arbitrum.core.fact_token_transfers t1 join ethpricet t2 on t1.block_timestamp::date = t2.DAY

where contract_address LIKE lower('0xff970a61a04b1ca14834a43f5de4533ebddb5cc8')

),

axlpricet as (

select date_trunc('h',recorded_hour) as day,

avg(close) as USDPrice

from crosschain.core.fact_hourly_prices

where id = 'axelar'