PREVIEW / stock_5min / 2013-06-28
file: by_date/stock_5min/2013/2013-06-28.parquet size: 5.4 MB rows: 356,599 symbols: 3,505
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-28 04:30:00 | AAPL | Stock | 14.0696 | 14.0696 | 14.0696 | 14.0696 | 2800.0 |
| 2013-06-28 04:55:00 | AAPL | Stock | 14.0646 | 14.0646 | 14.0646 | 14.0646 | 2800.0 |
| 2013-06-28 05:10:00 | AAPL | Stock | 14.0646 | 14.0646 | 14.0646 | 14.0646 | 19600.0 |
| 2013-06-28 05:35:00 | AAPL | Stock | 14.0696 | 14.0696 | 14.0696 | 14.0696 | 5600.0 |
| 2013-06-28 06:50:00 | AAPL | Stock | 14.0486 | 14.0486 | 14.0486 | 14.0486 | 12320.0 |
| 2013-06-28 07:05:00 | AAPL | Stock | 14.0357 | 14.0636 | 14.0325 | 14.0418 | 28000.0 |
| 2013-06-28 07:15:00 | AAPL | Stock | 14.0636 | 14.0636 | 14.0636 | 14.0636 | 9800.0 |
| 2013-06-28 07:25:00 | AAPL | Stock | 14.0857 | 14.1071 | 14.0857 | 14.1071 | 26040.0 |
| 2013-06-28 07:30:00 | AAPL | Stock | 14.1064 | 14.1071 | 14.1064 | 14.1071 | 5600.0 |
| 2013-06-28 07:35:00 | AAPL | Stock | 14.0825 | 14.0825 | 14.0825 | 14.0825 | 2800.0 |
| 2013-06-28 07:40:00 | AAPL | Stock | 14.0886 | 14.0886 | 14.0886 | 14.0886 | 5600.0 |
| 2013-06-28 07:45:00 | AAPL | Stock | 14.0718 | 14.0982 | 14.0661 | 14.0982 | 67200.0 |
| 2013-06-28 07:50:00 | AAPL | Stock | 14.0996 | 14.1 | 14.0979 | 14.0979 | 11200.0 |
| 2013-06-28 07:55:00 | AAPL | Stock | 14.0996 | 14.1036 | 14.0996 | 14.1036 | 33600.0 |
| 2013-06-28 08:00:00 | AAPL | Stock | 14.0964 | 14.0982 | 14.0325 | 14.0893 | 176120.0 |
| 2013-06-28 08:05:00 | AAPL | Stock | 14.0896 | 14.0907 | 14.0679 | 14.0729 | 81200.0 |
| 2013-06-28 08:10:00 | AAPL | Stock | 14.0646 | 14.0711 | 14.0536 | 14.0536 | 119140.0 |
| 2013-06-28 08:15:00 | AAPL | Stock | 14.0507 | 14.0536 | 14.0214 | 14.0214 | 334320.0 |
| 2013-06-28 08:20:00 | AAPL | Stock | 14.0261 | 14.0357 | 14.0179 | 14.0357 | 56000.0 |
| 2013-06-28 08:25:00 | AAPL | Stock | 14.0357 | 14.0464 | 14.0343 | 14.045 | 24584.0 |
| 2013-06-28 08:30:00 | AAPL | Stock | 14.0421 | 14.0421 | 14.0421 | 14.0421 | 3500.0 |
| 2013-06-28 08:35:00 | AAPL | Stock | 14.0411 | 14.05 | 14.0411 | 14.0464 | 58828.0 |
| 2013-06-28 08:40:00 | AAPL | Stock | 14.0411 | 14.0411 | 14.025 | 14.0289 | 47460.0 |
| 2013-06-28 08:45:00 | AAPL | Stock | 14.0343 | 14.0618 | 14.0343 | 14.0536 | 214788.0 |
| 2013-06-28 08:50:00 | AAPL | Stock | 14.0464 | 14.0464 | 14.0357 | 14.0443 | 49700.0 |
| 2013-06-28 08:55:00 | AAPL | Stock | 14.0475 | 14.0475 | 14.0379 | 14.0379 | 12628.0 |
| 2013-06-28 09:00:00 | AAPL | Stock | 14.0375 | 14.0386 | 14.0246 | 14.0246 | 62076.0 |
| 2013-06-28 09:05:00 | AAPL | Stock | 14.0307 | 14.0393 | 14.0307 | 14.0361 | 61992.0 |
| 2013-06-28 09:10:00 | AAPL | Stock | 14.0357 | 14.0357 | 14.0271 | 14.0321 | 152516.0 |
| 2013-06-28 09:15:00 | AAPL | Stock | 14.0271 | 14.0321 | 14.0214 | 14.0214 | 124068.0 |
| 2013-06-28 09:20:00 | AAPL | Stock | 14.0214 | 14.035 | 14.0207 | 14.0214 | 147560.0 |
| 2013-06-28 09:25:00 | AAPL | Stock | 14.0214 | 14.0225 | 13.9821 | 13.9821 | 505372.0 |
| 2013-06-28 09:30:00 | AAPL | Stock | 13.985 | 14.0 | 13.9286 | 13.9396 | 21090244.0 |
| 2013-06-28 09:35:00 | AAPL | Stock | 13.9429 | 13.9489 | 13.8882 | 13.9297 | 17391220.0 |
| 2013-06-28 09:40:00 | AAPL | Stock | 13.9325 | 13.9707 | 13.91 | 13.9682 | 10301004.0 |
| 2013-06-28 09:45:00 | AAPL | Stock | 13.9721 | 14.0393 | 13.9139 | 13.9843 | 15747536.0 |
| 2013-06-28 09:50:00 | AAPL | Stock | 13.9782 | 13.9835 | 13.9221 | 13.9425 | 6393632.0 |
| 2013-06-28 09:55:00 | AAPL | Stock | 13.9425 | 13.9664 | 13.9125 | 13.9568 | 10003644.0 |
| 2013-06-28 10:00:00 | AAPL | Stock | 13.9643 | 13.9782 | 13.9418 | 13.9514 | 6988828.0 |
| 2013-06-28 10:05:00 | AAPL | Stock | 13.9531 | 13.9889 | 13.9189 | 13.9843 | 7939260.0 |
| 2013-06-28 10:10:00 | AAPL | Stock | 13.9843 | 13.9979 | 13.9626 | 13.9786 | 6217708.0 |
| 2013-06-28 10:15:00 | AAPL | Stock | 13.9786 | 13.9946 | 13.9521 | 13.9871 | 4996432.0 |
| 2013-06-28 10:20:00 | AAPL | Stock | 13.9871 | 14.0075 | 13.9675 | 13.9682 | 4755212.0 |
| 2013-06-28 10:25:00 | AAPL | Stock | 13.9721 | 13.9829 | 13.9454 | 13.9625 | 5383868.0 |
| 2013-06-28 10:30:00 | AAPL | Stock | 13.9596 | 13.9721 | 13.9318 | 13.9336 | 4998364.0 |
| 2013-06-28 10:35:00 | AAPL | Stock | 13.9336 | 13.9836 | 13.9314 | 13.9704 | 5415256.0 |
| 2013-06-28 10:40:00 | AAPL | Stock | 13.9739 | 13.9957 | 13.9686 | 13.9718 | 4369792.0 |
| 2013-06-28 10:45:00 | AAPL | Stock | 13.9682 | 13.9864 | 13.9571 | 13.9864 | 3310160.0 |
| 2013-06-28 10:50:00 | AAPL | Stock | 13.9861 | 14.0071 | 13.9825 | 13.9946 | 5109160.0 |
| 2013-06-28 10:55:00 | AAPL | Stock | 13.9946 | 14.0321 | 13.9918 | 14.0232 | 6973848.0 |
> showing 50 of 356,599 rows — these rows as CSV