PREVIEW / stock_5min / 2007-07-17
file: by_date/stock_5min/2007/2007-07-17.parquet size: 4.0 MB rows: 297,256 symbols: 3,071
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-07-17 09:30:00 | AAPL | Stock | 4.9393 | 4.9507 | 4.9186 | 4.935 | 20557600.0 |
| 2007-07-17 09:35:00 | AAPL | Stock | 4.935 | 4.9593 | 4.9321 | 4.9425 | 20249264.0 |
| 2007-07-17 09:40:00 | AAPL | Stock | 4.9418 | 4.9493 | 4.9232 | 4.9393 | 20649048.0 |
| 2007-07-17 09:45:00 | AAPL | Stock | 4.9396 | 4.9411 | 4.925 | 4.935 | 13074852.0 |
| 2007-07-17 09:50:00 | AAPL | Stock | 4.935 | 4.9411 | 4.9268 | 4.9293 | 9471364.0 |
| 2007-07-17 09:55:00 | AAPL | Stock | 4.9289 | 4.9346 | 4.9196 | 4.9229 | 13763904.0 |
| 2007-07-17 10:00:00 | AAPL | Stock | 4.9225 | 4.9286 | 4.9161 | 4.9239 | 12356848.0 |
| 2007-07-17 10:05:00 | AAPL | Stock | 4.9246 | 4.9271 | 4.9107 | 4.9232 | 14924364.0 |
| 2007-07-17 10:10:00 | AAPL | Stock | 4.9225 | 4.9321 | 4.92 | 4.9254 | 11623360.0 |
| 2007-07-17 10:15:00 | AAPL | Stock | 4.9254 | 4.9354 | 4.9193 | 4.9336 | 14776580.0 |
| 2007-07-17 10:20:00 | AAPL | Stock | 4.9336 | 4.9396 | 4.9318 | 4.9339 | 11953900.0 |
| 2007-07-17 10:25:00 | AAPL | Stock | 4.9339 | 4.9514 | 4.9329 | 4.9454 | 18866764.0 |
| 2007-07-17 10:30:00 | AAPL | Stock | 4.9454 | 4.9536 | 4.9421 | 4.9518 | 13144404.0 |
| 2007-07-17 10:35:00 | AAPL | Stock | 4.9518 | 4.9554 | 4.9471 | 4.95 | 15511384.0 |
| 2007-07-17 10:40:00 | AAPL | Stock | 4.9496 | 4.9511 | 4.9415 | 4.9457 | 9781576.0 |
| 2007-07-17 10:45:00 | AAPL | Stock | 4.9461 | 4.9543 | 4.9443 | 4.9503 | 8269940.0 |
| 2007-07-17 10:50:00 | AAPL | Stock | 4.95 | 4.9625 | 4.9496 | 4.9625 | 13411692.0 |
| 2007-07-17 10:55:00 | AAPL | Stock | 4.9618 | 4.9689 | 4.9539 | 4.9664 | 18553304.0 |
| 2007-07-17 11:00:00 | AAPL | Stock | 4.9661 | 4.9818 | 4.9661 | 4.9739 | 19303788.0 |
| 2007-07-17 11:05:00 | AAPL | Stock | 4.9736 | 4.9807 | 4.9721 | 4.98 | 13471836.0 |
| 2007-07-17 11:10:00 | AAPL | Stock | 4.9796 | 4.9821 | 4.9718 | 4.9721 | 14161924.0 |
| 2007-07-17 11:15:00 | AAPL | Stock | 4.9725 | 4.9725 | 4.9596 | 4.9657 | 11754708.0 |
| 2007-07-17 11:20:00 | AAPL | Stock | 4.9654 | 4.9657 | 4.9571 | 4.9621 | 10928176.0 |
| 2007-07-17 11:25:00 | AAPL | Stock | 4.9621 | 4.9643 | 4.9582 | 4.9611 | 6612424.0 |
| 2007-07-17 11:30:00 | AAPL | Stock | 4.9611 | 4.9629 | 4.9589 | 4.9618 | 6850536.0 |
| 2007-07-17 11:35:00 | AAPL | Stock | 4.9621 | 4.9664 | 4.9589 | 4.9604 | 8608964.0 |
| 2007-07-17 11:40:00 | AAPL | Stock | 4.96 | 4.9682 | 4.9593 | 4.965 | 6718712.0 |
| 2007-07-17 11:45:00 | AAPL | Stock | 4.965 | 4.9661 | 4.9561 | 4.9579 | 4596956.0 |
| 2007-07-17 11:50:00 | AAPL | Stock | 4.9579 | 4.9632 | 4.9557 | 4.959 | 5658604.0 |
| 2007-07-17 11:55:00 | AAPL | Stock | 4.9586 | 4.9621 | 4.9571 | 4.9614 | 2920120.0 |
| 2007-07-17 12:00:00 | AAPL | Stock | 4.9614 | 4.9632 | 4.9571 | 4.9604 | 4230996.0 |
| 2007-07-17 12:05:00 | AAPL | Stock | 4.9604 | 4.9625 | 4.9568 | 4.96 | 4616696.0 |
| 2007-07-17 12:10:00 | AAPL | Stock | 4.9596 | 4.9611 | 4.9561 | 4.9568 | 3383660.0 |
| 2007-07-17 12:15:00 | AAPL | Stock | 4.9568 | 4.9589 | 4.9521 | 4.9571 | 7869120.0 |
| 2007-07-17 12:20:00 | AAPL | Stock | 4.9568 | 4.96 | 4.95 | 4.9557 | 9960020.0 |
| 2007-07-17 12:25:00 | AAPL | Stock | 4.9557 | 4.9568 | 4.9464 | 4.9532 | 4596564.0 |
| 2007-07-17 12:30:00 | AAPL | Stock | 4.9525 | 4.9571 | 4.9518 | 4.9536 | 6598228.0 |
| 2007-07-17 12:35:00 | AAPL | Stock | 4.9529 | 4.9546 | 4.9493 | 4.9504 | 6284992.0 |
| 2007-07-17 12:40:00 | AAPL | Stock | 4.9504 | 4.9614 | 4.9504 | 4.9575 | 6188952.0 |
| 2007-07-17 12:45:00 | AAPL | Stock | 4.9571 | 4.9636 | 4.9557 | 4.96 | 3848488.0 |
| 2007-07-17 12:50:00 | AAPL | Stock | 4.96 | 4.9643 | 4.9582 | 4.9611 | 4393536.0 |
| 2007-07-17 12:55:00 | AAPL | Stock | 4.9611 | 4.9621 | 4.9582 | 4.9589 | 3199392.0 |
| 2007-07-17 13:00:00 | AAPL | Stock | 4.9593 | 4.9625 | 4.9571 | 4.9607 | 5081076.0 |
| 2007-07-17 13:05:00 | AAPL | Stock | 4.9613 | 4.9614 | 4.9571 | 4.9593 | 3284232.0 |
| 2007-07-17 13:10:00 | AAPL | Stock | 4.9596 | 4.9629 | 4.9593 | 4.9611 | 3777676.0 |
| 2007-07-17 13:15:00 | AAPL | Stock | 4.9611 | 4.9614 | 4.9579 | 4.9604 | 2986340.0 |
| 2007-07-17 13:20:00 | AAPL | Stock | 4.9604 | 4.9607 | 4.9557 | 4.9561 | 3702384.0 |
| 2007-07-17 13:25:00 | AAPL | Stock | 4.9564 | 4.96 | 4.9554 | 4.9589 | 3219328.0 |
| 2007-07-17 13:30:00 | AAPL | Stock | 4.9586 | 4.9607 | 4.9575 | 4.9607 | 2237508.0 |
| 2007-07-17 13:35:00 | AAPL | Stock | 4.9606 | 4.9636 | 4.9596 | 4.9632 | 5380676.0 |
> showing 50 of 297,256 rows — these rows as CSV