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

tx_hash as txs,

AMOUNT_IN_USD as amountInUSD,

amount_out_usd as amountoutUSD,

SYMBOL_IN as symbolIn,

SYMBOL_OUT as symbolOut

FROM OPTIMISM.SUSHI.EZ_SWAPS

SELECT date,

count(txs) as dailyTXS,

SUM(amountInUSD) + SUM(amountoutusd) as dailyVolume

FROM total

GROUP BY date

ORDER BY date ASC