AVG_TX_COUNT | AVG_USER_COUNT | AVG_TOTAL_VOLUME | AVG_TX_FEE | |
|---|---|---|---|---|
1 | 44545.711864 | 214.220339 | 6.084255633 | 0.03279463395 |
elsinaAvg daily activity 2025
Updated 2025-03-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with daily as (
SELECT
date_trunc('day', block_timestamp) as date,
count(DISTINCT from_address) as user_count,
count(DISTINCT tx_hash) as tx_count,
sum(value) as volume,
sum(tx_fee) as tx_fees
from boba.core.fact_transactions
where
block_timestamp::date >= '2025-01-01'
group by 1
)
select
avg(tx_count) as avg_tx_count,
avg(user_count) as avg_user_count,
avg(volume) as avg_total_volume,
avg(tx_fees) as avg_tx_fee
from daily
Last run: 19 days ago
1
53B
3s