PREVIEW / stock_5min / 2012-10-22
file: by_date/stock_5min/2012/2012-10-22.parquet size: 4.7 MB rows: 313,070 symbols: 3,438
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-22 04:00:00 | AAPL | Stock | 21.8571 | 21.8571 | 21.8571 | 21.8571 | 5600.0 |
| 2012-10-22 04:05:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8214 | 21.8214 | 8400.0 |
| 2012-10-22 04:10:00 | AAPL | Stock | 21.8211 | 21.8214 | 21.8211 | 21.8214 | 12488.0 |
| 2012-10-22 04:20:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 5600.0 |
| 2012-10-22 04:30:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 23240.0 |
| 2012-10-22 04:35:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 2800.0 |
| 2012-10-22 04:45:00 | AAPL | Stock | 21.8393 | 21.8482 | 21.8393 | 21.8393 | 15820.0 |
| 2012-10-22 04:50:00 | AAPL | Stock | 21.8393 | 21.8464 | 21.8129 | 21.8214 | 69860.0 |
| 2012-10-22 04:55:00 | AAPL | Stock | 21.8214 | 21.8393 | 21.8214 | 21.8286 | 72660.0 |
| 2012-10-22 05:00:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 86408.0 |
| 2012-10-22 05:05:00 | AAPL | Stock | 21.8214 | 21.8214 | 21.8214 | 21.8214 | 2800.0 |
| 2012-10-22 05:10:00 | AAPL | Stock | 21.8389 | 21.8389 | 21.8389 | 21.8389 | 3108.0 |
| 2012-10-22 05:15:00 | AAPL | Stock | 21.8393 | 21.8571 | 21.8393 | 21.8571 | 19796.0 |
| 2012-10-22 05:20:00 | AAPL | Stock | 21.8746 | 21.875 | 21.8571 | 21.875 | 38640.0 |
| 2012-10-22 05:25:00 | AAPL | Stock | 21.875 | 21.875 | 21.875 | 21.875 | 16800.0 |
| 2012-10-22 05:30:00 | AAPL | Stock | 21.8825 | 21.8839 | 21.8825 | 21.8839 | 7000.0 |
| 2012-10-22 05:35:00 | AAPL | Stock | 21.8925 | 21.8929 | 21.8839 | 21.8929 | 48188.0 |
| 2012-10-22 05:40:00 | AAPL | Stock | 21.8929 | 21.8929 | 21.8839 | 21.8839 | 11200.0 |
| 2012-10-22 05:50:00 | AAPL | Stock | 21.875 | 21.8921 | 21.875 | 21.875 | 14000.0 |
| 2012-10-22 05:55:00 | AAPL | Stock | 21.875 | 21.875 | 21.875 | 21.875 | 22400.0 |
| 2012-10-22 06:00:00 | AAPL | Stock | 21.875 | 21.8786 | 21.8718 | 21.875 | 14168.0 |
| 2012-10-22 06:05:00 | AAPL | Stock | 21.8921 | 21.8921 | 21.8921 | 21.8921 | 14000.0 |
| 2012-10-22 06:10:00 | AAPL | Stock | 21.8839 | 21.8839 | 21.8839 | 21.8839 | 25200.0 |
| 2012-10-22 06:15:00 | AAPL | Stock | 21.8821 | 21.8929 | 21.8821 | 21.8929 | 36260.0 |
| 2012-10-22 06:20:00 | AAPL | Stock | 21.8929 | 21.8929 | 21.8929 | 21.8929 | 13580.0 |
| 2012-10-22 06:25:00 | AAPL | Stock | 21.8929 | 21.8929 | 21.875 | 21.875 | 47572.0 |
| 2012-10-22 06:30:00 | AAPL | Stock | 21.875 | 21.875 | 21.8714 | 21.8714 | 24220.0 |
| 2012-10-22 06:35:00 | AAPL | Stock | 21.8321 | 21.8554 | 21.8321 | 21.8554 | 11200.0 |
| 2012-10-22 06:40:00 | AAPL | Stock | 21.8554 | 21.8554 | 21.8411 | 21.8411 | 5600.0 |
| 2012-10-22 06:45:00 | AAPL | Stock | 21.85 | 21.85 | 21.8304 | 21.8357 | 19600.0 |
| 2012-10-22 06:50:00 | AAPL | Stock | 21.8554 | 21.8554 | 21.8554 | 21.8554 | 5320.0 |
| 2012-10-22 06:55:00 | AAPL | Stock | 21.8393 | 21.8393 | 21.8393 | 21.8393 | 5600.0 |
| 2012-10-22 07:00:00 | AAPL | Stock | 21.85 | 21.8607 | 21.8393 | 21.8607 | 124936.0 |
| 2012-10-22 07:05:00 | AAPL | Stock | 21.8607 | 21.8882 | 21.8607 | 21.8882 | 104300.0 |
| 2012-10-22 07:10:00 | AAPL | Stock | 21.8875 | 21.8893 | 21.8754 | 21.8893 | 50344.0 |
| 2012-10-22 07:15:00 | AAPL | Stock | 21.8886 | 21.9264 | 21.8696 | 21.9043 | 257012.0 |
| 2012-10-22 07:20:00 | AAPL | Stock | 21.9071 | 21.9107 | 21.8929 | 21.8964 | 82292.0 |
| 2012-10-22 07:25:00 | AAPL | Stock | 21.9029 | 21.9325 | 21.9029 | 21.9211 | 133084.0 |
| 2012-10-22 07:30:00 | AAPL | Stock | 21.9143 | 21.9171 | 21.9036 | 21.9036 | 55188.0 |
| 2012-10-22 07:35:00 | AAPL | Stock | 21.9029 | 21.9036 | 21.8839 | 21.8839 | 95900.0 |
| 2012-10-22 07:40:00 | AAPL | Stock | 21.8861 | 21.8929 | 21.8629 | 21.8661 | 53200.0 |
| 2012-10-22 07:45:00 | AAPL | Stock | 21.8714 | 21.875 | 21.8646 | 21.8729 | 22400.0 |
| 2012-10-22 07:50:00 | AAPL | Stock | 21.8714 | 21.8889 | 21.8696 | 21.875 | 111048.0 |
| 2012-10-22 07:55:00 | AAPL | Stock | 21.8743 | 21.8857 | 21.8743 | 21.8857 | 22400.0 |
| 2012-10-22 08:00:00 | AAPL | Stock | 21.8896 | 21.9171 | 21.8421 | 21.9021 | 856072.0 |
| 2012-10-22 08:05:00 | AAPL | Stock | 21.9043 | 21.905 | 21.8768 | 21.905 | 645456.0 |
| 2012-10-22 08:10:00 | AAPL | Stock | 21.905 | 21.9089 | 21.8771 | 21.9057 | 576072.0 |
| 2012-10-22 08:15:00 | AAPL | Stock | 21.9057 | 21.9232 | 21.8996 | 21.8996 | 635600.0 |
| 2012-10-22 08:20:00 | AAPL | Stock | 21.9 | 21.9071 | 21.8786 | 21.9071 | 972384.0 |
| 2012-10-22 08:25:00 | AAPL | Stock | 21.9021 | 21.9239 | 21.9011 | 21.9239 | 424900.0 |
> showing 50 of 313,070 rows — these rows as CSV