SELECT

origin_from_address AS user_address,

block_timestamp

FROM

base.core.fact_event_logs

WHERE

block_timestamp::date >= '2024-01-01'

AND block_timestamp::date < '2024-07-01'

AND TX_STATUS = 'SUCCESS'

),

old_wallets AS (

SELECT

origin_from_address AS user_address,

block_timestamp

FROM

base.core.fact_event_logs

WHERE

block_timestamp::date < '2024-01-01'

AND TX_STATUS = 'SUCCESS'

SELECT

COUNT(DISTINCT nw.user_address) AS new_wallet_count

FROM

new_wallets nw

LEFT JOIN

old_wallets ow ON nw.user_address = ow.user_address

WHERE

ow.user_address IS NULL;