PREVIEW / stock_5min / 2013-02-12
file: by_date/stock_5min/2013/2013-02-12.parquet size: 4.8 MB rows: 322,842 symbols: 3,479
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-02-12 04:25:00 | AAPL | Stock | 17.1246 | 17.1246 | 17.1246 | 17.1246 | 2800.0 |
| 2013-02-12 05:40:00 | AAPL | Stock | 17.1071 | 17.1071 | 17.1071 | 17.1071 | 3612.0 |
| 2013-02-12 05:50:00 | AAPL | Stock | 17.1375 | 17.15 | 17.1375 | 17.15 | 33600.0 |
| 2013-02-12 06:10:00 | AAPL | Stock | 17.1714 | 17.1714 | 17.1714 | 17.1714 | 2800.0 |
| 2013-02-12 06:15:00 | AAPL | Stock | 17.1589 | 17.1589 | 17.1429 | 17.1429 | 14000.0 |
| 2013-02-12 06:20:00 | AAPL | Stock | 17.1482 | 17.1482 | 17.1464 | 17.1464 | 5600.0 |
| 2013-02-12 06:30:00 | AAPL | Stock | 17.1689 | 17.1689 | 17.1689 | 17.1689 | 5600.0 |
| 2013-02-12 06:35:00 | AAPL | Stock | 17.1511 | 17.1511 | 17.1429 | 17.1429 | 29428.0 |
| 2013-02-12 06:40:00 | AAPL | Stock | 17.1304 | 17.1304 | 17.1304 | 17.1304 | 5600.0 |
| 2013-02-12 06:45:00 | AAPL | Stock | 17.1375 | 17.1375 | 17.1371 | 17.1371 | 8400.0 |
| 2013-02-12 06:50:00 | AAPL | Stock | 17.1161 | 17.1161 | 17.1071 | 17.1071 | 22400.0 |
| 2013-02-12 06:55:00 | AAPL | Stock | 17.1071 | 17.1071 | 17.1071 | 17.1071 | 2800.0 |
| 2013-02-12 07:00:00 | AAPL | Stock | 17.0907 | 17.1036 | 17.0893 | 17.1036 | 28000.0 |
| 2013-02-12 07:05:00 | AAPL | Stock | 17.1 | 17.1036 | 17.1 | 17.1036 | 8400.0 |
| 2013-02-12 07:10:00 | AAPL | Stock | 17.1143 | 17.1143 | 17.1143 | 17.1143 | 5600.0 |
| 2013-02-12 07:15:00 | AAPL | Stock | 17.1036 | 17.1036 | 17.1 | 17.1 | 8400.0 |
| 2013-02-12 07:20:00 | AAPL | Stock | 17.0929 | 17.0929 | 17.0893 | 17.0893 | 8400.0 |
| 2013-02-12 07:25:00 | AAPL | Stock | 17.0929 | 17.1064 | 17.0929 | 17.1064 | 6524.0 |
| 2013-02-12 07:30:00 | AAPL | Stock | 17.1071 | 17.1143 | 17.1071 | 17.1143 | 24080.0 |
| 2013-02-12 07:35:00 | AAPL | Stock | 17.1071 | 17.1232 | 17.1071 | 17.1232 | 40264.0 |
| 2013-02-12 07:40:00 | AAPL | Stock | 17.1339 | 17.16 | 17.1321 | 17.1582 | 75684.0 |
| 2013-02-12 07:45:00 | AAPL | Stock | 17.1629 | 17.1664 | 17.1429 | 17.1429 | 163604.0 |
| 2013-02-12 07:50:00 | AAPL | Stock | 17.1361 | 17.1429 | 17.1361 | 17.1429 | 23044.0 |
| 2013-02-12 07:55:00 | AAPL | Stock | 17.1396 | 17.1436 | 17.1396 | 17.1436 | 51800.0 |
| 2013-02-12 08:00:00 | AAPL | Stock | 17.1429 | 17.1607 | 17.0946 | 17.1 | 221676.0 |
| 2013-02-12 08:05:00 | AAPL | Stock | 17.0957 | 17.1039 | 17.0554 | 17.0661 | 188076.0 |
| 2013-02-12 08:10:00 | AAPL | Stock | 17.0536 | 17.0714 | 17.0464 | 17.0643 | 169372.0 |
| 2013-02-12 08:15:00 | AAPL | Stock | 17.0696 | 17.0714 | 17.0571 | 17.0714 | 100940.0 |
| 2013-02-12 08:20:00 | AAPL | Stock | 17.0714 | 17.1232 | 17.0714 | 17.1071 | 160020.0 |
| 2013-02-12 08:25:00 | AAPL | Stock | 17.1 | 17.1071 | 17.0918 | 17.1011 | 85148.0 |
| 2013-02-12 08:30:00 | AAPL | Stock | 17.0996 | 17.1336 | 17.0732 | 17.13 | 113204.0 |
| 2013-02-12 08:35:00 | AAPL | Stock | 17.125 | 17.1357 | 17.1218 | 17.1321 | 131320.0 |
| 2013-02-12 08:40:00 | AAPL | Stock | 17.1332 | 17.1425 | 17.1254 | 17.1264 | 282940.0 |
| 2013-02-12 08:45:00 | AAPL | Stock | 17.1354 | 17.1404 | 17.1143 | 17.1311 | 222852.0 |
| 2013-02-12 08:50:00 | AAPL | Stock | 17.1211 | 17.1264 | 17.12 | 17.125 | 50400.0 |
| 2013-02-12 08:55:00 | AAPL | Stock | 17.1346 | 17.1393 | 17.1207 | 17.1321 | 299796.0 |
| 2013-02-12 09:00:00 | AAPL | Stock | 17.1325 | 17.1325 | 17.1043 | 17.1314 | 432320.0 |
| 2013-02-12 09:05:00 | AAPL | Stock | 17.1343 | 17.1354 | 17.125 | 17.1304 | 182000.0 |
| 2013-02-12 09:10:00 | AAPL | Stock | 17.1329 | 17.1404 | 17.1329 | 17.1396 | 220332.0 |
| 2013-02-12 09:15:00 | AAPL | Stock | 17.14 | 17.1407 | 17.1332 | 17.1336 | 82180.0 |
| 2013-02-12 09:20:00 | AAPL | Stock | 17.1321 | 17.1321 | 17.125 | 17.125 | 59416.0 |
| 2013-02-12 09:25:00 | AAPL | Stock | 17.1214 | 17.1375 | 17.1114 | 17.1264 | 610512.0 |
| 2013-02-12 09:30:00 | AAPL | Stock | 17.1254 | 17.2279 | 17.0807 | 17.1586 | 20997900.0 |
| 2013-02-12 09:35:00 | AAPL | Stock | 17.1554 | 17.1736 | 17.0646 | 17.0769 | 13575100.0 |
| 2013-02-12 09:40:00 | AAPL | Stock | 17.08 | 17.1121 | 17.0611 | 17.0939 | 8017744.0 |
| 2013-02-12 09:45:00 | AAPL | Stock | 17.0961 | 17.0961 | 17.0154 | 17.0243 | 9764888.0 |
| 2013-02-12 09:50:00 | AAPL | Stock | 17.0243 | 17.0582 | 17.0111 | 17.037 | 9219364.0 |
| 2013-02-12 09:55:00 | AAPL | Stock | 17.0352 | 17.0361 | 16.9843 | 16.9893 | 10671080.0 |
| 2013-02-12 10:00:00 | AAPL | Stock | 16.9894 | 17.0454 | 16.9832 | 17.0326 | 9201444.0 |
| 2013-02-12 10:05:00 | AAPL | Stock | 17.03 | 17.05 | 17.0243 | 17.0466 | 4919348.0 |
> showing 50 of 322,842 rows — these rows as CSV