BLOCK_TIMESTAMP | VALUE | TX_FEE | FROM_ADDRESS | TO_ADDRESS | |
|---|---|---|---|---|---|
1 | 2025-02-20 15:59:06.000 | 3 | 7.41 | 0xcc7842f66fa9a8ab6920854ec3db9517aad9bbce | 0x5773fe763c7dfc57debcff7217962282d2466803 |
2 | 2025-02-20 19:11:55.000 | 20 | 7.41 | 0x6fa8c5688a2dbd5ef9fbbdb8994dd40bf5f9bb1f | 0xa3a8d555e0d7ec5f91eff80d929c555aa5fb9849 |
3 | 2025-02-20 21:16:52.000 | 2 | 7.41 | 0x6fa8c5688a2dbd5ef9fbbdb8994dd40bf5f9bb1f | 0x5c0896b8fd3723ceb02e29e607e7b6413b42c678 |
4 | 2025-02-20 21:31:24.000 | 1 | 7.41 | 0x6fa8c5688a2dbd5ef9fbbdb8994dd40bf5f9bb1f | 0x1ec6823aad9985f68b3eef8020ea71cdcae2d4cf |
5 | 2025-02-21 04:21:21.000 | 10 | 7.41 | 0x6fa8c5688a2dbd5ef9fbbdb8994dd40bf5f9bb1f | 0x7a491589650198b4872f8fb8b700165ac4c2fc1a |
6 | 2025-02-21 04:25:47.000 | 10 | 7.41 | 0x6fa8c5688a2dbd5ef9fbbdb8994dd40bf5f9bb1f | 0x7a491589650198b4872f8fb8b700165ac4c2fc1a |
7 | 2025-02-22 09:30:46.000 | 10 | 7.41 | 0x81512186bf3639b2516002f1876db0960dfd9781 | 0x3c3af080950e9ad4e69b31cca7b65ffc260b42f2 |
8 | 2025-02-23 23:56:06.000 | 5 | 7.41 | 0x81512186bf3639b2516002f1876db0960dfd9781 | 0x3556331841da461c66af3b95bcbd4e03b9465321 |
9 | 2025-02-25 19:17:13.000 | 0.5 | 27.5 | 0x32fa31de56d8baa24bbbf727c9dd6789e32caf16 | 0x9541738f4adbc711a3a7d8689cff272e4e093929 |
10 | 2025-02-26 09:52:15.000 | 0.01 | 21000 | 0x9a0c4b4997485f51ff1013f7080464780ba8b67d | 0xf0d452e397d81bc2aff4b905982062b1e88f1270 |
11 | 2025-02-26 09:53:46.000 | 0.01 | 21000 | 0x9a0c4b4997485f51ff1013f7080464780ba8b67d | 0xc67a44cd2cdba49dcc3f6f33093cc35ca54b0aaf |
12 | 2025-03-10 13:38:15.000 | 0.101 | 7.33875 | 0xde4ca1e38de15f1533df1f3660eef16c80152bdb | 0xd20ccb1152a69a7f10657e2530def9ea4bf089fc |
JeffersTransfers with gas fee > 5 MON
Updated 2025-03-14
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT t.block_timestamp, t.value, t.tx_fee, t.from_address, t.to_address -- t.tx_fee AS tx_fee
FROM monad.testnet.fact_transactions t
LEFT JOIN monad.testnet.dim_contracts c
ON t.to_address = c.address -- Check if receiver is a smart contract
WHERE value > 0 and t.tx_fee > 5
AND t.block_timestamp :: date >= '2025-02-19 15:00'
AND t.tx_succeeded = 'TRUE'
AND c.address IS NULL -- Only keep EOAs (not in dim_contracts)
AND t.from_address != t.to_address -- Exclude self-transfers
ORDER BY block_timestamp
Last run: 25 days ago
12
1KB
3s