SELECT date(block_timestamp) as day, avg(fee_usd) as avg_fee_paid , avg(avg_fee_paid) over (order by day) as avg_fee_paid_over_time,
count(*) as total_txs , sum(total_txs) over (order by day)
from ethereum.transactions where tx_id in
(SELECT tx_id from ethereum.dex_swaps
where platform = 'sushiswap') and date(block_timestamp) > '2021-11-20' AND DATE(BLOCK_TIMESTAMP)< '2021-12-01'
GROUP by 1
limit 100