-- forked from 02 - new users @ https://flipsidecrypto.xyz/edit/queries/b8ce767b-da86-444f-9f78-38482ab9a13f

-- forked from 02 - number @ https://flipsidecrypto.xyz/edit/queries/cf03d9d3-1a09-484c-88e3-2c9dcfe61829

-- forked from 01 - number @ https://flipsidecrypto.xyz/edit/queries/f08de54b-d0bc-498e-9a5c-2563c144ba9c

with

new AS

SELECT

min( a.block_timestamp ) AS min_date

, a.origin_from_address AS new_user

FROM

ethereum.core.ez_dex_swaps a

WHERE

a.platform LIKE 'uniswap%'

AND a.amount_in_usd IS NOT NULL

AND a.amount_in_usd > 0

GROUP BY

2

ORDER BY

1 DESC

,

eth_price AS

SELECT

date_trunc( 'day' , a.hour ) AS date

, avg( a.price ) AS price_usd

FROM

ethereum.core.fact_hourly_token_prices a