PREVIEW / stock_5min / 2013-11-25
file: by_date/stock_5min/2013/2013-11-25.parquet size: 5.4 MB rows: 356,089 symbols: 3,554
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-25 04:05:00 | AAPL | Stock | 18.6068 | 18.6068 | 18.6068 | 18.6068 | 2800.0 |
| 2013-11-25 04:15:00 | AAPL | Stock | 18.6054 | 18.6068 | 18.6054 | 18.6068 | 11200.0 |
| 2013-11-25 04:35:00 | AAPL | Stock | 18.6061 | 18.6061 | 18.6061 | 18.6061 | 2800.0 |
| 2013-11-25 05:05:00 | AAPL | Stock | 18.6218 | 18.6218 | 18.6218 | 18.6218 | 2940.0 |
| 2013-11-25 05:55:00 | AAPL | Stock | 18.6218 | 18.6218 | 18.6218 | 18.6218 | 2800.0 |
| 2013-11-25 06:10:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6036 | 18.6036 | 14000.0 |
| 2013-11-25 06:15:00 | AAPL | Stock | 18.5779 | 18.5779 | 18.5721 | 18.5721 | 14000.0 |
| 2013-11-25 06:50:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 16800.0 |
| 2013-11-25 07:00:00 | AAPL | Stock | 18.625 | 18.625 | 18.6071 | 18.625 | 50400.0 |
| 2013-11-25 07:05:00 | AAPL | Stock | 18.625 | 18.625 | 18.625 | 18.625 | 19600.0 |
| 2013-11-25 07:10:00 | AAPL | Stock | 18.63 | 18.6521 | 18.63 | 18.6521 | 25200.0 |
| 2013-11-25 07:15:00 | AAPL | Stock | 18.6521 | 18.6529 | 18.6521 | 18.6529 | 5600.0 |
| 2013-11-25 07:20:00 | AAPL | Stock | 18.6375 | 18.6375 | 18.6375 | 18.6375 | 14000.0 |
| 2013-11-25 07:30:00 | AAPL | Stock | 18.6475 | 18.6493 | 18.6475 | 18.6493 | 29960.0 |
| 2013-11-25 07:40:00 | AAPL | Stock | 18.6529 | 18.6746 | 18.6514 | 18.6746 | 156632.0 |
| 2013-11-25 07:45:00 | AAPL | Stock | 18.6736 | 18.6782 | 18.6543 | 18.6689 | 116004.0 |
| 2013-11-25 07:50:00 | AAPL | Stock | 18.6546 | 18.6621 | 18.6525 | 18.6621 | 29400.0 |
| 2013-11-25 07:55:00 | AAPL | Stock | 18.6621 | 18.6621 | 18.6621 | 18.6621 | 2800.0 |
| 2013-11-25 08:00:00 | AAPL | Stock | 18.6568 | 18.66 | 18.6071 | 18.6571 | 123648.0 |
| 2013-11-25 08:05:00 | AAPL | Stock | 18.6446 | 18.6446 | 18.625 | 18.625 | 36820.0 |
| 2013-11-25 08:10:00 | AAPL | Stock | 18.6386 | 18.6411 | 18.625 | 18.625 | 62020.0 |
| 2013-11-25 08:15:00 | AAPL | Stock | 18.6254 | 18.6257 | 18.6096 | 18.6143 | 69720.0 |
| 2013-11-25 08:20:00 | AAPL | Stock | 18.6132 | 18.6232 | 18.6082 | 18.6232 | 190400.0 |
| 2013-11-25 08:25:00 | AAPL | Stock | 18.6314 | 18.6329 | 18.6079 | 18.6146 | 46228.0 |
| 2013-11-25 08:30:00 | AAPL | Stock | 18.6139 | 18.6271 | 18.6079 | 18.625 | 167804.0 |
| 2013-11-25 08:35:00 | AAPL | Stock | 18.6182 | 18.6264 | 18.6182 | 18.625 | 103740.0 |
| 2013-11-25 08:40:00 | AAPL | Stock | 18.6318 | 18.6429 | 18.6318 | 18.6429 | 135604.0 |
| 2013-11-25 08:45:00 | AAPL | Stock | 18.6446 | 18.6554 | 18.63 | 18.6339 | 260624.0 |
| 2013-11-25 08:50:00 | AAPL | Stock | 18.63 | 18.635 | 18.6246 | 18.6321 | 127400.0 |
| 2013-11-25 08:55:00 | AAPL | Stock | 18.625 | 18.6429 | 18.6246 | 18.6429 | 159432.0 |
| 2013-11-25 09:00:00 | AAPL | Stock | 18.6393 | 18.6421 | 18.625 | 18.625 | 100016.0 |
| 2013-11-25 09:05:00 | AAPL | Stock | 18.6354 | 18.6414 | 18.6289 | 18.6293 | 42000.0 |
| 2013-11-25 09:10:00 | AAPL | Stock | 18.6357 | 18.6393 | 18.6339 | 18.6361 | 95424.0 |
| 2013-11-25 09:15:00 | AAPL | Stock | 18.6382 | 18.6382 | 18.6339 | 18.6382 | 42000.0 |
| 2013-11-25 09:20:00 | AAPL | Stock | 18.6393 | 18.6393 | 18.6275 | 18.6339 | 65268.0 |
| 2013-11-25 09:25:00 | AAPL | Stock | 18.6332 | 18.6332 | 18.6071 | 18.6093 | 121688.0 |
| 2013-11-25 09:30:00 | AAPL | Stock | 18.6079 | 18.6782 | 18.6071 | 18.6332 | 11865308.0 |
| 2013-11-25 09:35:00 | AAPL | Stock | 18.6382 | 18.7318 | 18.6282 | 18.6894 | 11061932.0 |
| 2013-11-25 09:40:00 | AAPL | Stock | 18.6879 | 18.7475 | 18.6875 | 18.7446 | 10483452.0 |
| 2013-11-25 09:45:00 | AAPL | Stock | 18.7446 | 18.7536 | 18.7186 | 18.7232 | 8036672.0 |
| 2013-11-25 09:50:00 | AAPL | Stock | 18.7275 | 18.7368 | 18.7089 | 18.7157 | 3417428.0 |
| 2013-11-25 09:55:00 | AAPL | Stock | 18.7146 | 18.7307 | 18.68 | 18.6899 | 6026692.0 |
| 2013-11-25 10:00:00 | AAPL | Stock | 18.6907 | 18.7211 | 18.69 | 18.7204 | 3526404.0 |
| 2013-11-25 10:05:00 | AAPL | Stock | 18.7175 | 18.7673 | 18.7093 | 18.7507 | 10326204.0 |
| 2013-11-25 10:10:00 | AAPL | Stock | 18.7514 | 18.7639 | 18.7507 | 18.7556 | 4193644.0 |
| 2013-11-25 10:15:00 | AAPL | Stock | 18.7571 | 18.7648 | 18.7146 | 18.7225 | 4403448.0 |
| 2013-11-25 10:20:00 | AAPL | Stock | 18.7204 | 18.7318 | 18.7082 | 18.7214 | 2813468.0 |
| 2013-11-25 10:25:00 | AAPL | Stock | 18.7214 | 18.7343 | 18.6829 | 18.7054 | 5391456.0 |
| 2013-11-25 10:30:00 | AAPL | Stock | 18.7011 | 18.7225 | 18.7011 | 18.7018 | 4039168.0 |
| 2013-11-25 10:35:00 | AAPL | Stock | 18.7061 | 18.7321 | 18.6979 | 18.7187 | 5490996.0 |
> showing 50 of 356,089 rows — these rows as CSV