DATE | NO_OF_TX | |
|---|---|---|
1 | 2024-09-11 00:00:00.000 | 1170510 |
2 | 2024-09-10 00:00:00.000 | 1166560 |
3 | 2024-09-09 00:00:00.000 | 1158357 |
4 | 2024-09-03 00:00:00.000 | 1129081 |
5 | 2024-09-06 00:00:00.000 | 1124382 |
6 | 2024-09-05 00:00:00.000 | 1121084 |
7 | 2024-09-07 00:00:00.000 | 1115728 |
8 | 2024-09-04 00:00:00.000 | 1108873 |
9 | 2024-09-02 00:00:00.000 | 1086384 |
10 | 2024-09-08 00:00:00.000 | 1085480 |
11 | 2024-09-01 00:00:00.000 | 1011212 |
defi__joshno. of ETH tx
Updated 2025-03-19
9
1
2
3
4
5
6
7
8
›
⌄
select
block_timestamp :: date as date,
count(tx_hash) as no_of_tx
from ethereum.core.fact_transactions
where block_timestamp :: date between '2024-09-01' and '2024-09-11'
group by date
order by no_of_tx desc;
Last run: 23 days ago
11
397B
3s