SELECT DATE_TRUNC('DAY', HOUR) AS DAY,

AVG(PRICE) AS ETH_USD_PRICE

FROM ethereum.core.fact_hourly_token_prices

WHERE SYMBOL = 'WETH'

GROUP BY DAY

),

SOL_PRICE AS (

SELECT DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY,

AVG (SWAP_TO_AMOUNT/SWAP_FROM_AMOUNT) AS SOL_USD_PRICE

FROM solana.core.fact_swaps

WHERE SWAP_FROM_MINT = 'So11111111111111111111111111111111111111112'

AND SWAP_TO_MINT IN ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v','Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB')

AND SWAP_TO_AMOUNT > 0

AND SWAP_FROM_AMOUNT > 0

AND SUCCEEDED = 'TRUE'

GROUP BY DAY

),

ALGO_PRICE AS (

SELECT DATE_TRUNC('DAY', BLOCK_HOUR) AS DAY,

AVG (PRICE_USD) AS ALGO_USD_PRICE

FROM algorand.core.ez_price_pool_balances

WHERE ASSET_ID = '0'

GROUP BY DAY

),

FLOW_PRICE AS (

SELECT DATE_TRUNC('DAY', TIMESTAMP) AS DAY,

AVG (PRICE_USD) AS FLOW_USD_PRICE

FROM flow.core.fact_prices

WHERE SOURCE = 'coinmarketcap'

AND SYMBOL = 'FLOW'

GROUP BY DAY

),