PREVIEW / stock_5min / 2011-08-23
file: by_date/stock_5min/2011/2011-08-23.parquet size: 5.0 MB rows: 336,132 symbols: 3,537
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-23 04:00:00 | AAPL | Stock | 12.8443 | 12.9768 | 12.8443 | 12.9686 | 62300.0 |
| 2011-08-23 04:05:00 | AAPL | Stock | 12.9732 | 12.9804 | 12.9732 | 12.9804 | 28000.0 |
| 2011-08-23 04:25:00 | AAPL | Stock | 12.9782 | 12.9782 | 12.9782 | 12.9782 | 2800.0 |
| 2011-08-23 04:30:00 | AAPL | Stock | 12.9679 | 12.9679 | 12.9557 | 12.9557 | 5600.0 |
| 2011-08-23 04:35:00 | AAPL | Stock | 12.9443 | 12.9464 | 12.9361 | 12.9364 | 14000.0 |
| 2011-08-23 04:40:00 | AAPL | Stock | 12.935 | 12.935 | 12.935 | 12.935 | 2800.0 |
| 2011-08-23 04:45:00 | AAPL | Stock | 12.9439 | 12.9454 | 12.9 | 12.9429 | 44800.0 |
| 2011-08-23 04:50:00 | AAPL | Stock | 12.9464 | 12.9571 | 12.9464 | 12.9571 | 9800.0 |
| 2011-08-23 04:55:00 | AAPL | Stock | 12.9286 | 12.9286 | 12.9286 | 12.9286 | 8400.0 |
| 2011-08-23 05:00:00 | AAPL | Stock | 12.9179 | 12.9275 | 12.9179 | 12.9275 | 14000.0 |
| 2011-08-23 05:05:00 | AAPL | Stock | 12.925 | 12.925 | 12.925 | 12.925 | 8400.0 |
| 2011-08-23 05:15:00 | AAPL | Stock | 12.9389 | 12.9389 | 12.9389 | 12.9389 | 2800.0 |
| 2011-08-23 05:20:00 | AAPL | Stock | 12.9425 | 12.9425 | 12.9425 | 12.9425 | 2800.0 |
| 2011-08-23 05:25:00 | AAPL | Stock | 12.9425 | 12.9464 | 12.9425 | 12.9464 | 8400.0 |
| 2011-08-23 05:30:00 | AAPL | Stock | 12.9786 | 12.9804 | 12.9786 | 12.9804 | 5600.0 |
| 2011-08-23 05:35:00 | AAPL | Stock | 12.9768 | 12.9768 | 12.9768 | 12.9768 | 2800.0 |
| 2011-08-23 06:00:00 | AAPL | Stock | 12.9714 | 12.9714 | 12.9289 | 12.9289 | 68880.0 |
| 2011-08-23 06:05:00 | AAPL | Stock | 12.9332 | 12.9332 | 12.92 | 12.92 | 72800.0 |
| 2011-08-23 06:10:00 | AAPL | Stock | 12.9196 | 12.9196 | 12.9196 | 12.9196 | 5600.0 |
| 2011-08-23 06:25:00 | AAPL | Stock | 12.9486 | 12.9486 | 12.9486 | 12.9486 | 2800.0 |
| 2011-08-23 06:30:00 | AAPL | Stock | 12.9579 | 12.9607 | 12.9579 | 12.9607 | 5600.0 |
| 2011-08-23 06:45:00 | AAPL | Stock | 12.95 | 12.95 | 12.95 | 12.95 | 19348.0 |
| 2011-08-23 06:50:00 | AAPL | Stock | 12.9289 | 12.9289 | 12.9286 | 12.9286 | 11200.0 |
| 2011-08-23 07:00:00 | AAPL | Stock | 12.9111 | 12.9286 | 12.8786 | 12.8886 | 126000.0 |
| 2011-08-23 07:05:00 | AAPL | Stock | 12.8907 | 12.9714 | 12.8614 | 12.9404 | 603400.0 |
| 2011-08-23 07:10:00 | AAPL | Stock | 12.9343 | 12.9343 | 12.9196 | 12.9304 | 61600.0 |
| 2011-08-23 07:15:00 | AAPL | Stock | 12.9361 | 12.9407 | 12.9321 | 12.9321 | 59500.0 |
| 2011-08-23 07:20:00 | AAPL | Stock | 12.9339 | 12.95 | 12.9275 | 12.9386 | 306880.0 |
| 2011-08-23 07:25:00 | AAPL | Stock | 12.9339 | 12.9339 | 12.9286 | 12.9304 | 81200.0 |
| 2011-08-23 07:30:00 | AAPL | Stock | 12.9307 | 12.9425 | 12.9307 | 12.9375 | 171472.0 |
| 2011-08-23 07:35:00 | AAPL | Stock | 12.9404 | 12.9554 | 12.9375 | 12.9396 | 170660.0 |
| 2011-08-23 07:40:00 | AAPL | Stock | 12.9404 | 12.9464 | 12.94 | 12.9464 | 57400.0 |
| 2011-08-23 07:45:00 | AAPL | Stock | 12.9464 | 12.9464 | 12.9357 | 12.9357 | 81648.0 |
| 2011-08-23 07:50:00 | AAPL | Stock | 12.9304 | 12.935 | 12.9096 | 12.9107 | 273448.0 |
| 2011-08-23 07:55:00 | AAPL | Stock | 12.9114 | 12.9114 | 12.8843 | 12.8911 | 101080.0 |
| 2011-08-23 08:00:00 | AAPL | Stock | 12.8911 | 12.9321 | 12.8286 | 12.8546 | 632576.0 |
| 2011-08-23 08:05:00 | AAPL | Stock | 12.8532 | 12.8693 | 12.8521 | 12.855 | 300272.0 |
| 2011-08-23 08:10:00 | AAPL | Stock | 12.8529 | 12.88 | 12.8529 | 12.8729 | 336252.0 |
| 2011-08-23 08:15:00 | AAPL | Stock | 12.8714 | 12.9071 | 12.8714 | 12.8929 | 328216.0 |
| 2011-08-23 08:20:00 | AAPL | Stock | 12.8929 | 12.9036 | 12.8868 | 12.8868 | 82348.0 |
| 2011-08-23 08:25:00 | AAPL | Stock | 12.8757 | 12.8875 | 12.8757 | 12.8857 | 22400.0 |
| 2011-08-23 08:30:00 | AAPL | Stock | 12.8789 | 12.8821 | 12.8529 | 12.8536 | 352240.0 |
| 2011-08-23 08:35:00 | AAPL | Stock | 12.8571 | 12.8768 | 12.8571 | 12.8718 | 70952.0 |
| 2011-08-23 08:40:00 | AAPL | Stock | 12.8714 | 12.8793 | 12.8536 | 12.8625 | 198156.0 |
| 2011-08-23 08:45:00 | AAPL | Stock | 12.8575 | 12.8625 | 12.8414 | 12.8446 | 149660.0 |
| 2011-08-23 08:50:00 | AAPL | Stock | 12.8479 | 12.8482 | 12.8307 | 12.8371 | 246568.0 |
| 2011-08-23 08:55:00 | AAPL | Stock | 12.8321 | 12.8439 | 12.8254 | 12.8261 | 593600.0 |
| 2011-08-23 09:00:00 | AAPL | Stock | 12.825 | 12.8625 | 12.825 | 12.8571 | 202804.0 |
| 2011-08-23 09:05:00 | AAPL | Stock | 12.8571 | 12.8625 | 12.8429 | 12.8432 | 271768.0 |
| 2011-08-23 09:10:00 | AAPL | Stock | 12.8432 | 12.8607 | 12.8414 | 12.8604 | 491568.0 |
> showing 50 of 336,132 rows — these rows as CSV