PREVIEW / stock_5min / 2012-09-14
file: by_date/stock_5min/2012/2012-09-14.parquet size: 5.0 MB rows: 332,282 symbols: 3,503
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-09-14 04:00:00 | AAPL | Stock | 24.475 | 24.475 | 24.475 | 24.475 | 14000.0 |
| 2012-09-14 04:05:00 | AAPL | Stock | 24.4761 | 24.4761 | 24.4761 | 24.4761 | 5600.0 |
| 2012-09-14 04:10:00 | AAPL | Stock | 24.4996 | 24.5 | 24.4996 | 24.5 | 5600.0 |
| 2012-09-14 04:15:00 | AAPL | Stock | 24.4761 | 24.4821 | 24.4761 | 24.4821 | 16520.0 |
| 2012-09-14 04:40:00 | AAPL | Stock | 24.5 | 24.5 | 24.5 | 24.5 | 2800.0 |
| 2012-09-14 05:05:00 | AAPL | Stock | 24.4929 | 24.4929 | 24.4929 | 24.4929 | 2800.0 |
| 2012-09-14 05:20:00 | AAPL | Stock | 24.4911 | 24.4911 | 24.4911 | 24.4911 | 2800.0 |
| 2012-09-14 05:35:00 | AAPL | Stock | 24.5143 | 24.5143 | 24.5143 | 24.5143 | 2800.0 |
| 2012-09-14 05:40:00 | AAPL | Stock | 24.5164 | 24.5164 | 24.5164 | 24.5164 | 2800.0 |
| 2012-09-14 05:45:00 | AAPL | Stock | 24.5268 | 24.5357 | 24.5268 | 24.5357 | 5600.0 |
| 2012-09-14 05:55:00 | AAPL | Stock | 24.5357 | 24.5357 | 24.5304 | 24.5357 | 14000.0 |
| 2012-09-14 06:10:00 | AAPL | Stock | 24.5482 | 24.5482 | 24.5357 | 24.5429 | 33600.0 |
| 2012-09-14 06:15:00 | AAPL | Stock | 24.5429 | 24.5429 | 24.5429 | 24.5429 | 22960.0 |
| 2012-09-14 06:20:00 | AAPL | Stock | 24.5429 | 24.5429 | 24.5425 | 24.5425 | 7700.0 |
| 2012-09-14 06:25:00 | AAPL | Stock | 24.5425 | 24.5425 | 24.5425 | 24.5425 | 2800.0 |
| 2012-09-14 06:30:00 | AAPL | Stock | 24.5425 | 24.5425 | 24.5421 | 24.5421 | 5600.0 |
| 2012-09-14 06:40:00 | AAPL | Stock | 24.5425 | 24.5429 | 24.5425 | 24.5429 | 7140.0 |
| 2012-09-14 06:45:00 | AAPL | Stock | 24.5321 | 24.5321 | 24.5318 | 24.5321 | 16800.0 |
| 2012-09-14 06:50:00 | AAPL | Stock | 24.5089 | 24.5089 | 24.5089 | 24.5089 | 2800.0 |
| 2012-09-14 06:55:00 | AAPL | Stock | 24.5289 | 24.5429 | 24.5289 | 24.5429 | 10640.0 |
| 2012-09-14 07:00:00 | AAPL | Stock | 24.5536 | 24.5536 | 24.5343 | 24.5443 | 52360.0 |
| 2012-09-14 07:05:00 | AAPL | Stock | 24.5357 | 24.5486 | 24.5268 | 24.5268 | 108780.0 |
| 2012-09-14 07:10:00 | AAPL | Stock | 24.5339 | 24.5357 | 24.5268 | 24.5325 | 68040.0 |
| 2012-09-14 07:15:00 | AAPL | Stock | 24.5382 | 24.5632 | 24.5382 | 24.5593 | 124712.0 |
| 2012-09-14 07:20:00 | AAPL | Stock | 24.5632 | 24.5804 | 24.5625 | 24.5714 | 326116.0 |
| 2012-09-14 07:25:00 | AAPL | Stock | 24.5711 | 24.5714 | 24.5536 | 24.5689 | 100016.0 |
| 2012-09-14 07:30:00 | AAPL | Stock | 24.5561 | 24.5711 | 24.5536 | 24.5711 | 126420.0 |
| 2012-09-14 07:35:00 | AAPL | Stock | 24.5607 | 24.5686 | 24.5536 | 24.5625 | 125636.0 |
| 2012-09-14 07:40:00 | AAPL | Stock | 24.5539 | 24.5711 | 24.5539 | 24.5711 | 60760.0 |
| 2012-09-14 07:45:00 | AAPL | Stock | 24.5625 | 24.5696 | 24.5571 | 24.5639 | 159600.0 |
| 2012-09-14 07:50:00 | AAPL | Stock | 24.5632 | 24.5654 | 24.5554 | 24.5554 | 115640.0 |
| 2012-09-14 07:55:00 | AAPL | Stock | 24.5482 | 24.5593 | 24.5357 | 24.5464 | 133560.0 |
| 2012-09-14 08:00:00 | AAPL | Stock | 24.5393 | 24.5779 | 24.5357 | 24.55 | 861924.0 |
| 2012-09-14 08:05:00 | AAPL | Stock | 24.55 | 24.5732 | 24.5446 | 24.5714 | 599536.0 |
| 2012-09-14 08:10:00 | AAPL | Stock | 24.5718 | 24.5732 | 24.5607 | 24.5714 | 352800.0 |
| 2012-09-14 08:15:00 | AAPL | Stock | 24.5696 | 24.5957 | 24.5643 | 24.5929 | 354984.0 |
| 2012-09-14 08:20:00 | AAPL | Stock | 24.5893 | 24.6214 | 24.585 | 24.6161 | 369040.0 |
| 2012-09-14 08:25:00 | AAPL | Stock | 24.6139 | 24.6161 | 24.5929 | 24.6161 | 658896.0 |
| 2012-09-14 08:30:00 | AAPL | Stock | 24.6114 | 24.6282 | 24.565 | 24.5786 | 900004.0 |
| 2012-09-14 08:35:00 | AAPL | Stock | 24.5746 | 24.58 | 24.5507 | 24.5636 | 500892.0 |
| 2012-09-14 08:40:00 | AAPL | Stock | 24.5593 | 24.575 | 24.5586 | 24.5714 | 240940.0 |
| 2012-09-14 08:45:00 | AAPL | Stock | 24.58 | 24.5804 | 24.5571 | 24.5607 | 626528.0 |
| 2012-09-14 08:50:00 | AAPL | Stock | 24.5607 | 24.58 | 24.5536 | 24.58 | 189644.0 |
| 2012-09-14 08:55:00 | AAPL | Stock | 24.575 | 24.5893 | 24.5714 | 24.5804 | 189868.0 |
| 2012-09-14 09:00:00 | AAPL | Stock | 24.5871 | 24.5986 | 24.5811 | 24.5961 | 173040.0 |
| 2012-09-14 09:05:00 | AAPL | Stock | 24.5971 | 24.6 | 24.5807 | 24.5929 | 268324.0 |
| 2012-09-14 09:10:00 | AAPL | Stock | 24.5954 | 24.6214 | 24.5954 | 24.6196 | 503356.0 |
| 2012-09-14 09:15:00 | AAPL | Stock | 24.6171 | 24.6339 | 24.6071 | 24.6232 | 779296.0 |
| 2012-09-14 09:20:00 | AAPL | Stock | 24.6239 | 24.6382 | 24.6239 | 24.6382 | 263060.0 |
| 2012-09-14 09:25:00 | AAPL | Stock | 24.6357 | 24.6493 | 24.6207 | 24.6429 | 883344.0 |
> showing 50 of 332,282 rows — these rows as CSV