tannycompact-jade
Updated 2024-11-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- Count of Unique Users Engaging with Uniswap v3 Each Month
SELECT
DATE_TRUNC('month', block_timestamp) AS month,
COUNT(DISTINCT sender) AS unique_users
FROM
ethereum.uniswapv3.ez_swaps
WHERE
block_timestamp BETWEEN '2024-07-01' AND '2024-09-30'
GROUP BY
month
ORDER BY
month;
QueryRunArchived: QueryRun has been archived