flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Base DEXs: Returning Users To One Time User Percentage
i_dan
Base DEXs: Returning Users To One Time User Percentage
Updated 2024-09-07
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
origin_from_address
,
CASE
WHEN
COUNT
(
DISTINCT
tx_hash
)
>
1
THEN
'Returning User'
ELSE
'One Time User'
END
AS
User_Status
,
COUNT
(
tx_hash
)
AS
no_of_transactions
FROM
base
.
defi
.
ez_dex_swaps
GROUP
BY
1
--ORDER BY 1 DESC
--LIMIT 100
Results
QueryRunArchived: QueryRun has been archived