TRANSFER_DATE | TOTAL_TRANSFERS | TOTAL_VALUE | |
|---|---|---|---|
1 | 2025-02-19 00:00:00.000 | 159021 | 2143616.93 |
2 | 2025-02-20 00:00:00.000 | 1121326 | 4214603.67 |
3 | 2025-02-21 00:00:00.000 | 1024136 | 3523760.83 |
4 | 2025-02-22 00:00:00.000 | 487575 | 42783419.25 |
5 | 2025-02-23 00:00:00.000 | 542966 | 4623335.54 |
6 | 2025-02-24 00:00:00.000 | 614882 | 4866384.32 |
7 | 2025-02-25 00:00:00.000 | 944317 | 8597674.02 |
8 | 2025-02-26 00:00:00.000 | 1543044 | 7142873.65 |
9 | 2025-02-27 00:00:00.000 | 782249 | 3997776.69 |
10 | 2025-02-28 00:00:00.000 | 1276113 | 3033618.36 |
11 | 2025-03-01 00:00:00.000 | 742032 | 3455750.17 |
12 | 2025-03-02 00:00:00.000 | 695320 | 2406623.55 |
13 | 2025-03-03 00:00:00.000 | 860864 | 13931053.35 |
14 | 2025-03-04 00:00:00.000 | 1008681 | 3113053.66 |
15 | 2025-03-05 00:00:00.000 | 918271 | 2337439.42 |
JeffersMon transfers
Updated 2025-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
DATE(t.block_timestamp) AS transfer_date,
COUNT(*) AS total_transfers,
round(SUM(t.value), 2) AS total_value
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 t.value > 0 and t.block_timestamp >= '2025-02-19 15:00' and t.tx_succeeded = 'TRUE'
AND c.address IS NULL -- Only include transfers to EOAs
AND t.from_address != t.to_address -- Exclude self-transfers
group by transfer_date
ORDER BY transfer_date ASC;
Last run: 13 days ago
15
698B
8s