flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
TOTAL ACTIVE USERS
apostleoffinance
TOTAL ACTIVE USERS
Updated 2022-11-17
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
platform
,
COUNT
(
DISTINCT
tx_hash
)
AS
transaction_id
,
COUNT
(
DISTINCT
origin_from_address
)
AS
total_active_users
FROM
ethereum
.
core
.
ez_dex_swaps
WHERE
event_name
=
'Swap'
AND
platform
=
'uniswap-v3'
GROUP
BY
1
Results
Run a query to Download Data