select date_trunc('month',block_timestamp) as date,

count(DISTINCT tx_signer) as users

from near.core.fact_transactions

where date>= '2023-01-01'

group by 1

having date is not null

),

aurora as (

select date_trunc('month',block_timestamp) as date,

count(DISTINCT from_address) as users

from aurora.core.fact_transactions

where date>= '2023-01-01'

group by 1

select date,

a.users as "NEAR Monthly Users",

b.users as "AURORA Monthly Users"

from near a

left join Aurora b using(date)