PREVIEW / stock_5min / 2013-06-21
file: by_date/stock_5min/2013/2013-06-21.parquet size: 5.5 MB rows: 364,673 symbols: 3,518
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-21 05:50:00 | AAPL | Stock | 14.9707 | 14.9707 | 14.9707 | 14.9707 | 11200.0 |
| 2013-06-21 05:55:00 | AAPL | Stock | 14.9675 | 14.9675 | 14.9675 | 14.9675 | 5600.0 |
| 2013-06-21 06:50:00 | AAPL | Stock | 14.9714 | 14.9718 | 14.9714 | 14.9714 | 22372.0 |
| 2013-06-21 07:00:00 | AAPL | Stock | 14.9643 | 14.9796 | 14.9643 | 14.9679 | 40404.0 |
| 2013-06-21 07:05:00 | AAPL | Stock | 14.9732 | 14.9782 | 14.9686 | 14.9686 | 21280.0 |
| 2013-06-21 07:15:00 | AAPL | Stock | 14.9643 | 14.9679 | 14.9643 | 14.9643 | 19600.0 |
| 2013-06-21 07:20:00 | AAPL | Stock | 14.9643 | 14.9643 | 14.9436 | 14.9436 | 23296.0 |
| 2013-06-21 07:25:00 | AAPL | Stock | 14.9607 | 14.9643 | 14.9607 | 14.9643 | 5600.0 |
| 2013-06-21 07:35:00 | AAPL | Stock | 14.9604 | 14.9711 | 14.9518 | 14.9518 | 27020.0 |
| 2013-06-21 07:40:00 | AAPL | Stock | 14.9679 | 14.9732 | 14.9643 | 14.9732 | 22204.0 |
| 2013-06-21 07:45:00 | AAPL | Stock | 14.975 | 14.9811 | 14.975 | 14.975 | 30800.0 |
| 2013-06-21 07:50:00 | AAPL | Stock | 14.9764 | 14.9775 | 14.9757 | 14.9768 | 18200.0 |
| 2013-06-21 07:55:00 | AAPL | Stock | 14.98 | 14.9889 | 14.9789 | 14.9789 | 56560.0 |
| 2013-06-21 08:00:00 | AAPL | Stock | 14.9918 | 14.9946 | 14.8536 | 14.8536 | 279216.0 |
| 2013-06-21 08:05:00 | AAPL | Stock | 14.9882 | 14.9882 | 14.9654 | 14.9654 | 160944.0 |
| 2013-06-21 08:10:00 | AAPL | Stock | 14.9711 | 14.9711 | 14.9607 | 14.9607 | 185780.0 |
| 2013-06-21 08:15:00 | AAPL | Stock | 14.9593 | 14.9607 | 14.9396 | 14.9396 | 267540.0 |
| 2013-06-21 08:20:00 | AAPL | Stock | 14.9496 | 14.9589 | 14.9461 | 14.9468 | 113708.0 |
| 2013-06-21 08:25:00 | AAPL | Stock | 14.9479 | 14.95 | 14.9479 | 14.95 | 28280.0 |
| 2013-06-21 08:30:00 | AAPL | Stock | 14.9464 | 14.9571 | 14.9429 | 14.9571 | 62132.0 |
| 2013-06-21 08:35:00 | AAPL | Stock | 14.9571 | 14.9589 | 14.9496 | 14.955 | 64400.0 |
| 2013-06-21 08:40:00 | AAPL | Stock | 14.88 | 14.9571 | 14.88 | 14.9571 | 628992.0 |
| 2013-06-21 08:45:00 | AAPL | Stock | 14.9536 | 14.9568 | 14.9379 | 14.9379 | 137256.0 |
| 2013-06-21 08:50:00 | AAPL | Stock | 14.9379 | 14.9379 | 14.9179 | 14.9282 | 239092.0 |
| 2013-06-21 08:55:00 | AAPL | Stock | 14.925 | 14.9396 | 14.925 | 14.9286 | 29960.0 |
| 2013-06-21 09:00:00 | AAPL | Stock | 14.93 | 14.9318 | 14.9207 | 14.925 | 191520.0 |
| 2013-06-21 09:05:00 | AAPL | Stock | 14.925 | 14.9464 | 14.9225 | 14.9393 | 199304.0 |
| 2013-06-21 09:10:00 | AAPL | Stock | 14.9446 | 14.9446 | 14.9339 | 14.9393 | 93716.0 |
| 2013-06-21 09:15:00 | AAPL | Stock | 14.9379 | 14.9443 | 14.9329 | 14.9343 | 114828.0 |
| 2013-06-21 09:20:00 | AAPL | Stock | 14.9389 | 14.9429 | 14.9325 | 14.9325 | 50120.0 |
| 2013-06-21 09:25:00 | AAPL | Stock | 14.9357 | 15.0 | 14.9357 | 14.9468 | 1798188.0 |
| 2013-06-21 09:30:00 | AAPL | Stock | 14.9464 | 15.0 | 14.8443 | 14.9068 | 79591148.0 |
| 2013-06-21 09:35:00 | AAPL | Stock | 14.905 | 14.9093 | 14.8654 | 14.8743 | 7517440.0 |
| 2013-06-21 09:40:00 | AAPL | Stock | 14.8696 | 14.8772 | 14.8339 | 14.8468 | 8469804.0 |
| 2013-06-21 09:45:00 | AAPL | Stock | 14.8482 | 14.905 | 14.8457 | 14.8882 | 5767160.0 |
| 2013-06-21 09:50:00 | AAPL | Stock | 14.8929 | 14.9079 | 14.8643 | 14.8704 | 4829300.0 |
| 2013-06-21 09:55:00 | AAPL | Stock | 14.8679 | 14.8857 | 14.7773 | 14.7793 | 9058616.0 |
| 2013-06-21 10:00:00 | AAPL | Stock | 14.7857 | 14.83 | 14.7734 | 14.8121 | 6655908.0 |
| 2013-06-21 10:05:00 | AAPL | Stock | 14.8141 | 14.8214 | 14.7768 | 14.7793 | 4171412.0 |
| 2013-06-21 10:10:00 | AAPL | Stock | 14.7796 | 14.7911 | 14.7589 | 14.7646 | 6427316.0 |
| 2013-06-21 10:15:00 | AAPL | Stock | 14.7657 | 14.7736 | 14.7429 | 14.7539 | 6651092.0 |
| 2013-06-21 10:20:00 | AAPL | Stock | 14.755 | 14.7796 | 14.7489 | 14.773 | 6352108.0 |
| 2013-06-21 10:25:00 | AAPL | Stock | 14.7718 | 14.7893 | 14.7261 | 14.7354 | 6304284.0 |
| 2013-06-21 10:30:00 | AAPL | Stock | 14.7354 | 14.7439 | 14.7065 | 14.71 | 5639452.0 |
| 2013-06-21 10:35:00 | AAPL | Stock | 14.7089 | 14.7139 | 14.6554 | 14.6946 | 11441220.0 |
| 2013-06-21 10:40:00 | AAPL | Stock | 14.6921 | 14.7036 | 14.6618 | 14.6991 | 5679464.0 |
| 2013-06-21 10:45:00 | AAPL | Stock | 14.7014 | 14.7203 | 14.6711 | 14.7203 | 5194196.0 |
| 2013-06-21 10:50:00 | AAPL | Stock | 14.72 | 14.72 | 14.6893 | 14.7086 | 4115384.0 |
| 2013-06-21 10:55:00 | AAPL | Stock | 14.7086 | 14.7129 | 14.6789 | 14.6882 | 3084116.0 |
| 2013-06-21 11:00:00 | AAPL | Stock | 14.6857 | 14.6896 | 14.6304 | 14.6379 | 7541296.0 |
> showing 50 of 364,673 rows — these rows as CSV