jay_1ARB ACTIVE USERS OVERTIME
Updated 2024-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from ARB TOTAL NUMBER OF TRANSACTIONS @ https://flipsidecrypto.xyz/edit/queries/30a0c408-9135-4482-bfce-9013ce5d8e7e
SELECT
date_trunc('day', block_timestamp) AS Date,
COUNT(DISTINCT origin_from_address) AS active_users_overtime
--platform
FROM arbitrum.defi.ez_dex_swaps
WHERE event_name = 'Swap'
AND amount_in_usd IS NOT NULL
AND platform = 'camelot-v3'
--AND symbol_in = 'ARB'
--AND DATE(block_timestamp) >= '2023-01-01'
GROUP BY 1
ORDER BY 2 DESC
LIMIT 1000
QueryRunArchived: QueryRun has been archived