PREVIEW / stock_5min / 2007-07-23
file: by_date/stock_5min/2007/2007-07-23.parquet size: 4.0 MB rows: 298,354 symbols: 3,081
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 |
|---|---|---|---|---|---|---|---|
| 2007-07-23 09:30:00 | AAPL | Stock | 5.1182 | 5.1239 | 5.0982 | 5.0993 | 31250296.0 |
| 2007-07-23 09:35:00 | AAPL | Stock | 5.0989 | 5.1044 | 5.0539 | 5.0589 | 35547680.0 |
| 2007-07-23 09:40:00 | AAPL | Stock | 5.0596 | 5.1221 | 5.0571 | 5.0582 | 30832760.0 |
| 2007-07-23 09:45:00 | AAPL | Stock | 5.0586 | 5.1071 | 5.0332 | 5.0529 | 34238932.0 |
| 2007-07-23 09:50:00 | AAPL | Stock | 5.0529 | 5.0604 | 5.05 | 5.0504 | 16007908.0 |
| 2007-07-23 09:55:00 | AAPL | Stock | 5.05 | 5.0721 | 5.0493 | 5.065 | 21208320.0 |
| 2007-07-23 10:00:00 | AAPL | Stock | 5.065 | 5.075 | 5.0636 | 5.0704 | 14714980.0 |
| 2007-07-23 10:05:00 | AAPL | Stock | 5.0707 | 5.0714 | 5.0536 | 5.0561 | 15430996.0 |
| 2007-07-23 10:10:00 | AAPL | Stock | 5.055 | 5.0604 | 5.0532 | 5.0554 | 12215308.0 |
| 2007-07-23 10:15:00 | AAPL | Stock | 5.0554 | 5.0621 | 5.0536 | 5.06 | 9267748.0 |
| 2007-07-23 10:20:00 | AAPL | Stock | 5.0605 | 5.0786 | 5.0596 | 5.0775 | 13132336.0 |
| 2007-07-23 10:25:00 | AAPL | Stock | 5.0779 | 5.0871 | 5.0754 | 5.0789 | 12156508.0 |
| 2007-07-23 10:30:00 | AAPL | Stock | 5.0789 | 5.0961 | 5.0782 | 5.0904 | 16457112.0 |
| 2007-07-23 10:35:00 | AAPL | Stock | 5.0907 | 5.1071 | 5.0893 | 5.1061 | 13872712.0 |
| 2007-07-23 10:40:00 | AAPL | Stock | 5.106 | 5.1179 | 5.1043 | 5.1143 | 25001452.0 |
| 2007-07-23 10:45:00 | AAPL | Stock | 5.1143 | 5.1282 | 5.1082 | 5.1104 | 23015132.0 |
| 2007-07-23 10:50:00 | AAPL | Stock | 5.1107 | 5.1196 | 5.1068 | 5.1168 | 15643712.0 |
| 2007-07-23 10:55:00 | AAPL | Stock | 5.1164 | 5.1375 | 5.1164 | 5.1371 | 24458196.0 |
| 2007-07-23 11:00:00 | AAPL | Stock | 5.1368 | 5.1418 | 5.1361 | 5.1386 | 14747656.0 |
| 2007-07-23 11:05:00 | AAPL | Stock | 5.1382 | 5.1507 | 5.1346 | 5.1432 | 22151696.0 |
| 2007-07-23 11:10:00 | AAPL | Stock | 5.1432 | 5.1482 | 5.1371 | 5.1375 | 16418836.0 |
| 2007-07-23 11:15:00 | AAPL | Stock | 5.1371 | 5.1393 | 5.1296 | 5.1331 | 12182492.0 |
| 2007-07-23 11:20:00 | AAPL | Stock | 5.1332 | 5.1418 | 5.1326 | 5.14 | 11318356.0 |
| 2007-07-23 11:25:00 | AAPL | Stock | 5.1396 | 5.145 | 5.1304 | 5.135 | 12040728.0 |
| 2007-07-23 11:30:00 | AAPL | Stock | 5.135 | 5.1357 | 5.1214 | 5.1275 | 15919204.0 |
| 2007-07-23 11:35:00 | AAPL | Stock | 5.1275 | 5.1386 | 5.1243 | 5.1286 | 10932096.0 |
| 2007-07-23 11:40:00 | AAPL | Stock | 5.1293 | 5.1375 | 5.1269 | 5.1375 | 7162036.0 |
| 2007-07-23 11:45:00 | AAPL | Stock | 5.1375 | 5.1393 | 5.1339 | 5.1368 | 6835416.0 |
| 2007-07-23 11:50:00 | AAPL | Stock | 5.1371 | 5.1446 | 5.1343 | 5.1407 | 9033892.0 |
| 2007-07-23 11:55:00 | AAPL | Stock | 5.1404 | 5.1425 | 5.1346 | 5.1371 | 6221628.0 |
| 2007-07-23 12:00:00 | AAPL | Stock | 5.1368 | 5.1421 | 5.13 | 5.1344 | 11355176.0 |
| 2007-07-23 12:05:00 | AAPL | Stock | 5.1346 | 5.1371 | 5.1318 | 5.1354 | 4107236.0 |
| 2007-07-23 12:10:00 | AAPL | Stock | 5.1346 | 5.1414 | 5.1339 | 5.1389 | 4879952.0 |
| 2007-07-23 12:15:00 | AAPL | Stock | 5.1389 | 5.1407 | 5.1332 | 5.1371 | 3985324.0 |
| 2007-07-23 12:20:00 | AAPL | Stock | 5.137 | 5.15 | 5.1354 | 5.1471 | 10472000.0 |
| 2007-07-23 12:25:00 | AAPL | Stock | 5.1468 | 5.1586 | 5.1468 | 5.1579 | 15132068.0 |
| 2007-07-23 12:30:00 | AAPL | Stock | 5.1579 | 5.1675 | 5.1521 | 5.1639 | 12719280.0 |
| 2007-07-23 12:35:00 | AAPL | Stock | 5.1639 | 5.1786 | 5.1625 | 5.1761 | 17677184.0 |
| 2007-07-23 12:40:00 | AAPL | Stock | 5.1757 | 5.1821 | 5.1743 | 5.1771 | 19921440.0 |
| 2007-07-23 12:45:00 | AAPL | Stock | 5.1775 | 5.1864 | 5.1679 | 5.1846 | 14406504.0 |
| 2007-07-23 12:50:00 | AAPL | Stock | 5.1846 | 5.1854 | 5.1768 | 5.1775 | 12875156.0 |
| 2007-07-23 12:55:00 | AAPL | Stock | 5.1779 | 5.1832 | 5.1757 | 5.18 | 12931436.0 |
| 2007-07-23 13:00:00 | AAPL | Stock | 5.1799 | 5.1821 | 5.1721 | 5.1754 | 12664988.0 |
| 2007-07-23 13:05:00 | AAPL | Stock | 5.1754 | 5.1764 | 5.1621 | 5.1636 | 10944780.0 |
| 2007-07-23 13:10:00 | AAPL | Stock | 5.1632 | 5.1679 | 5.1543 | 5.1629 | 12047336.0 |
| 2007-07-23 13:15:00 | AAPL | Stock | 5.1647 | 5.1671 | 5.1593 | 5.1595 | 5585300.0 |
| 2007-07-23 13:20:00 | AAPL | Stock | 5.1593 | 5.1636 | 5.1518 | 5.1575 | 8773856.0 |
| 2007-07-23 13:25:00 | AAPL | Stock | 5.1575 | 5.1575 | 5.1357 | 5.1411 | 15620752.0 |
| 2007-07-23 13:30:00 | AAPL | Stock | 5.1411 | 5.1475 | 5.1393 | 5.1436 | 7544012.0 |
| 2007-07-23 13:35:00 | AAPL | Stock | 5.1436 | 5.1536 | 5.1429 | 5.1496 | 6959540.0 |
> showing 50 of 298,354 rows — these rows as CSV