PREVIEW / stock_5min / 2013-11-12
file: by_date/stock_5min/2013/2013-11-12.parquet size: 5.2 MB rows: 345,885 symbols: 3,549
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-12 05:55:00 | AAPL | Stock | 18.4839 | 18.4839 | 18.4821 | 18.4821 | 5600.0 |
| 2013-11-12 07:00:00 | AAPL | Stock | 18.4936 | 18.4936 | 18.4936 | 18.4936 | 12600.0 |
| 2013-11-12 07:10:00 | AAPL | Stock | 18.475 | 18.475 | 18.475 | 18.475 | 21560.0 |
| 2013-11-12 07:20:00 | AAPL | Stock | 18.4921 | 18.5161 | 18.4921 | 18.5089 | 106400.0 |
| 2013-11-12 07:25:00 | AAPL | Stock | 18.5011 | 18.5011 | 18.5011 | 18.5011 | 8400.0 |
| 2013-11-12 07:30:00 | AAPL | Stock | 18.5025 | 18.5025 | 18.5018 | 18.5018 | 19600.0 |
| 2013-11-12 07:35:00 | AAPL | Stock | 18.5089 | 18.5143 | 18.5089 | 18.5143 | 29400.0 |
| 2013-11-12 07:45:00 | AAPL | Stock | 18.5143 | 18.5143 | 18.5143 | 18.5143 | 2800.0 |
| 2013-11-12 07:50:00 | AAPL | Stock | 18.5204 | 18.5204 | 18.5204 | 18.5204 | 2800.0 |
| 2013-11-12 07:55:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5018 | 18.5018 | 67200.0 |
| 2013-11-12 08:00:00 | AAPL | Stock | 18.4939 | 18.5374 | 18.4786 | 18.5004 | 1898456.0 |
| 2013-11-12 08:05:00 | AAPL | Stock | 18.5089 | 18.5139 | 18.5089 | 18.5139 | 20524.0 |
| 2013-11-12 08:10:00 | AAPL | Stock | 18.5089 | 18.5089 | 18.49 | 18.4929 | 52080.0 |
| 2013-11-12 08:15:00 | AAPL | Stock | 18.4911 | 18.5 | 18.4843 | 18.4979 | 240688.0 |
| 2013-11-12 08:20:00 | AAPL | Stock | 18.4979 | 18.4979 | 18.4979 | 18.4979 | 33600.0 |
| 2013-11-12 08:25:00 | AAPL | Stock | 18.5071 | 18.5157 | 18.5 | 18.5 | 27160.0 |
| 2013-11-12 08:30:00 | AAPL | Stock | 18.5036 | 18.5036 | 18.5 | 18.5036 | 16800.0 |
| 2013-11-12 08:35:00 | AAPL | Stock | 18.4979 | 18.4979 | 18.4957 | 18.4957 | 12040.0 |
| 2013-11-12 08:40:00 | AAPL | Stock | 18.5061 | 18.5107 | 18.5 | 18.5089 | 54516.0 |
| 2013-11-12 08:45:00 | AAPL | Stock | 18.5025 | 18.5025 | 18.5007 | 18.5007 | 28308.0 |
| 2013-11-12 08:50:00 | AAPL | Stock | 18.5007 | 18.5007 | 18.4964 | 18.4964 | 8400.0 |
| 2013-11-12 09:00:00 | AAPL | Stock | 18.5086 | 18.5125 | 18.5036 | 18.5036 | 56000.0 |
| 2013-11-12 09:05:00 | AAPL | Stock | 18.4943 | 18.4982 | 18.4929 | 18.4982 | 21308.0 |
| 2013-11-12 09:10:00 | AAPL | Stock | 18.4921 | 18.4993 | 18.4918 | 18.4918 | 19600.0 |
| 2013-11-12 09:15:00 | AAPL | Stock | 18.4993 | 18.5071 | 18.4982 | 18.5071 | 8400.0 |
| 2013-11-12 09:20:00 | AAPL | Stock | 18.5025 | 18.5025 | 18.5 | 18.5018 | 44800.0 |
| 2013-11-12 09:25:00 | AAPL | Stock | 18.5 | 18.5 | 18.4646 | 18.4679 | 390824.0 |
| 2013-11-12 09:30:00 | AAPL | Stock | 18.4882 | 18.5786 | 18.4643 | 18.5554 | 9401840.0 |
| 2013-11-12 09:35:00 | AAPL | Stock | 18.5568 | 18.5857 | 18.53 | 18.5429 | 5675908.0 |
| 2013-11-12 09:40:00 | AAPL | Stock | 18.5421 | 18.5461 | 18.5 | 18.5236 | 4043984.0 |
| 2013-11-12 09:45:00 | AAPL | Stock | 18.5254 | 18.5571 | 18.5029 | 18.5428 | 3003280.0 |
| 2013-11-12 09:50:00 | AAPL | Stock | 18.5425 | 18.5643 | 18.5239 | 18.5468 | 2977772.0 |
| 2013-11-12 09:55:00 | AAPL | Stock | 18.5468 | 18.6036 | 18.544 | 18.5999 | 6618164.0 |
| 2013-11-12 10:00:00 | AAPL | Stock | 18.6016 | 18.6582 | 18.5932 | 18.6396 | 8509928.0 |
| 2013-11-12 10:05:00 | AAPL | Stock | 18.6404 | 18.645 | 18.5932 | 18.6181 | 4601072.0 |
| 2013-11-12 10:10:00 | AAPL | Stock | 18.6179 | 18.6357 | 18.5789 | 18.5872 | 4077416.0 |
| 2013-11-12 10:15:00 | AAPL | Stock | 18.5871 | 18.6318 | 18.5714 | 18.6232 | 6153504.0 |
| 2013-11-12 10:20:00 | AAPL | Stock | 18.6221 | 18.6729 | 18.61 | 18.6614 | 5587624.0 |
| 2013-11-12 10:25:00 | AAPL | Stock | 18.6632 | 18.6986 | 18.6575 | 18.6925 | 6006532.0 |
| 2013-11-12 10:30:00 | AAPL | Stock | 18.69 | 18.7114 | 18.6732 | 18.6757 | 5485256.0 |
| 2013-11-12 10:35:00 | AAPL | Stock | 18.6786 | 18.6918 | 18.6729 | 18.6839 | 3006164.0 |
| 2013-11-12 10:40:00 | AAPL | Stock | 18.6839 | 18.6996 | 18.6746 | 18.6925 | 3827628.0 |
| 2013-11-12 10:45:00 | AAPL | Stock | 18.6925 | 18.7025 | 18.6843 | 18.6914 | 2501688.0 |
| 2013-11-12 10:50:00 | AAPL | Stock | 18.6927 | 18.6927 | 18.6575 | 18.6625 | 2716532.0 |
| 2013-11-12 10:55:00 | AAPL | Stock | 18.6646 | 18.6664 | 18.615 | 18.6282 | 3767400.0 |
| 2013-11-12 11:00:00 | AAPL | Stock | 18.6279 | 18.65 | 18.62 | 18.6361 | 2199456.0 |
| 2013-11-12 11:05:00 | AAPL | Stock | 18.6389 | 18.6539 | 18.6136 | 18.6221 | 2421468.0 |
| 2013-11-12 11:10:00 | AAPL | Stock | 18.6232 | 18.6286 | 18.6007 | 18.61 | 2534140.0 |
| 2013-11-12 11:15:00 | AAPL | Stock | 18.6139 | 18.65 | 18.6139 | 18.6496 | 2272648.0 |
| 2013-11-12 11:20:00 | AAPL | Stock | 18.6471 | 18.6511 | 18.6307 | 18.6311 | 2039100.0 |
> showing 50 of 345,885 rows — these rows as CSV