Description

Rebuild of backend for stock price history graph microservice deployed on AWS EC2 T2 micros.

Screenshot of frontend:

API

Route

/api/graph/stockHistory

GET

/api/graph/stockHistory?id=[ID]&term=[TERM]

ID = stock ticker, ex 'MSFT'

TERM = ['1D', '1W', '1M', '3M', '1Y', '5Y']

Response:

{
  tags: ["Top 100", "Technology", "Banking"],
  historicPrice1D: [166.09, …],
  name: "American Express Co",
  symbol: "AMEX",
  analystHold: 0,
  robinhoodOwners: 28513,
  price: 166.09,
}

*historicPrice property matching query term will be returned.

POST

/api/graph/stockHistory

Body Format (JSON):

{
  "prices": [
    {
      "timestamp": "1999-01-08 04:05:00 -8:00",
      "symbol": "MSFT",
      "price": 166.09
    },
    {
      "timestamp": "1999-01-08 04:10:00 -8:00",
      "symbol": "MSFT",
      "price": 167.19
    }
  ]
}

timestamp must be rounded to nearest 5 minutes

Response:

created priceIdCount

{
  createdCount: 2,
}

PUT

/api/graph/stockHistory

Body Format (JSON):

{
  [
    {
      timestamp: '1999-01-08 04:05:00 -8:00',
      symbol: 'MSFT',
      price: 166.09,
    },
    {
      timestamp: '1999-01-08 04:10:00 -8:00',
      symbol: 'MSFT',
      price: 167.19,
    },
  ]
}

timestamp must be rounded to nearest 5 minutes

Response:

updated priceIdCount

{
  updatedCount: 2,
}

DELETE

/api/graph/stockHistory

Body Format (JSON):

{
  {
    startTimestamp: '1999-01-08 04:05:00 -8:00',
    endTimestamp: '1999-01-09 04:05:00 -8:00',
    symbol: 'MSFT',
  },
  {
    startTimestamp: '1999-01-08 04:05:00 -8:00',
    endTimestamp: '1999-01-09 04:05:00 -8:00',
    symbol: 'MSFT',
  },
}

timestamp must be rounded to nearest 5 minutes

Response:

deleted priceIdCount

{
  deletedCount: 2,
}