DATE | Daily avg tx per block | |
|---|---|---|
1 | 2024-12-21 00:00:00.000 | 1.099676 |
2 | 2024-12-20 00:00:00.000 | 1.105324 |
3 | 2024-12-12 00:00:00.000 | 1.048611 |
4 | 2025-02-12 00:00:00.000 | 1.127662 |
5 | 2025-01-21 00:00:00.000 | 1.105787 |
6 | 2025-02-04 00:00:00.000 | 1.156042 |
7 | 2024-12-25 00:00:00.000 | 1.088194 |
8 | 2025-01-23 00:00:00.000 | 1.166667 |
9 | 2025-02-08 00:00:00.000 | 1.097639 |
10 | 2024-12-22 00:00:00.000 | 1.109792 |
11 | 2024-12-17 00:00:00.000 | 1.050856 |
12 | 2025-01-10 00:00:00.000 | 1.100741 |
13 | 2025-01-12 00:00:00.000 | 1.082106 |
14 | 2025-02-16 00:00:00.000 | 1.120949 |
15 | 2025-03-02 00:00:00.000 | 1.127315 |
16 | 2024-12-11 00:00:00.000 | 1.05537 |
17 | 2024-12-16 00:00:00.000 | 1.052708 |
18 | 2024-11-29 00:00:00.000 | 1.000093 |
19 | 2025-02-24 00:00:00.000 | 1.112708 |
20 | 2024-12-02 00:00:00.000 | 1.003333 |
Mrfti2024-07-25 12:47 AM copy
Updated 21 hours 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: about 21 hours agoAuto-refreshes every 12 hours
...
111
4KB
3s