btc_prices AS (

SELECT

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS period,

AVG(ASSET_USD) AS avg_btc_price

FROM thorchain.price.fact_prices

WHERE POOL_NAME = 'BTC.BTC'

AND DATE_TRUNC('week', BLOCK_TIMESTAMP) >= '2023-01-01'

GROUP BY period

),

eth_prices AS (

SELECT

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS period,

AVG(ASSET_USD) AS avg_eth_price

FROM thorchain.price.fact_prices

WHERE POOL_NAME = 'ETH.ETH'

AND DATE_TRUNC('week', BLOCK_TIMESTAMP) >= '2023-01-01'

GROUP BY period

),

uni_prices AS (

SELECT

DATE_TRUNC('week', HOUR) AS period,

AVG(PRICE) AS avg_uni_price

FROM ethereum.price.ez_prices_hourly

WHERE TOKEN_ADDRESS = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984' -- UNI contract address

AND DATE_TRUNC('week', HOUR) >= '2023-01-01'

GROUP BY period

),

link_prices AS (

SELECT

DATE_TRUNC('week', HOUR) AS period,