PREVIEW / stock_5min / 2007-10-22
file: by_date/stock_5min/2007/2007-10-22.parquet size: 4.3 MB rows: 314,516 symbols: 3,157
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-10-22 04:15:00 | AAPL | Stock | 6.0729 | 6.0729 | 6.0729 | 6.0729 | 2800.0 |
| 2007-10-22 04:25:00 | AAPL | Stock | 6.0379 | 6.0379 | 6.0379 | 6.0379 | 2800.0 |
| 2007-10-22 04:45:00 | AAPL | Stock | 6.0536 | 6.0536 | 6.0536 | 6.0536 | 28000.0 |
| 2007-10-22 04:50:00 | AAPL | Stock | 6.0571 | 6.0571 | 6.0536 | 6.0536 | 30800.0 |
| 2007-10-22 04:55:00 | AAPL | Stock | 6.0446 | 6.0446 | 6.0446 | 6.0446 | 22400.0 |
| 2007-10-22 05:05:00 | AAPL | Stock | 6.0714 | 6.0714 | 6.0714 | 6.0714 | 2800.0 |
| 2007-10-22 05:20:00 | AAPL | Stock | 6.0661 | 6.0661 | 6.0625 | 6.0625 | 54600.0 |
| 2007-10-22 05:50:00 | AAPL | Stock | 6.0589 | 6.0589 | 6.0589 | 6.0589 | 26600.0 |
| 2007-10-22 06:00:00 | AAPL | Stock | 6.0586 | 6.0586 | 6.0586 | 6.0586 | 2800.0 |
| 2007-10-22 06:15:00 | AAPL | Stock | 6.0586 | 6.0586 | 6.0586 | 6.0586 | 10556.0 |
| 2007-10-22 06:30:00 | AAPL | Stock | 6.0589 | 6.0589 | 6.0554 | 6.0554 | 33600.0 |
| 2007-10-22 06:40:00 | AAPL | Stock | 6.05 | 6.05 | 6.05 | 6.05 | 28000.0 |
| 2007-10-22 07:00:00 | AAPL | Stock | 6.0446 | 6.0446 | 6.0364 | 6.0396 | 54600.0 |
| 2007-10-22 07:05:00 | AAPL | Stock | 6.0404 | 6.0411 | 6.0396 | 6.0411 | 71400.0 |
| 2007-10-22 07:10:00 | AAPL | Stock | 6.0411 | 6.0411 | 6.0396 | 6.0396 | 55860.0 |
| 2007-10-22 07:15:00 | AAPL | Stock | 6.0396 | 6.0396 | 6.0396 | 6.0396 | 11928.0 |
| 2007-10-22 07:25:00 | AAPL | Stock | 6.0379 | 6.0379 | 6.0321 | 6.0336 | 33880.0 |
| 2007-10-22 07:30:00 | AAPL | Stock | 6.0336 | 6.0429 | 6.0336 | 6.0414 | 36960.0 |
| 2007-10-22 07:35:00 | AAPL | Stock | 6.0414 | 6.0429 | 6.0357 | 6.0357 | 16800.0 |
| 2007-10-22 07:40:00 | AAPL | Stock | 6.0286 | 6.0286 | 6.0214 | 6.0214 | 16800.0 |
| 2007-10-22 07:45:00 | AAPL | Stock | 6.0357 | 6.04 | 6.0357 | 6.04 | 56000.0 |
| 2007-10-22 07:50:00 | AAPL | Stock | 6.0429 | 6.0429 | 6.0357 | 6.0357 | 26320.0 |
| 2007-10-22 07:55:00 | AAPL | Stock | 6.0357 | 6.0357 | 6.0357 | 6.0357 | 30800.0 |
| 2007-10-22 08:00:00 | AAPL | Stock | 6.0411 | 6.0675 | 6.0357 | 6.0643 | 1731296.0 |
| 2007-10-22 08:05:00 | AAPL | Stock | 6.0643 | 6.1171 | 6.0643 | 6.1171 | 1706488.0 |
| 2007-10-22 08:10:00 | AAPL | Stock | 6.1118 | 6.125 | 6.1071 | 6.1107 | 1081668.0 |
| 2007-10-22 08:15:00 | AAPL | Stock | 6.1121 | 6.1375 | 6.1121 | 6.1321 | 1204420.0 |
| 2007-10-22 08:20:00 | AAPL | Stock | 6.1354 | 6.1357 | 6.1193 | 6.1279 | 1258460.0 |
| 2007-10-22 08:25:00 | AAPL | Stock | 6.1279 | 6.1321 | 6.12 | 6.1321 | 760088.0 |
| 2007-10-22 08:30:00 | AAPL | Stock | 6.1336 | 6.1411 | 6.125 | 6.1286 | 633864.0 |
| 2007-10-22 08:35:00 | AAPL | Stock | 6.13 | 6.1339 | 6.1232 | 6.1246 | 557004.0 |
| 2007-10-22 08:40:00 | AAPL | Stock | 6.1246 | 6.125 | 6.1054 | 6.1136 | 1903356.0 |
| 2007-10-22 08:45:00 | AAPL | Stock | 6.1136 | 6.1164 | 6.0996 | 6.1071 | 780668.0 |
| 2007-10-22 08:50:00 | AAPL | Stock | 6.1071 | 6.1164 | 6.1036 | 6.1071 | 684600.0 |
| 2007-10-22 08:55:00 | AAPL | Stock | 6.1079 | 6.1114 | 6.1068 | 6.1082 | 687036.0 |
| 2007-10-22 09:00:00 | AAPL | Stock | 6.1096 | 6.1136 | 6.1071 | 6.11 | 484848.0 |
| 2007-10-22 09:05:00 | AAPL | Stock | 6.11 | 6.1125 | 6.1071 | 6.1093 | 513184.0 |
| 2007-10-22 09:10:00 | AAPL | Stock | 6.1104 | 6.1104 | 6.0921 | 6.0996 | 875700.0 |
| 2007-10-22 09:15:00 | AAPL | Stock | 6.0971 | 6.1004 | 6.0925 | 6.0925 | 416724.0 |
| 2007-10-22 09:20:00 | AAPL | Stock | 6.0921 | 6.0954 | 6.0811 | 6.0875 | 558572.0 |
| 2007-10-22 09:25:00 | AAPL | Stock | 6.0861 | 6.0964 | 6.0764 | 6.08 | 847364.0 |
| 2007-10-22 09:30:00 | AAPL | Stock | 6.0804 | 6.1429 | 6.0704 | 6.1346 | 45455452.0 |
| 2007-10-22 09:35:00 | AAPL | Stock | 6.1346 | 6.1521 | 6.1204 | 6.1443 | 22792616.0 |
| 2007-10-22 09:40:00 | AAPL | Stock | 6.1436 | 6.1607 | 6.1311 | 6.1471 | 31629416.0 |
| 2007-10-22 09:45:00 | AAPL | Stock | 6.1464 | 6.1679 | 6.1407 | 6.16 | 24019072.0 |
| 2007-10-22 09:50:00 | AAPL | Stock | 6.1589 | 6.1929 | 6.1571 | 6.1925 | 27496756.0 |
| 2007-10-22 09:55:00 | AAPL | Stock | 6.1921 | 6.1996 | 6.1679 | 6.1854 | 31794672.0 |
| 2007-10-22 10:00:00 | AAPL | Stock | 6.185 | 6.2036 | 6.1725 | 6.1789 | 21893396.0 |
| 2007-10-22 10:05:00 | AAPL | Stock | 6.1782 | 6.2143 | 6.1775 | 6.2089 | 19226676.0 |
| 2007-10-22 10:10:00 | AAPL | Stock | 6.2076 | 6.2296 | 6.2018 | 6.2279 | 29052660.0 |
> showing 50 of 314,516 rows — these rows as CSV