select

ROW_NUMBER() OVER (ORDER BY month) AS row_num,*

from ( select

date_trunc('month', tm) as month,

count(distinct sender) as squid_n_new_address,

sum(squid_n_new_address) OVER (

ORDER BY month asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW

) AS Squid_user_growth

from (

select sender, min(block_timestamp) as tm

from axelar.core.ez_squid

group by 1

order by 1

)

group by 1

order by 1 asc

)

), tc as (

select

ROW_NUMBER() OVER (ORDER BY month) AS row_num,* from (select

date_trunc('month', tm) as month,

count(distinct from_address) as tc_n_new_address,

sum(tc_n_new_address) OVER (

ORDER BY month asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW

) AS Thorchain_user_growth

from (

select from_address, min(block_timestamp) as tm

from thorchain.core.fact_swaps

group by 1

)

group by 1

order by 1 asc

limit 100)