flipside

    2024-05-20 05:43 PM
    jeason-eth2024-05-20 05:43 PM
    Updated 2024-05-20
    SELECT
    PUBKEY_SCRIPT_ADDRESS as address,
    COUNT(1) AS output_count,
    SUM(VALUE) AS output_value,
    FROM
    bitcoin.core.fact_outputs
    WHERE
    BLOCK_NUMBER >= 333292
    GROUP BY
    PUBKEY_SCRIPT_ADDRESS
    QueryRunArchived: QueryRun has been archived