StangFAST02 - new users' activity token in
Updated 2023-08-03Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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
)
,
top_tokens AS
(
SELECT
a.symbol_in AS "token"
, sum( a.amount_in_usd ) AS "usd volume"
FROM
ethereum.core.ez_dex_swaps a
INNER JOIN
new_users b
ON a.origin_from_address = b.new_users
WHERE
a.platform LIKE 'uniswap%'
AND a.block_timestamp::date > '2023-01-01'
AND a.amount_in_usd IS NOT NULL
GROUP BY 1
ORDER BY 2 DESC LIMIT 100
)
Run a query to Download Data