PERIOD | DAILY_TX_COUNT | DAILY_USER_COUNT | DAILY_TX_FEE | |
|---|---|---|---|---|
1 | Before | 1172136.741935 | 875313.322581 | 2009.942967362 |
2 | After | 1712298.16129 | 1095253.096774 | 3303.477294775 |
elsinaDaily avg amount
Updated 2025-02-21
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,
case
when date < '2024-11-13' then 'Before'
else 'After' end as period,
count(distinct tx_hash) as tx_count,
count(distinct from_address) as user_count,
sum(tx_fee) as fees
from ronin.core.fact_transactions
where date between '2024-10-13' and '2024-12-13'
group by 1, 2
)
select
period,
avg(tx_count) as daily_tx_count,
avg(user_count) as daily_user_count,
avg(fees) as daily_tx_fee
from daily
group by 1
Last run: 28 days ago
2
110B
10s