AVG_UNIQUE_TX_PER_DAY | MEDIAN_UNIQUE_TX_PER_DAY | |
|---|---|---|
1 | 4608000.722071 | 4520214 |
picasoavg.median
Updated 2025-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
WITH daily_tx AS (
SELECT
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS tx_date,
COUNT(DISTINCT TRANSACTION_HASH) AS daily_count
FROM stellar.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= DATEADD(YEAR, -1, CURRENT_DATE)
GROUP BY tx_date
)
SELECT
AVG(daily_count) AS avg_unique_tx_per_day,
APPROX_PERCENTILE(daily_count, 0.5) AS median_unique_tx_per_day
FROM daily_tx;
Last run: about 1 month ago
1
26B
515s