TOTAL_TX_HASH | TOTAL_USERS | ACTIVE_TRADERS_LAST_24H | ACTIVE_TRADERS_LAST_7D | TX_LAST_1H | TX_LAST_24H | TX_LAST_7D | FIRST_SWAP_TIME | LAST_SWAP_TIME | ACTIVE_DAYS | FREQUENT_TRADERS_10PLUS_TX | MEDIAN_TX_PER_USER | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 396129 | 71074 | 495 | 1929 | 1 | 2462 | 12564 | 2024-12-26 21:00:00.000 | 2025-04-28 03:00:00.000 | 124 | 9156 | 9 |
datavortexTotal Trades
Updated 9 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 SwapData AS (
SELECT
tx_hash,
origin_from_address,
block_timestamp
FROM
ink.core.ez_decoded_event_logs
WHERE
event_name = 'Swap'
AND origin_to_address = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
AND block_timestamp IS NOT NULL
AND tx_succeeded = TRUE
)
SELECT
COUNT(DISTINCT tx_hash) AS total_tx_hash,
COUNT(DISTINCT origin_from_address) AS total_users,
COUNT(
DISTINCT CASE
WHEN block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '24 hours' THEN origin_from_address
ELSE NULL
END
) AS active_traders_last_24h,
COUNT(
DISTINCT CASE
WHEN block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '7 days' THEN origin_from_address
ELSE NULL
END
) AS active_traders_last_7d,
COUNT(
DISTINCT CASE
WHEN block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '1 hour' THEN tx_hash
ELSE NULL
END
) AS tx_last_1h,
COUNT(
DISTINCT CASE
Last run: 9 days ago
1
101B
3s