PREVIEW / stock_5min / 2011-08-30
file: by_date/stock_5min/2011/2011-08-30.parquet size: 4.8 MB rows: 323,684 symbols: 3,514
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-30 04:30:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8682 | 13.8682 | 5600.0 |
| 2011-08-30 05:10:00 | AAPL | Stock | 13.8789 | 13.8789 | 13.8789 | 13.8789 | 2800.0 |
| 2011-08-30 06:15:00 | AAPL | Stock | 13.8743 | 13.8743 | 13.8661 | 13.8661 | 9240.0 |
| 2011-08-30 06:25:00 | AAPL | Stock | 13.8632 | 13.8661 | 13.8632 | 13.8661 | 5600.0 |
| 2011-08-30 06:45:00 | AAPL | Stock | 13.8661 | 13.8661 | 13.8661 | 13.8661 | 14336.0 |
| 2011-08-30 06:50:00 | AAPL | Stock | 13.8871 | 13.8871 | 13.8871 | 13.8871 | 2800.0 |
| 2011-08-30 07:00:00 | AAPL | Stock | 13.8918 | 13.8929 | 13.8918 | 13.8929 | 13860.0 |
| 2011-08-30 07:05:00 | AAPL | Stock | 13.8929 | 13.8929 | 13.8929 | 13.8929 | 2800.0 |
| 2011-08-30 07:10:00 | AAPL | Stock | 13.8854 | 13.8929 | 13.8725 | 13.8929 | 63196.0 |
| 2011-08-30 07:20:00 | AAPL | Stock | 13.8754 | 13.8754 | 13.875 | 13.875 | 14000.0 |
| 2011-08-30 07:30:00 | AAPL | Stock | 13.8804 | 13.8889 | 13.8804 | 13.8889 | 9240.0 |
| 2011-08-30 07:35:00 | AAPL | Stock | 13.8736 | 13.8736 | 13.8714 | 13.8714 | 15960.0 |
| 2011-08-30 07:45:00 | AAPL | Stock | 13.8821 | 13.8875 | 13.8789 | 13.8875 | 16800.0 |
| 2011-08-30 07:50:00 | AAPL | Stock | 13.8725 | 13.8725 | 13.8664 | 13.8664 | 24416.0 |
| 2011-08-30 07:55:00 | AAPL | Stock | 13.8686 | 13.8786 | 13.8686 | 13.8761 | 20356.0 |
| 2011-08-30 08:00:00 | AAPL | Stock | 13.8875 | 13.8875 | 13.8614 | 13.875 | 245728.0 |
| 2011-08-30 08:05:00 | AAPL | Stock | 13.875 | 13.875 | 13.8518 | 13.8536 | 244972.0 |
| 2011-08-30 08:10:00 | AAPL | Stock | 13.8532 | 13.8571 | 13.8518 | 13.8518 | 355880.0 |
| 2011-08-30 08:15:00 | AAPL | Stock | 13.8564 | 13.8714 | 13.8564 | 13.8661 | 78092.0 |
| 2011-08-30 08:20:00 | AAPL | Stock | 13.8625 | 13.8625 | 13.8482 | 13.8604 | 113316.0 |
| 2011-08-30 08:25:00 | AAPL | Stock | 13.8607 | 13.875 | 13.8571 | 13.8571 | 130900.0 |
| 2011-08-30 08:30:00 | AAPL | Stock | 13.8568 | 13.8568 | 13.8393 | 13.8393 | 217840.0 |
| 2011-08-30 08:35:00 | AAPL | Stock | 13.8321 | 13.8432 | 13.8229 | 13.8389 | 317352.0 |
| 2011-08-30 08:40:00 | AAPL | Stock | 13.845 | 13.8475 | 13.8282 | 13.8293 | 191296.0 |
| 2011-08-30 08:45:00 | AAPL | Stock | 13.8321 | 13.8357 | 13.8236 | 13.825 | 101612.0 |
| 2011-08-30 08:50:00 | AAPL | Stock | 13.8261 | 13.8357 | 13.825 | 13.835 | 137340.0 |
| 2011-08-30 08:55:00 | AAPL | Stock | 13.8307 | 13.8314 | 13.8164 | 13.8246 | 257068.0 |
| 2011-08-30 09:00:00 | AAPL | Stock | 13.8282 | 13.8393 | 13.8236 | 13.8339 | 235704.0 |
| 2011-08-30 09:05:00 | AAPL | Stock | 13.8386 | 13.8411 | 13.8343 | 13.8389 | 123200.0 |
| 2011-08-30 09:10:00 | AAPL | Stock | 13.8389 | 13.8414 | 13.8314 | 13.8414 | 411656.0 |
| 2011-08-30 09:15:00 | AAPL | Stock | 13.8482 | 13.8493 | 13.8414 | 13.8439 | 174160.0 |
| 2011-08-30 09:20:00 | AAPL | Stock | 13.8461 | 13.8654 | 13.8407 | 13.8579 | 266980.0 |
| 2011-08-30 09:25:00 | AAPL | Stock | 13.8579 | 13.8689 | 13.8532 | 13.8643 | 336448.0 |
| 2011-08-30 09:30:00 | AAPL | Stock | 13.8661 | 13.9104 | 13.8239 | 13.8764 | 9244424.0 |
| 2011-08-30 09:35:00 | AAPL | Stock | 13.8807 | 13.9054 | 13.8768 | 13.8807 | 8573488.0 |
| 2011-08-30 09:40:00 | AAPL | Stock | 13.8807 | 13.8861 | 13.8589 | 13.8727 | 4884404.0 |
| 2011-08-30 09:45:00 | AAPL | Stock | 13.8738 | 13.9196 | 13.8696 | 13.9104 | 6922300.0 |
| 2011-08-30 09:50:00 | AAPL | Stock | 13.9079 | 13.9204 | 13.8987 | 13.9114 | 5774188.0 |
| 2011-08-30 09:55:00 | AAPL | Stock | 13.9114 | 13.9161 | 13.8911 | 13.8929 | 5045572.0 |
| 2011-08-30 10:00:00 | AAPL | Stock | 13.8886 | 13.9029 | 13.8071 | 13.8079 | 16894108.0 |
| 2011-08-30 10:05:00 | AAPL | Stock | 13.8096 | 13.8518 | 13.7932 | 13.85 | 15162616.0 |
| 2011-08-30 10:10:00 | AAPL | Stock | 13.8496 | 13.8554 | 13.8314 | 13.8471 | 5970748.0 |
| 2011-08-30 10:15:00 | AAPL | Stock | 13.8464 | 13.8554 | 13.8286 | 13.8339 | 5985196.0 |
| 2011-08-30 10:20:00 | AAPL | Stock | 13.8346 | 13.8386 | 13.8147 | 13.8216 | 4660404.0 |
| 2011-08-30 10:25:00 | AAPL | Stock | 13.8225 | 13.88 | 13.8179 | 13.8793 | 7502124.0 |
| 2011-08-30 10:30:00 | AAPL | Stock | 13.8768 | 13.8839 | 13.8586 | 13.8789 | 4894092.0 |
| 2011-08-30 10:35:00 | AAPL | Stock | 13.8779 | 13.881 | 13.8621 | 13.8721 | 3626196.0 |
| 2011-08-30 10:40:00 | AAPL | Stock | 13.8736 | 13.8807 | 13.8593 | 13.8625 | 2950080.0 |
| 2011-08-30 10:45:00 | AAPL | Stock | 13.8627 | 13.8714 | 13.8432 | 13.8505 | 3944640.0 |
| 2011-08-30 10:50:00 | AAPL | Stock | 13.8511 | 13.8714 | 13.8439 | 13.8629 | 3300024.0 |
> showing 50 of 323,684 rows — these rows as CSV