Guest User

Untitled

a guest
Oct 18th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.89 KB | None | 0 0
  1. {
  2. "_id" : ObjectId("5bc838e7af72c90c5c2550df"),
  3. "Ticker" : "AAPL",
  4. "Daily" : [
  5. {
  6. "date" : "2017-10-17",
  7. "open" : 157.4,
  8. "high" : 158.4738,
  9. "low" : 156.8582,
  10. "close" : 158.0798,
  11. "volume" : 18997275,
  12. "unadjustedVolume" : 18997275,
  13. "change" : 0.581211,
  14. "changePercent" : 0.369,
  15. "vwap" : 157.654,
  16. "label" : "Oct 17, 17",
  17. "changeOverTime" : 0
  18. },
  19. {
  20. "date" : "2017-10-18",
  21. "open" : 158.0305,
  22. "high" : 158.3162,
  23. "low" : 157.2227,
  24. "close" : 157.3803,
  25. "volume" : 16374164,
  26. "unadjustedVolume" : 16374164,
  27. "change" : -0.699423,
  28. "changePercent" : -0.442,
  29. "vwap" : 157.7015,
  30. "label" : "Oct 18, 17",
  31. "changeOverTime" : -0.00442498029476252
  32. }}
  33.  
  34. db.getCollection('HistoricalData').update(
  35. {"Ticker":'AAPL'},
  36. {"$addToSet":{"Daily":[{'date': '2017-10-18',
  37. 'open': 158.0305,
  38. 'high': 158.3162,
  39. 'low': 157.2227,
  40. 'close': 157.3803,
  41. 'volume': 16374164,
  42. 'unadjustedVolume': 16374164,
  43. 'change': -0.699423,
  44. 'changePercent': -0.442,
  45. 'vwap': 157.7015,
  46. 'label': 'Oct 18, 17',
  47. 'changeOverTime': -0.004424980294762521},
  48. {'date': '2017-10-19',
  49. 'open': 154.4152,
  50. 'high': 154.7403,
  51. 'low': 152.7109,
  52. 'close': 153.6567,
  53. 'volume': 42584166,
  54. 'unadjustedVolume': 42584166,
  55. 'change': -3.7237,
  56. 'changePercent': -2.366,
  57. 'vwap': 153.4613,
  58. 'label': 'Oct 19, 17',
  59. 'changeOverTime': -0.027980172039691376}]}},
  60. {"upsert":true}
  61. )
  62.  
  63. {
  64. "_id" : ObjectId("5bc838e7af72c90c5c2550df"),
  65. "Ticker" : "AAPL",
  66. "Daily" : [
  67. {
  68. "date" : "2017-10-17",
  69. "open" : 157.4,
  70. "high" : 158.4738,
  71. "low" : 156.8582,
  72. "close" : 158.0798,
  73. "volume" : 18997275,
  74. "unadjustedVolume" : 18997275,
  75. "change" : 0.581211,
  76. "changePercent" : 0.369,
  77. "vwap" : 157.654,
  78. "label" : "Oct 17, 17",
  79. "changeOverTime" : 0
  80. },
  81. {
  82. "date" : "2017-10-18",
  83. "open" : 158.0305,
  84. "high" : 158.3162,
  85. "low" : 157.2227,
  86. "close" : 157.3803,
  87. "volume" : 16374164,
  88. "unadjustedVolume" : 16374164,
  89. "change" : -0.699423,
  90. "changePercent" : -0.442,
  91. "vwap" : 157.7015,
  92. "label" : "Oct 18, 17",
  93. "changeOverTime" : -0.00442498029476252
  94. },
  95. {'date': '2017-10-19',
  96. 'open': 154.4152,
  97. 'high': 154.7403,
  98. 'low': 152.7109,
  99. 'close': 153.6567,
  100. 'volume': 42584166,
  101. 'unadjustedVolume': 42584166,
  102. 'change': -3.7237,
  103. 'changePercent': -2.366,
  104. 'vwap': 153.4613,
  105. 'label': 'Oct 19, 17',
  106. 'changeOverTime': -0.027980172039691376}]}
  107. }
Add Comment
Please, Sign In to add comment