Changeset 9e6d8a2 for server/db/schema_creation.sql

Timestamp:

09/17/26 00:36:39 (13 days ago)

Author:

Stefan <trsunovstefan@…>

Branches:

main

Children:

4438e45

Parents:

35bcb41

Message:

Remove volatility from Phase 6

File:

• server/db/schema_creation.sql (modified) (3 diffs)

server/db/schema_creation.sql

@@ -261 +261 @@
     avg_price            numeric,
     market_return_pct    numeric,
-    price_volatility     numeric,
     participating_users  bigint
 )
@@ -281 +280 @@
             COUNT(*)         AS trade_count,
             AVG(price)       AS avg_price,
-            STDDEV(price)    AS price_volatility,
             MAX(first_price) AS first_price,
             MAX(last_price)  AS last_price
@@ -300 +298 @@
         ROUND(ms.avg_price, 6)                                                            AS avg_price,
         ROUND((ms.last_price - ms.first_price) / NULLIF(ms.first_price, 0) * 100, 2)      AS market_return_pct,
-        ROUND(COALESCE(ms.price_volatility, 0), 6)                                        AS price_volatility,
         COALESCE(p.participating_users, 0)                                                AS participating_users
     FROM market_stats ms