FIRST_DATE | USERS | TX | TOTAL_7_DAYS_TRANSACTION_VOLUME | NEW_USERS | NEW_USERS_TX | NEW_USERS_TRANSACTION_VOLUME | |
|---|---|---|---|---|---|---|---|
1 | 2025-03-24 00:00:00.000 | 2785596 | 9482692 | 3235263126.405 | 2471032 | 3493688 | 108299349.59 |
i_danBase DEXs: Total Users And New Users Transactions And Volume In Last 7 Days
Updated 2 days ago
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH recent_transactions AS (
SELECT
origin_from_address,
tx_hash,
amount_in_usd,
amount_out_usd,
MIN(date_trunc('day', block_timestamp)) AS first_date
FROM
base.defi.ez_dex_swaps
WHERE block_timestamp >= (current_date - INTERVAL '7 DAYS')
GROUP BY 1, 2, 3, 4
),
filtered_addresses AS (
SELECT
origin_from_address
FROM
base.defi.ez_dex_swaps
WHERE block_timestamp < (current_date - INTERVAL '7 DAYS')
GROUP BY origin_from_address
),
new_users AS (
SELECT
COUNT(DISTINCT r.origin_from_address) AS new_users
, MIN(r.first_date) AS date
, COUNT(DISTINCT r.tx_hash) AS new_users_tx
, SUM(ABS(amount_in_usd) + ABS(amount_out_usd)) / 2 AS New_users_transaction_volume
FROM
recent_transactions r
LEFT JOIN filtered_addresses f
ON r.origin_from_address = f.origin_from_address
WHERE
f.origin_from_address IS NULL
ORDER BY r.first_date;
),
Last run: 2 days ago
1
89B
28s