PREVIEW / stock_5min / 2013-01-29
file: by_date/stock_5min/2013/2013-01-29.parquet size: 5.0 MB rows: 336,869 symbols: 3,489
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-01-29 04:00:00 | AAPL | Stock | 16.1604 | 16.1786 | 16.1604 | 16.1779 | 98000.0 |
| 2013-01-29 04:05:00 | AAPL | Stock | 16.1679 | 16.1679 | 16.1607 | 16.1607 | 8400.0 |
| 2013-01-29 04:15:00 | AAPL | Stock | 16.1682 | 16.1682 | 16.1429 | 16.1429 | 11200.0 |
| 2013-01-29 04:20:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 2800.0 |
| 2013-01-29 04:25:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1386 | 16.1429 | 16800.0 |
| 2013-01-29 04:30:00 | AAPL | Stock | 16.1429 | 16.1496 | 16.1429 | 16.1496 | 5600.0 |
| 2013-01-29 04:40:00 | AAPL | Stock | 16.1496 | 16.1496 | 16.1496 | 16.1496 | 11200.0 |
| 2013-01-29 04:45:00 | AAPL | Stock | 16.1411 | 16.1411 | 16.1393 | 16.1393 | 5600.0 |
| 2013-01-29 04:50:00 | AAPL | Stock | 16.1382 | 16.1382 | 16.1382 | 16.1382 | 5600.0 |
| 2013-01-29 04:55:00 | AAPL | Stock | 16.1493 | 16.1493 | 16.1493 | 16.1493 | 8400.0 |
| 2013-01-29 05:05:00 | AAPL | Stock | 16.1496 | 16.1496 | 16.1496 | 16.1496 | 2800.0 |
| 2013-01-29 05:10:00 | AAPL | Stock | 16.1371 | 16.1371 | 16.1371 | 16.1371 | 2800.0 |
| 2013-01-29 05:15:00 | AAPL | Stock | 16.1496 | 16.1496 | 16.1493 | 16.1496 | 19600.0 |
| 2013-01-29 05:20:00 | AAPL | Stock | 16.1554 | 16.1604 | 16.1554 | 16.1604 | 16800.0 |
| 2013-01-29 05:25:00 | AAPL | Stock | 16.1643 | 16.1643 | 16.1571 | 16.1571 | 5600.0 |
| 2013-01-29 05:30:00 | AAPL | Stock | 16.1571 | 16.1571 | 16.1571 | 16.1571 | 2800.0 |
| 2013-01-29 05:35:00 | AAPL | Stock | 16.1525 | 16.1525 | 16.1525 | 16.1525 | 2800.0 |
| 2013-01-29 06:00:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 8400.0 |
| 2013-01-29 06:10:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 10640.0 |
| 2013-01-29 06:15:00 | AAPL | Stock | 16.1375 | 16.1375 | 16.1318 | 16.1318 | 16800.0 |
| 2013-01-29 06:20:00 | AAPL | Stock | 16.1368 | 16.1368 | 16.1368 | 16.1368 | 2800.0 |
| 2013-01-29 06:25:00 | AAPL | Stock | 16.1421 | 16.1421 | 16.1421 | 16.1421 | 2800.0 |
| 2013-01-29 06:30:00 | AAPL | Stock | 16.1329 | 16.1329 | 16.1325 | 16.1325 | 8400.0 |
| 2013-01-29 06:35:00 | AAPL | Stock | 16.1368 | 16.1421 | 16.1368 | 16.1421 | 26096.0 |
| 2013-01-29 06:40:00 | AAPL | Stock | 16.1421 | 16.1429 | 16.1411 | 16.1411 | 11200.0 |
| 2013-01-29 06:45:00 | AAPL | Stock | 16.1296 | 16.13 | 16.1096 | 16.1164 | 42000.0 |
| 2013-01-29 06:50:00 | AAPL | Stock | 16.1071 | 16.1164 | 16.1071 | 16.1164 | 10388.0 |
| 2013-01-29 06:55:00 | AAPL | Stock | 16.1207 | 16.1207 | 16.1207 | 16.1207 | 2800.0 |
| 2013-01-29 07:00:00 | AAPL | Stock | 16.1214 | 16.125 | 16.1179 | 16.125 | 30800.0 |
| 2013-01-29 07:05:00 | AAPL | Stock | 16.125 | 16.125 | 16.1036 | 16.1036 | 89432.0 |
| 2013-01-29 07:10:00 | AAPL | Stock | 16.1071 | 16.1075 | 16.1004 | 16.1036 | 82880.0 |
| 2013-01-29 07:15:00 | AAPL | Stock | 16.1071 | 16.1225 | 16.1039 | 16.1225 | 33824.0 |
| 2013-01-29 07:20:00 | AAPL | Stock | 16.1286 | 16.1286 | 16.1243 | 16.1286 | 33600.0 |
| 2013-01-29 07:25:00 | AAPL | Stock | 16.1232 | 16.1232 | 16.1232 | 16.1232 | 3080.0 |
| 2013-01-29 07:30:00 | AAPL | Stock | 16.1232 | 16.1621 | 16.1232 | 16.1571 | 99932.0 |
| 2013-01-29 07:35:00 | AAPL | Stock | 16.1518 | 16.1661 | 16.1518 | 16.1643 | 22400.0 |
| 2013-01-29 07:40:00 | AAPL | Stock | 16.1643 | 16.1643 | 16.1314 | 16.1432 | 36624.0 |
| 2013-01-29 07:45:00 | AAPL | Stock | 16.1429 | 16.1429 | 16.1429 | 16.1429 | 3920.0 |
| 2013-01-29 07:50:00 | AAPL | Stock | 16.1411 | 16.1429 | 16.1343 | 16.1343 | 16800.0 |
| 2013-01-29 07:55:00 | AAPL | Stock | 16.1339 | 16.1339 | 16.1239 | 16.125 | 51324.0 |
| 2013-01-29 08:00:00 | AAPL | Stock | 16.125 | 16.1696 | 16.1036 | 16.1432 | 434392.0 |
| 2013-01-29 08:05:00 | AAPL | Stock | 16.1532 | 16.1732 | 16.1446 | 16.1714 | 239596.0 |
| 2013-01-29 08:10:00 | AAPL | Stock | 16.1718 | 16.1736 | 16.1589 | 16.1589 | 303828.0 |
| 2013-01-29 08:15:00 | AAPL | Stock | 16.1643 | 16.1714 | 16.1607 | 16.1646 | 79884.0 |
| 2013-01-29 08:20:00 | AAPL | Stock | 16.1696 | 16.1736 | 16.1614 | 16.1643 | 253316.0 |
| 2013-01-29 08:25:00 | AAPL | Stock | 16.1707 | 16.2036 | 16.1621 | 16.2011 | 407344.0 |
| 2013-01-29 08:30:00 | AAPL | Stock | 16.1968 | 16.2411 | 16.1789 | 16.2054 | 1328348.0 |
| 2013-01-29 08:35:00 | AAPL | Stock | 16.2054 | 16.2593 | 16.205 | 16.25 | 793436.0 |
| 2013-01-29 08:40:00 | AAPL | Stock | 16.2504 | 16.2507 | 16.2268 | 16.2321 | 559244.0 |
| 2013-01-29 08:45:00 | AAPL | Stock | 16.2243 | 16.2357 | 16.2061 | 16.2321 | 548212.0 |
> showing 50 of 336,869 rows — these rows as CSV