-- Get the first transaction date for each address

SELECT

sender,

MIN(DATE_TRUNC('week', block_timestamp)) AS first_tx_week

FROM

aptos.core.fact_transactions

WHERE

tx_type = 'user_transaction'

AND success = TRUE

AND block_timestamp >= '2022-10-17'

GROUP BY

sender

SELECT

first_tx_week AS week,

COUNT(DISTINCT sender) AS new_addresses

FROM

address_first_tx

WHERE

first_tx_week >= '2024-01-01' -- Only consider new addresses for 2024

GROUP BY

first_tx_week

ORDER BY

week;