select

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

from ( select

date_trunc('day', tm) as day,

count(distinct sender) as n_new_address,

sum(n_new_address) OVER (

ORDER BY day asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW

) AS Stargate_user_growth

from (select

origin_from_address as sender,

min(t) as tm

from(

(

select

origin_from_address,

block_timestamp as t

from

ethereum.core.fact_token_transfers

where

origin_to_address = '0x5cbe98480a790554403694b98bff71a525907f5d' --tx_hash='0x00a9c0efae65cdeb7f73d39d50b3736ff7b6a7e3c792cfd4343ab472b1bb4ca1'

)

union

(

select

origin_from_address,

block_timestamp as t

from

arbitrum.core.fact_token_transfers

where

origin_to_address = '0x650af55d5877f289837c30b94af91538a7504b76'

--or origin_to_address = '0xbf22f0f184bccbea268df387a49ff5238dd23e40'

--tx_hash='0x00a9c0efae65cdeb7f73d39d50b3736ff7b6a7e3c792cfd4343ab472b1bb4ca1'

)