PREVIEW / stock_5min / 2013-06-05
file: by_date/stock_5min/2013/2013-06-05.parquet size: 5.1 MB rows: 339,289 symbols: 3,515
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-06-05 04:00:00 | AAPL | Stock | 15.9471 | 15.9471 | 15.9471 | 15.9471 | 3640.0 |
| 2013-06-05 04:50:00 | AAPL | Stock | 15.9686 | 15.9686 | 15.9686 | 15.9686 | 5600.0 |
| 2013-06-05 05:40:00 | AAPL | Stock | 15.9664 | 15.9664 | 15.9604 | 15.9604 | 31696.0 |
| 2013-06-05 05:45:00 | AAPL | Stock | 15.9582 | 15.96 | 15.9582 | 15.96 | 15680.0 |
| 2013-06-05 05:50:00 | AAPL | Stock | 15.9575 | 15.9575 | 15.9575 | 15.9575 | 11200.0 |
| 2013-06-05 06:15:00 | AAPL | Stock | 15.9511 | 15.9511 | 15.9511 | 15.9511 | 2800.0 |
| 2013-06-05 06:30:00 | AAPL | Stock | 15.9332 | 15.9332 | 15.9332 | 15.9332 | 2800.0 |
| 2013-06-05 06:35:00 | AAPL | Stock | 15.9321 | 15.9321 | 15.925 | 15.925 | 16800.0 |
| 2013-06-05 06:40:00 | AAPL | Stock | 15.9143 | 15.9143 | 15.9143 | 15.9143 | 2800.0 |
| 2013-06-05 06:45:00 | AAPL | Stock | 15.9161 | 15.9161 | 15.9107 | 15.9107 | 19600.0 |
| 2013-06-05 06:50:00 | AAPL | Stock | 15.8989 | 15.9093 | 15.8946 | 15.9093 | 8400.0 |
| 2013-06-05 06:55:00 | AAPL | Stock | 15.9014 | 15.9286 | 15.9011 | 15.9286 | 33600.0 |
| 2013-06-05 07:00:00 | AAPL | Stock | 15.9136 | 15.9136 | 15.9011 | 15.9011 | 31920.0 |
| 2013-06-05 07:05:00 | AAPL | Stock | 15.895 | 15.925 | 15.8768 | 15.9193 | 105700.0 |
| 2013-06-05 07:15:00 | AAPL | Stock | 15.9111 | 15.9404 | 15.9111 | 15.9404 | 50400.0 |
| 2013-06-05 07:20:00 | AAPL | Stock | 15.9429 | 15.9429 | 15.9368 | 15.9368 | 11200.0 |
| 2013-06-05 07:25:00 | AAPL | Stock | 15.9443 | 15.9443 | 15.9443 | 15.9443 | 2800.0 |
| 2013-06-05 07:30:00 | AAPL | Stock | 15.9396 | 15.9396 | 15.9143 | 15.9143 | 79268.0 |
| 2013-06-05 07:35:00 | AAPL | Stock | 15.9286 | 15.9289 | 15.9286 | 15.9286 | 21672.0 |
| 2013-06-05 07:40:00 | AAPL | Stock | 15.9196 | 15.9196 | 15.9143 | 15.9143 | 5600.0 |
| 2013-06-05 07:45:00 | AAPL | Stock | 15.9168 | 15.9271 | 15.9161 | 15.9161 | 16800.0 |
| 2013-06-05 07:50:00 | AAPL | Stock | 15.9107 | 15.9196 | 15.9107 | 15.9161 | 78624.0 |
| 2013-06-05 07:55:00 | AAPL | Stock | 15.9179 | 15.9196 | 15.9139 | 15.9196 | 19712.0 |
| 2013-06-05 08:00:00 | AAPL | Stock | 15.9143 | 16.0357 | 15.8768 | 15.9186 | 294420.0 |
| 2013-06-05 08:05:00 | AAPL | Stock | 15.9164 | 15.935 | 15.9164 | 15.925 | 236740.0 |
| 2013-06-05 08:10:00 | AAPL | Stock | 15.9229 | 15.9496 | 15.9196 | 15.9357 | 138180.0 |
| 2013-06-05 08:15:00 | AAPL | Stock | 15.9357 | 15.9546 | 15.9161 | 15.9479 | 244552.0 |
| 2013-06-05 08:20:00 | AAPL | Stock | 15.9604 | 15.9768 | 15.9593 | 15.9761 | 362544.0 |
| 2013-06-05 08:25:00 | AAPL | Stock | 15.9711 | 15.9711 | 15.9468 | 15.9554 | 167048.0 |
| 2013-06-05 08:30:00 | AAPL | Stock | 15.9589 | 15.9625 | 15.9446 | 15.945 | 97020.0 |
| 2013-06-05 08:35:00 | AAPL | Stock | 15.9525 | 15.9586 | 15.9489 | 15.9489 | 20860.0 |
| 2013-06-05 08:40:00 | AAPL | Stock | 15.9471 | 15.9604 | 15.9471 | 15.9604 | 26880.0 |
| 2013-06-05 08:45:00 | AAPL | Stock | 15.9604 | 15.9604 | 15.9504 | 15.9543 | 14000.0 |
| 2013-06-05 08:50:00 | AAPL | Stock | 15.9507 | 15.9604 | 15.9507 | 15.96 | 32676.0 |
| 2013-06-05 08:55:00 | AAPL | Stock | 15.95 | 15.9643 | 15.95 | 15.95 | 122780.0 |
| 2013-06-05 09:00:00 | AAPL | Stock | 15.9539 | 15.9554 | 15.9361 | 15.9375 | 167776.0 |
| 2013-06-05 09:05:00 | AAPL | Stock | 15.945 | 15.9539 | 15.9368 | 15.9464 | 144032.0 |
| 2013-06-05 09:10:00 | AAPL | Stock | 15.9493 | 15.9643 | 15.9493 | 15.9554 | 72352.0 |
| 2013-06-05 09:15:00 | AAPL | Stock | 15.9571 | 15.9643 | 15.9571 | 15.9604 | 87780.0 |
| 2013-06-05 09:20:00 | AAPL | Stock | 15.9586 | 15.9668 | 15.9586 | 15.965 | 249592.0 |
| 2013-06-05 09:25:00 | AAPL | Stock | 15.9639 | 15.975 | 15.9107 | 15.9118 | 645288.0 |
| 2013-06-05 09:30:00 | AAPL | Stock | 15.9161 | 16.0167 | 15.8957 | 15.9929 | 15350020.0 |
| 2013-06-05 09:35:00 | AAPL | Stock | 15.9929 | 16.0425 | 15.9614 | 16.0218 | 9326156.0 |
| 2013-06-05 09:40:00 | AAPL | Stock | 16.02 | 16.0611 | 15.9846 | 16.0479 | 7764988.0 |
| 2013-06-05 09:45:00 | AAPL | Stock | 16.0521 | 16.0886 | 16.0179 | 16.0868 | 8384152.0 |
| 2013-06-05 09:50:00 | AAPL | Stock | 16.08 | 16.0921 | 16.0498 | 16.0675 | 8052968.0 |
| 2013-06-05 09:55:00 | AAPL | Stock | 16.0661 | 16.0971 | 16.0059 | 16.0209 | 6467244.0 |
| 2013-06-05 10:00:00 | AAPL | Stock | 16.0214 | 16.0525 | 16.0214 | 16.0461 | 7998172.0 |
| 2013-06-05 10:05:00 | AAPL | Stock | 16.0446 | 16.0525 | 15.9921 | 16.0054 | 7760032.0 |
| 2013-06-05 10:10:00 | AAPL | Stock | 16.0054 | 16.0068 | 15.9796 | 15.9929 | 5317872.0 |
> showing 50 of 339,289 rows — these rows as CSV