Query editor
WITH smart_contract_address AS (SELECT DISTINCT addressFROM ethereum.tracesWHERE 'type' = 'create'AND code IS NOT NULLAND success),first_transaction AS (SELECT MIN(block_time) AS first_txn,"from" AS userFROM ethereum.transactionsWHERE "from" NOT IN (SELECT address FROM smart_contract_address)AND block_time < date_trunc('week', (SELECT MAX(block_time) FROM ethereum.transactions))GROUP BY 2),new_data AS (SELECT DATE_TRUNC('week', first_txn) AS time,COUNT (user) AS new_usersFROM first_transactionGROUP BY 1),total_data AS (SELECT DATE_TRUNC('week', block_time) time,COUNT(DISTINCT "from") AS total_usersFROM ethereum.transactionsWHERE "from" NOT IN (SELECT address FROM smart_contract_address)AND block_time < DATE_TRUNC('week', (SELECT MAX(block_time) FROM ethereum.transactions))GROUP BY 1)SELECT td.time,td.total_users - nd.new_users AS existing_users,nd.new_usersFROM total_data tdLEFT JOIN new_data ndON td.time = nd.timeGROUP BY 1, 2, 3ORDER BY td.time ASC