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

count(distinct x.origin_from_address) as daily_trasnferrers,

sum(daily_trasnferrers) over (order by date) as cum_transferrers,

count(distinct x.tx_hash) as daily_transfers,

sum(daily_transfers) over (order by date) as cum_transfers,

sum(tx_fee) as daily_transfer_fees,

sum(daily_transfer_fees) over (order by date) as cum_transfer_fees,

avg(tx_fee) as avg_fee_per_transfer

from gnosis.core.fact_token_transfers x

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

join gnosis.core.fact_transactions z on x.tx_hash=z.tx_hash

where event_name = 'Swap'

group by 1

order by 1 asc