DATE | Daily avg tx per address | |
|---|---|---|
1 | 2024-06-28 00:00:00.000 | 4.33125 |
2 | 2024-07-04 00:00:00.000 | 4.418381 |
3 | 2024-07-06 00:00:00.000 | 4.102607 |
4 | 2024-07-02 00:00:00.000 | 3.926309 |
5 | 2024-08-08 00:00:00.000 | 4.747723 |
6 | 2024-08-22 00:00:00.000 | 4.633909 |
7 | 2024-08-24 00:00:00.000 | 5.875262 |
8 | 2024-10-15 00:00:00.000 | 4.075263 |
9 | 2024-10-18 00:00:00.000 | 6.147677 |
10 | 2024-11-06 00:00:00.000 | 7.376104 |
11 | 2024-12-17 00:00:00.000 | 5.721268 |
12 | 2025-01-10 00:00:00.000 | 4.858971 |
13 | 2024-06-26 00:00:00.000 | 4.586206 |
14 | 2024-07-15 00:00:00.000 | 4.584835 |
15 | 2024-08-06 00:00:00.000 | 4.805121 |
16 | 2024-08-28 00:00:00.000 | 9.109148 |
17 | 2024-09-10 00:00:00.000 | 6.129412 |
18 | 2024-10-04 00:00:00.000 | 4.065642 |
19 | 2024-10-08 00:00:00.000 | 4.375931 |
20 | 2025-01-13 00:00:00.000 | 4.601407 |
Mrfti2024-07-25 12:47 AM copy
Updated 7 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tbl AS
(
SELECT
date_trunc(day, block_timestamp) as date,
count(DISTINCT from_address) as "Daily addresses",
count (DISTINCT tx_hash) as "Daily tx"
from berachain.testnet.fact_transactions
GROUP by 1
)
SELECT
date,
"Daily tx"/"Daily addresses" as "Daily avg tx per address"
from tbl
where date > '2024-06-10 00:00:00.000'
Last run: 7 days ago
...
242
9KB
441s