UNIQUE_TX_COUNT | |
|---|---|
1 | 1691136265 |
picasounique_tx_count
Updated 2025-02-18
9
1
2
3
4
5
6
7
8
9
›
⌄
WITH recent_tx AS (
SELECT
BLOCK_TIMESTAMP,
TRANSACTION_HASH
FROM stellar.core.fact_transactions
WHERE BLOCK_TIMESTAMP >= DATEADD(YEAR, -1, CURRENT_DATE)
)
SELECT COUNT(DISTINCT TRANSACTION_HASH) AS unique_tx_count
FROM recent_tx;
Last run: about 2 months ago
1
14B
514s