DATE | Daily avg tx per block | |
|---|---|---|
1 | 2025-01-04 00:00:00.000 | 1.077546 |
2 | 2024-12-27 00:00:00.000 | 1.081042 |
3 | 2025-01-08 00:00:00.000 | 1.106412 |
4 | 2025-01-07 00:00:00.000 | 1.101389 |
5 | 2025-01-27 00:00:00.000 | 1.136829 |
6 | 2025-02-03 00:00:00.000 | 1.177523 |
7 | 2024-12-23 00:00:00.000 | 1.103981 |
8 | 2025-01-03 00:00:00.000 | 1.082986 |
9 | 2025-01-18 00:00:00.000 | 1.106991 |
10 | 2025-02-20 00:00:00.000 | 1.083241 |
11 | 2025-01-30 00:00:00.000 | 1.122153 |
12 | 2025-02-18 00:00:00.000 | 1.117153 |
13 | 2025-02-22 00:00:00.000 | 1.08831 |
14 | 2025-03-11 00:00:00.000 | 1.138912 |
15 | 2025-03-06 00:00:00.000 | 1.150671 |
16 | 2025-01-02 00:00:00.000 | 1.092986 |
17 | 2025-01-26 00:00:00.000 | 1.100255 |
18 | 2025-01-14 00:00:00.000 | 1.098056 |
19 | 2025-02-09 00:00:00.000 | 1.097431 |
20 | 2024-12-24 00:00:00.000 | 1.090972 |
Mrfti2024-07-25 12:47 AM copy
Updated 20 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 20 hours agoAuto-refreshes every 12 hours
...
110
4KB
2s