trunc(x.block_timestamp,'day') as date,

count(distinct from_address) as daily_swappers,

sum(daily_swappers) over (order by date) as cum_swappers,

count(distinct x.tx_hash) as daily_swaps,

sum(daily_swaps) over (order by date) as cum_swaps,

sum(tx_fee) as daily_swap_fees,

sum(daily_swap_fees) over (order by date) as cum_swap_fees,

avg(tx_fee) as avg_fee_per_swap

from gnosis.core.fact_transactions x

join gnosis.core.fact_event_logs y on x.tx_hash = y.tx_hash

where event_name = 'Swap'

group by 1

order by 1 asc