YEARLY | USER_COUNT | TX_COUNT | VOLUME | TX_FEES | |
---|---|---|---|---|---|
1 | 2023 | 5030 | 169783 | 3649.631701556 | 36.119239788 |
2 | 2025 | 3459 | 2630046 | 359.059820482 | 1.934992664 |
3 | 2021 | 12203 | 271549 | 279967.726348247 | 812.748074767 |
4 | 2024 | 15349 | 11604235 | 28977.023778777 | 23.251786433 |
5 | 2022 | 13934 | 654764 | 69937.450236625 | 233.9356565 |
elsinaYearly activity
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
›
⌄
SELECT
case
when block_timestamp < '2022-01-01' then '2021'
when block_timestamp >= '2022-01-01' and block_timestamp < '2023-01-01' then '2022'
when block_timestamp >= '2023-01-01' and block_timestamp < '2024-01-01' then '2023'
when block_timestamp >= '2024-01-01' and block_timestamp < '2025-01-01' then '2024'
when block_timestamp >= '2025-01-01' then '2025'
end as yearly,
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
group by 1
Last run: 18 days ago
5
254B
4s