PREVIEW / stock_5min / 2013-10-28
file: by_date/stock_5min/2013/2013-10-28.parquet size: 5.2 MB rows: 344,784 symbols: 3,528
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-10-28 04:00:00 | AAPL | Stock | 18.8518 | 18.8518 | 18.8518 | 18.8518 | 14000.0 |
| 2013-10-28 04:20:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8854 | 18.8854 | 5600.0 |
| 2013-10-28 04:35:00 | AAPL | Stock | 18.9036 | 18.905 | 18.9036 | 18.905 | 5600.0 |
| 2013-10-28 04:40:00 | AAPL | Stock | 18.905 | 18.9196 | 18.905 | 18.9196 | 28000.0 |
| 2013-10-28 04:45:00 | AAPL | Stock | 18.9196 | 18.9196 | 18.9196 | 18.9196 | 5600.0 |
| 2013-10-28 04:50:00 | AAPL | Stock | 18.9268 | 18.9279 | 18.9268 | 18.9279 | 14000.0 |
| 2013-10-28 04:55:00 | AAPL | Stock | 18.9282 | 18.9286 | 18.9268 | 18.9286 | 28168.0 |
| 2013-10-28 05:05:00 | AAPL | Stock | 18.9314 | 18.9429 | 18.9314 | 18.9429 | 5600.0 |
| 2013-10-28 05:10:00 | AAPL | Stock | 18.9411 | 18.9411 | 18.9411 | 18.9411 | 2800.0 |
| 2013-10-28 05:25:00 | AAPL | Stock | 18.9286 | 18.9286 | 18.9214 | 18.9214 | 11200.0 |
| 2013-10-28 05:30:00 | AAPL | Stock | 18.9068 | 18.9286 | 18.9064 | 18.9286 | 28000.0 |
| 2013-10-28 05:40:00 | AAPL | Stock | 18.925 | 18.9286 | 18.925 | 18.9286 | 39900.0 |
| 2013-10-28 05:50:00 | AAPL | Stock | 18.9054 | 18.9286 | 18.9018 | 18.9286 | 25200.0 |
| 2013-10-28 06:00:00 | AAPL | Stock | 18.9268 | 18.9268 | 18.9268 | 18.9268 | 11900.0 |
| 2013-10-28 06:05:00 | AAPL | Stock | 18.9036 | 18.9036 | 18.8696 | 18.8696 | 88200.0 |
| 2013-10-28 06:15:00 | AAPL | Stock | 18.8764 | 18.8764 | 18.875 | 18.875 | 11200.0 |
| 2013-10-28 06:25:00 | AAPL | Stock | 18.8696 | 18.8696 | 18.8571 | 18.8696 | 19600.0 |
| 2013-10-28 06:30:00 | AAPL | Stock | 18.9025 | 18.9025 | 18.8929 | 18.8929 | 19600.0 |
| 2013-10-28 06:40:00 | AAPL | Stock | 18.8989 | 18.8989 | 18.8989 | 18.8989 | 2800.0 |
| 2013-10-28 06:45:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 2800.0 |
| 2013-10-28 06:50:00 | AAPL | Stock | 18.8621 | 18.8968 | 18.8614 | 18.8614 | 32816.0 |
| 2013-10-28 06:55:00 | AAPL | Stock | 18.8618 | 18.8618 | 18.8607 | 18.8607 | 8400.0 |
| 2013-10-28 07:00:00 | AAPL | Stock | 18.8571 | 18.875 | 18.8396 | 18.85 | 95228.0 |
| 2013-10-28 07:05:00 | AAPL | Stock | 18.8411 | 18.8411 | 18.8393 | 18.8396 | 13636.0 |
| 2013-10-28 07:10:00 | AAPL | Stock | 18.8486 | 18.8486 | 18.8486 | 18.8486 | 2800.0 |
| 2013-10-28 07:15:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 8400.0 |
| 2013-10-28 07:20:00 | AAPL | Stock | 18.8643 | 18.8643 | 18.8643 | 18.8643 | 42196.0 |
| 2013-10-28 07:25:00 | AAPL | Stock | 18.8714 | 18.8786 | 18.8607 | 18.8779 | 127288.0 |
| 2013-10-28 07:30:00 | AAPL | Stock | 18.8786 | 18.8893 | 18.8714 | 18.8714 | 36400.0 |
| 2013-10-28 07:35:00 | AAPL | Stock | 18.8714 | 18.8714 | 18.8571 | 18.8571 | 44744.0 |
| 2013-10-28 07:40:00 | AAPL | Stock | 18.8393 | 18.85 | 18.8393 | 18.85 | 17444.0 |
| 2013-10-28 07:45:00 | AAPL | Stock | 18.8532 | 18.8643 | 18.8532 | 18.8571 | 52080.0 |
| 2013-10-28 07:50:00 | AAPL | Stock | 18.8614 | 18.8614 | 18.8607 | 18.8607 | 16800.0 |
| 2013-10-28 07:55:00 | AAPL | Stock | 18.8557 | 18.8814 | 18.8557 | 18.8814 | 82628.0 |
| 2013-10-28 08:00:00 | AAPL | Stock | 18.8807 | 18.8946 | 18.8393 | 18.8568 | 330680.0 |
| 2013-10-28 08:05:00 | AAPL | Stock | 18.8554 | 18.8679 | 18.8489 | 18.8571 | 158228.0 |
| 2013-10-28 08:10:00 | AAPL | Stock | 18.8607 | 18.8661 | 18.8482 | 18.8571 | 130256.0 |
| 2013-10-28 08:15:00 | AAPL | Stock | 18.85 | 18.8536 | 18.8325 | 18.8325 | 173096.0 |
| 2013-10-28 08:20:00 | AAPL | Stock | 18.8482 | 18.8489 | 18.8321 | 18.8321 | 51268.0 |
| 2013-10-28 08:25:00 | AAPL | Stock | 18.8361 | 18.8607 | 18.8325 | 18.8604 | 119140.0 |
| 2013-10-28 08:30:00 | AAPL | Stock | 18.8596 | 18.8646 | 18.8504 | 18.8579 | 108556.0 |
| 2013-10-28 08:35:00 | AAPL | Stock | 18.8596 | 18.8654 | 18.8479 | 18.8639 | 305508.0 |
| 2013-10-28 08:40:00 | AAPL | Stock | 18.8625 | 18.8679 | 18.8589 | 18.8611 | 94584.0 |
| 2013-10-28 08:45:00 | AAPL | Stock | 18.8679 | 18.8768 | 18.8668 | 18.8746 | 102060.0 |
| 2013-10-28 08:50:00 | AAPL | Stock | 18.8739 | 18.8871 | 18.8739 | 18.8789 | 214200.0 |
| 2013-10-28 08:55:00 | AAPL | Stock | 18.8814 | 18.8929 | 18.8789 | 18.8896 | 265776.0 |
| 2013-10-28 09:00:00 | AAPL | Stock | 18.8889 | 18.8929 | 18.8832 | 18.8875 | 213360.0 |
| 2013-10-28 09:05:00 | AAPL | Stock | 18.8868 | 18.8929 | 18.8821 | 18.8925 | 593628.0 |
| 2013-10-28 09:10:00 | AAPL | Stock | 18.8864 | 18.8929 | 18.8821 | 18.8914 | 314860.0 |
| 2013-10-28 09:15:00 | AAPL | Stock | 18.8907 | 18.8911 | 18.8646 | 18.8646 | 112420.0 |
> showing 50 of 344,784 rows — these rows as CSV