PREVIEW / stock_5min / 2010-10-15
file: by_date/stock_5min/2010/2010-10-15.parquet size: 4.7 MB rows: 321,653 symbols: 3,461
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-15 05:35:00 | AAPL | Stock | 10.8882 | 10.8882 | 10.8786 | 10.8786 | 25788.0 |
| 2010-10-15 05:40:00 | AAPL | Stock | 10.8911 | 10.8911 | 10.8911 | 10.8911 | 2800.0 |
| 2010-10-15 05:55:00 | AAPL | Stock | 10.8929 | 10.8929 | 10.8875 | 10.8875 | 8400.0 |
| 2010-10-15 06:00:00 | AAPL | Stock | 10.8721 | 10.8721 | 10.8721 | 10.8721 | 16800.0 |
| 2010-10-15 06:05:00 | AAPL | Stock | 10.8721 | 10.8721 | 10.8721 | 10.8721 | 5600.0 |
| 2010-10-15 06:10:00 | AAPL | Stock | 10.8929 | 10.8929 | 10.8929 | 10.8929 | 7812.0 |
| 2010-10-15 06:25:00 | AAPL | Stock | 10.8929 | 10.8929 | 10.8929 | 10.8929 | 2800.0 |
| 2010-10-15 06:30:00 | AAPL | Stock | 10.8679 | 10.8679 | 10.8679 | 10.8679 | 2800.0 |
| 2010-10-15 06:45:00 | AAPL | Stock | 10.8643 | 10.8643 | 10.8643 | 10.8643 | 5600.0 |
| 2010-10-15 07:00:00 | AAPL | Stock | 10.8643 | 10.8739 | 10.8643 | 10.8739 | 7000.0 |
| 2010-10-15 07:05:00 | AAPL | Stock | 10.8729 | 10.875 | 10.8729 | 10.875 | 117600.0 |
| 2010-10-15 07:10:00 | AAPL | Stock | 10.8868 | 10.8929 | 10.8868 | 10.8868 | 112392.0 |
| 2010-10-15 07:15:00 | AAPL | Stock | 10.8929 | 10.8929 | 10.8846 | 10.8846 | 50792.0 |
| 2010-10-15 07:20:00 | AAPL | Stock | 10.8886 | 10.8886 | 10.8654 | 10.8729 | 68600.0 |
| 2010-10-15 07:25:00 | AAPL | Stock | 10.8729 | 10.8729 | 10.85 | 10.8571 | 110404.0 |
| 2010-10-15 07:30:00 | AAPL | Stock | 10.8493 | 10.8493 | 10.8446 | 10.8475 | 43092.0 |
| 2010-10-15 07:35:00 | AAPL | Stock | 10.8489 | 10.8504 | 10.8393 | 10.8393 | 74760.0 |
| 2010-10-15 07:40:00 | AAPL | Stock | 10.845 | 10.845 | 10.8336 | 10.8336 | 48160.0 |
| 2010-10-15 07:45:00 | AAPL | Stock | 10.8311 | 10.8443 | 10.8214 | 10.8293 | 99960.0 |
| 2010-10-15 07:50:00 | AAPL | Stock | 10.8282 | 10.8489 | 10.8218 | 10.8339 | 69160.0 |
| 2010-10-15 07:55:00 | AAPL | Stock | 10.8464 | 10.8464 | 10.8429 | 10.8439 | 22400.0 |
| 2010-10-15 08:00:00 | AAPL | Stock | 10.8429 | 10.8804 | 10.8321 | 10.8396 | 657412.0 |
| 2010-10-15 08:05:00 | AAPL | Stock | 10.8396 | 10.8893 | 10.8396 | 10.8796 | 478576.0 |
| 2010-10-15 08:10:00 | AAPL | Stock | 10.8861 | 10.8929 | 10.885 | 10.8893 | 820904.0 |
| 2010-10-15 08:15:00 | AAPL | Stock | 10.8889 | 10.9068 | 10.8864 | 10.9068 | 1219820.0 |
| 2010-10-15 08:20:00 | AAPL | Stock | 10.9068 | 10.9071 | 10.8839 | 10.8918 | 871724.0 |
| 2010-10-15 08:25:00 | AAPL | Stock | 10.8875 | 10.9054 | 10.8868 | 10.895 | 289128.0 |
| 2010-10-15 08:30:00 | AAPL | Stock | 10.8929 | 10.9393 | 10.8929 | 10.9321 | 1738352.0 |
| 2010-10-15 08:35:00 | AAPL | Stock | 10.9343 | 10.9507 | 10.9286 | 10.9482 | 1449700.0 |
| 2010-10-15 08:40:00 | AAPL | Stock | 10.9504 | 10.9504 | 10.9286 | 10.9329 | 715204.0 |
| 2010-10-15 08:45:00 | AAPL | Stock | 10.9343 | 10.9371 | 10.9171 | 10.9371 | 840476.0 |
| 2010-10-15 08:50:00 | AAPL | Stock | 10.9371 | 10.9546 | 10.9357 | 10.9521 | 542948.0 |
| 2010-10-15 08:55:00 | AAPL | Stock | 10.9521 | 10.9525 | 10.9239 | 10.925 | 923720.0 |
| 2010-10-15 09:00:00 | AAPL | Stock | 10.925 | 10.9286 | 10.9021 | 10.9268 | 1145956.0 |
| 2010-10-15 09:05:00 | AAPL | Stock | 10.9264 | 10.9596 | 10.9261 | 10.9571 | 1374352.0 |
| 2010-10-15 09:10:00 | AAPL | Stock | 10.9575 | 10.9732 | 10.9575 | 10.9621 | 948472.0 |
| 2010-10-15 09:15:00 | AAPL | Stock | 10.9621 | 10.965 | 10.9471 | 10.9536 | 730968.0 |
| 2010-10-15 09:20:00 | AAPL | Stock | 10.9525 | 10.9607 | 10.95 | 10.9554 | 480172.0 |
| 2010-10-15 09:25:00 | AAPL | Stock | 10.9486 | 10.9786 | 10.9486 | 10.9761 | 1893472.0 |
| 2010-10-15 09:30:00 | AAPL | Stock | 10.9739 | 10.9804 | 10.9111 | 10.915 | 75166476.0 |
| 2010-10-15 09:35:00 | AAPL | Stock | 10.9146 | 10.9282 | 10.8896 | 10.8996 | 24762080.0 |
| 2010-10-15 09:40:00 | AAPL | Stock | 10.8957 | 10.925 | 10.8896 | 10.9182 | 19778948.0 |
| 2010-10-15 09:45:00 | AAPL | Stock | 10.9182 | 10.9357 | 10.9107 | 10.9239 | 13804000.0 |
| 2010-10-15 09:50:00 | AAPL | Stock | 10.9257 | 10.9464 | 10.9236 | 10.9436 | 13214152.0 |
| 2010-10-15 09:55:00 | AAPL | Stock | 10.9436 | 10.9671 | 10.935 | 10.9614 | 17741500.0 |
| 2010-10-15 10:00:00 | AAPL | Stock | 10.9636 | 10.9661 | 10.9071 | 10.9193 | 20277600.0 |
| 2010-10-15 10:05:00 | AAPL | Stock | 10.9193 | 10.9411 | 10.9018 | 10.9268 | 15101968.0 |
| 2010-10-15 10:10:00 | AAPL | Stock | 10.9253 | 10.9596 | 10.925 | 10.9475 | 12579616.0 |
| 2010-10-15 10:15:00 | AAPL | Stock | 10.9486 | 10.9521 | 10.9164 | 10.925 | 13914264.0 |
| 2010-10-15 10:20:00 | AAPL | Stock | 10.9232 | 10.9357 | 10.9224 | 10.9307 | 8973412.0 |
> showing 50 of 321,653 rows — these rows as CSV