-- forked from NEAR - MAU copy @ https://flipsidecrypto.xyz/edit/queries/f81ab652-ad80-45e3-b6f9-a72c56b68a99

-- forked from NEAR - MAU @ https://flipsidecrypto.xyz/edit/queries/52b580a7-5541-4f51-ba5b-56a30b09362a

-- forked from StangFAST / 01 - chart @ https://flipsidecrypto.xyz/StangFAST/q/41DvKHIA2J5w/01---chart

SELECT

date_trunc( 'month' , a.block_timestamp ) AS "date"

, count( DISTINCT a.from_address ) AS "Active Users"

FROM

arbitrum.core.fact_transactions a

WHERE "date" >= '2023-01-01'

AND "date" < '2023-10-01'

GROUP BY 1

ORDER BY 1 DESC