PREVIEW / stock_5min / 2013-09-04
file: by_date/stock_5min/2013/2013-09-04.parquet size: 5.1 MB rows: 342,016 symbols: 3,516
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-09-04 04:00:00 | AAPL | Stock | 17.4464 | 17.4464 | 17.4464 | 17.4464 | 9660.0 |
| 2013-09-04 04:30:00 | AAPL | Stock | 17.4225 | 17.4375 | 17.4171 | 17.4375 | 39200.0 |
| 2013-09-04 05:20:00 | AAPL | Stock | 17.4332 | 17.4332 | 17.4332 | 17.4332 | 2800.0 |
| 2013-09-04 06:00:00 | AAPL | Stock | 17.4607 | 17.4607 | 17.4607 | 17.4607 | 2800.0 |
| 2013-09-04 06:20:00 | AAPL | Stock | 17.4339 | 17.4339 | 17.4125 | 17.4125 | 11200.0 |
| 2013-09-04 06:25:00 | AAPL | Stock | 17.4875 | 17.4875 | 17.4875 | 17.4875 | 2800.0 |
| 2013-09-04 06:35:00 | AAPL | Stock | 17.4871 | 17.4971 | 17.485 | 17.4971 | 25200.0 |
| 2013-09-04 06:40:00 | AAPL | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 2800.0 |
| 2013-09-04 06:45:00 | AAPL | Stock | 17.5125 | 17.5257 | 17.5125 | 17.5257 | 36400.0 |
| 2013-09-04 06:50:00 | AAPL | Stock | 17.5286 | 17.5714 | 17.5286 | 17.5714 | 84000.0 |
| 2013-09-04 06:55:00 | AAPL | Stock | 17.5893 | 17.6071 | 17.5893 | 17.6071 | 69440.0 |
| 2013-09-04 07:00:00 | AAPL | Stock | 17.6071 | 17.6429 | 17.6071 | 17.6429 | 44016.0 |
| 2013-09-04 07:05:00 | AAPL | Stock | 17.6425 | 17.6936 | 17.6425 | 17.6832 | 108416.0 |
| 2013-09-04 07:10:00 | AAPL | Stock | 17.6893 | 17.6954 | 17.6643 | 17.6875 | 183708.0 |
| 2013-09-04 07:15:00 | AAPL | Stock | 17.6843 | 17.6875 | 17.6607 | 17.6671 | 185528.0 |
| 2013-09-04 07:20:00 | AAPL | Stock | 17.6836 | 17.7371 | 17.6836 | 17.7143 | 244608.0 |
| 2013-09-04 07:25:00 | AAPL | Stock | 17.7182 | 17.7475 | 17.7143 | 17.7475 | 260120.0 |
| 2013-09-04 07:30:00 | AAPL | Stock | 17.7336 | 17.7411 | 17.7143 | 17.735 | 177996.0 |
| 2013-09-04 07:35:00 | AAPL | Stock | 17.7357 | 17.78 | 17.7321 | 17.7643 | 190456.0 |
| 2013-09-04 07:40:00 | AAPL | Stock | 17.7739 | 17.8036 | 17.7714 | 17.7864 | 312032.0 |
| 2013-09-04 07:45:00 | AAPL | Stock | 17.7868 | 17.8532 | 17.7861 | 17.8443 | 737492.0 |
| 2013-09-04 07:50:00 | AAPL | Stock | 17.8218 | 17.8393 | 17.8057 | 17.8057 | 135800.0 |
| 2013-09-04 07:55:00 | AAPL | Stock | 17.8161 | 17.8396 | 17.805 | 17.8304 | 482636.0 |
| 2013-09-04 08:00:00 | AAPL | Stock | 17.8225 | 17.8568 | 17.7146 | 17.8393 | 1743056.0 |
| 2013-09-04 08:05:00 | AAPL | Stock | 17.8339 | 17.8364 | 17.8136 | 17.8286 | 681772.0 |
| 2013-09-04 08:10:00 | AAPL | Stock | 17.8321 | 17.8357 | 17.8125 | 17.8125 | 507444.0 |
| 2013-09-04 08:15:00 | AAPL | Stock | 17.8132 | 17.8132 | 17.775 | 17.7929 | 641088.0 |
| 2013-09-04 08:20:00 | AAPL | Stock | 17.7918 | 17.8136 | 17.7918 | 17.8136 | 300608.0 |
| 2013-09-04 08:25:00 | AAPL | Stock | 17.8143 | 17.8236 | 17.8089 | 17.8179 | 246232.0 |
| 2013-09-04 08:30:00 | AAPL | Stock | 17.8204 | 17.8211 | 17.7868 | 17.7879 | 433496.0 |
| 2013-09-04 08:35:00 | AAPL | Stock | 17.7893 | 17.8068 | 17.775 | 17.7964 | 303408.0 |
| 2013-09-04 08:40:00 | AAPL | Stock | 17.8029 | 17.8029 | 17.7857 | 17.7943 | 254184.0 |
| 2013-09-04 08:45:00 | AAPL | Stock | 17.7943 | 17.8268 | 17.7889 | 17.8264 | 445088.0 |
| 2013-09-04 08:50:00 | AAPL | Stock | 17.8214 | 17.8257 | 17.8129 | 17.82 | 448308.0 |
| 2013-09-04 08:55:00 | AAPL | Stock | 17.82 | 17.8371 | 17.8143 | 17.8264 | 485996.0 |
| 2013-09-04 09:00:00 | AAPL | Stock | 17.825 | 17.8571 | 17.8214 | 17.8532 | 861896.0 |
| 2013-09-04 09:05:00 | AAPL | Stock | 17.8568 | 17.8804 | 17.8436 | 17.8739 | 1515668.0 |
| 2013-09-04 09:10:00 | AAPL | Stock | 17.8746 | 17.9375 | 17.87 | 17.9307 | 2161796.0 |
| 2013-09-04 09:15:00 | AAPL | Stock | 17.925 | 17.9275 | 17.8811 | 17.9 | 1409212.0 |
| 2013-09-04 09:20:00 | AAPL | Stock | 17.9 | 17.9179 | 17.8789 | 17.9011 | 1368136.0 |
| 2013-09-04 09:25:00 | AAPL | Stock | 17.895 | 17.9036 | 17.8446 | 17.8564 | 1083572.0 |
| 2013-09-04 09:30:00 | AAPL | Stock | 17.8425 | 17.9371 | 17.8214 | 17.88 | 35148008.0 |
| 2013-09-04 09:35:00 | AAPL | Stock | 17.88 | 17.8853 | 17.7861 | 17.8546 | 19157096.0 |
| 2013-09-04 09:40:00 | AAPL | Stock | 17.8529 | 17.9029 | 17.8379 | 17.8624 | 12847968.0 |
| 2013-09-04 09:45:00 | AAPL | Stock | 17.8627 | 17.8736 | 17.8175 | 17.8464 | 8666616.0 |
| 2013-09-04 09:50:00 | AAPL | Stock | 17.8471 | 17.8639 | 17.8093 | 17.823 | 7862120.0 |
| 2013-09-04 09:55:00 | AAPL | Stock | 17.823 | 17.825 | 17.7618 | 17.78 | 13687240.0 |
| 2013-09-04 10:00:00 | AAPL | Stock | 17.78 | 17.8232 | 17.7714 | 17.8075 | 9218104.0 |
| 2013-09-04 10:05:00 | AAPL | Stock | 17.8075 | 17.8461 | 17.7718 | 17.775 | 8105832.0 |
| 2013-09-04 10:10:00 | AAPL | Stock | 17.7718 | 17.8157 | 17.7664 | 17.8114 | 5178684.0 |
> showing 50 of 342,016 rows — these rows as CSV