Query editor
SELECT dt, num_txs, active_users, new_users, active_users - new_users AS existing_usersFROM(SELECT DATE_TRUNC('day',tx.block_time) AS dt,COUNT(*) AS num_txs,COUNT(DISTINCT "from") AS active_users,SUM(CASE WHEN "nonce" = 0AND "from" NOT IN (SELECT user_address FROM ovm1."user_addresses")THEN 1 ELSE 0 END) AS new_usersFROM optimism.transactions txGROUP BY 1) a