Changeset 9e6d8a2 for server

Timestamp:

09/17/26 00:36:39 (2 weeks ago)

Author:

Stefan <trsunovstefan@…>

Branches:

main

Children:

4438e45

Parents:

35bcb41

Message:

Remove volatility from Phase 6

Location:

server

Files:

• db/schema_creation.sql (modified) (3 diffs)
• reports.go (modified) (2 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

server/reports.go

@@ -81 +81 @@
         defer rows.Close()
 
-        header := fmt.Sprintf("  %-6s  %-5s  %12s  %8s  %14s  %12s  %14s  %8s",
-                "Symbol", "Quote", "Volume", "Trades", "Avg Price", "Return %", "Volatility", "Users")
+        header := fmt.Sprintf("  %-6s  %-5s  %12s  %8s  %14s  %12s  %8s",
+                "Symbol", "Quote", "Volume", "Trades", "Avg Price", "Return %", "Users")
         fmt.Println()
         fmt.Println(header)
@@ -90 +90 @@
         for rows.Next() {
                 var symbol, quote string
-                var volume, avgPrice, returnPct, volatility float64
+                var volume, avgPrice, returnPct float64
                 var tradeCount, users int64
-                if err := rows.Scan(&symbol, &quote, &volume, &tradeCount, &avgPrice, &returnPct, &volatility, &users); err != nil {
+                if err := rows.Scan(&symbol, &quote, &volume, &tradeCount, &avgPrice, &returnPct, &users); err != nil {
                         fmt.Println("scan error:", err)
                         return
                 }
-                fmt.Printf("  %-6s  %-5s  %12.4f  %8d  %14.6f  %+12.2f  %14.6f  %8d\n",
-                        symbol, quote, volume, tradeCount, avgPrice, returnPct, volatility, users)
+                fmt.Printf("  %-6s  %-5s  %12.4f  %8d  %14.6f  %+12.2f  %8d\n",
+                        symbol, quote, volume, tradeCount, avgPrice, returnPct, users)
                 empty = false
         }