PREVIEW / stock_5min / 2010-06-11
file: by_date/stock_5min/2010/2010-06-11.parquet size: 4.6 MB rows: 318,234 symbols: 3,457
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-06-11 05:50:00 | AAPL | Stock | 8.9911 | 8.9911 | 8.9911 | 8.9911 | 2800.0 |
| 2010-06-11 06:05:00 | AAPL | Stock | 8.9821 | 8.9821 | 8.9821 | 8.9821 | 2800.0 |
| 2010-06-11 07:00:00 | AAPL | Stock | 8.9732 | 8.9732 | 8.9732 | 8.9732 | 2800.0 |
| 2010-06-11 07:05:00 | AAPL | Stock | 8.9611 | 8.9732 | 8.9611 | 8.9732 | 8400.0 |
| 2010-06-11 07:20:00 | AAPL | Stock | 8.9482 | 8.9482 | 8.9429 | 8.9461 | 42140.0 |
| 2010-06-11 07:25:00 | AAPL | Stock | 8.94 | 8.94 | 8.94 | 8.94 | 5096.0 |
| 2010-06-11 07:30:00 | AAPL | Stock | 8.9525 | 8.9525 | 8.9525 | 8.9525 | 8400.0 |
| 2010-06-11 07:40:00 | AAPL | Stock | 8.9396 | 8.9396 | 8.9396 | 8.9396 | 2800.0 |
| 2010-06-11 07:50:00 | AAPL | Stock | 8.9464 | 8.9464 | 8.9464 | 8.9464 | 12600.0 |
| 2010-06-11 07:55:00 | AAPL | Stock | 8.9429 | 8.9429 | 8.9429 | 8.9429 | 28000.0 |
| 2010-06-11 08:00:00 | AAPL | Stock | 8.9504 | 8.9618 | 8.9432 | 8.9589 | 131824.0 |
| 2010-06-11 08:05:00 | AAPL | Stock | 8.9521 | 8.9521 | 8.9464 | 8.9518 | 45780.0 |
| 2010-06-11 08:10:00 | AAPL | Stock | 8.9464 | 8.9589 | 8.9464 | 8.9589 | 88032.0 |
| 2010-06-11 08:15:00 | AAPL | Stock | 8.9589 | 8.9604 | 8.9539 | 8.9539 | 65520.0 |
| 2010-06-11 08:20:00 | AAPL | Stock | 8.9554 | 8.9564 | 8.9536 | 8.9554 | 43400.0 |
| 2010-06-11 08:25:00 | AAPL | Stock | 8.9539 | 8.9546 | 8.9482 | 8.9546 | 39200.0 |
| 2010-06-11 08:30:00 | AAPL | Stock | 8.9482 | 8.9482 | 8.87 | 8.8754 | 1739752.0 |
| 2010-06-11 08:35:00 | AAPL | Stock | 8.8759 | 8.8911 | 8.8754 | 8.8793 | 345240.0 |
| 2010-06-11 08:40:00 | AAPL | Stock | 8.8793 | 8.8943 | 8.8736 | 8.8929 | 705684.0 |
| 2010-06-11 08:45:00 | AAPL | Stock | 8.8918 | 8.8921 | 8.8754 | 8.8789 | 255500.0 |
| 2010-06-11 08:50:00 | AAPL | Stock | 8.8768 | 8.8796 | 8.8696 | 8.8707 | 406924.0 |
| 2010-06-11 08:55:00 | AAPL | Stock | 8.87 | 8.8718 | 8.8564 | 8.8589 | 1003492.0 |
| 2010-06-11 09:00:00 | AAPL | Stock | 8.86 | 8.8671 | 8.8521 | 8.8543 | 631428.0 |
| 2010-06-11 09:05:00 | AAPL | Stock | 8.8546 | 8.8554 | 8.8454 | 8.855 | 690396.0 |
| 2010-06-11 09:10:00 | AAPL | Stock | 8.8554 | 8.8636 | 8.8529 | 8.8636 | 356580.0 |
| 2010-06-11 09:15:00 | AAPL | Stock | 8.8636 | 8.865 | 8.8518 | 8.8557 | 338072.0 |
| 2010-06-11 09:20:00 | AAPL | Stock | 8.8554 | 8.8625 | 8.8536 | 8.8607 | 121828.0 |
| 2010-06-11 09:25:00 | AAPL | Stock | 8.8614 | 8.8668 | 8.86 | 8.8632 | 215068.0 |
| 2010-06-11 09:30:00 | AAPL | Stock | 8.8652 | 8.8889 | 8.8486 | 8.8832 | 18780244.0 |
| 2010-06-11 09:35:00 | AAPL | Stock | 8.8829 | 8.8893 | 8.8546 | 8.8571 | 12657400.0 |
| 2010-06-11 09:40:00 | AAPL | Stock | 8.8561 | 8.8818 | 8.8552 | 8.8661 | 8978872.0 |
| 2010-06-11 09:45:00 | AAPL | Stock | 8.8654 | 8.8811 | 8.8346 | 8.8506 | 16110164.0 |
| 2010-06-11 09:50:00 | AAPL | Stock | 8.8511 | 8.8682 | 8.8486 | 8.8607 | 7831684.0 |
| 2010-06-11 09:55:00 | AAPL | Stock | 8.8614 | 8.9107 | 8.8543 | 8.9046 | 19533220.0 |
| 2010-06-11 10:00:00 | AAPL | Stock | 8.9018 | 8.9107 | 8.8896 | 8.8996 | 8900696.0 |
| 2010-06-11 10:05:00 | AAPL | Stock | 8.9007 | 8.9371 | 8.8929 | 8.9229 | 14272188.0 |
| 2010-06-11 10:10:00 | AAPL | Stock | 8.9214 | 8.9404 | 8.9196 | 8.938 | 12815992.0 |
| 2010-06-11 10:15:00 | AAPL | Stock | 8.9364 | 8.9461 | 8.9257 | 8.9429 | 8581216.0 |
| 2010-06-11 10:20:00 | AAPL | Stock | 8.9418 | 8.98 | 8.9293 | 8.956 | 14003192.0 |
| 2010-06-11 10:25:00 | AAPL | Stock | 8.9543 | 8.9618 | 8.9461 | 8.96 | 5108936.0 |
| 2010-06-11 10:30:00 | AAPL | Stock | 8.96 | 8.9711 | 8.935 | 8.9409 | 8614508.0 |
| 2010-06-11 10:35:00 | AAPL | Stock | 8.9446 | 8.9446 | 8.9214 | 8.9269 | 7878976.0 |
| 2010-06-11 10:40:00 | AAPL | Stock | 8.9275 | 8.9504 | 8.9275 | 8.9393 | 4854752.0 |
| 2010-06-11 10:45:00 | AAPL | Stock | 8.9393 | 8.9482 | 8.933 | 8.9436 | 2992556.0 |
| 2010-06-11 10:50:00 | AAPL | Stock | 8.9446 | 8.9479 | 8.9039 | 8.9121 | 8997324.0 |
| 2010-06-11 10:55:00 | AAPL | Stock | 8.9124 | 8.9154 | 8.8968 | 8.9033 | 5510148.0 |
| 2010-06-11 11:00:00 | AAPL | Stock | 8.9057 | 8.9132 | 8.8982 | 8.9068 | 3249512.0 |
| 2010-06-11 11:05:00 | AAPL | Stock | 8.9086 | 8.9086 | 8.8675 | 8.8711 | 9297932.0 |
| 2010-06-11 11:10:00 | AAPL | Stock | 8.8707 | 8.8843 | 8.8593 | 8.8707 | 7448840.0 |
| 2010-06-11 11:15:00 | AAPL | Stock | 8.8701 | 8.8703 | 8.85 | 8.8579 | 9074716.0 |
> showing 50 of 318,234 rows — these rows as CSV