DATE(BLOCK_TIMESTAMP) AS activity_date,

COUNT(DISTINCT BLOCK_ID) AS daily_active_addresses

FROM

near.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= current_date - INTERVAL '30 days'

AND TX_SUCCEEDED = 'TRUE'

GROUP BY

activity_date

ORDER BY

activity_date;