TIME | AMOUNT_USD | TRANSACTION_SEQUENCE | HOURS_SINCE_PREVIOUS | RUNNING_TOTAL_USD | |
|---|---|---|---|---|---|
1 | 2025-03-02 08:58:59.000 | 9.59 | 38 | 0 | 327.43 |
2 | 2025-03-02 08:58:59.000 | 0.08 | 39 | 0 | 317.84 |
3 | 2025-03-02 08:58:59.000 | 9.67 | 37 | 233 | 308.09 |
4 | 2025-03-02 08:58:59.000 | 9.67 | 40 | 0 | 317.76 |
5 | 2025-02-20 15:19:47.000 | 21.08 | 36 | 80 | 298.42 |
6 | 2025-02-17 07:47:47.000 | 1.19 | 35 | 4 | 277.34 |
7 | 2025-02-17 03:03:11.000 | 0.56 | 33 | 0 | 276.15 |
8 | 2025-02-17 03:03:11.000 | 0 | 31 | 0 | 275.03 |
9 | 2025-02-17 03:03:11.000 | 0.56 | 34 | 0 | 275.59 |
10 | 2025-02-17 03:03:11.000 | 0.56 | 32 | 12 | 275.03 |
11 | 2025-02-16 15:52:59.000 | 2.6 | 30 | 0 | 274.45 |
12 | 2025-02-16 15:52:59.000 | 2.63 | 27 | 0 | 271.85 |
13 | 2025-02-16 15:52:59.000 | 2.6 | 29 | 0 | 269.22 |
14 | 2025-02-16 15:52:59.000 | 0.02 | 28 | 0 | 274.47 |
15 | 2025-02-16 15:08:23.000 | 0.01 | 24 | 0 | 264.5 |
16 | 2025-02-16 15:08:23.000 | 1.06 | 25 | 0 | 265.56 |
17 | 2025-02-16 15:08:23.000 | 1.06 | 26 | 0 | 266.62 |
18 | 2025-02-16 15:08:23.000 | 1.05 | 23 | 1 | 264.49 |
19 | 2025-02-16 14:45:23.000 | 2.49 | 21 | 0 | 258.46 |
20 | 2025-02-16 14:45:23.000 | 0.02 | 22 | 0 | 258.48 |
angelnathTransaction Sequencing
Updated 2025-03-12
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
›
⌄
-- For a given wallet address (you can use a placeholder like 'YOUR_WALLET_ADDRESS'),
-- write a query that shows all transactions in chronological order with:
-- 1. A sequential number for each transaction
-- 2. The time difference (in hours) between each transaction and the previous one
-- 3. A running total of the transaction amounts
SELECT
block_timestamp as time,
amount_usd,
-- Sequential number for each transaction
ROW_NUMBER() OVER (ORDER BY block_timestamp) AS transaction_sequence,
-- Time difference between transactions
DATEDIFF('hour',
LAG(block_timestamp) OVER (ORDER BY block_timestamp),
block_timestamp
) AS hours_since_previous,
-- Running total of amounts
SUM(amount_usd) OVER (ORDER BY block_timestamp ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS running_total_usd
FROM ethereum.core.ez_native_transfers
WHERE origin_from_address = '0x5d15392bfd0248fdf5300044440700eb509fe894'
ORDER BY block_timestamp DESC
Last run: about 1 month ago
40
2KB
1s