PREVIEW / stock_5min / 2011-03-04
file: by_date/stock_5min/2011/2011-03-04.parquet size: 4.9 MB rows: 330,276 symbols: 3,531
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-03-04 04:10:00 | AAPL | Stock | 12.8571 | 12.8571 | 12.8571 | 12.8571 | 2800.0 |
| 2011-03-04 05:25:00 | AAPL | Stock | 12.9 | 12.9 | 12.9 | 12.9 | 2800.0 |
| 2011-03-04 05:30:00 | AAPL | Stock | 12.9 | 12.9 | 12.9 | 12.9 | 11200.0 |
| 2011-03-04 05:35:00 | AAPL | Stock | 12.9082 | 12.9082 | 12.9082 | 12.9082 | 16100.0 |
| 2011-03-04 06:00:00 | AAPL | Stock | 12.9154 | 12.9154 | 12.9154 | 12.9154 | 5600.0 |
| 2011-03-04 06:25:00 | AAPL | Stock | 12.915 | 12.915 | 12.915 | 12.915 | 2800.0 |
| 2011-03-04 06:35:00 | AAPL | Stock | 12.9154 | 12.9154 | 12.9154 | 12.9154 | 5600.0 |
| 2011-03-04 06:40:00 | AAPL | Stock | 12.9107 | 12.9154 | 12.9107 | 12.9154 | 11200.0 |
| 2011-03-04 06:45:00 | AAPL | Stock | 12.9107 | 12.9107 | 12.9107 | 12.9107 | 2800.0 |
| 2011-03-04 07:00:00 | AAPL | Stock | 12.9018 | 12.9018 | 12.8929 | 12.8929 | 383880.0 |
| 2011-03-04 07:05:00 | AAPL | Stock | 12.8954 | 12.8954 | 12.8929 | 12.8929 | 17976.0 |
| 2011-03-04 07:10:00 | AAPL | Stock | 12.8736 | 12.8746 | 12.8714 | 12.8746 | 56000.0 |
| 2011-03-04 07:15:00 | AAPL | Stock | 12.8821 | 12.8857 | 12.8682 | 12.8857 | 22064.0 |
| 2011-03-04 07:20:00 | AAPL | Stock | 12.8871 | 12.8871 | 12.8871 | 12.8871 | 2800.0 |
| 2011-03-04 07:30:00 | AAPL | Stock | 12.8911 | 12.895 | 12.8911 | 12.8929 | 114800.0 |
| 2011-03-04 07:35:00 | AAPL | Stock | 12.9011 | 12.9011 | 12.8907 | 12.8929 | 21000.0 |
| 2011-03-04 07:40:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8893 | 12.8893 | 60200.0 |
| 2011-03-04 07:45:00 | AAPL | Stock | 12.8843 | 12.8929 | 12.8807 | 12.8929 | 54600.0 |
| 2011-03-04 07:50:00 | AAPL | Stock | 12.8921 | 12.8921 | 12.8921 | 12.8921 | 5600.0 |
| 2011-03-04 07:55:00 | AAPL | Stock | 12.8918 | 12.895 | 12.8918 | 12.895 | 67424.0 |
| 2011-03-04 08:00:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8668 | 12.885 | 325808.0 |
| 2011-03-04 08:05:00 | AAPL | Stock | 12.885 | 12.8925 | 12.8786 | 12.8914 | 649012.0 |
| 2011-03-04 08:10:00 | AAPL | Stock | 12.8914 | 12.9036 | 12.8914 | 12.8993 | 165620.0 |
| 2011-03-04 08:15:00 | AAPL | Stock | 12.9 | 12.9168 | 12.8968 | 12.9114 | 558488.0 |
| 2011-03-04 08:20:00 | AAPL | Stock | 12.9107 | 12.9107 | 12.8979 | 12.8982 | 297724.0 |
| 2011-03-04 08:25:00 | AAPL | Stock | 12.8946 | 12.9071 | 12.8946 | 12.8964 | 279300.0 |
| 2011-03-04 08:30:00 | AAPL | Stock | 12.9036 | 12.9229 | 12.8839 | 12.8968 | 1295728.0 |
| 2011-03-04 08:35:00 | AAPL | Stock | 12.895 | 12.8954 | 12.8689 | 12.8689 | 1087688.0 |
| 2011-03-04 08:40:00 | AAPL | Stock | 12.8689 | 12.89 | 12.8679 | 12.8871 | 343168.0 |
| 2011-03-04 08:45:00 | AAPL | Stock | 12.8879 | 12.8925 | 12.8786 | 12.8925 | 212688.0 |
| 2011-03-04 08:50:00 | AAPL | Stock | 12.89 | 12.89 | 12.8782 | 12.8804 | 200900.0 |
| 2011-03-04 08:55:00 | AAPL | Stock | 12.8786 | 12.8814 | 12.8696 | 12.8736 | 345464.0 |
| 2011-03-04 09:00:00 | AAPL | Stock | 12.8729 | 12.8821 | 12.8718 | 12.8786 | 306236.0 |
| 2011-03-04 09:05:00 | AAPL | Stock | 12.8768 | 12.8821 | 12.8718 | 12.8718 | 105504.0 |
| 2011-03-04 09:10:00 | AAPL | Stock | 12.8718 | 12.875 | 12.8571 | 12.8643 | 446628.0 |
| 2011-03-04 09:15:00 | AAPL | Stock | 12.8639 | 12.8714 | 12.8621 | 12.8714 | 277452.0 |
| 2011-03-04 09:20:00 | AAPL | Stock | 12.8707 | 12.8875 | 12.8679 | 12.8857 | 447328.0 |
| 2011-03-04 09:25:00 | AAPL | Stock | 12.8861 | 12.8879 | 12.8496 | 12.86 | 1197532.0 |
| 2011-03-04 09:30:00 | AAPL | Stock | 12.8596 | 12.8675 | 12.8296 | 12.8432 | 21264152.0 |
| 2011-03-04 09:35:00 | AAPL | Stock | 12.8443 | 12.8461 | 12.8161 | 12.8375 | 13937644.0 |
| 2011-03-04 09:40:00 | AAPL | Stock | 12.8356 | 12.85 | 12.8346 | 12.8371 | 9419060.0 |
| 2011-03-04 09:45:00 | AAPL | Stock | 12.8371 | 12.8568 | 12.8232 | 12.8254 | 14164920.0 |
| 2011-03-04 09:50:00 | AAPL | Stock | 12.8254 | 12.8254 | 12.7989 | 12.8189 | 17532760.0 |
| 2011-03-04 09:55:00 | AAPL | Stock | 12.8189 | 12.8321 | 12.8111 | 12.827 | 7048216.0 |
| 2011-03-04 10:00:00 | AAPL | Stock | 12.8279 | 12.8307 | 12.8143 | 12.8208 | 5697860.0 |
| 2011-03-04 10:05:00 | AAPL | Stock | 12.8193 | 12.8282 | 12.81 | 12.8207 | 8462076.0 |
| 2011-03-04 10:10:00 | AAPL | Stock | 12.8196 | 12.8236 | 12.7896 | 12.8046 | 11461856.0 |
| 2011-03-04 10:15:00 | AAPL | Stock | 12.8043 | 12.8125 | 12.8011 | 12.8082 | 6243216.0 |
| 2011-03-04 10:20:00 | AAPL | Stock | 12.8093 | 12.8118 | 12.7921 | 12.8025 | 7406476.0 |
| 2011-03-04 10:25:00 | AAPL | Stock | 12.8014 | 12.8054 | 12.7796 | 12.8011 | 12149060.0 |
> showing 50 of 330,276 rows — these rows as CSV