PREVIEW / stock_5min / 2013-11-15
file: by_date/stock_5min/2013/2013-11-15.parquet size: 5.3 MB rows: 346,905 symbols: 3,545
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-11-15 04:05:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2013-11-15 04:20:00 | AAPL | Stock | 18.8854 | 18.8854 | 18.8629 | 18.8629 | 5600.0 |
| 2013-11-15 04:25:00 | AAPL | Stock | 18.8571 | 18.8932 | 18.8571 | 18.8932 | 11200.0 |
| 2013-11-15 05:05:00 | AAPL | Stock | 18.8589 | 18.8589 | 18.8589 | 18.8589 | 2800.0 |
| 2013-11-15 05:10:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8457 | 18.8457 | 8400.0 |
| 2013-11-15 05:45:00 | AAPL | Stock | 18.8689 | 18.8689 | 18.8689 | 18.8689 | 2800.0 |
| 2013-11-15 05:50:00 | AAPL | Stock | 18.8807 | 18.8807 | 18.8611 | 18.8611 | 5600.0 |
| 2013-11-15 06:15:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 5600.0 |
| 2013-11-15 06:35:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 5376.0 |
| 2013-11-15 06:50:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 11200.0 |
| 2013-11-15 06:55:00 | AAPL | Stock | 18.8929 | 18.8929 | 18.8929 | 18.8929 | 8288.0 |
| 2013-11-15 07:00:00 | AAPL | Stock | 18.8929 | 18.8932 | 18.8925 | 18.8929 | 74648.0 |
| 2013-11-15 07:05:00 | AAPL | Stock | 18.8936 | 18.9054 | 18.8936 | 18.9054 | 24668.0 |
| 2013-11-15 07:15:00 | AAPL | Stock | 18.9036 | 18.9036 | 18.8929 | 18.8929 | 29400.0 |
| 2013-11-15 07:20:00 | AAPL | Stock | 18.8993 | 18.9036 | 18.8993 | 18.9036 | 27580.0 |
| 2013-11-15 07:30:00 | AAPL | Stock | 18.9036 | 18.9121 | 18.9036 | 18.9104 | 54600.0 |
| 2013-11-15 07:35:00 | AAPL | Stock | 18.9064 | 18.9064 | 18.8839 | 18.8839 | 145684.0 |
| 2013-11-15 07:40:00 | AAPL | Stock | 18.8839 | 18.8839 | 18.8839 | 18.8839 | 21476.0 |
| 2013-11-15 07:45:00 | AAPL | Stock | 18.8761 | 18.8761 | 18.875 | 18.875 | 24304.0 |
| 2013-11-15 07:50:00 | AAPL | Stock | 18.8825 | 18.8839 | 18.8571 | 18.8711 | 61600.0 |
| 2013-11-15 07:55:00 | AAPL | Stock | 18.8679 | 18.8679 | 18.8571 | 18.8571 | 69160.0 |
| 2013-11-15 08:00:00 | AAPL | Stock | 18.875 | 18.9036 | 18.8214 | 18.8404 | 165200.0 |
| 2013-11-15 08:05:00 | AAPL | Stock | 18.8561 | 18.8629 | 18.8389 | 18.8504 | 240240.0 |
| 2013-11-15 08:10:00 | AAPL | Stock | 18.8471 | 18.8536 | 18.8436 | 18.8486 | 123200.0 |
| 2013-11-15 08:15:00 | AAPL | Stock | 18.8489 | 18.8661 | 18.8486 | 18.865 | 98756.0 |
| 2013-11-15 08:20:00 | AAPL | Stock | 18.865 | 18.8679 | 18.8579 | 18.8679 | 52528.0 |
| 2013-11-15 08:25:00 | AAPL | Stock | 18.8743 | 18.8775 | 18.8679 | 18.8696 | 81872.0 |
| 2013-11-15 08:30:00 | AAPL | Stock | 18.8693 | 18.8696 | 18.8586 | 18.8586 | 106988.0 |
| 2013-11-15 08:35:00 | AAPL | Stock | 18.8664 | 18.8664 | 18.85 | 18.8571 | 167580.0 |
| 2013-11-15 08:40:00 | AAPL | Stock | 18.8643 | 18.8643 | 18.8482 | 18.8482 | 33600.0 |
| 2013-11-15 08:45:00 | AAPL | Stock | 18.8432 | 18.8432 | 18.8354 | 18.8354 | 53200.0 |
| 2013-11-15 08:50:00 | AAPL | Stock | 18.8375 | 18.8446 | 18.8375 | 18.8436 | 36400.0 |
| 2013-11-15 08:55:00 | AAPL | Stock | 18.8436 | 18.8482 | 18.8414 | 18.8482 | 92596.0 |
| 2013-11-15 09:00:00 | AAPL | Stock | 18.8482 | 18.8504 | 18.8464 | 18.8504 | 29400.0 |
| 2013-11-15 09:05:00 | AAPL | Stock | 18.8564 | 18.8564 | 18.8564 | 18.8564 | 11200.0 |
| 2013-11-15 09:10:00 | AAPL | Stock | 18.855 | 18.8554 | 18.8493 | 18.8554 | 25900.0 |
| 2013-11-15 09:15:00 | AAPL | Stock | 18.855 | 18.8554 | 18.855 | 18.8554 | 5600.0 |
| 2013-11-15 09:20:00 | AAPL | Stock | 18.8454 | 18.8464 | 18.8321 | 18.8393 | 83300.0 |
| 2013-11-15 09:25:00 | AAPL | Stock | 18.8343 | 18.8443 | 18.7896 | 18.8071 | 669144.0 |
| 2013-11-15 09:30:00 | AAPL | Stock | 18.8071 | 18.8626 | 18.7979 | 18.8536 | 24044580.0 |
| 2013-11-15 09:35:00 | AAPL | Stock | 18.8536 | 18.8536 | 18.78 | 18.7943 | 7170772.0 |
| 2013-11-15 09:40:00 | AAPL | Stock | 18.7914 | 18.8329 | 18.7876 | 18.8007 | 4330676.0 |
| 2013-11-15 09:45:00 | AAPL | Stock | 18.801 | 18.8196 | 18.775 | 18.7814 | 6638884.0 |
| 2013-11-15 09:50:00 | AAPL | Stock | 18.7829 | 18.811 | 18.7739 | 18.7987 | 4559660.0 |
| 2013-11-15 09:55:00 | AAPL | Stock | 18.7989 | 18.8354 | 18.7979 | 18.8232 | 3628716.0 |
| 2013-11-15 10:00:00 | AAPL | Stock | 18.8225 | 18.8714 | 18.8154 | 18.8446 | 7570584.0 |
| 2013-11-15 10:05:00 | AAPL | Stock | 18.8457 | 18.8789 | 18.8386 | 18.8719 | 5437712.0 |
| 2013-11-15 10:10:00 | AAPL | Stock | 18.8725 | 18.8961 | 18.8557 | 18.8857 | 6238736.0 |
| 2013-11-15 10:15:00 | AAPL | Stock | 18.8839 | 18.8914 | 18.8482 | 18.8518 | 3240888.0 |
| 2013-11-15 10:20:00 | AAPL | Stock | 18.8518 | 18.8614 | 18.8368 | 18.8464 | 2882404.0 |
> showing 50 of 346,905 rows — these rows as CSV