This service acts as the central handler for managing market-data and personal market transactions in a locally hosted CockroachDB instance. It provides RESTful APIs to perform various operations, including CRUD and complex compute support for market entities.
- 📅 Date – Stored in
yyyyMMddformat - 🔖 Ticker – Includes stock exchange & country code
- 💰 Close Price (or Adjusted Close Price)
- 🔢 Order ID (Primary Key)
- 🔼 Direction –
BUY/SELL - 🔖 Ticker – Includes stock exchange & country code
- 🔄 Quantity Transacted
- 💵 Transaction Price (Total Cost)
- 💲 Price per Share
- 📅 Transaction Date
- 📆 Settlement Date
- 🏷️ Ticker Name
- 🏛️ Ticker Sector
- 🏦 Account Type –
TFSA 🇨🇦/FHSA 🇨🇦/Non-Registered 🇨🇦 - 🔢 Account Number
- 🏷️ CUSIP Number (Committee on Uniform Securities Identification Procedures)
- ⚖️ Transaction Type –
Fractional/Limit/Market/Stock Split, etc. - 📊 Instrument Type –
ETF/Equity - 🌍 Country Code –
CA
✔ CRUD and complex operations on market entities
✔ RESTful API endpoints for seamless integration
✔ CockroachDB-backed storage for high availability and scalability
| Stable | Latest |
|---|---|
| 2.1.22 | 2.1.22 |
-
🏗️ twm-artifactory
Centralized repository for source and compiled Protocol Buffers (Protobufs) used across TWM projects. -
🔗 twm-ping-client
A lightweight library providing Eureka-based heartbeat (ping) functionality for service discovery.
- Start up local cockroachdb cluster
- Start up twm-eureka
- Ensure the stable version is checked out (or latest if you are more brave)
- Run the Local Build step if not already done, to generate the jar
- Fire up the script at 'twm-market-data-crdb.sh' using no args
- Checkout the latest libraries and build their jars for local maven repo (~/.m2)
mvn clean install
For questions or suggestions, please feel free to reach out to me at v2k.verma@gmail.com