SELECT BLOCK_TIMESTAMP, amount_in, amount_in_usd, amount_out, amount_out_usd, symbol_in, symbol_out,

CASE WHEN symbol_in = 'WETH' THEN 'buy' else 'sell' END AS side

FROM ethereum.defi.ez_dex_swaps

WHERE platform = 'curve' AND (SYMBOL_IN = 'stETH' OR SYMBOL_OUT = 'stETH') AND block_timestamp > '2023-12-01'

SELECT date_trunc('hour', block_timestamp) as date, sum(amount_in_usd) as volume

FROM trades

GROUP BY date

ORDER BY date