PREVIEW / stock_1min / 2007-11-23
file: by_date/stock_1min/2007/2007-11-23.parquet size: 6.5 MB rows: 508,543 symbols: 2,503
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-11-23 05:35:00 | AAPL | Stock | 6.0764 | 6.0764 | 6.0764 | 6.0764 | 2800.0 |
| 2007-11-23 06:00:00 | AAPL | Stock | 6.09 | 6.09 | 6.09 | 6.09 | 10444.0 |
| 2007-11-23 06:02:00 | AAPL | Stock | 6.1054 | 6.1054 | 6.1054 | 6.1054 | 16156.0 |
| 2007-11-23 06:10:00 | AAPL | Stock | 6.1061 | 6.1429 | 6.1061 | 6.1429 | 56000.0 |
| 2007-11-23 06:24:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 8232.0 |
| 2007-11-23 06:25:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 19768.0 |
| 2007-11-23 06:37:00 | AAPL | Stock | 6.1375 | 6.1375 | 6.1075 | 6.1075 | 11200.0 |
| 2007-11-23 06:46:00 | AAPL | Stock | 6.1371 | 6.1371 | 6.1371 | 6.1371 | 5600.0 |
| 2007-11-23 06:56:00 | AAPL | Stock | 6.1339 | 6.1339 | 6.1339 | 6.1339 | 2800.0 |
| 2007-11-23 06:57:00 | AAPL | Stock | 6.1357 | 6.1375 | 6.1357 | 6.1375 | 13832.0 |
| 2007-11-23 07:02:00 | AAPL | Stock | 6.1639 | 6.1639 | 6.1371 | 6.1371 | 19600.0 |
| 2007-11-23 07:05:00 | AAPL | Stock | 6.1371 | 6.1371 | 6.125 | 6.125 | 8400.0 |
| 2007-11-23 07:06:00 | AAPL | Stock | 6.125 | 6.125 | 6.125 | 6.125 | 53200.0 |
| 2007-11-23 07:15:00 | AAPL | Stock | 6.1357 | 6.1357 | 6.1357 | 6.1357 | 12460.0 |
| 2007-11-23 07:16:00 | AAPL | Stock | 6.1411 | 6.1411 | 6.1411 | 6.1411 | 2800.0 |
| 2007-11-23 07:17:00 | AAPL | Stock | 6.1429 | 6.1429 | 6.1429 | 6.1429 | 15512.0 |
| 2007-11-23 07:21:00 | AAPL | Stock | 6.125 | 6.125 | 6.125 | 6.125 | 22400.0 |
| 2007-11-23 07:22:00 | AAPL | Stock | 6.1246 | 6.1246 | 6.1246 | 6.1246 | 5600.0 |
| 2007-11-23 07:23:00 | AAPL | Stock | 6.1246 | 6.1246 | 6.1007 | 6.1007 | 8400.0 |
| 2007-11-23 07:29:00 | AAPL | Stock | 6.1239 | 6.1239 | 6.1218 | 6.1221 | 30800.0 |
| 2007-11-23 07:30:00 | AAPL | Stock | 6.1221 | 6.1221 | 6.1071 | 6.1071 | 22400.0 |
| 2007-11-23 07:33:00 | AAPL | Stock | 6.1054 | 6.1054 | 6.1011 | 6.1011 | 14000.0 |
| 2007-11-23 07:35:00 | AAPL | Stock | 6.1011 | 6.1011 | 6.1011 | 6.1011 | 2800.0 |
| 2007-11-23 07:36:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 28000.0 |
| 2007-11-23 07:39:00 | AAPL | Stock | 6.1007 | 6.1007 | 6.0989 | 6.0989 | 10920.0 |
| 2007-11-23 07:46:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 5600.0 |
| 2007-11-23 07:47:00 | AAPL | Stock | 6.1043 | 6.1043 | 6.1043 | 6.1043 | 2800.0 |
| 2007-11-23 07:49:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1036 | 6.1036 | 8400.0 |
| 2007-11-23 07:51:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1036 | 6.1036 | 9520.0 |
| 2007-11-23 07:52:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1036 | 6.1036 | 2800.0 |
| 2007-11-23 07:53:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1 | 6.1 | 8400.0 |
| 2007-11-23 07:54:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1036 | 6.1036 | 8400.0 |
| 2007-11-23 07:55:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1 | 6.1 | 14000.0 |
| 2007-11-23 07:56:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1032 | 6.1032 | 14000.0 |
| 2007-11-23 07:57:00 | AAPL | Stock | 6.1029 | 6.1029 | 6.0982 | 6.1025 | 22120.0 |
| 2007-11-23 07:58:00 | AAPL | Stock | 6.1025 | 6.1129 | 6.0957 | 6.1129 | 197680.0 |
| 2007-11-23 07:59:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 54880.0 |
| 2007-11-23 08:00:00 | AAPL | Stock | 6.1136 | 6.1214 | 6.1029 | 6.1179 | 614236.0 |
| 2007-11-23 08:01:00 | AAPL | Stock | 6.1175 | 6.1175 | 6.11 | 6.1157 | 115780.0 |
| 2007-11-23 08:02:00 | AAPL | Stock | 6.1157 | 6.1214 | 6.1071 | 6.115 | 264740.0 |
| 2007-11-23 08:03:00 | AAPL | Stock | 6.115 | 6.1221 | 6.1125 | 6.1143 | 323904.0 |
| 2007-11-23 08:04:00 | AAPL | Stock | 6.1161 | 6.12 | 6.1125 | 6.1125 | 91000.0 |
| 2007-11-23 08:05:00 | AAPL | Stock | 6.1161 | 6.1214 | 6.115 | 6.1214 | 328328.0 |
| 2007-11-23 08:06:00 | AAPL | Stock | 6.1218 | 6.1243 | 6.1164 | 6.1214 | 223776.0 |
| 2007-11-23 08:07:00 | AAPL | Stock | 6.1239 | 6.1239 | 6.12 | 6.1221 | 157416.0 |
| 2007-11-23 08:08:00 | AAPL | Stock | 6.1232 | 6.1271 | 6.1214 | 6.1221 | 185640.0 |
| 2007-11-23 08:09:00 | AAPL | Stock | 6.1221 | 6.1246 | 6.1189 | 6.1204 | 220248.0 |
| 2007-11-23 08:10:00 | AAPL | Stock | 6.1193 | 6.1193 | 6.1157 | 6.1157 | 99764.0 |
| 2007-11-23 08:11:00 | AAPL | Stock | 6.1157 | 6.1161 | 6.11 | 6.11 | 68628.0 |
| 2007-11-23 08:12:00 | AAPL | Stock | 6.1096 | 6.1129 | 6.1089 | 6.1093 | 45780.0 |
> showing 50 of 508,543 rows — these rows as CSV