with base3 as (select block_timestamp,
from_address as active_user,
tx_hash
from gnosis.core.fact_transactions
where block_timestamp >= '2022-05-17'),
base13 as (select block_timestamp,
from_address as active_user,
tx_hash
from ethereum.core.fact_transactions
where block_timestamp >= '2022-05-17')
select
date_trunc('day', block_timestamp) as day,
date_trunc('week', block_timestamp) as week,
count(distinct(active_user)),
count(distinct(tx_hash)),
'Ethereum'
from base13
group by 1,2
union
select
date_trunc('day', block_timestamp) as day,
date_trunc('week', block_timestamp) as week,
count(distinct(active_user)),
count(distinct(tx_hash)),
'Gnosis'
from base3
group by 1,2
order by 4 asc