Mrftidefensive-turquoise
    Updated 2025-02-13
    WITH wallet_tx_counts AS (
    SELECT
    s.value::string as wallet,
    COUNT(*) as tx_count
    FROM eclipse.core.fact_transactions,
    LATERAL FLATTEN(input => signers) s
    WHERE succeeded = TRUE
    GROUP BY 1
    ),

    wallet_percentiles AS (
    SELECT
    wallet,
    tx_count,
    PERCENT_RANK() OVER (ORDER BY tx_count) as percentile
    FROM wallet_tx_counts
    )

    SELECT
    COUNT(*) as "Top 1% User count"
    FROM wallet_percentiles
    WHERE percentile >= 0.99;
    Last run: about 1 month ago
    Top 1% User count
    1
    55511
    1
    9B
    119s