( (SELECT

BLOCK_TIMESTAMP ,

TO_ADDRESS AS USER

FROM

blast.core.ez_native_transfers

WHERE

FROM_ADDRESS='0xf70da97812cb96acdf810712aa562db8dfa3dbef')

UNION ALL

(SELECT

BLOCK_TIMESTAMP ,

FROM_ADDRESS AS USER

FROM

blast.core.ez_native_transfers

WHERE

TO_ADDRESS='0xf70da97812cb96acdf810712aa562db8dfa3dbef')),

T2 AS

(SELECT

MIN(BLOCK_TIMESTAMP) AS DOTE,

USER

FROM T1

GROUP BY 2),

T3 AS

(SELECT

COUNT(*) AS ACTIVE_USERS ,

DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DATE

FROM T1

GROUP BY 2),