-- forked from 02 - new users' activity @ https://flipsidecrypto.xyz/edit/queries/a21e20ca-cd8b-4d04-b52e-6ea02f087ce3

-- 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

a.symbol_in AS "token"

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

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

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

, "total transactions" / "total users" AS "transactions per user"

, "total usd volume" / "total users" AS "usd volume per user"

FROM

ethereum.core.ez_dex_swaps a

INNER JOIN

new_users b

ON a.origin_from_address = b.new_users