-- Fetch daily average Bitcoin prices

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS period,

AVG(ASSET_USD) AS avg_btc_price

FROM thorchain.price.fact_prices

WHERE POOL_NAME = 'BTC.BTC'

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

GROUP BY period

),

eth_prices AS (

-- Fetch daily average ETH prices

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS period,

AVG(ASSET_USD) AS avg_eth_price

FROM thorchain.price.fact_prices

WHERE POOL_NAME = 'ETH.ETH'

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

GROUP BY period

),

avax_prices AS (

-- Fetch daily average AVAX prices

SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS period,

AVG(ASSET_USD) AS avg_avax_price

FROM thorchain.price.fact_prices

WHERE POOL_NAME = 'AVAX.AVAX'

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

GROUP BY period

),

uni_prices AS (

-- Fetch daily average UNI prices

SELECT