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

count(distinct x.origin_from_address) as daily_xdai_transferrers,

sum(daily_xdai_transferrers) over (order by date) as cum_xdai_transferrers,

count(distinct x.tx_hash) as daily_xdai_transfers,

sum(daily_xdai_transfers) over (order by date) as cum_xdai_transfers,

sum(tx_fee) as daily_xdai_transfer_fees,

sum(daily_xdai_transfer_fees) over (order by date) as cum_xdai_transfer_fees,

avg(tx_fee) as avg_fee_per_xdai_transfer

from gnosis.core.ez_xdai_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