SELECT

HOUR AS price_time,

symbol,

price

FROM aleo.price.ez_prices_hourly

WHERE symbol = 'ALEO'

),

swaps_with_prices AS (

SELECT

s.tx_id,

s.swapper,

s.from_symbol,

s.to_symbol,

s.from_amount,

s.to_amount,

s.succeeded,

s.block_timestamp,

CASE

WHEN s.from_symbol = 'vUSDC' THEN 1

WHEN s.from_symbol IN ('ALEO', 'pALEO') THEN COALESCE(p.price, NULL)

ELSE NULL

END AS from_symbol_price,

CASE

WHEN s.to_symbol = 'vUSDC' THEN 1

WHEN s.to_symbol IN ('ALEO', 'pALEO') THEN COALESCE(q.price, NULL)

ELSE NULL

END AS to_symbol_price

FROM aleo.defi.fact_swaps s

LEFT JOIN aleo_prices p ON s.from_symbol IN ('ALEO', 'pALEO') AND s.block_timestamp >= p.price_time

LEFT JOIN aleo_prices q ON s.to_symbol IN ('ALEO', 'pALEO') AND s.block_timestamp >= q.price_time

WHERE s.succeeded = TRUE

),

swap_volume AS (

SELECT