📖 Schema Information
The database schema includes the following tables:
SystemStock - Stores stock information and monitoring flags
├── StockId (UUID, Primary Key)
├── StockName (VARCHAR 500)
├── StockTicker (VARCHAR 50)
├── StockIsPosition (BOOLEAN)
├── StockIsMonitor (BOOLEAN)
└── BatchId (UUID)
SystemStockDataHistory - Stores fundamental data as key-value pairs
├── HistoryId (UUID, Primary Key)
├── StockId (UUID, Foreign Key)
├── BatchId (UUID)
├── HistoryDate (DATETIME)
├── DataKey (VARCHAR 500)
└── DataValue (VARCHAR 500)
SystemStockOptionHistory - Stores options chain data
├── StockId (UUID, Primary Key part)
├── HistoryDate (DATE, Primary Key part)
├── OptionStrikePrice (DECIMAL, Primary Key part)
├── OptionExpiration (DATE, Primary Key part)
├── OptionType (VARCHAR 10, Primary Key part)
├── BatchId (UUID)
├── OptionLastClose (DECIMAL)
├── OptionPriceChange (DECIMAL)
├── OptionBid/Ask (DECIMAL)
├── OptionVolume (INT)
├── OptionOpenInterest (INT)
└── Greeks: OptionIV, OptionDelta, OptionGamma, OptionTheta, OptionVega, OptionRho
⚙️ Configuration Requirements
Make sure your monitorconfig.json file contains:
{
"cachedir": "cache/",
"mysqlconnstr": "mysql:host=127.0.0.1;dbname=YourDatabase;charset=utf8mb4",
"mysql_username": "your_username",
"mysql_password": "your_password",
"mysql_port": 3306
}