-- forked from 01 - new users monthly @ https://flipsidecrypto.xyz/edit/queries/8ceba136-b558-46d8-8598-abf79e95ffab

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.block_timestamp ) AS "date"

, count( DISTINCT a.origin_from_address ) AS "users"

, count( DISTINCT a.tx_hash ) AS "transactions"

, sum( a.amount_in_usd ) AS "usd volume"

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

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

, sum( "usd volume" ) over ( ORDER BY "date" ASC ) AS "total usd volume"

FROM

ethereum.core.ez_dex_swaps a

INNER JOIN

new_users b