from gnosis.core.fact_transactions

group by 2)

,

new_user_count as ( select date , count(DISTINCT(from_address)) as new_users,

sum(new_users) over (order by date asc) as cum_new_user

from new_user

where date >= CURRENT_DATE - 120

group by 1)

,

transactions as ( select date(block_timestamp) as date , count(DISTINCT(tx_hash)) as total_tx,

sum(total_tx) over (order by date asc) as cum_tx

from gnosis.core.fact_transactions

where block_timestamp::date >= CURRENT_DATE - 120

group by 1)

select a.date, new_users, total_tx, cum_new_user, cum_tx

from transactions a left outer join new_user_count b on a.date = b.date