with tab1 as (

SELECT TX_HASH

from near.core.ez_token_transfers

where CONTRACT_ADDRESS='linear-protocol.near'

and MEMO='stake'

select date_trunc('week',BLOCK_TIMESTAMP)as week

,count(distinct FROM_ADDRESS)as total_stakers

from near.core.ez_token_transfers

where TX_HASH in (select TX_HASH from tab1)

and TO_ADDRESS='linear-protocol.near'

and BLOCK_TIMESTAMP::date>=current_date-180

group by 1

),

act2 as (

with tab1 as (

SELECT TX_HASH

from near.core.ez_token_transfers

where CONTRACT_ADDRESS='linear-protocol.near'

and MEMO='stake'

select FROM_ADDRESS

,min(BLOCK_TIMESTAMP::date) as first_time

from near.core.ez_token_transfers

where TX_HASH in (select TX_HASH from tab1)

and TO_ADDRESS='linear-protocol.near'

group by 1

),

act3 as (

select date_trunc('week',first_time) as week

,count(distinct FROM_ADDRESS) as new_stakers

from act2

group by 1

select