WITH dex_prices AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS pr_dt,

AVG(CASE

WHEN symbol_in = 'OP' THEN amount_in_usd/amount_in

WHEN symbol_out = 'OP' THEN amount_out_usd/amount_out END

) AS price

FROM

optimism.sushi.ez_swaps

GROUP BY pr_dt

ORDER BY pr_dt desc

SELECT * FROM dex_prices