PREVIEW / stock_1min / 2009-08-28
file: by_date/stock_1min/2009/2009-08-28.parquet size: 12.1 MB rows: 920,620 symbols: 2,757
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-28 04:46:00 | AAPL | Stock | 6.1014 | 6.1014 | 6.1014 | 6.1014 | 14000.0 |
| 2009-08-28 05:19:00 | AAPL | Stock | 6.1018 | 6.1018 | 6.1018 | 6.1018 | 5600.0 |
| 2009-08-28 05:20:00 | AAPL | Stock | 6.1029 | 6.1029 | 6.1029 | 6.1029 | 14000.0 |
| 2009-08-28 05:52:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 5600.0 |
| 2009-08-28 05:59:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 5600.0 |
| 2009-08-28 06:18:00 | AAPL | Stock | 6.1075 | 6.1075 | 6.1075 | 6.1075 | 2800.0 |
| 2009-08-28 06:37:00 | AAPL | Stock | 6.1111 | 6.1111 | 6.1071 | 6.1071 | 14000.0 |
| 2009-08-28 07:01:00 | AAPL | Stock | 6.1246 | 6.1246 | 6.1246 | 6.1246 | 3136.0 |
| 2009-08-28 07:02:00 | AAPL | Stock | 6.1243 | 6.1243 | 6.1243 | 6.1243 | 5600.0 |
| 2009-08-28 07:04:00 | AAPL | Stock | 6.1179 | 6.1179 | 6.1179 | 6.1179 | 2800.0 |
| 2009-08-28 07:06:00 | AAPL | Stock | 6.1161 | 6.1186 | 6.1161 | 6.1186 | 8064.0 |
| 2009-08-28 07:07:00 | AAPL | Stock | 6.1214 | 6.1214 | 6.1214 | 6.1214 | 2800.0 |
| 2009-08-28 07:11:00 | AAPL | Stock | 6.1179 | 6.1179 | 6.1179 | 6.1179 | 3640.0 |
| 2009-08-28 07:12:00 | AAPL | Stock | 6.1214 | 6.1214 | 6.1161 | 6.1161 | 23800.0 |
| 2009-08-28 07:15:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 8400.0 |
| 2009-08-28 07:17:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 5600.0 |
| 2009-08-28 07:20:00 | AAPL | Stock | 6.1211 | 6.1211 | 6.1211 | 6.1211 | 5600.0 |
| 2009-08-28 07:23:00 | AAPL | Stock | 6.1193 | 6.1193 | 6.1193 | 6.1193 | 2800.0 |
| 2009-08-28 07:28:00 | AAPL | Stock | 6.1179 | 6.1179 | 6.1179 | 6.1179 | 2800.0 |
| 2009-08-28 07:30:00 | AAPL | Stock | 6.1196 | 6.1196 | 6.1196 | 6.1196 | 25200.0 |
| 2009-08-28 07:34:00 | AAPL | Stock | 6.1164 | 6.1164 | 6.1164 | 6.1164 | 22400.0 |
| 2009-08-28 07:35:00 | AAPL | Stock | 6.1164 | 6.1164 | 6.1164 | 6.1164 | 2800.0 |
| 2009-08-28 07:36:00 | AAPL | Stock | 6.1168 | 6.1168 | 6.1168 | 6.1168 | 11200.0 |
| 2009-08-28 07:37:00 | AAPL | Stock | 6.1164 | 6.1164 | 6.1164 | 6.1164 | 25200.0 |
| 2009-08-28 07:44:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 28000.0 |
| 2009-08-28 07:45:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 2800.0 |
| 2009-08-28 07:47:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 8960.0 |
| 2009-08-28 07:49:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 2800.0 |
| 2009-08-28 07:51:00 | AAPL | Stock | 6.1107 | 6.1157 | 6.1107 | 6.1157 | 61180.0 |
| 2009-08-28 07:52:00 | AAPL | Stock | 6.1161 | 6.1164 | 6.1161 | 6.1164 | 14000.0 |
| 2009-08-28 07:53:00 | AAPL | Stock | 6.1164 | 6.1164 | 6.1164 | 6.1164 | 2800.0 |
| 2009-08-28 07:54:00 | AAPL | Stock | 6.1107 | 6.1214 | 6.1107 | 6.1214 | 36400.0 |
| 2009-08-28 07:55:00 | AAPL | Stock | 6.1179 | 6.1214 | 6.1179 | 6.1196 | 35000.0 |
| 2009-08-28 07:57:00 | AAPL | Stock | 6.1196 | 6.1196 | 6.1179 | 6.1179 | 142800.0 |
| 2009-08-28 07:58:00 | AAPL | Stock | 6.1207 | 6.1207 | 6.1207 | 6.1207 | 28000.0 |
| 2009-08-28 07:59:00 | AAPL | Stock | 6.1207 | 6.1232 | 6.1207 | 6.1207 | 33600.0 |
| 2009-08-28 08:00:00 | AAPL | Stock | 6.1179 | 6.1239 | 6.1179 | 6.1232 | 426244.0 |
| 2009-08-28 08:01:00 | AAPL | Stock | 6.1232 | 6.1239 | 6.1214 | 6.1232 | 102340.0 |
| 2009-08-28 08:02:00 | AAPL | Stock | 6.1239 | 6.1239 | 6.1214 | 6.1239 | 53284.0 |
| 2009-08-28 08:03:00 | AAPL | Stock | 6.1218 | 6.1218 | 6.1214 | 6.1214 | 11200.0 |
| 2009-08-28 08:04:00 | AAPL | Stock | 6.1218 | 6.1232 | 6.1214 | 6.1232 | 42196.0 |
| 2009-08-28 08:05:00 | AAPL | Stock | 6.1232 | 6.125 | 6.1232 | 6.1246 | 137228.0 |
| 2009-08-28 08:06:00 | AAPL | Stock | 6.1246 | 6.125 | 6.1246 | 6.125 | 59388.0 |
| 2009-08-28 08:07:00 | AAPL | Stock | 6.1264 | 6.1268 | 6.1232 | 6.1232 | 28420.0 |
| 2009-08-28 08:08:00 | AAPL | Stock | 6.1236 | 6.1236 | 6.1236 | 6.1236 | 2800.0 |
| 2009-08-28 08:09:00 | AAPL | Stock | 6.125 | 6.1254 | 6.125 | 6.125 | 57680.0 |
| 2009-08-28 08:10:00 | AAPL | Stock | 6.1254 | 6.1261 | 6.1254 | 6.1257 | 150332.0 |
| 2009-08-28 08:11:00 | AAPL | Stock | 6.1261 | 6.1261 | 6.1254 | 6.1254 | 33320.0 |
| 2009-08-28 08:12:00 | AAPL | Stock | 6.1261 | 6.1268 | 6.125 | 6.125 | 122500.0 |
| 2009-08-28 08:13:00 | AAPL | Stock | 6.1264 | 6.1275 | 6.1264 | 6.1275 | 80528.0 |
> showing 50 of 920,620 rows — these rows as CSV