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 ETHEREUM.SUSHI.EZ_SWAPS

),

summary AS (

SELECT date,

count(txs) as dailyTXS,

SUM(amountInUSD) + SUM(amountoutusd) as dailyVolume

FROM total

GROUP BY date

ORDER BY date ASC

SELECT SUM(dailyVolume) as totalVolume, SUM(dailyVolume) / COUNT(date) as averageVolume_perDay

FROM summary