PREVIEW / stock_5min / 2008-03-31
file: by_date/stock_5min/2008/2008-03-31.parquet size: 4.3 MB rows: 311,529 symbols: 3,283
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-03-31 05:10:00 | AAPL | Stock | 5.0993 | 5.0993 | 5.0864 | 5.0864 | 5600.0 |
| 2008-03-31 06:30:00 | AAPL | Stock | 5.0929 | 5.0929 | 5.0929 | 5.0929 | 2800.0 |
| 2008-03-31 06:55:00 | AAPL | Stock | 5.1046 | 5.1046 | 5.1046 | 5.1046 | 2800.0 |
| 2008-03-31 07:00:00 | AAPL | Stock | 5.1125 | 5.1125 | 5.1125 | 5.1125 | 5600.0 |
| 2008-03-31 07:05:00 | AAPL | Stock | 5.1225 | 5.1357 | 5.1225 | 5.125 | 36400.0 |
| 2008-03-31 07:10:00 | AAPL | Stock | 5.1254 | 5.1254 | 5.1171 | 5.1171 | 33600.0 |
| 2008-03-31 07:20:00 | AAPL | Stock | 5.1179 | 5.1232 | 5.1179 | 5.1232 | 10332.0 |
| 2008-03-31 07:25:00 | AAPL | Stock | 5.1246 | 5.1307 | 5.1246 | 5.125 | 38052.0 |
| 2008-03-31 07:30:00 | AAPL | Stock | 5.1232 | 5.1232 | 5.1221 | 5.1232 | 14000.0 |
| 2008-03-31 07:35:00 | AAPL | Stock | 5.1232 | 5.1246 | 5.1232 | 5.1246 | 5600.0 |
| 2008-03-31 07:45:00 | AAPL | Stock | 5.1339 | 5.1339 | 5.1339 | 5.1339 | 33600.0 |
| 2008-03-31 07:50:00 | AAPL | Stock | 5.1343 | 5.1371 | 5.1339 | 5.1371 | 43064.0 |
| 2008-03-31 07:55:00 | AAPL | Stock | 5.1371 | 5.1375 | 5.1371 | 5.1375 | 21532.0 |
| 2008-03-31 08:00:00 | AAPL | Stock | 5.1361 | 5.1429 | 5.1343 | 5.1411 | 482692.0 |
| 2008-03-31 08:05:00 | AAPL | Stock | 5.1421 | 5.1429 | 5.1375 | 5.1375 | 227864.0 |
| 2008-03-31 08:10:00 | AAPL | Stock | 5.1361 | 5.1393 | 5.1361 | 5.1393 | 16296.0 |
| 2008-03-31 08:15:00 | AAPL | Stock | 5.1396 | 5.1421 | 5.1375 | 5.1421 | 192416.0 |
| 2008-03-31 08:20:00 | AAPL | Stock | 5.1407 | 5.1407 | 5.1343 | 5.1357 | 300860.0 |
| 2008-03-31 08:25:00 | AAPL | Stock | 5.1361 | 5.1371 | 5.1357 | 5.1368 | 60872.0 |
| 2008-03-31 08:30:00 | AAPL | Stock | 5.1371 | 5.1375 | 5.125 | 5.125 | 333536.0 |
| 2008-03-31 08:35:00 | AAPL | Stock | 5.125 | 5.1268 | 5.1232 | 5.1243 | 183204.0 |
| 2008-03-31 08:40:00 | AAPL | Stock | 5.1232 | 5.1232 | 5.1107 | 5.1129 | 412216.0 |
| 2008-03-31 08:45:00 | AAPL | Stock | 5.1136 | 5.1136 | 5.1071 | 5.1071 | 189868.0 |
| 2008-03-31 08:50:00 | AAPL | Stock | 5.105 | 5.1186 | 5.105 | 5.1179 | 101192.0 |
| 2008-03-31 08:55:00 | AAPL | Stock | 5.1168 | 5.1214 | 5.1125 | 5.1214 | 62132.0 |
| 2008-03-31 09:00:00 | AAPL | Stock | 5.1143 | 5.1221 | 5.1143 | 5.1179 | 147560.0 |
| 2008-03-31 09:05:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1125 | 5.1161 | 113540.0 |
| 2008-03-31 09:10:00 | AAPL | Stock | 5.1164 | 5.125 | 5.1164 | 5.1196 | 93464.0 |
| 2008-03-31 09:15:00 | AAPL | Stock | 5.1175 | 5.1218 | 5.1129 | 5.1214 | 111132.0 |
| 2008-03-31 09:20:00 | AAPL | Stock | 5.1211 | 5.1232 | 5.1189 | 5.1229 | 70000.0 |
| 2008-03-31 09:25:00 | AAPL | Stock | 5.1221 | 5.1229 | 5.1143 | 5.1143 | 394800.0 |
| 2008-03-31 09:30:00 | AAPL | Stock | 5.1168 | 5.1639 | 5.1136 | 5.1614 | 22581636.0 |
| 2008-03-31 09:35:00 | AAPL | Stock | 5.1618 | 5.1732 | 5.145 | 5.1725 | 17069948.0 |
| 2008-03-31 09:40:00 | AAPL | Stock | 5.1725 | 5.2039 | 5.1657 | 5.1857 | 27118672.0 |
| 2008-03-31 09:45:00 | AAPL | Stock | 5.1857 | 5.1864 | 5.1729 | 5.1804 | 18705652.0 |
| 2008-03-31 09:50:00 | AAPL | Stock | 5.1807 | 5.1925 | 5.1771 | 5.185 | 16366644.0 |
| 2008-03-31 09:55:00 | AAPL | Stock | 5.1846 | 5.1907 | 5.175 | 5.1761 | 12848752.0 |
| 2008-03-31 10:00:00 | AAPL | Stock | 5.1761 | 5.1771 | 5.1536 | 5.1607 | 20443080.0 |
| 2008-03-31 10:05:00 | AAPL | Stock | 5.1607 | 5.1786 | 5.1546 | 5.1611 | 13643560.0 |
| 2008-03-31 10:10:00 | AAPL | Stock | 5.1611 | 5.1657 | 5.1464 | 5.1564 | 10950156.0 |
| 2008-03-31 10:15:00 | AAPL | Stock | 5.1564 | 5.1689 | 5.1489 | 5.1686 | 10280984.0 |
| 2008-03-31 10:20:00 | AAPL | Stock | 5.1686 | 5.1764 | 5.1607 | 5.1636 | 9441348.0 |
| 2008-03-31 10:25:00 | AAPL | Stock | 5.1621 | 5.1679 | 5.1443 | 5.1479 | 10305400.0 |
| 2008-03-31 10:30:00 | AAPL | Stock | 5.1486 | 5.1668 | 5.1457 | 5.1543 | 11039532.0 |
| 2008-03-31 10:35:00 | AAPL | Stock | 5.1543 | 5.1643 | 5.1507 | 5.1539 | 10018120.0 |
| 2008-03-31 10:40:00 | AAPL | Stock | 5.1546 | 5.1546 | 5.1414 | 5.1471 | 9496368.0 |
| 2008-03-31 10:45:00 | AAPL | Stock | 5.1464 | 5.1536 | 5.1411 | 5.1418 | 7979300.0 |
| 2008-03-31 10:50:00 | AAPL | Stock | 5.1421 | 5.1514 | 5.1346 | 5.1371 | 9952796.0 |
| 2008-03-31 10:55:00 | AAPL | Stock | 5.1371 | 5.1689 | 5.1346 | 5.1629 | 13042260.0 |
| 2008-03-31 11:00:00 | AAPL | Stock | 5.1632 | 5.1664 | 5.1479 | 5.1489 | 9387896.0 |
> showing 50 of 311,529 rows — these rows as CSV