PREVIEW / stock_5min / 2011-10-03
file: by_date/stock_5min/2011/2011-10-03.parquet size: 5.1 MB rows: 344,229 symbols: 3,528
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-10-03 04:00:00 | AAPL | Stock | 13.57 | 13.57 | 13.5443 | 13.5493 | 22400.0 |
| 2011-10-03 04:35:00 | AAPL | Stock | 13.6186 | 13.6186 | 13.6186 | 13.6186 | 14000.0 |
| 2011-10-03 04:55:00 | AAPL | Stock | 13.6179 | 13.6179 | 13.6179 | 13.6179 | 9240.0 |
| 2011-10-03 05:00:00 | AAPL | Stock | 13.6179 | 13.6179 | 13.6179 | 13.6179 | 14000.0 |
| 2011-10-03 05:15:00 | AAPL | Stock | 13.5743 | 13.5743 | 13.5743 | 13.5743 | 2800.0 |
| 2011-10-03 05:25:00 | AAPL | Stock | 13.5893 | 13.5893 | 13.5893 | 13.5893 | 2800.0 |
| 2011-10-03 05:30:00 | AAPL | Stock | 13.6036 | 13.6036 | 13.6036 | 13.6036 | 16800.0 |
| 2011-10-03 05:55:00 | AAPL | Stock | 13.5825 | 13.5825 | 13.5825 | 13.5825 | 8400.0 |
| 2011-10-03 06:10:00 | AAPL | Stock | 13.6175 | 13.6175 | 13.6175 | 13.6175 | 2800.0 |
| 2011-10-03 06:20:00 | AAPL | Stock | 13.6175 | 13.6175 | 13.6071 | 13.6071 | 33600.0 |
| 2011-10-03 06:25:00 | AAPL | Stock | 13.6071 | 13.6175 | 13.6071 | 13.6175 | 5600.0 |
| 2011-10-03 06:30:00 | AAPL | Stock | 13.6175 | 13.625 | 13.6175 | 13.625 | 5600.0 |
| 2011-10-03 06:35:00 | AAPL | Stock | 13.6411 | 13.6429 | 13.6411 | 13.6429 | 8400.0 |
| 2011-10-03 06:40:00 | AAPL | Stock | 13.6429 | 13.6429 | 13.6429 | 13.6429 | 2800.0 |
| 2011-10-03 06:45:00 | AAPL | Stock | 13.6429 | 13.6489 | 13.6429 | 13.6489 | 19600.0 |
| 2011-10-03 06:50:00 | AAPL | Stock | 13.6504 | 13.6518 | 13.6504 | 13.6518 | 8400.0 |
| 2011-10-03 06:55:00 | AAPL | Stock | 13.6746 | 13.6746 | 13.6746 | 13.6746 | 2800.0 |
| 2011-10-03 07:00:00 | AAPL | Stock | 13.6643 | 13.6904 | 13.6643 | 13.6786 | 65800.0 |
| 2011-10-03 07:05:00 | AAPL | Stock | 13.675 | 13.6786 | 13.6643 | 13.6646 | 110460.0 |
| 2011-10-03 07:10:00 | AAPL | Stock | 13.6679 | 13.6839 | 13.6679 | 13.6839 | 81480.0 |
| 2011-10-03 07:15:00 | AAPL | Stock | 13.6696 | 13.6696 | 13.6696 | 13.6696 | 8400.0 |
| 2011-10-03 07:20:00 | AAPL | Stock | 13.6696 | 13.6725 | 13.6429 | 13.6693 | 121800.0 |
| 2011-10-03 07:25:00 | AAPL | Stock | 13.6704 | 13.69 | 13.6704 | 13.69 | 43680.0 |
| 2011-10-03 07:30:00 | AAPL | Stock | 13.6921 | 13.71 | 13.6821 | 13.71 | 87612.0 |
| 2011-10-03 07:35:00 | AAPL | Stock | 13.6979 | 13.6979 | 13.6821 | 13.6893 | 193760.0 |
| 2011-10-03 07:40:00 | AAPL | Stock | 13.6861 | 13.6861 | 13.6732 | 13.6786 | 128296.0 |
| 2011-10-03 07:45:00 | AAPL | Stock | 13.6754 | 13.7 | 13.6754 | 13.6861 | 50400.0 |
| 2011-10-03 07:50:00 | AAPL | Stock | 13.6839 | 13.6911 | 13.6821 | 13.6904 | 47600.0 |
| 2011-10-03 07:55:00 | AAPL | Stock | 13.6843 | 13.7125 | 13.6843 | 13.7125 | 132272.0 |
| 2011-10-03 08:00:00 | AAPL | Stock | 13.7107 | 13.7296 | 13.6136 | 13.6925 | 443884.0 |
| 2011-10-03 08:05:00 | AAPL | Stock | 13.6929 | 13.7036 | 13.6786 | 13.6839 | 200928.0 |
| 2011-10-03 08:10:00 | AAPL | Stock | 13.6786 | 13.6875 | 13.6661 | 13.6875 | 198912.0 |
| 2011-10-03 08:15:00 | AAPL | Stock | 13.6875 | 13.6929 | 13.67 | 13.6929 | 436548.0 |
| 2011-10-03 08:20:00 | AAPL | Stock | 13.6907 | 13.6907 | 13.6461 | 13.66 | 301168.0 |
| 2011-10-03 08:25:00 | AAPL | Stock | 13.6607 | 13.6707 | 13.6457 | 13.6493 | 199416.0 |
| 2011-10-03 08:30:00 | AAPL | Stock | 13.6518 | 13.6696 | 13.6518 | 13.6607 | 175840.0 |
| 2011-10-03 08:35:00 | AAPL | Stock | 13.6607 | 13.6643 | 13.6489 | 13.6625 | 43568.0 |
| 2011-10-03 08:40:00 | AAPL | Stock | 13.6643 | 13.6679 | 13.6607 | 13.6643 | 69804.0 |
| 2011-10-03 08:45:00 | AAPL | Stock | 13.6614 | 13.6786 | 13.6507 | 13.6693 | 426804.0 |
| 2011-10-03 08:50:00 | AAPL | Stock | 13.6786 | 13.6786 | 13.6489 | 13.6489 | 92120.0 |
| 2011-10-03 08:55:00 | AAPL | Stock | 13.6536 | 13.6575 | 13.6186 | 13.6575 | 169988.0 |
| 2011-10-03 09:00:00 | AAPL | Stock | 13.6518 | 13.6518 | 13.6314 | 13.6318 | 350252.0 |
| 2011-10-03 09:05:00 | AAPL | Stock | 13.6343 | 13.6421 | 13.6229 | 13.6339 | 437276.0 |
| 2011-10-03 09:10:00 | AAPL | Stock | 13.6271 | 13.6429 | 13.6136 | 13.6429 | 422632.0 |
| 2011-10-03 09:15:00 | AAPL | Stock | 13.6293 | 13.6339 | 13.6286 | 13.6336 | 50540.0 |
| 2011-10-03 09:20:00 | AAPL | Stock | 13.6339 | 13.6339 | 13.6186 | 13.6286 | 427364.0 |
| 2011-10-03 09:25:00 | AAPL | Stock | 13.6136 | 13.6411 | 13.5779 | 13.5839 | 1045128.0 |
| 2011-10-03 09:30:00 | AAPL | Stock | 13.5839 | 13.6318 | 13.5 | 13.5189 | 28320516.0 |
| 2011-10-03 09:35:00 | AAPL | Stock | 13.5204 | 13.6193 | 13.5046 | 13.6089 | 21191744.0 |
| 2011-10-03 09:40:00 | AAPL | Stock | 13.6076 | 13.615 | 13.5236 | 13.545 | 16307368.0 |
> showing 50 of 344,229 rows — these rows as CSV