mau_near AS

SELECT

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

, count( DISTINCT a.tx_signer ) AS "active users"

, sum( "active users" ) over ( ORDER BY "date" ASC ) AS "total active users"

FROM

near.core.fact_transactions a

LEFT JOIN

near.core.dim_address_labels b

ON a.tx_receiver = b.address

WHERE

b.project_name IS NOT NULL

AND a.tx_signer != a.tx_receiver

AND "date" > dateadd( 'month', -{{month}} , current_date )

GROUP BY 1

ORDER BY 1 DESC

,

mau_aurora AS

SELECT

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

, count( DISTINCT a.from_address ) AS "active users"

, sum( "active users" ) over ( ORDER BY "date" ASC ) AS "total active users"

FROM

aurora.core.fact_transactions a

WHERE

a.from_address != a.to_address

AND "date" > dateadd( 'month', -{{month}} , current_date )

GROUP BY 1

ORDER BY 1 DESC