PREVIEW / stock_5min / 2011-11-11
file: by_date/stock_5min/2011/2011-11-11.parquet size: 4.7 MB rows: 317,704 symbols: 3,502
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-11 04:00:00 | AAPL | Stock | 13.8393 | 13.8393 | 13.8393 | 13.8393 | 2800.0 |
| 2011-11-11 05:40:00 | AAPL | Stock | 13.8214 | 13.8214 | 13.8214 | 13.8214 | 2800.0 |
| 2011-11-11 06:35:00 | AAPL | Stock | 13.8143 | 13.8143 | 13.8143 | 13.8143 | 2800.0 |
| 2011-11-11 07:00:00 | AAPL | Stock | 13.8107 | 13.8107 | 13.8107 | 13.8107 | 4200.0 |
| 2011-11-11 07:20:00 | AAPL | Stock | 13.8104 | 13.8214 | 13.8104 | 13.8214 | 41748.0 |
| 2011-11-11 07:25:00 | AAPL | Stock | 13.8214 | 13.8214 | 13.8161 | 13.8175 | 16800.0 |
| 2011-11-11 07:30:00 | AAPL | Stock | 13.8214 | 13.83 | 13.8214 | 13.8221 | 81200.0 |
| 2011-11-11 07:35:00 | AAPL | Stock | 13.8179 | 13.8179 | 13.8179 | 13.8179 | 2800.0 |
| 2011-11-11 07:40:00 | AAPL | Stock | 13.8161 | 13.8161 | 13.8161 | 13.8161 | 8400.0 |
| 2011-11-11 07:45:00 | AAPL | Stock | 13.8175 | 13.8214 | 13.8125 | 13.8125 | 47600.0 |
| 2011-11-11 07:50:00 | AAPL | Stock | 13.8104 | 13.8289 | 13.8086 | 13.8289 | 101724.0 |
| 2011-11-11 07:55:00 | AAPL | Stock | 13.83 | 13.8375 | 13.83 | 13.8375 | 99064.0 |
| 2011-11-11 08:00:00 | AAPL | Stock | 13.8375 | 13.85 | 13.7786 | 13.8464 | 277564.0 |
| 2011-11-11 08:05:00 | AAPL | Stock | 13.8496 | 13.8846 | 13.8482 | 13.8786 | 539532.0 |
| 2011-11-11 08:10:00 | AAPL | Stock | 13.8868 | 13.9093 | 13.8714 | 13.8779 | 373492.0 |
| 2011-11-11 08:15:00 | AAPL | Stock | 13.8761 | 13.8839 | 13.8661 | 13.8768 | 257320.0 |
| 2011-11-11 08:20:00 | AAPL | Stock | 13.8743 | 13.8857 | 13.8643 | 13.8857 | 423080.0 |
| 2011-11-11 08:25:00 | AAPL | Stock | 13.8811 | 13.8929 | 13.8804 | 13.8886 | 219324.0 |
| 2011-11-11 08:30:00 | AAPL | Stock | 13.8911 | 13.8979 | 13.8804 | 13.8879 | 227444.0 |
| 2011-11-11 08:35:00 | AAPL | Stock | 13.8811 | 13.8857 | 13.8696 | 13.875 | 281540.0 |
| 2011-11-11 08:40:00 | AAPL | Stock | 13.8804 | 13.8839 | 13.8793 | 13.8839 | 25480.0 |
| 2011-11-11 08:45:00 | AAPL | Stock | 13.8804 | 13.8921 | 13.8804 | 13.885 | 123256.0 |
| 2011-11-11 08:50:00 | AAPL | Stock | 13.885 | 13.8889 | 13.8786 | 13.8786 | 210504.0 |
| 2011-11-11 08:55:00 | AAPL | Stock | 13.8768 | 13.8796 | 13.8682 | 13.8696 | 1030204.0 |
| 2011-11-11 09:00:00 | AAPL | Stock | 13.8664 | 13.8843 | 13.8518 | 13.8714 | 499576.0 |
| 2011-11-11 09:05:00 | AAPL | Stock | 13.8714 | 13.8714 | 13.8536 | 13.8571 | 481012.0 |
| 2011-11-11 09:10:00 | AAPL | Stock | 13.8571 | 13.8661 | 13.8411 | 13.8429 | 1064028.0 |
| 2011-11-11 09:15:00 | AAPL | Stock | 13.8429 | 13.8518 | 13.8164 | 13.8164 | 575148.0 |
| 2011-11-11 09:20:00 | AAPL | Stock | 13.8146 | 13.8186 | 13.8011 | 13.8068 | 1468964.0 |
| 2011-11-11 09:25:00 | AAPL | Stock | 13.8061 | 13.8143 | 13.7964 | 13.8111 | 998676.0 |
| 2011-11-11 09:30:00 | AAPL | Stock | 13.8096 | 13.8129 | 13.725 | 13.7395 | 27047384.0 |
| 2011-11-11 09:35:00 | AAPL | Stock | 13.7357 | 13.7471 | 13.6854 | 13.722 | 19035828.0 |
| 2011-11-11 09:40:00 | AAPL | Stock | 13.7212 | 13.7846 | 13.7161 | 13.7307 | 14449736.0 |
| 2011-11-11 09:45:00 | AAPL | Stock | 13.7332 | 13.7407 | 13.6625 | 13.6639 | 14266812.0 |
| 2011-11-11 09:50:00 | AAPL | Stock | 13.6625 | 13.6632 | 13.5807 | 13.6361 | 31293388.0 |
| 2011-11-11 09:55:00 | AAPL | Stock | 13.635 | 13.6835 | 13.6325 | 13.6414 | 15104320.0 |
| 2011-11-11 10:00:00 | AAPL | Stock | 13.6414 | 13.71 | 13.6357 | 13.7057 | 18408264.0 |
| 2011-11-11 10:05:00 | AAPL | Stock | 13.7086 | 13.7214 | 13.6821 | 13.7071 | 11092088.0 |
| 2011-11-11 10:10:00 | AAPL | Stock | 13.7068 | 13.7304 | 13.6839 | 13.6889 | 13815088.0 |
| 2011-11-11 10:15:00 | AAPL | Stock | 13.6893 | 13.7002 | 13.6793 | 13.6818 | 8479520.0 |
| 2011-11-11 10:20:00 | AAPL | Stock | 13.6821 | 13.6961 | 13.6643 | 13.6804 | 9442916.0 |
| 2011-11-11 10:25:00 | AAPL | Stock | 13.68 | 13.6814 | 13.6157 | 13.6361 | 15291724.0 |
| 2011-11-11 10:30:00 | AAPL | Stock | 13.6368 | 13.6843 | 13.6339 | 13.6768 | 8931552.0 |
| 2011-11-11 10:35:00 | AAPL | Stock | 13.6782 | 13.6821 | 13.62 | 13.625 | 8753248.0 |
| 2011-11-11 10:40:00 | AAPL | Stock | 13.6243 | 13.675 | 13.6214 | 13.6699 | 8727488.0 |
| 2011-11-11 10:45:00 | AAPL | Stock | 13.6702 | 13.6807 | 13.6489 | 13.6596 | 6414548.0 |
| 2011-11-11 10:50:00 | AAPL | Stock | 13.6596 | 13.6629 | 13.6354 | 13.6482 | 5702592.0 |
| 2011-11-11 10:55:00 | AAPL | Stock | 13.6496 | 13.6714 | 13.6379 | 13.6444 | 6457948.0 |
| 2011-11-11 11:00:00 | AAPL | Stock | 13.6461 | 13.6679 | 13.6429 | 13.6496 | 4708592.0 |
| 2011-11-11 11:05:00 | AAPL | Stock | 13.6482 | 13.6664 | 13.6382 | 13.6522 | 4981452.0 |
> showing 50 of 317,704 rows — these rows as CSV