flipside

    back test
    datavortexback test
    Updated 2025-02-28
    SELECT DISTINCT PROJECT_NAME
    FROM bitcoin.core.dim_entity_clusters
    WHERE PROJECT_NAME IS NOT NULL
    LIMIT 100;
    /*
    WITH outputs AS (
    SELECT
    tx_id,
    block_number,
    block_timestamp,
    PUBKEY_SCRIPT_HEX,
    PUBKEY_SCRIPT_TYPE,
    VALUE_SATS / 100000000.0 AS value,
    "INDEX"
    FROM bitcoin.core.fact_outputs
    ),
    nulldata_outputs AS (
    SELECT
    tx_id,
    block_number,
    block_timestamp,
    PUBKEY_SCRIPT_HEX AS script_hex,
    SUBSTR(PUBKEY_SCRIPT_HEX, 5) AS data
    FROM outputs
    WHERE PUBKEY_SCRIPT_TYPE = 'nulldata'
    ),
    value_outputs AS (
    SELECT
    tx_id,
    SUM(value) AS total_value
    FROM outputs
    WHERE PUBKEY_SCRIPT_TYPE != 'nulldata'
    AND "INDEX" = 0
    GROUP BY tx_id
    ),
    potential_lombard AS (
    QueryRunArchived: QueryRun has been archived