vhictoiryaAerodrome: Number of Active users
Updated 2025-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
SELECT
date_trunc ('day', block_timestamp) AS Date,
COUNT (DISTINCT origin_from_address) AS Active_Users
---amount_in_usd,
---platform,
---symbol_in,
---tx_hash,
---event_name
FROM
base.defi.ez_dex_swaps
WHERE
event_name = 'Swap'
AND
amount_in_usd IS NOT NULL
AND
platform = 'aerodrome'
AND
Date (block_timestamp) BETWEEN '2023-05-01' AND '2024-01-01'
GROUP BY
1
ORDER BY
1 DESC
LIMIT
1000
QueryRunArchived: QueryRun has been archived