---------------------------FLOW---------------------------

flow_new_user as (

select

PROPOSER,

min(block_timestamp) as min_date

from

flow.core.fact_transactions

where

TX_SUCCEEDED = 'TRUE'

group by

1

),

flow_N_new_user as (

select

count(distinct proposer) as "# New User"

from

flow_new_user

where

min_date >= CURRENT_DATE - 180

),

flow_New_users_TXs as (

select

count(distinct TX_ID) as "# TXs"

from

flow.core.fact_transactions

where

1 = 1

and PROPOSER in (

select

proposer

from

flow_new_user

where

min_date >= CURRENT_DATE - 180

)