PREVIEW / stock_1min / 2004-11-23
file: by_date/stock_1min/2004/2004-11-23.parquet size: 6.5 MB rows: 541,128 symbols: 1,547
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-23 08:00:00 | AAPL | Stock | 1.1 | 1.1 | 1.1 | 1.1 | 5600.0 |
| 2004-11-23 08:01:00 | AAPL | Stock | 1.1011 | 1.1018 | 1.1007 | 1.1018 | 603008.0 |
| 2004-11-23 08:02:00 | AAPL | Stock | 1.1027 | 1.1048 | 1.1027 | 1.1048 | 114072.0 |
| 2004-11-23 08:03:00 | AAPL | Stock | 1.1057 | 1.1071 | 1.1036 | 1.1052 | 276024.0 |
| 2004-11-23 08:04:00 | AAPL | Stock | 1.1052 | 1.1052 | 1.1027 | 1.1045 | 94360.0 |
| 2004-11-23 08:06:00 | AAPL | Stock | 1.1043 | 1.1043 | 1.1027 | 1.1027 | 149128.0 |
| 2004-11-23 08:07:00 | AAPL | Stock | 1.1025 | 1.1034 | 1.1 | 1.1034 | 48160.0 |
| 2004-11-23 08:09:00 | AAPL | Stock | 1.1023 | 1.1023 | 1.1009 | 1.1009 | 72800.0 |
| 2004-11-23 08:10:00 | AAPL | Stock | 1.1009 | 1.1027 | 1.1009 | 1.1027 | 58800.0 |
| 2004-11-23 08:11:00 | AAPL | Stock | 1.1009 | 1.1018 | 1.1009 | 1.1011 | 70000.0 |
| 2004-11-23 08:12:00 | AAPL | Stock | 1.1018 | 1.1018 | 1.1018 | 1.1018 | 56000.0 |
| 2004-11-23 08:13:00 | AAPL | Stock | 1.1018 | 1.1018 | 1.1018 | 1.1018 | 33600.0 |
| 2004-11-23 08:14:00 | AAPL | Stock | 1.1018 | 1.1018 | 1.1018 | 1.1018 | 56000.0 |
| 2004-11-23 08:15:00 | AAPL | Stock | 1.1021 | 1.1027 | 1.1021 | 1.1027 | 72800.0 |
| 2004-11-23 08:16:00 | AAPL | Stock | 1.1027 | 1.1036 | 1.1027 | 1.1036 | 21784.0 |
| 2004-11-23 08:17:00 | AAPL | Stock | 1.1027 | 1.1036 | 1.1027 | 1.1034 | 58800.0 |
| 2004-11-23 08:18:00 | AAPL | Stock | 1.1036 | 1.1036 | 1.1036 | 1.1036 | 14000.0 |
| 2004-11-23 08:19:00 | AAPL | Stock | 1.1045 | 1.1045 | 1.1045 | 1.1045 | 11200.0 |
| 2004-11-23 08:20:00 | AAPL | Stock | 1.1045 | 1.1054 | 1.1045 | 1.1054 | 56000.0 |
| 2004-11-23 08:21:00 | AAPL | Stock | 1.105 | 1.107 | 1.1045 | 1.1052 | 88648.0 |
| 2004-11-23 08:22:00 | AAPL | Stock | 1.1054 | 1.108 | 1.1054 | 1.1071 | 461832.0 |
| 2004-11-23 08:23:00 | AAPL | Stock | 1.1071 | 1.1089 | 1.1071 | 1.1089 | 67200.0 |
| 2004-11-23 08:24:00 | AAPL | Stock | 1.1096 | 1.1107 | 1.1096 | 1.1107 | 365120.0 |
| 2004-11-23 08:25:00 | AAPL | Stock | 1.1107 | 1.1148 | 1.1107 | 1.1148 | 312816.0 |
| 2004-11-23 08:26:00 | AAPL | Stock | 1.1134 | 1.1134 | 1.1107 | 1.1134 | 155232.0 |
| 2004-11-23 08:27:00 | AAPL | Stock | 1.1125 | 1.1134 | 1.1107 | 1.1107 | 245000.0 |
| 2004-11-23 08:28:00 | AAPL | Stock | 1.1114 | 1.1125 | 1.1107 | 1.112 | 229600.0 |
| 2004-11-23 08:29:00 | AAPL | Stock | 1.112 | 1.1132 | 1.1116 | 1.1121 | 246400.0 |
| 2004-11-23 08:30:00 | AAPL | Stock | 1.1118 | 1.1118 | 1.1098 | 1.11 | 272160.0 |
| 2004-11-23 08:31:00 | AAPL | Stock | 1.1098 | 1.1098 | 1.1098 | 1.1098 | 116592.0 |
| 2004-11-23 08:32:00 | AAPL | Stock | 1.1098 | 1.1098 | 1.1095 | 1.1095 | 100800.0 |
| 2004-11-23 08:33:00 | AAPL | Stock | 1.1095 | 1.1098 | 1.1089 | 1.1089 | 296184.0 |
| 2004-11-23 08:34:00 | AAPL | Stock | 1.1089 | 1.1089 | 1.1089 | 1.1089 | 5600.0 |
| 2004-11-23 08:35:00 | AAPL | Stock | 1.1089 | 1.1089 | 1.1073 | 1.1073 | 34160.0 |
| 2004-11-23 08:36:00 | AAPL | Stock | 1.1073 | 1.1098 | 1.1064 | 1.1098 | 854224.0 |
| 2004-11-23 08:37:00 | AAPL | Stock | 1.1086 | 1.1089 | 1.1084 | 1.1089 | 134400.0 |
| 2004-11-23 08:38:00 | AAPL | Stock | 1.1089 | 1.1089 | 1.1082 | 1.1084 | 33600.0 |
| 2004-11-23 08:39:00 | AAPL | Stock | 1.1089 | 1.1089 | 1.1086 | 1.1089 | 397600.0 |
| 2004-11-23 08:40:00 | AAPL | Stock | 1.1088 | 1.1089 | 1.1082 | 1.1082 | 275520.0 |
| 2004-11-23 08:41:00 | AAPL | Stock | 1.108 | 1.108 | 1.1075 | 1.1075 | 224000.0 |
| 2004-11-23 08:42:00 | AAPL | Stock | 1.108 | 1.108 | 1.108 | 1.108 | 44800.0 |
| 2004-11-23 08:43:00 | AAPL | Stock | 1.1082 | 1.1107 | 1.1071 | 1.1071 | 516544.0 |
| 2004-11-23 08:44:00 | AAPL | Stock | 1.1073 | 1.1088 | 1.1055 | 1.1061 | 348152.0 |
| 2004-11-23 08:45:00 | AAPL | Stock | 1.1063 | 1.108 | 1.1046 | 1.1064 | 156800.0 |
| 2004-11-23 08:46:00 | AAPL | Stock | 1.1063 | 1.107 | 1.1063 | 1.1063 | 33600.0 |
| 2004-11-23 08:47:00 | AAPL | Stock | 1.1063 | 1.1066 | 1.1036 | 1.1041 | 535640.0 |
| 2004-11-23 08:48:00 | AAPL | Stock | 1.1041 | 1.1064 | 1.1041 | 1.1048 | 156800.0 |
| 2004-11-23 08:49:00 | AAPL | Stock | 1.1054 | 1.1055 | 1.1054 | 1.1055 | 134400.0 |
| 2004-11-23 08:50:00 | AAPL | Stock | 1.105 | 1.1054 | 1.105 | 1.1052 | 78400.0 |
| 2004-11-23 08:53:00 | AAPL | Stock | 1.1045 | 1.1045 | 1.1036 | 1.1036 | 282800.0 |
> showing 50 of 541,128 rows — these rows as CSV