flipside

    unique_tx_count
    picasounique_tx_count
    Updated 2025-02-18
    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: 27 days ago
    UNIQUE_TX_COUNT
    1
    		1691136265
    1
    14B
    514s