date_trunc('day', BLOCK_TIMESTAMP) AS DATE,

count(VALUE) as NEW_USERS

FROM flipside_prod_db.mdao_harmony.txs

WHERE NONCE = '0x0'

GROUP BY DATE

ORDER BY DATE ASC