ssq.time,

new_users as "New",

(unique_users - new_users) as "Old"

FROM (

SELECT

sq.time,

COUNT(*) AS new_users

FROM (

SELECT

FROM_ADDRESS as unique_users,

MIN(date_trunc('day', BLOCK_TIMESTAMP)) AS time

FROM ethereum.core.fact_transactions

GROUP BY 1

ORDER BY 1 DESC

) sq

GROUP BY 1

) ssq

LEFT JOIN (

SELECT

date_trunc('day', BLOCK_TIMESTAMP) AS time,

COUNT(DISTINCT FROM_ADDRESS) AS unique_users

FROM ethereum.core.fact_transactions

GROUP BY 1

ORDER BY 1

) t2 ON t2.time = ssq.time

ORDER BY 1 DESC