theericstonescores vs spend
    Updated 2024-09-16
    -- Example query in Snowflake to produce the given dataset
    WITH Data AS (
    SELECT
    1 AS SCORE, 1000000 AS Addresses, 100 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    2 AS Score, 600000 AS Addresses, 150 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    3 AS Score, 100000 AS Addresses, 175 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    4 AS Score, 80000 AS Addresses, 400 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    5 AS Score, 65000 AS Addresses, 800 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    6 AS Score, 40000 AS Addresses, 1300 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    7 AS Score, 30000 AS Addresses, 10000 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    8 AS Score, 20000 AS Addresses, 19000 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    9 AS Score, 15000 AS Addresses, 30000 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    10 AS Score, 10000 AS Addresses, 50000 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    11 AS Score, 7000 AS Addresses, 80000 AS Typical_On_Chain_Spend
    UNION ALL
    SELECT
    QueryRunArchived: QueryRun has been archived