PREVIEW / stock_5min / 2012-10-15
file: by_date/stock_5min/2012/2012-10-15.parquet size: 4.6 MB rows: 307,066 symbols: 3,478
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-15 04:00:00 | AAPL | Stock | 22.5357 | 22.6071 | 22.5357 | 22.6071 | 44800.0 |
| 2012-10-15 04:25:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 5600.0 |
| 2012-10-15 04:30:00 | AAPL | Stock | 22.5968 | 22.5968 | 22.5968 | 22.5968 | 2800.0 |
| 2012-10-15 04:55:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 14000.0 |
| 2012-10-15 05:00:00 | AAPL | Stock | 22.6071 | 22.6071 | 22.6071 | 22.6071 | 6888.0 |
| 2012-10-15 05:05:00 | AAPL | Stock | 22.6214 | 22.6214 | 22.6214 | 22.6214 | 2800.0 |
| 2012-10-15 05:35:00 | AAPL | Stock | 22.6393 | 22.6393 | 22.6393 | 22.6393 | 2800.0 |
| 2012-10-15 06:05:00 | AAPL | Stock | 22.6268 | 22.6346 | 22.6268 | 22.6346 | 13580.0 |
| 2012-10-15 06:40:00 | AAPL | Stock | 22.6346 | 22.6346 | 22.6346 | 22.6346 | 4200.0 |
| 2012-10-15 06:45:00 | AAPL | Stock | 22.6346 | 22.6346 | 22.6346 | 22.6346 | 2800.0 |
| 2012-10-15 07:00:00 | AAPL | Stock | 22.625 | 22.625 | 22.6093 | 22.6093 | 39424.0 |
| 2012-10-15 07:05:00 | AAPL | Stock | 22.6214 | 22.6271 | 22.6004 | 22.6232 | 65800.0 |
| 2012-10-15 07:10:00 | AAPL | Stock | 22.6157 | 22.63 | 22.6157 | 22.63 | 33292.0 |
| 2012-10-15 07:25:00 | AAPL | Stock | 22.625 | 22.6429 | 22.625 | 22.6429 | 51800.0 |
| 2012-10-15 07:30:00 | AAPL | Stock | 22.6436 | 22.6436 | 22.6357 | 22.6357 | 19600.0 |
| 2012-10-15 07:35:00 | AAPL | Stock | 22.6311 | 22.6418 | 22.6089 | 22.6089 | 95172.0 |
| 2012-10-15 07:40:00 | AAPL | Stock | 22.6143 | 22.6261 | 22.6143 | 22.6261 | 28000.0 |
| 2012-10-15 07:45:00 | AAPL | Stock | 22.6232 | 22.6268 | 22.615 | 22.615 | 44940.0 |
| 2012-10-15 07:50:00 | AAPL | Stock | 22.6232 | 22.625 | 22.6232 | 22.625 | 22400.0 |
| 2012-10-15 07:55:00 | AAPL | Stock | 22.6243 | 22.6243 | 22.6146 | 22.6146 | 34020.0 |
| 2012-10-15 08:00:00 | AAPL | Stock | 22.6129 | 22.6289 | 22.5893 | 22.6021 | 180768.0 |
| 2012-10-15 08:05:00 | AAPL | Stock | 22.6036 | 22.6325 | 22.5896 | 22.6004 | 360136.0 |
| 2012-10-15 08:10:00 | AAPL | Stock | 22.6 | 22.6036 | 22.5786 | 22.5989 | 216636.0 |
| 2012-10-15 08:15:00 | AAPL | Stock | 22.5971 | 22.6071 | 22.5893 | 22.6032 | 124040.0 |
| 2012-10-15 08:20:00 | AAPL | Stock | 22.5914 | 22.5925 | 22.5839 | 22.5893 | 72128.0 |
| 2012-10-15 08:25:00 | AAPL | Stock | 22.5893 | 22.5893 | 22.5821 | 22.5857 | 23856.0 |
| 2012-10-15 08:30:00 | AAPL | Stock | 22.5889 | 22.6171 | 22.5889 | 22.6096 | 300328.0 |
| 2012-10-15 08:35:00 | AAPL | Stock | 22.61 | 22.61 | 22.5893 | 22.6 | 108640.0 |
| 2012-10-15 08:40:00 | AAPL | Stock | 22.5914 | 22.5914 | 22.5746 | 22.5746 | 144228.0 |
| 2012-10-15 08:45:00 | AAPL | Stock | 22.5786 | 22.5871 | 22.5757 | 22.5871 | 67200.0 |
| 2012-10-15 08:50:00 | AAPL | Stock | 22.585 | 22.5929 | 22.5825 | 22.5829 | 85960.0 |
| 2012-10-15 08:55:00 | AAPL | Stock | 22.5829 | 22.5829 | 22.5536 | 22.5636 | 157780.0 |
| 2012-10-15 09:00:00 | AAPL | Stock | 22.5621 | 22.5714 | 22.5571 | 22.5571 | 115612.0 |
| 2012-10-15 09:05:00 | AAPL | Stock | 22.5571 | 22.575 | 22.5568 | 22.5718 | 101444.0 |
| 2012-10-15 09:10:00 | AAPL | Stock | 22.5718 | 22.5775 | 22.5636 | 22.5636 | 74900.0 |
| 2012-10-15 09:15:00 | AAPL | Stock | 22.5679 | 22.5839 | 22.5679 | 22.5714 | 295680.0 |
| 2012-10-15 09:20:00 | AAPL | Stock | 22.5714 | 22.5818 | 22.5625 | 22.5625 | 191548.0 |
| 2012-10-15 09:25:00 | AAPL | Stock | 22.5614 | 22.5911 | 22.5614 | 22.5839 | 270508.0 |
| 2012-10-15 09:30:00 | AAPL | Stock | 22.5821 | 22.6686 | 22.5125 | 22.64 | 15830752.0 |
| 2012-10-15 09:35:00 | AAPL | Stock | 22.6396 | 22.6514 | 22.5764 | 22.5939 | 6666520.0 |
| 2012-10-15 09:40:00 | AAPL | Stock | 22.5929 | 22.6221 | 22.5357 | 22.5418 | 6544356.0 |
| 2012-10-15 09:45:00 | AAPL | Stock | 22.5396 | 22.5529 | 22.4682 | 22.5104 | 9552228.0 |
| 2012-10-15 09:50:00 | AAPL | Stock | 22.5057 | 22.5329 | 22.455 | 22.5296 | 7721896.0 |
| 2012-10-15 09:55:00 | AAPL | Stock | 22.5275 | 22.5625 | 22.4911 | 22.5186 | 5793340.0 |
| 2012-10-15 10:00:00 | AAPL | Stock | 22.5186 | 22.5836 | 22.5071 | 22.5529 | 5938492.0 |
| 2012-10-15 10:05:00 | AAPL | Stock | 22.5489 | 22.5636 | 22.5154 | 22.5214 | 3351432.0 |
| 2012-10-15 10:10:00 | AAPL | Stock | 22.5257 | 22.5654 | 22.4086 | 22.4206 | 8917832.0 |
| 2012-10-15 10:15:00 | AAPL | Stock | 22.4136 | 22.4471 | 22.3929 | 22.4396 | 8887816.0 |
| 2012-10-15 10:20:00 | AAPL | Stock | 22.4396 | 22.4707 | 22.3814 | 22.4361 | 6133288.0 |
| 2012-10-15 10:25:00 | AAPL | Stock | 22.4421 | 22.4436 | 22.3789 | 22.3914 | 6466824.0 |
> showing 50 of 307,066 rows — these rows as CSV