with

new_users AS

SELECT

min( a.block_timestamp ) AS min_date

, a.origin_from_address AS new_users

FROM

ethereum.core.ez_dex_swaps a

WHERE

a.platform LIKE 'uniswap%'

GROUP BY 2

ORDER BY 1 DESC

,

final AS

SELECT

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

, count( DISTINCT a.new_users ) AS "new users"

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

FROM

new_users a

WHERE

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

AND "date" < dateadd( 'month' , -1 , current_date )

GROUP BY 1

ORDER BY 1 DESC

SELECT

avg( "new users" ) , sum( "new users" )

FROM

final