PREVIEW / stock_5min / 2007-12-11
file: by_date/stock_5min/2007/2007-12-11.parquet size: 4.4 MB rows: 320,498 symbols: 3,230
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-11 06:40:00 | AAPL | Stock | 6.9071 | 6.9071 | 6.9043 | 6.9043 | 5600.0 |
| 2007-12-11 07:00:00 | AAPL | Stock | 6.9286 | 6.9286 | 6.9286 | 6.9286 | 9100.0 |
| 2007-12-11 07:35:00 | AAPL | Stock | 6.9318 | 6.9318 | 6.9318 | 6.9318 | 8400.0 |
| 2007-12-11 07:40:00 | AAPL | Stock | 6.9354 | 6.9357 | 6.9354 | 6.9354 | 11900.0 |
| 2007-12-11 07:45:00 | AAPL | Stock | 6.9389 | 6.9568 | 6.9389 | 6.9568 | 62300.0 |
| 2007-12-11 07:50:00 | AAPL | Stock | 6.9571 | 6.9625 | 6.9571 | 6.9571 | 26684.0 |
| 2007-12-11 07:55:00 | AAPL | Stock | 6.9571 | 6.9589 | 6.9571 | 6.9571 | 166880.0 |
| 2007-12-11 08:00:00 | AAPL | Stock | 6.9589 | 6.9589 | 6.9464 | 6.95 | 214424.0 |
| 2007-12-11 08:05:00 | AAPL | Stock | 6.9489 | 6.9589 | 6.9479 | 6.9557 | 134624.0 |
| 2007-12-11 08:10:00 | AAPL | Stock | 6.9571 | 6.9571 | 6.9511 | 6.9529 | 106400.0 |
| 2007-12-11 08:15:00 | AAPL | Stock | 6.9532 | 6.9536 | 6.9464 | 6.9464 | 155708.0 |
| 2007-12-11 08:20:00 | AAPL | Stock | 6.9507 | 6.9529 | 6.9464 | 6.9475 | 120680.0 |
| 2007-12-11 08:25:00 | AAPL | Stock | 6.9518 | 6.9564 | 6.9486 | 6.9504 | 267932.0 |
| 2007-12-11 08:30:00 | AAPL | Stock | 6.95 | 6.9518 | 6.9468 | 6.9468 | 86800.0 |
| 2007-12-11 08:35:00 | AAPL | Stock | 6.9471 | 6.9514 | 6.9464 | 6.9514 | 74144.0 |
| 2007-12-11 08:40:00 | AAPL | Stock | 6.9507 | 6.9507 | 6.9457 | 6.9457 | 56896.0 |
| 2007-12-11 08:45:00 | AAPL | Stock | 6.9461 | 6.9482 | 6.9414 | 6.9414 | 80164.0 |
| 2007-12-11 08:50:00 | AAPL | Stock | 6.9432 | 6.9482 | 6.9429 | 6.9482 | 44212.0 |
| 2007-12-11 08:55:00 | AAPL | Stock | 6.95 | 6.9564 | 6.9482 | 6.955 | 236740.0 |
| 2007-12-11 09:00:00 | AAPL | Stock | 6.9564 | 6.9564 | 6.9536 | 6.9536 | 86548.0 |
| 2007-12-11 09:05:00 | AAPL | Stock | 6.955 | 6.96 | 6.9536 | 6.9571 | 492100.0 |
| 2007-12-11 09:10:00 | AAPL | Stock | 6.9539 | 6.9539 | 6.9464 | 6.9536 | 258888.0 |
| 2007-12-11 09:15:00 | AAPL | Stock | 6.9557 | 6.9596 | 6.9529 | 6.9557 | 119000.0 |
| 2007-12-11 09:20:00 | AAPL | Stock | 6.9539 | 6.9543 | 6.9518 | 6.9521 | 192640.0 |
| 2007-12-11 09:25:00 | AAPL | Stock | 6.9518 | 6.9643 | 6.9511 | 6.9568 | 669312.0 |
| 2007-12-11 09:30:00 | AAPL | Stock | 6.9568 | 6.9714 | 6.9446 | 6.9586 | 20819260.0 |
| 2007-12-11 09:35:00 | AAPL | Stock | 6.9579 | 6.9786 | 6.9504 | 6.9704 | 15381268.0 |
| 2007-12-11 09:40:00 | AAPL | Stock | 6.97 | 6.9804 | 6.9611 | 6.9693 | 14645792.0 |
| 2007-12-11 09:45:00 | AAPL | Stock | 6.97 | 6.9782 | 6.9614 | 6.9736 | 8836128.0 |
| 2007-12-11 09:50:00 | AAPL | Stock | 6.9739 | 6.9836 | 6.9557 | 6.9561 | 17646804.0 |
| 2007-12-11 09:55:00 | AAPL | Stock | 6.9561 | 6.9693 | 6.9561 | 6.9629 | 8371972.0 |
| 2007-12-11 10:00:00 | AAPL | Stock | 6.9621 | 6.965 | 6.9532 | 6.9632 | 9934960.0 |
| 2007-12-11 10:05:00 | AAPL | Stock | 6.9629 | 6.9768 | 6.9604 | 6.975 | 10438820.0 |
| 2007-12-11 10:10:00 | AAPL | Stock | 6.9746 | 6.9793 | 6.9707 | 6.9781 | 6434820.0 |
| 2007-12-11 10:15:00 | AAPL | Stock | 6.9779 | 6.9814 | 6.9661 | 6.9696 | 9054612.0 |
| 2007-12-11 10:20:00 | AAPL | Stock | 6.9696 | 6.9904 | 6.9693 | 6.9857 | 10712604.0 |
| 2007-12-11 10:25:00 | AAPL | Stock | 6.9857 | 6.9868 | 6.9739 | 6.9791 | 10083752.0 |
| 2007-12-11 10:30:00 | AAPL | Stock | 6.9789 | 6.9821 | 6.975 | 6.9775 | 7689472.0 |
| 2007-12-11 10:35:00 | AAPL | Stock | 6.9775 | 6.9946 | 6.9768 | 6.9918 | 12583228.0 |
| 2007-12-11 10:40:00 | AAPL | Stock | 6.9907 | 6.9916 | 6.9754 | 6.9782 | 8458128.0 |
| 2007-12-11 10:45:00 | AAPL | Stock | 6.9771 | 6.9839 | 6.9714 | 6.9782 | 9946300.0 |
| 2007-12-11 10:50:00 | AAPL | Stock | 6.9775 | 6.9845 | 6.9761 | 6.9832 | 6200124.0 |
| 2007-12-11 10:55:00 | AAPL | Stock | 6.9821 | 6.9961 | 6.9811 | 6.9936 | 10807356.0 |
| 2007-12-11 11:00:00 | AAPL | Stock | 6.9936 | 7.0036 | 6.9918 | 6.9986 | 16461732.0 |
| 2007-12-11 11:05:00 | AAPL | Stock | 6.9989 | 7.0139 | 6.9986 | 7.0096 | 13560036.0 |
| 2007-12-11 11:10:00 | AAPL | Stock | 7.0104 | 7.0296 | 7.0093 | 7.0212 | 19086144.0 |
| 2007-12-11 11:15:00 | AAPL | Stock | 7.0221 | 7.0221 | 7.0093 | 7.0164 | 11836776.0 |
| 2007-12-11 11:20:00 | AAPL | Stock | 7.0161 | 7.0214 | 7.0111 | 7.0209 | 7531916.0 |
| 2007-12-11 11:25:00 | AAPL | Stock | 7.0204 | 7.0282 | 7.0154 | 7.0261 | 8554700.0 |
| 2007-12-11 11:30:00 | AAPL | Stock | 7.0257 | 7.0271 | 7.0054 | 7.0061 | 11061736.0 |
> showing 50 of 320,498 rows — these rows as CSV