PREVIEW / stock_5min / 2014-05-08
file: by_date/stock_5min/2014/2014-05-08.parquet size: 5.5 MB rows: 362,082 symbols: 3,537
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-08 04:05:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0714 | 21.0714 | 2800.0 |
| 2014-05-08 04:10:00 | AAPL | Stock | 21.1089 | 21.1089 | 21.1089 | 21.1089 | 2800.0 |
| 2014-05-08 04:35:00 | AAPL | Stock | 21.1071 | 21.1071 | 21.1071 | 21.1071 | 5600.0 |
| 2014-05-08 04:45:00 | AAPL | Stock | 21.1071 | 21.1071 | 21.1071 | 21.1071 | 2800.0 |
| 2014-05-08 04:50:00 | AAPL | Stock | 21.1107 | 21.1107 | 21.1107 | 21.1107 | 2800.0 |
| 2014-05-08 04:55:00 | AAPL | Stock | 21.1107 | 21.1107 | 21.1107 | 21.1107 | 2800.0 |
| 2014-05-08 05:15:00 | AAPL | Stock | 21.0893 | 21.0893 | 21.0893 | 21.0893 | 8400.0 |
| 2014-05-08 05:30:00 | AAPL | Stock | 21.0721 | 21.0721 | 21.0718 | 21.0718 | 5600.0 |
| 2014-05-08 06:10:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0643 | 21.0643 | 14000.0 |
| 2014-05-08 06:50:00 | AAPL | Stock | 21.0643 | 21.0643 | 21.0643 | 21.0643 | 15428.0 |
| 2014-05-08 06:55:00 | AAPL | Stock | 21.045 | 21.045 | 21.0429 | 21.0429 | 53200.0 |
| 2014-05-08 07:15:00 | AAPL | Stock | 21.0711 | 21.0879 | 21.0711 | 21.0821 | 16800.0 |
| 2014-05-08 07:25:00 | AAPL | Stock | 21.0818 | 21.0818 | 21.0818 | 21.0818 | 2800.0 |
| 2014-05-08 07:30:00 | AAPL | Stock | 21.0714 | 21.0714 | 21.0625 | 21.0625 | 16800.0 |
| 2014-05-08 07:35:00 | AAPL | Stock | 21.055 | 21.0557 | 21.055 | 21.0557 | 16800.0 |
| 2014-05-08 07:40:00 | AAPL | Stock | 21.0446 | 21.0557 | 21.0236 | 21.0357 | 146804.0 |
| 2014-05-08 07:45:00 | AAPL | Stock | 21.0357 | 21.0446 | 21.0193 | 21.0339 | 168700.0 |
| 2014-05-08 07:50:00 | AAPL | Stock | 21.0332 | 21.0443 | 21.0304 | 21.0307 | 80500.0 |
| 2014-05-08 07:55:00 | AAPL | Stock | 21.0446 | 21.0482 | 21.0446 | 21.0446 | 28420.0 |
| 2014-05-08 08:00:00 | AAPL | Stock | 21.0536 | 21.0557 | 21.0368 | 21.0418 | 71204.0 |
| 2014-05-08 08:05:00 | AAPL | Stock | 21.0464 | 21.0464 | 21.0179 | 21.0179 | 108808.0 |
| 2014-05-08 08:10:00 | AAPL | Stock | 21.0189 | 21.0214 | 21.0107 | 21.0214 | 37520.0 |
| 2014-05-08 08:15:00 | AAPL | Stock | 21.0214 | 21.0286 | 21.0132 | 21.0246 | 74200.0 |
| 2014-05-08 08:20:00 | AAPL | Stock | 21.0114 | 21.0179 | 21.0 | 21.0179 | 277200.0 |
| 2014-05-08 08:25:00 | AAPL | Stock | 21.0014 | 21.0071 | 20.9954 | 21.0071 | 219380.0 |
| 2014-05-08 08:30:00 | AAPL | Stock | 20.9964 | 21.0211 | 20.9964 | 21.0211 | 105840.0 |
| 2014-05-08 08:35:00 | AAPL | Stock | 21.0214 | 21.0443 | 21.0071 | 21.0286 | 197960.0 |
| 2014-05-08 08:40:00 | AAPL | Stock | 21.0282 | 21.0339 | 21.0268 | 21.0282 | 153720.0 |
| 2014-05-08 08:45:00 | AAPL | Stock | 21.0189 | 21.0318 | 21.0179 | 21.0318 | 88424.0 |
| 2014-05-08 08:50:00 | AAPL | Stock | 21.0321 | 21.0354 | 21.0232 | 21.0232 | 48524.0 |
| 2014-05-08 08:55:00 | AAPL | Stock | 21.0286 | 21.0357 | 21.0196 | 21.0282 | 94052.0 |
| 2014-05-08 09:00:00 | AAPL | Stock | 21.0304 | 21.0354 | 21.0225 | 21.0346 | 42000.0 |
| 2014-05-08 09:05:00 | AAPL | Stock | 21.0354 | 21.0439 | 21.0354 | 21.0439 | 39480.0 |
| 2014-05-08 09:10:00 | AAPL | Stock | 21.0407 | 21.0407 | 21.0246 | 21.0271 | 53200.0 |
| 2014-05-08 09:15:00 | AAPL | Stock | 21.0279 | 21.0282 | 21.0179 | 21.0179 | 31500.0 |
| 2014-05-08 09:20:00 | AAPL | Stock | 21.0186 | 21.0221 | 21.0179 | 21.0221 | 47740.0 |
| 2014-05-08 09:25:00 | AAPL | Stock | 21.0243 | 21.0404 | 21.0107 | 21.03 | 388080.0 |
| 2014-05-08 09:30:00 | AAPL | Stock | 21.0311 | 21.0714 | 21.0089 | 21.0514 | 6033412.0 |
| 2014-05-08 09:35:00 | AAPL | Stock | 21.0514 | 21.1139 | 21.0386 | 21.0982 | 5429900.0 |
| 2014-05-08 09:40:00 | AAPL | Stock | 21.0954 | 21.1011 | 21.0507 | 21.0814 | 3559752.0 |
| 2014-05-08 09:45:00 | AAPL | Stock | 21.0771 | 21.0925 | 21.0429 | 21.0593 | 3957576.0 |
| 2014-05-08 09:50:00 | AAPL | Stock | 21.0461 | 21.0868 | 21.0461 | 21.0842 | 3282860.0 |
| 2014-05-08 09:55:00 | AAPL | Stock | 21.0818 | 21.1386 | 21.075 | 21.1375 | 4693752.0 |
| 2014-05-08 10:00:00 | AAPL | Stock | 21.1375 | 21.1479 | 21.1236 | 21.1421 | 3726660.0 |
| 2014-05-08 10:05:00 | AAPL | Stock | 21.145 | 21.1489 | 21.1343 | 21.1439 | 2364824.0 |
| 2014-05-08 10:10:00 | AAPL | Stock | 21.145 | 21.1736 | 21.1411 | 21.1582 | 3502324.0 |
| 2014-05-08 10:15:00 | AAPL | Stock | 21.1625 | 21.1768 | 21.1572 | 21.1639 | 2854040.0 |
| 2014-05-08 10:20:00 | AAPL | Stock | 21.1636 | 21.1989 | 21.1621 | 21.1871 | 3548440.0 |
| 2014-05-08 10:25:00 | AAPL | Stock | 21.1868 | 21.1886 | 21.1518 | 21.1704 | 2530920.0 |
| 2014-05-08 10:30:00 | AAPL | Stock | 21.1711 | 21.1736 | 21.1307 | 21.1307 | 2199988.0 |
> showing 50 of 362,082 rows — these rows as CSV