SELECT

COUNT(DISTINCT SENDER) AS DAU

FROM movement.core.fact_transactions

WHERE tx_type = 'user_transaction'

AND block_timestamp::Date >= current_date - 7

),

new_add AS (

SELECT

min(block_timestamp::date) as day,

sender

FROM movement.core.fact_transactions

WHERE tx_type = 'user_transaction'

group by 2

),

new_dau AS (

SELECT

COUNT(DISTINCT sender) AS new

FROM new_add

where day >= current_date - 7

SELECT

DAU,

DAU - COALESCE(new, 0) AS "Returning",

COALESCE(new, 0) AS "New Address"

FROM dau , new_dau