DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS activity_date,

COUNT(DISTINCT TX_FROM) AS daily_active_users

FROM

sei.core.fact_transactions;

WHERE

TX_SUCCEEDED = TRUE

AND BLOCK_TIMESTAMP >= DATEADD(DAY, -60, CURRENT_DATE)

GROUP BY

activity_date

ORDER BY

activity_date ASC;