PREVIEW / stock_5min / 2013-10-18
file: by_date/stock_5min/2013/2013-10-18.parquet size: 5.4 MB rows: 354,670 symbols: 3,540
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-10-18 04:00:00 | AAPL | Stock | 18.0839 | 18.1071 | 18.0839 | 18.1071 | 19600.0 |
| 2013-10-18 04:10:00 | AAPL | Stock | 18.1125 | 18.1304 | 18.1125 | 18.1304 | 33600.0 |
| 2013-10-18 04:15:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 11200.0 |
| 2013-10-18 04:20:00 | AAPL | Stock | 18.1357 | 18.1357 | 18.1357 | 18.1357 | 8400.0 |
| 2013-10-18 04:25:00 | AAPL | Stock | 18.1393 | 18.1393 | 18.1393 | 18.1393 | 2800.0 |
| 2013-10-18 04:30:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.1429 | 18.1429 | 6440.0 |
| 2013-10-18 04:35:00 | AAPL | Stock | 18.1357 | 18.1357 | 18.1357 | 18.1357 | 2800.0 |
| 2013-10-18 04:45:00 | AAPL | Stock | 18.1357 | 18.1357 | 18.1357 | 18.1357 | 2800.0 |
| 2013-10-18 04:55:00 | AAPL | Stock | 18.1429 | 18.1429 | 18.125 | 18.125 | 23968.0 |
| 2013-10-18 05:00:00 | AAPL | Stock | 18.1357 | 18.1393 | 18.1357 | 18.1393 | 19600.0 |
| 2013-10-18 05:10:00 | AAPL | Stock | 18.1286 | 18.1286 | 18.125 | 18.125 | 75376.0 |
| 2013-10-18 05:20:00 | AAPL | Stock | 18.125 | 18.125 | 18.125 | 18.125 | 2800.0 |
| 2013-10-18 05:25:00 | AAPL | Stock | 18.125 | 18.125 | 18.125 | 18.125 | 5600.0 |
| 2013-10-18 05:30:00 | AAPL | Stock | 18.1125 | 18.1125 | 18.1125 | 18.1125 | 2800.0 |
| 2013-10-18 05:35:00 | AAPL | Stock | 18.1021 | 18.1021 | 18.1021 | 18.1021 | 5600.0 |
| 2013-10-18 05:45:00 | AAPL | Stock | 18.1125 | 18.1125 | 18.1125 | 18.1125 | 11200.0 |
| 2013-10-18 05:50:00 | AAPL | Stock | 18.1021 | 18.1021 | 18.1021 | 18.1021 | 2800.0 |
| 2013-10-18 05:55:00 | AAPL | Stock | 18.0768 | 18.0829 | 18.0768 | 18.0829 | 8400.0 |
| 2013-10-18 06:20:00 | AAPL | Stock | 18.1071 | 18.1143 | 18.1071 | 18.1143 | 20328.0 |
| 2013-10-18 06:25:00 | AAPL | Stock | 18.1071 | 18.1071 | 18.1071 | 18.1071 | 33628.0 |
| 2013-10-18 06:30:00 | AAPL | Stock | 18.0982 | 18.0982 | 18.0982 | 18.0982 | 30688.0 |
| 2013-10-18 06:35:00 | AAPL | Stock | 18.1161 | 18.1161 | 18.1161 | 18.1161 | 2800.0 |
| 2013-10-18 06:40:00 | AAPL | Stock | 18.1071 | 18.1071 | 18.1071 | 18.1071 | 2800.0 |
| 2013-10-18 07:00:00 | AAPL | Stock | 18.1071 | 18.1071 | 18.1071 | 18.1071 | 13440.0 |
| 2013-10-18 07:05:00 | AAPL | Stock | 18.1125 | 18.1321 | 18.1125 | 18.1321 | 65884.0 |
| 2013-10-18 07:10:00 | AAPL | Stock | 18.1329 | 18.1607 | 18.1329 | 18.1604 | 133364.0 |
| 2013-10-18 07:15:00 | AAPL | Stock | 18.145 | 18.145 | 18.125 | 18.125 | 92960.0 |
| 2013-10-18 07:20:00 | AAPL | Stock | 18.125 | 18.125 | 18.125 | 18.125 | 5208.0 |
| 2013-10-18 07:25:00 | AAPL | Stock | 18.125 | 18.1321 | 18.125 | 18.1321 | 30576.0 |
| 2013-10-18 07:30:00 | AAPL | Stock | 18.1321 | 18.1321 | 18.1161 | 18.1179 | 45640.0 |
| 2013-10-18 07:35:00 | AAPL | Stock | 18.1221 | 18.1221 | 18.1214 | 18.1214 | 14000.0 |
| 2013-10-18 07:40:00 | AAPL | Stock | 18.1375 | 18.1375 | 18.125 | 18.1357 | 42000.0 |
| 2013-10-18 07:45:00 | AAPL | Stock | 18.1354 | 18.1354 | 18.1236 | 18.1325 | 37100.0 |
| 2013-10-18 07:50:00 | AAPL | Stock | 18.1339 | 18.1429 | 18.1318 | 18.1339 | 272104.0 |
| 2013-10-18 07:55:00 | AAPL | Stock | 18.1336 | 18.1336 | 18.1268 | 18.1268 | 36428.0 |
| 2013-10-18 08:00:00 | AAPL | Stock | 18.1268 | 18.1607 | 18.0 | 18.1364 | 460348.0 |
| 2013-10-18 08:05:00 | AAPL | Stock | 18.1411 | 18.1429 | 18.125 | 18.1343 | 565404.0 |
| 2013-10-18 08:10:00 | AAPL | Stock | 18.1357 | 18.1643 | 18.1357 | 18.1643 | 548968.0 |
| 2013-10-18 08:15:00 | AAPL | Stock | 18.1607 | 18.1786 | 18.155 | 18.1768 | 441784.0 |
| 2013-10-18 08:20:00 | AAPL | Stock | 18.1764 | 18.1814 | 18.1518 | 18.1643 | 459284.0 |
| 2013-10-18 08:25:00 | AAPL | Stock | 18.1675 | 18.1689 | 18.1432 | 18.1432 | 153384.0 |
| 2013-10-18 08:30:00 | AAPL | Stock | 18.15 | 18.1689 | 18.15 | 18.1643 | 160944.0 |
| 2013-10-18 08:35:00 | AAPL | Stock | 18.1607 | 18.1607 | 18.1536 | 18.1561 | 50596.0 |
| 2013-10-18 08:40:00 | AAPL | Stock | 18.1561 | 18.1732 | 18.1429 | 18.1732 | 251944.0 |
| 2013-10-18 08:45:00 | AAPL | Stock | 18.1729 | 18.1761 | 18.1679 | 18.1679 | 57232.0 |
| 2013-10-18 08:50:00 | AAPL | Stock | 18.1654 | 18.1761 | 18.1643 | 18.1643 | 189140.0 |
| 2013-10-18 08:55:00 | AAPL | Stock | 18.1629 | 18.1629 | 18.1518 | 18.1536 | 140560.0 |
| 2013-10-18 09:00:00 | AAPL | Stock | 18.1536 | 18.1643 | 18.1536 | 18.1571 | 79520.0 |
| 2013-10-18 09:05:00 | AAPL | Stock | 18.1575 | 18.1589 | 18.1539 | 18.1589 | 56000.0 |
| 2013-10-18 09:10:00 | AAPL | Stock | 18.1593 | 18.1593 | 18.1518 | 18.1521 | 139104.0 |
> showing 50 of 354,670 rows — these rows as CSV