SELECT 'NaN' as nan

), universe AS (

SELECT FROM_ADDRESS AS ADDRESS, BLOCK_TIMESTAMP

FROM base.core.fact_transactions

), contracts AS (

SELECT ADDRESS, CREATED_BLOCK_TIMESTAMP

FROM base.core.dim_contracts

WHERE CREATED_BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '24 hours'

), accounts AS (

SELECT DISTINCT(t1.address)

FROM universe t1

LEFT JOIN contracts t2 ON t2.address = t1.address

WHERE t2.address IS NULL

AND t1.BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '24 hours'

SELECT COUNT(ADDRESS)

FROM accounts