txns as (

select

t.*,

((t.gas_price/1e9) * (t.gas_used)) as gas_used_eth

from gnosis.core.fact_transactions t

join gnosis.core.fact_event_logs e on t.tx_hash = e.tx_hash and e.event_name = 'Swap'

select

block_timestamp::date as date,

count(distinct from_address) as n_users,

count(distinct tx_hash) as swap_frequency,

sum(gas_used_eth) as swap_gas_eth,

sum(n_users) over (order by date asc rows between unbounded preceding and current row) as cum_n_users,

sum(swap_gas_eth) over (order by date asc rows between unbounded preceding and current row) as cum_swap_gas_eth,

sum(swap_frequency) over (order by date asc rows between unbounded preceding and current row) as cum_swap_frequency

from txns

group by date