TRANSACTION_DATE | TRANSACTION_COUNT | TOTAL_FEES | USERS_COUNT | |
|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 150855716 | 94922.823082069 | 408001 |
2 | 2024-12-01 00:00:00.000 | 154403544 | 73411.140536285 | 464830 |
3 | 2024-09-01 00:00:00.000 | 127082593 | 30688.986770499 | 381926 |
4 | 2024-07-01 00:00:00.000 | 124624772 | 55495.0421437 | 211749 |
5 | 2024-05-01 00:00:00.000 | 142134466 | 66278.961110199 | 223879 |
6 | 2024-03-01 00:00:00.000 | 183204106 | 108526.505671284 | 273062 |
7 | 2025-02-01 00:00:00.000 | 77083289 | 43106.754722766 | 251510 |
8 | 2024-11-01 00:00:00.000 | 151179346 | 94345.575390171 | 555344 |
9 | 2024-10-01 00:00:00.000 | 120499725 | 37466.146505298 | 242155 |
10 | 2024-08-01 00:00:00.000 | 133800216 | 52537.584441399 | 220381 |
11 | 2024-06-01 00:00:00.000 | 115573716 | 60221.212873699 | 216302 |
12 | 2024-04-01 00:00:00.000 | 145732212 | 68685.485490798 | 226093 |
13 | 2024-02-01 00:00:00.000 | 147379050 | 74833.930840392 | 271804 |
14 | 2024-01-01 00:00:00.000 | 130121067 | 54921.017921099 | 279592 |
par_rnStellar 02
Updated 2025-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH TransactionSummary AS (
SELECT
COUNT(*) AS total_transactions
FROM stellar.core.fact_transactions
),
FeeSummary AS (
SELECT
SUM(FEE_CHARGED / POWER(10,7)) AS total_fees,
AVG(FEE_CHARGED / POWER(10,7)) AS avg_fee,
MAX(FEE_CHARGED / POWER(10,7)) AS max_fee
FROM stellar.core.fact_transactions
),
MonthlyTransactionCount AS (
SELECT
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS transaction_date,
COUNT(*) AS transaction_count
FROM stellar.core.fact_transactions
GROUP BY transaction_date
ORDER BY transaction_date DESC
),
TopAccounts AS (
SELECT
ACCOUNT,
COUNT(*) AS transaction_count
FROM stellar.core.fact_transactions
GROUP BY ACCOUNT
ORDER BY transaction_count DESC
LIMIT 10
),
MonthlyUsersSummary AS (
SELECT
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS transaction_date,
COUNT(DISTINCT ACCOUNT) AS users_count
FROM stellar.core.fact_transactions
GROUP BY transaction_date
ORDER BY transaction_date DESC
Last run: 27 days ago
14
853B
72s