DATE | Daily avg tx per block | |
|---|---|---|
1 | 2024-12-16 00:00:00.000 | 1.052708 |
2 | 2024-12-11 00:00:00.000 | 1.05537 |
3 | 2024-12-02 00:00:00.000 | 1.003333 |
4 | 2025-02-24 00:00:00.000 | 1.112708 |
5 | 2024-11-29 00:00:00.000 | 1.000093 |
6 | 2025-01-24 00:00:00.000 | 1.1325 |
7 | 2025-01-25 00:00:00.000 | 1.103866 |
8 | 2025-02-05 00:00:00.000 | 1.119375 |
9 | 2025-01-17 00:00:00.000 | 1.090255 |
10 | 2025-01-28 00:00:00.000 | 1.131134 |
11 | 2024-12-06 00:00:00.000 | 1.050463 |
12 | 2025-03-14 00:00:00.000 | 1.079074 |
13 | 2025-03-07 00:00:00.000 | 1.146343 |
14 | 2025-01-13 00:00:00.000 | 1.12088 |
15 | 2024-12-04 00:00:00.000 | 1.048565 |
16 | 2025-03-13 00:00:00.000 | 1.084468 |
17 | 2025-03-12 00:00:00.000 | 1.160046 |
18 | 2025-03-03 00:00:00.000 | 1.146389 |
19 | 2025-02-23 00:00:00.000 | 1.089144 |
20 | 2025-02-26 00:00:00.000 | 1.132292 |
Mrfti2024-07-25 12:47 AM copy
Updated 1 day ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
-- forked from 2024-07-25 12:47 AM @ https://flipsidecrypto.xyz/studio/queries/33d39e25-bb8d-4f6d-941c-96ded7331dca
with tbl AS
(
SELECT
date_trunc(day, block_timestamp) as date,
count(DISTINCT block_number) as "Daily blocks",
sum(tx_count) as "Daily tx"
from swell.core.fact_blocks
GROUP by 1
)
SELECT
date,
"Daily tx"/"Daily blocks" as "Daily avg tx per block"
from tbl
where "Daily tx" is not null
--GROUP by 1,2
Last run: 1 day agoAuto-refreshes every 12 hours
...
112
4KB
2s