DAY | ETH_TRANSACTIONS | |
|---|---|---|
1 | 2023-07-20 00:00:00.000 | 1018668 |
2 | 2023-06-22 00:00:00.000 | 1021765 |
3 | 2023-08-01 00:00:00.000 | 1041275 |
4 | 2023-08-05 00:00:00.000 | 1096633 |
5 | 2023-03-23 00:00:00.000 | 1054724 |
6 | 2023-02-06 00:00:00.000 | 1048345 |
7 | 2023-03-19 00:00:00.000 | 960934 |
8 | 2023-12-15 00:00:00.000 | 1140711 |
9 | 2024-01-24 00:00:00.000 | 1063317 |
10 | 2023-05-08 00:00:00.000 | 1092421 |
11 | 2023-07-25 00:00:00.000 | 956796 |
12 | 2023-07-27 00:00:00.000 | 966918 |
13 | 2023-09-04 00:00:00.000 | 926766 |
14 | 2023-02-04 00:00:00.000 | 1033600 |
15 | 2023-06-23 00:00:00.000 | 1028768 |
16 | 2023-10-07 00:00:00.000 | 977015 |
17 | 2023-03-08 00:00:00.000 | 978537 |
18 | 2024-01-13 00:00:00.000 | 1197988 |
19 | 2024-01-17 00:00:00.000 | 1159195 |
20 | 2023-07-13 00:00:00.000 | 1090777 |
Blazeeth daily trans
Updated 2024-01-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- forked from 2024-01-31 06:42 PM copy @ https://flipsidecrypto.xyz/edit/queries/18855e17-1dc6-4f70-86ae-01e8037967ab
select
date_trunc('day',block_timestamp) as day,
count(distinct tx_hash) as eth_transactions
from
ethereum.core.fact_transactions as eth
where
date_trunc('day',block_timestamp) >date_trunc('day',CURRENT_TIMESTAMP) - interval '12 months'
and status='SUCCESS'
group by 1
Last run: about 1 year ago
...
365
13KB
45s