PREVIEW / stock_5min / 2013-11-19
file: by_date/stock_5min/2013/2013-11-19.parquet size: 5.3 MB rows: 349,805 symbols: 3,546
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2013-11-19 05:55:00 | AAPL | Stock | 18.5114 | 18.5114 | 18.5107 | 18.5107 | 5600.0 |
| 2013-11-19 07:00:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5107 | 18.5107 | 2800.0 |
| 2013-11-19 07:05:00 | AAPL | Stock | 18.5268 | 18.5268 | 18.5268 | 18.5268 | 44800.0 |
| 2013-11-19 07:30:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5 | 18.5 | 26460.0 |
| 2013-11-19 07:35:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5107 | 18.5107 | 11200.0 |
| 2013-11-19 07:40:00 | AAPL | Stock | 18.5179 | 18.5179 | 18.5179 | 18.5179 | 2800.0 |
| 2013-11-19 07:45:00 | AAPL | Stock | 18.5211 | 18.5214 | 18.5211 | 18.5214 | 28000.0 |
| 2013-11-19 07:50:00 | AAPL | Stock | 18.5179 | 18.5179 | 18.5089 | 18.5089 | 16800.0 |
| 2013-11-19 08:00:00 | AAPL | Stock | 18.5196 | 18.5436 | 18.5082 | 18.5082 | 139972.0 |
| 2013-11-19 08:05:00 | AAPL | Stock | 18.5446 | 18.5446 | 18.5446 | 18.5446 | 3080.0 |
| 2013-11-19 08:10:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5275 | 18.5275 | 14000.0 |
| 2013-11-19 08:15:00 | AAPL | Stock | 18.5279 | 18.5539 | 18.5275 | 18.5536 | 76776.0 |
| 2013-11-19 08:20:00 | AAPL | Stock | 18.5571 | 18.5618 | 18.5571 | 18.5589 | 14000.0 |
| 2013-11-19 08:25:00 | AAPL | Stock | 18.5625 | 18.5664 | 18.5589 | 18.5643 | 71428.0 |
| 2013-11-19 08:30:00 | AAPL | Stock | 18.5625 | 18.5889 | 18.5625 | 18.5889 | 211876.0 |
| 2013-11-19 08:35:00 | AAPL | Stock | 18.5889 | 18.6 | 18.5786 | 18.5786 | 67228.0 |
| 2013-11-19 08:40:00 | AAPL | Stock | 18.5779 | 18.5786 | 18.5721 | 18.5721 | 19096.0 |
| 2013-11-19 08:45:00 | AAPL | Stock | 18.5786 | 18.5786 | 18.5714 | 18.5714 | 99400.0 |
| 2013-11-19 08:50:00 | AAPL | Stock | 18.5636 | 18.5696 | 18.5625 | 18.5625 | 16800.0 |
| 2013-11-19 08:55:00 | AAPL | Stock | 18.5589 | 18.5589 | 18.5557 | 18.5571 | 22540.0 |
| 2013-11-19 09:00:00 | AAPL | Stock | 18.5671 | 18.5693 | 18.5571 | 18.5693 | 22400.0 |
| 2013-11-19 09:05:00 | AAPL | Stock | 18.5654 | 18.5832 | 18.5654 | 18.5786 | 120400.0 |
| 2013-11-19 09:10:00 | AAPL | Stock | 18.5736 | 18.5804 | 18.5714 | 18.5771 | 55888.0 |
| 2013-11-19 09:15:00 | AAPL | Stock | 18.575 | 18.575 | 18.5579 | 18.5643 | 55524.0 |
| 2013-11-19 09:20:00 | AAPL | Stock | 18.5643 | 18.5643 | 18.5557 | 18.5643 | 17864.0 |
| 2013-11-19 09:25:00 | AAPL | Stock | 18.5704 | 18.5832 | 18.5379 | 18.545 | 190652.0 |
| 2013-11-19 09:30:00 | AAPL | Stock | 18.5568 | 18.5886 | 18.5154 | 18.5329 | 9695700.0 |
| 2013-11-19 09:35:00 | AAPL | Stock | 18.5264 | 18.6229 | 18.5261 | 18.5932 | 6374872.0 |
| 2013-11-19 09:40:00 | AAPL | Stock | 18.5868 | 18.5954 | 18.5425 | 18.5754 | 3624040.0 |
| 2013-11-19 09:45:00 | AAPL | Stock | 18.5761 | 18.6514 | 18.5475 | 18.6393 | 6488468.0 |
| 2013-11-19 09:50:00 | AAPL | Stock | 18.641 | 18.6604 | 18.62 | 18.6586 | 4966248.0 |
| 2013-11-19 09:55:00 | AAPL | Stock | 18.6518 | 18.66 | 18.6321 | 18.6489 | 2482200.0 |
| 2013-11-19 10:00:00 | AAPL | Stock | 18.6489 | 18.6728 | 18.6414 | 18.6677 | 4455444.0 |
| 2013-11-19 10:05:00 | AAPL | Stock | 18.6677 | 18.6921 | 18.6677 | 18.6725 | 4822104.0 |
| 2013-11-19 10:10:00 | AAPL | Stock | 18.6725 | 18.6807 | 18.6465 | 18.6546 | 2776340.0 |
| 2013-11-19 10:15:00 | AAPL | Stock | 18.6546 | 18.6764 | 18.645 | 18.6518 | 2517872.0 |
| 2013-11-19 10:20:00 | AAPL | Stock | 18.6486 | 18.6634 | 18.615 | 18.6268 | 3336172.0 |
| 2013-11-19 10:25:00 | AAPL | Stock | 18.6264 | 18.635 | 18.6061 | 18.6071 | 2440032.0 |
| 2013-11-19 10:30:00 | AAPL | Stock | 18.6075 | 18.6366 | 18.5964 | 18.6282 | 2534392.0 |
| 2013-11-19 10:35:00 | AAPL | Stock | 18.6286 | 18.6425 | 18.6029 | 18.6071 | 2905812.0 |
| 2013-11-19 10:40:00 | AAPL | Stock | 18.6071 | 18.6339 | 18.6004 | 18.6079 | 2502556.0 |
| 2013-11-19 10:45:00 | AAPL | Stock | 18.6064 | 18.64 | 18.6007 | 18.6139 | 3166268.0 |
| 2013-11-19 10:50:00 | AAPL | Stock | 18.6143 | 18.6161 | 18.5968 | 18.615 | 1903692.0 |
| 2013-11-19 10:55:00 | AAPL | Stock | 18.6129 | 18.6157 | 18.5986 | 18.6 | 2668512.0 |
| 2013-11-19 11:00:00 | AAPL | Stock | 18.6 | 18.6121 | 18.5875 | 18.6011 | 2417408.0 |
| 2013-11-19 11:05:00 | AAPL | Stock | 18.5979 | 18.6107 | 18.5979 | 18.6043 | 668416.0 |
| 2013-11-19 11:10:00 | AAPL | Stock | 18.5989 | 18.6021 | 18.5657 | 18.5682 | 1860516.0 |
| 2013-11-19 11:15:00 | AAPL | Stock | 18.57 | 18.5718 | 18.5454 | 18.5621 | 2861684.0 |
| 2013-11-19 11:20:00 | AAPL | Stock | 18.5606 | 18.5621 | 18.5393 | 18.5491 | 4026568.0 |
| 2013-11-19 11:25:00 | AAPL | Stock | 18.5493 | 18.5719 | 18.5371 | 18.5714 | 2325596.0 |
> showing 50 of 349,805 rows — these rows as CSV