0xtollexActive users
Updated 2024-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
DATE_TRUNC(month,block_timestamp) date,
--origin_to_address,
--Platform,
COUNT(DISTINCT origin_from_address) Active_user
--symbol_in,
--amount_in_usd
FROM optimism.defi.ez_dex_swaps
WHERE
--AND platform = 'uniswap-v3'
event_name = 'Swap'
AND amount_in_usd IS NOT NULL
AND DATE(block_timestamp) >= '2023-01-01'
GROUP BY 1
ORDER BY 1 DESC
LIMIT 1000
QueryRunArchived: QueryRun has been archived