PREVIEW / stock_5min / 2004-12-09
file: by_date/stock_5min/2004/2004-12-09.parquet size: 2.6 MB rows: 185,655 symbols: 1,887
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-12-09 08:00:00 | AAPL | Stock | 1.1268 | 1.1268 | 1.1268 | 1.1268 | 16800.0 |
| 2004-12-09 08:05:00 | AAPL | Stock | 1.1268 | 1.1268 | 1.1268 | 1.1268 | 56000.0 |
| 2004-12-09 08:10:00 | AAPL | Stock | 1.1295 | 1.1295 | 1.1268 | 1.1286 | 77000.0 |
| 2004-12-09 08:25:00 | AAPL | Stock | 1.125 | 1.125 | 1.1214 | 1.1223 | 30800.0 |
| 2004-12-09 08:30:00 | AAPL | Stock | 1.1238 | 1.1238 | 1.1214 | 1.1214 | 16800.0 |
| 2004-12-09 08:40:00 | AAPL | Stock | 1.125 | 1.125 | 1.1216 | 1.1216 | 110880.0 |
| 2004-12-09 08:45:00 | AAPL | Stock | 1.1216 | 1.1216 | 1.1216 | 1.1216 | 28000.0 |
| 2004-12-09 08:50:00 | AAPL | Stock | 1.1223 | 1.1223 | 1.1223 | 1.1223 | 75600.0 |
| 2004-12-09 08:55:00 | AAPL | Stock | 1.1223 | 1.1223 | 1.1214 | 1.1214 | 39200.0 |
| 2004-12-09 09:00:00 | AAPL | Stock | 1.125 | 1.1259 | 1.125 | 1.125 | 33600.0 |
| 2004-12-09 09:05:00 | AAPL | Stock | 1.125 | 1.1259 | 1.1241 | 1.1241 | 147280.0 |
| 2004-12-09 09:10:00 | AAPL | Stock | 1.1259 | 1.1259 | 1.1259 | 1.1259 | 147000.0 |
| 2004-12-09 09:15:00 | AAPL | Stock | 1.1241 | 1.125 | 1.1241 | 1.125 | 145600.0 |
| 2004-12-09 09:20:00 | AAPL | Stock | 1.125 | 1.125 | 1.125 | 1.125 | 5600.0 |
| 2004-12-09 09:25:00 | AAPL | Stock | 1.1291 | 1.1291 | 1.1198 | 1.1198 | 621600.0 |
| 2004-12-09 09:30:00 | AAPL | Stock | 1.1205 | 1.1209 | 1.1089 | 1.1154 | 24785544.0 |
| 2004-12-09 09:35:00 | AAPL | Stock | 1.1154 | 1.1179 | 1.1118 | 1.1157 | 15350664.0 |
| 2004-12-09 09:40:00 | AAPL | Stock | 1.1159 | 1.1173 | 1.113 | 1.1152 | 8794688.0 |
| 2004-12-09 09:45:00 | AAPL | Stock | 1.1154 | 1.1157 | 1.1084 | 1.1132 | 18186392.0 |
| 2004-12-09 09:50:00 | AAPL | Stock | 1.113 | 1.1196 | 1.113 | 1.1196 | 15376032.0 |
| 2004-12-09 09:55:00 | AAPL | Stock | 1.1196 | 1.1223 | 1.1171 | 1.12 | 13409648.0 |
| 2004-12-09 10:00:00 | AAPL | Stock | 1.1195 | 1.12 | 1.1164 | 1.118 | 9634408.0 |
| 2004-12-09 10:05:00 | AAPL | Stock | 1.1179 | 1.1241 | 1.1163 | 1.1189 | 18958744.0 |
| 2004-12-09 10:10:00 | AAPL | Stock | 1.1189 | 1.1216 | 1.1138 | 1.1163 | 20234144.0 |
| 2004-12-09 10:15:00 | AAPL | Stock | 1.1161 | 1.1171 | 1.1116 | 1.1136 | 12836824.0 |
| 2004-12-09 10:20:00 | AAPL | Stock | 1.1139 | 1.1161 | 1.1127 | 1.1161 | 11321520.0 |
| 2004-12-09 10:25:00 | AAPL | Stock | 1.1152 | 1.1161 | 1.112 | 1.1141 | 9453696.0 |
| 2004-12-09 10:30:00 | AAPL | Stock | 1.1139 | 1.1146 | 1.11 | 1.1139 | 13408304.0 |
| 2004-12-09 10:35:00 | AAPL | Stock | 1.1139 | 1.1184 | 1.1139 | 1.117 | 12995360.0 |
| 2004-12-09 10:40:00 | AAPL | Stock | 1.1168 | 1.1186 | 1.1148 | 1.1186 | 7970424.0 |
| 2004-12-09 10:45:00 | AAPL | Stock | 1.1186 | 1.1196 | 1.1168 | 1.1188 | 7910224.0 |
| 2004-12-09 10:50:00 | AAPL | Stock | 1.1186 | 1.122 | 1.1184 | 1.1218 | 9225776.0 |
| 2004-12-09 10:55:00 | AAPL | Stock | 1.1216 | 1.1241 | 1.1205 | 1.1232 | 7485408.0 |
| 2004-12-09 11:00:00 | AAPL | Stock | 1.1232 | 1.1236 | 1.1204 | 1.1207 | 10151512.0 |
| 2004-12-09 11:05:00 | AAPL | Stock | 1.1205 | 1.1214 | 1.1184 | 1.1198 | 5122432.0 |
| 2004-12-09 11:10:00 | AAPL | Stock | 1.1198 | 1.1218 | 1.1177 | 1.1195 | 6001016.0 |
| 2004-12-09 11:15:00 | AAPL | Stock | 1.1188 | 1.1196 | 1.1161 | 1.1179 | 5820528.0 |
| 2004-12-09 11:20:00 | AAPL | Stock | 1.1177 | 1.12 | 1.1164 | 1.1186 | 4598496.0 |
| 2004-12-09 11:25:00 | AAPL | Stock | 1.1182 | 1.1196 | 1.1161 | 1.1179 | 3844568.0 |
| 2004-12-09 11:30:00 | AAPL | Stock | 1.1173 | 1.1179 | 1.1138 | 1.1152 | 5438944.0 |
| 2004-12-09 11:35:00 | AAPL | Stock | 1.1152 | 1.1154 | 1.1141 | 1.1146 | 2047192.0 |
| 2004-12-09 11:40:00 | AAPL | Stock | 1.1143 | 1.1164 | 1.1143 | 1.1154 | 2204720.0 |
| 2004-12-09 11:45:00 | AAPL | Stock | 1.115 | 1.1159 | 1.1138 | 1.1154 | 4851728.0 |
| 2004-12-09 11:50:00 | AAPL | Stock | 1.1154 | 1.117 | 1.1143 | 1.1157 | 3952872.0 |
| 2004-12-09 11:55:00 | AAPL | Stock | 1.1164 | 1.1188 | 1.1154 | 1.1177 | 3731000.0 |
| 2004-12-09 12:00:00 | AAPL | Stock | 1.1177 | 1.1184 | 1.1172 | 1.118 | 1493184.0 |
| 2004-12-09 12:05:00 | AAPL | Stock | 1.118 | 1.1182 | 1.117 | 1.117 | 1775648.0 |
| 2004-12-09 12:10:00 | AAPL | Stock | 1.1173 | 1.1173 | 1.1143 | 1.1152 | 2198280.0 |
| 2004-12-09 12:15:00 | AAPL | Stock | 1.1152 | 1.1182 | 1.1148 | 1.1182 | 4122328.0 |
| 2004-12-09 12:20:00 | AAPL | Stock | 1.1182 | 1.1205 | 1.118 | 1.1188 | 7853944.0 |
> showing 50 of 185,655 rows — these rows as CSV