Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. TradeID Stock Timestamp
  2. 1 GOOG 2014.03.03 09:13:59.054
  3. 2 GOOG 2014.03.03 09:28:12.003
  4. 3 GOOG 2014.03.03 09:28:18.199
  5. 4 GOOG 2014.03.03 09:52:03.628
  6. 5 GOOG 2014.03.03 11:18:52.629
  7. ...
  8.  
  9. Stock Timestamp Bid Ask
  10. GOOG 2014.03.03 08:02:34.297 102.21 102.41
  11. GOOG 2014.03.03 08:02:40.118 102.32 102.42
  12. GOOG 2014.03.03 08:02:44.090 102.33 102.43
  13. GOOG 2014.03.03 08:03:20.197 102.34 102.44
  14. GOOG 2014.03.03 08:05:09.325 102.35 102.45
  15. ...
  16.  
  17. aj[
  18. `Stock`Timestamp;
  19. Trades;
  20. update TimestampPrice:Timestamp from Prices / let's me track which price gets joined
  21. ]
  22.  
  23. TradeID Stock Timestamp TimestampPrice Bid Ask
  24. 1 GOOG 2014.03.03 09:13:59.054 2014.03.03 08:05:09.325 102.35 102.45
  25. 2 GOOG 2014.03.03 09:28:12.003 2014.03.03 08:05:09.325 102.35 102.45
  26. 3 GOOG 2014.03.03 09:28:18.199 2014.03.03 08:05:09.325 102.35 102.45
  27. 4 GOOG 2014.03.03 09:52:03.628 2014.03.03 08:05:09.325 102.35 102.45
  28. 5 GOOG 2014.03.03 11:18:52.629 2014.03.03 10:31:45.043 102.24 102.35
  29. 6 GOOG 2014.03.03 11:33:52.021 2014.03.03 10:31:45.043 102.24 102.35
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement