WITH sushi_vol as (SELECT date_trunc('day', block_timestamp) as days,

sum(amount_out_usd) as sushi_volume,

count(DISTINCT tx_hash) as swaps,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM optimism.sushi.ez_swaps

GROUP BY 1

)

SELECT *

FROM (SELECT date_trunc('day', block_timestamp) as day,

avg(amount_out_usd/amount_out) as avg_price,

median(amount_out_usd/amount_out) as OP_price

FROM optimism.sushi.ez_swaps

WHERE SYMBOL_OUT LIKE 'OP'

GROUP BY 1

)

LEFT outer JOIN sushi_vol

ON days = day