PREVIEW / stock_5min / 2008-06-13
file: by_date/stock_5min/2008/2008-06-13.parquet size: 4.3 MB rows: 307,743 symbols: 3,329
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 |
|---|---|---|---|---|---|---|---|
| 2008-06-13 06:20:00 | AAPL | Stock | 6.1221 | 6.1221 | 6.1221 | 6.1221 | 2800.0 |
| 2008-06-13 06:25:00 | AAPL | Stock | 6.1314 | 6.1332 | 6.1314 | 6.1332 | 11200.0 |
| 2008-06-13 06:35:00 | AAPL | Stock | 6.1332 | 6.1375 | 6.1246 | 6.1375 | 25200.0 |
| 2008-06-13 06:40:00 | AAPL | Stock | 6.1368 | 6.1368 | 6.1329 | 6.1329 | 5600.0 |
| 2008-06-13 06:55:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 2800.0 |
| 2008-06-13 07:00:00 | AAPL | Stock | 6.1596 | 6.1604 | 6.1596 | 6.1596 | 70252.0 |
| 2008-06-13 07:10:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 27160.0 |
| 2008-06-13 07:20:00 | AAPL | Stock | 6.1396 | 6.1396 | 6.1393 | 6.1393 | 9660.0 |
| 2008-06-13 07:30:00 | AAPL | Stock | 6.1396 | 6.14 | 6.1396 | 6.14 | 11200.0 |
| 2008-06-13 07:35:00 | AAPL | Stock | 6.1396 | 6.1396 | 6.1393 | 6.1393 | 20300.0 |
| 2008-06-13 07:45:00 | AAPL | Stock | 6.1396 | 6.1396 | 6.1396 | 6.1396 | 2800.0 |
| 2008-06-13 07:50:00 | AAPL | Stock | 6.1411 | 6.1464 | 6.1411 | 6.1464 | 36400.0 |
| 2008-06-13 07:55:00 | AAPL | Stock | 6.1475 | 6.1475 | 6.1429 | 6.1464 | 36400.0 |
| 2008-06-13 08:00:00 | AAPL | Stock | 6.1543 | 6.1543 | 6.125 | 6.1286 | 375200.0 |
| 2008-06-13 08:05:00 | AAPL | Stock | 6.1296 | 6.1339 | 6.1146 | 6.1146 | 554428.0 |
| 2008-06-13 08:10:00 | AAPL | Stock | 6.1143 | 6.1321 | 6.1071 | 6.1236 | 267960.0 |
| 2008-06-13 08:15:00 | AAPL | Stock | 6.1268 | 6.1318 | 6.1071 | 6.1236 | 354172.0 |
| 2008-06-13 08:20:00 | AAPL | Stock | 6.1261 | 6.1407 | 6.1232 | 6.1357 | 213024.0 |
| 2008-06-13 08:25:00 | AAPL | Stock | 6.1357 | 6.14 | 6.1271 | 6.1339 | 75936.0 |
| 2008-06-13 08:30:00 | AAPL | Stock | 6.1339 | 6.1875 | 6.1154 | 6.1871 | 1588916.0 |
| 2008-06-13 08:35:00 | AAPL | Stock | 6.1886 | 6.1889 | 6.1646 | 6.1857 | 879844.0 |
| 2008-06-13 08:40:00 | AAPL | Stock | 6.1857 | 6.2082 | 6.1786 | 6.2082 | 1210160.0 |
| 2008-06-13 08:45:00 | AAPL | Stock | 6.2082 | 6.2096 | 6.1839 | 6.1871 | 673120.0 |
| 2008-06-13 08:50:00 | AAPL | Stock | 6.1893 | 6.1907 | 6.185 | 6.1893 | 610988.0 |
| 2008-06-13 08:55:00 | AAPL | Stock | 6.1896 | 6.19 | 6.1643 | 6.1682 | 794836.0 |
| 2008-06-13 09:00:00 | AAPL | Stock | 6.1686 | 6.1836 | 6.1686 | 6.1807 | 350588.0 |
| 2008-06-13 09:05:00 | AAPL | Stock | 6.1796 | 6.1811 | 6.1679 | 6.17 | 517720.0 |
| 2008-06-13 09:10:00 | AAPL | Stock | 6.1704 | 6.1725 | 6.1639 | 6.1686 | 198856.0 |
| 2008-06-13 09:15:00 | AAPL | Stock | 6.1664 | 6.1704 | 6.1629 | 6.1675 | 179200.0 |
| 2008-06-13 09:20:00 | AAPL | Stock | 6.1679 | 6.1679 | 6.1511 | 6.1611 | 443800.0 |
| 2008-06-13 09:25:00 | AAPL | Stock | 6.1546 | 6.1607 | 6.1239 | 6.1321 | 3021340.0 |
| 2008-06-13 09:30:00 | AAPL | Stock | 6.1339 | 6.1704 | 6.0736 | 6.0932 | 39850216.0 |
| 2008-06-13 09:35:00 | AAPL | Stock | 6.0929 | 6.0946 | 5.9039 | 6.0568 | 97057744.0 |
| 2008-06-13 09:40:00 | AAPL | Stock | 6.0564 | 6.0571 | 5.9664 | 5.9936 | 44361940.0 |
| 2008-06-13 09:45:00 | AAPL | Stock | 5.9939 | 6.0107 | 5.9357 | 5.9643 | 47044648.0 |
| 2008-06-13 09:50:00 | AAPL | Stock | 5.9657 | 6.0268 | 5.9599 | 5.9979 | 38700984.0 |
| 2008-06-13 09:55:00 | AAPL | Stock | 5.9982 | 6.0579 | 5.9721 | 6.0536 | 37125032.0 |
| 2008-06-13 10:00:00 | AAPL | Stock | 6.0521 | 6.0854 | 6.0375 | 6.0771 | 37206792.0 |
| 2008-06-13 10:05:00 | AAPL | Stock | 6.0771 | 6.0929 | 6.0357 | 6.071 | 30922360.0 |
| 2008-06-13 10:10:00 | AAPL | Stock | 6.0704 | 6.0743 | 6.0179 | 6.0296 | 25235280.0 |
| 2008-06-13 10:15:00 | AAPL | Stock | 6.0304 | 6.0829 | 6.0296 | 6.0756 | 25786012.0 |
| 2008-06-13 10:20:00 | AAPL | Stock | 6.076 | 6.1296 | 6.0753 | 6.1275 | 33284216.0 |
| 2008-06-13 10:25:00 | AAPL | Stock | 6.1278 | 6.1732 | 6.1196 | 6.1318 | 41552112.0 |
| 2008-06-13 10:30:00 | AAPL | Stock | 6.1318 | 6.145 | 6.0982 | 6.1345 | 24993388.0 |
| 2008-06-13 10:35:00 | AAPL | Stock | 6.1346 | 6.1389 | 6.1039 | 6.1039 | 17372908.0 |
| 2008-06-13 10:40:00 | AAPL | Stock | 6.1036 | 6.1175 | 6.0857 | 6.1161 | 20079108.0 |
| 2008-06-13 10:45:00 | AAPL | Stock | 6.1157 | 6.1314 | 6.1054 | 6.1223 | 16056992.0 |
| 2008-06-13 10:50:00 | AAPL | Stock | 6.1214 | 6.1464 | 6.1161 | 6.145 | 14986944.0 |
| 2008-06-13 10:55:00 | AAPL | Stock | 6.1436 | 6.1639 | 6.125 | 6.1539 | 19373032.0 |
| 2008-06-13 11:00:00 | AAPL | Stock | 6.1549 | 6.1964 | 6.1549 | 6.1596 | 31764880.0 |
> showing 50 of 307,743 rows — these rows as CSV