TeexaTOTAL ACTIVE USERS
Updated 2024-06-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
--- Date_Trunc('day',block_timestamp) AS Date,
platform,
COUNT(DISTINCT origin_from_address) AS Total_user
--symbol_in,
--COUNT (DISTINCT tx_hash) AS No_of_Transactions
--event_name
FROM arbitrum.defi.ez_dex_swaps
WHERE platform = 'uniswap-v3'
---AND Date >= '2023-10-01'
GROUP BY 1
ORDER BY 1 DESC
LIMIT 1000
QueryRunArchived: QueryRun has been archived