PREVIEW / stock_1min / 2009-09-14
file: by_date/stock_1min/2009/2009-09-14.parquet size: 12.3 MB rows: 931,928 symbols: 2,728
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-09-14 07:02:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1036 | 6.1036 | 8400.0 |
| 2009-09-14 07:04:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 2800.0 |
| 2009-09-14 07:21:00 | AAPL | Stock | 6.1064 | 6.1079 | 6.1064 | 6.1079 | 10080.0 |
| 2009-09-14 07:23:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 2800.0 |
| 2009-09-14 07:26:00 | AAPL | Stock | 6.1075 | 6.1075 | 6.1075 | 6.1075 | 5600.0 |
| 2009-09-14 07:27:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 11200.0 |
| 2009-09-14 07:31:00 | AAPL | Stock | 6.0993 | 6.0993 | 6.0982 | 6.0982 | 5600.0 |
| 2009-09-14 07:36:00 | AAPL | Stock | 6.1054 | 6.1054 | 6.1054 | 6.1054 | 5600.0 |
| 2009-09-14 07:51:00 | AAPL | Stock | 6.1054 | 6.1054 | 6.1054 | 6.1054 | 2800.0 |
| 2009-09-14 08:00:00 | AAPL | Stock | 6.1054 | 6.1143 | 6.1007 | 6.1054 | 61264.0 |
| 2009-09-14 08:01:00 | AAPL | Stock | 6.1068 | 6.1068 | 6.1054 | 6.1054 | 8400.0 |
| 2009-09-14 08:03:00 | AAPL | Stock | 6.1007 | 6.1007 | 6.1007 | 6.1007 | 12012.0 |
| 2009-09-14 08:04:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1071 | 6.1104 | 23800.0 |
| 2009-09-14 08:07:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1036 | 6.1036 | 2800.0 |
| 2009-09-14 08:08:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1036 | 6.1036 | 2800.0 |
| 2009-09-14 08:11:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 2800.0 |
| 2009-09-14 08:15:00 | AAPL | Stock | 6.105 | 6.105 | 6.105 | 6.105 | 2800.0 |
| 2009-09-14 08:16:00 | AAPL | Stock | 6.105 | 6.105 | 6.105 | 6.105 | 8400.0 |
| 2009-09-14 08:17:00 | AAPL | Stock | 6.1036 | 6.1071 | 6.1036 | 6.1071 | 5600.0 |
| 2009-09-14 08:20:00 | AAPL | Stock | 6.1079 | 6.1079 | 6.1079 | 6.1079 | 8400.0 |
| 2009-09-14 08:22:00 | AAPL | Stock | 6.1086 | 6.1086 | 6.1071 | 6.1071 | 11200.0 |
| 2009-09-14 08:25:00 | AAPL | Stock | 6.1064 | 6.1079 | 6.1064 | 6.1079 | 11480.0 |
| 2009-09-14 08:27:00 | AAPL | Stock | 6.1104 | 6.1107 | 6.1104 | 6.1107 | 19516.0 |
| 2009-09-14 08:29:00 | AAPL | Stock | 6.1139 | 6.1154 | 6.1139 | 6.1154 | 8680.0 |
| 2009-09-14 08:32:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 2800.0 |
| 2009-09-14 08:34:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 2800.0 |
| 2009-09-14 08:42:00 | AAPL | Stock | 6.1089 | 6.1089 | 6.1089 | 6.1089 | 28000.0 |
| 2009-09-14 08:44:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 16128.0 |
| 2009-09-14 08:47:00 | AAPL | Stock | 6.1079 | 6.1079 | 6.1079 | 6.1079 | 2800.0 |
| 2009-09-14 08:52:00 | AAPL | Stock | 6.1089 | 6.1089 | 6.1089 | 6.1089 | 28000.0 |
| 2009-09-14 08:54:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 21756.0 |
| 2009-09-14 08:55:00 | AAPL | Stock | 6.1107 | 6.1107 | 6.1107 | 6.1107 | 42560.0 |
| 2009-09-14 08:56:00 | AAPL | Stock | 6.1118 | 6.1125 | 6.1118 | 6.1125 | 9464.0 |
| 2009-09-14 08:58:00 | AAPL | Stock | 6.1136 | 6.1136 | 6.1136 | 6.1136 | 4564.0 |
| 2009-09-14 09:00:00 | AAPL | Stock | 6.1143 | 6.1143 | 6.1143 | 6.1143 | 6356.0 |
| 2009-09-14 09:02:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1125 | 6.1125 | 7000.0 |
| 2009-09-14 09:03:00 | AAPL | Stock | 6.1154 | 6.1154 | 6.1154 | 6.1154 | 4760.0 |
| 2009-09-14 09:05:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1125 | 6.1125 | 2800.0 |
| 2009-09-14 09:06:00 | AAPL | Stock | 6.1125 | 6.1125 | 6.1125 | 6.1125 | 14000.0 |
| 2009-09-14 09:07:00 | AAPL | Stock | 6.1089 | 6.1089 | 6.1089 | 6.1089 | 2800.0 |
| 2009-09-14 09:09:00 | AAPL | Stock | 6.1096 | 6.1096 | 6.1093 | 6.1093 | 5600.0 |
| 2009-09-14 09:10:00 | AAPL | Stock | 6.1089 | 6.1089 | 6.1089 | 6.1089 | 2800.0 |
| 2009-09-14 09:11:00 | AAPL | Stock | 6.1089 | 6.1089 | 6.1089 | 6.1089 | 20720.0 |
| 2009-09-14 09:12:00 | AAPL | Stock | 6.1089 | 6.1089 | 6.1089 | 6.1089 | 4760.0 |
| 2009-09-14 09:14:00 | AAPL | Stock | 6.1089 | 6.1089 | 6.1039 | 6.1039 | 28000.0 |
| 2009-09-14 09:16:00 | AAPL | Stock | 6.1082 | 6.1089 | 6.1082 | 6.1089 | 14840.0 |
| 2009-09-14 09:19:00 | AAPL | Stock | 6.1089 | 6.1136 | 6.1089 | 6.11 | 42336.0 |
| 2009-09-14 09:21:00 | AAPL | Stock | 6.11 | 6.11 | 6.11 | 6.11 | 8400.0 |
| 2009-09-14 09:22:00 | AAPL | Stock | 6.1136 | 6.1136 | 6.1132 | 6.1136 | 36008.0 |
| 2009-09-14 09:23:00 | AAPL | Stock | 6.1136 | 6.115 | 6.1136 | 6.1146 | 28000.0 |
> showing 50 of 931,928 rows — these rows as CSV