PREVIEW / stock_5min / 2004-11-24
file: by_date/stock_5min/2004/2004-11-24.parquet size: 2.4 MB rows: 181,070 symbols: 1,873
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-24 08:00:00 | AAPL | Stock | 1.0946 | 1.1009 | 1.0946 | 1.1009 | 50400.0 |
| 2004-11-24 08:10:00 | AAPL | Stock | 1.0982 | 1.1009 | 1.0982 | 1.1009 | 33600.0 |
| 2004-11-24 08:15:00 | AAPL | Stock | 1.1007 | 1.1009 | 1.1 | 1.1009 | 193200.0 |
| 2004-11-24 08:20:00 | AAPL | Stock | 1.1016 | 1.1034 | 1.1016 | 1.1034 | 78400.0 |
| 2004-11-24 08:25:00 | AAPL | Stock | 1.1027 | 1.1071 | 1.1027 | 1.1071 | 380800.0 |
| 2004-11-24 08:30:00 | AAPL | Stock | 1.1071 | 1.1089 | 1.1055 | 1.1063 | 322000.0 |
| 2004-11-24 08:35:00 | AAPL | Stock | 1.1039 | 1.1068 | 1.1036 | 1.1068 | 117600.0 |
| 2004-11-24 08:40:00 | AAPL | Stock | 1.1045 | 1.1066 | 1.1039 | 1.1039 | 36904.0 |
| 2004-11-24 08:45:00 | AAPL | Stock | 1.1041 | 1.1041 | 1.1027 | 1.1027 | 143360.0 |
| 2004-11-24 08:50:00 | AAPL | Stock | 1.1018 | 1.1036 | 1.1018 | 1.1036 | 165200.0 |
| 2004-11-24 08:55:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 61600.0 |
| 2004-11-24 09:00:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1009 | 1.1009 | 1153208.0 |
| 2004-11-24 09:05:00 | AAPL | Stock | 1.1009 | 1.1009 | 1.1002 | 1.1002 | 33600.0 |
| 2004-11-24 09:10:00 | AAPL | Stock | 1.1002 | 1.1002 | 1.1002 | 1.1002 | 67200.0 |
| 2004-11-24 09:20:00 | AAPL | Stock | 1.1002 | 1.1002 | 1.0988 | 1.0988 | 151928.0 |
| 2004-11-24 09:25:00 | AAPL | Stock | 1.0982 | 1.1039 | 1.0982 | 1.1009 | 4187120.0 |
| 2004-11-24 09:30:00 | AAPL | Stock | 1.1016 | 1.107 | 1.0991 | 1.1018 | 36519840.0 |
| 2004-11-24 09:35:00 | AAPL | Stock | 1.1014 | 1.1066 | 1.0998 | 1.1061 | 20258280.0 |
| 2004-11-24 09:40:00 | AAPL | Stock | 1.1061 | 1.1071 | 1.103 | 1.103 | 20166608.0 |
| 2004-11-24 09:45:00 | AAPL | Stock | 1.1029 | 1.1057 | 1.102 | 1.1038 | 14015568.0 |
| 2004-11-24 09:50:00 | AAPL | Stock | 1.1038 | 1.1046 | 1.1011 | 1.1025 | 7515200.0 |
| 2004-11-24 09:55:00 | AAPL | Stock | 1.1023 | 1.1045 | 1.1014 | 1.1018 | 8310232.0 |
| 2004-11-24 10:00:00 | AAPL | Stock | 1.1023 | 1.1041 | 1.1011 | 1.1041 | 11054904.0 |
| 2004-11-24 10:05:00 | AAPL | Stock | 1.1041 | 1.1063 | 1.1036 | 1.1048 | 9930704.0 |
| 2004-11-24 10:10:00 | AAPL | Stock | 1.1048 | 1.1071 | 1.1018 | 1.1068 | 8760640.0 |
| 2004-11-24 10:15:00 | AAPL | Stock | 1.1068 | 1.1071 | 1.1034 | 1.107 | 10871000.0 |
| 2004-11-24 10:20:00 | AAPL | Stock | 1.107 | 1.1159 | 1.1068 | 1.1155 | 35580608.0 |
| 2004-11-24 10:25:00 | AAPL | Stock | 1.1155 | 1.1229 | 1.1152 | 1.1189 | 39583824.0 |
| 2004-11-24 10:30:00 | AAPL | Stock | 1.1186 | 1.1195 | 1.1139 | 1.1157 | 19617024.0 |
| 2004-11-24 10:35:00 | AAPL | Stock | 1.1157 | 1.12 | 1.1143 | 1.12 | 21240464.0 |
| 2004-11-24 10:40:00 | AAPL | Stock | 1.12 | 1.1211 | 1.1188 | 1.1195 | 20682144.0 |
| 2004-11-24 10:45:00 | AAPL | Stock | 1.1195 | 1.125 | 1.1186 | 1.125 | 27644512.0 |
| 2004-11-24 10:50:00 | AAPL | Stock | 1.125 | 1.1325 | 1.1239 | 1.1273 | 50561672.0 |
| 2004-11-24 10:55:00 | AAPL | Stock | 1.1273 | 1.1295 | 1.1227 | 1.1245 | 29652560.0 |
| 2004-11-24 11:00:00 | AAPL | Stock | 1.1243 | 1.1248 | 1.118 | 1.1189 | 29555568.0 |
| 2004-11-24 11:05:00 | AAPL | Stock | 1.1189 | 1.1234 | 1.1189 | 1.123 | 14167888.0 |
| 2004-11-24 11:10:00 | AAPL | Stock | 1.1227 | 1.1266 | 1.1225 | 1.125 | 17003280.0 |
| 2004-11-24 11:15:00 | AAPL | Stock | 1.1248 | 1.1261 | 1.1241 | 1.1248 | 12049856.0 |
| 2004-11-24 11:20:00 | AAPL | Stock | 1.125 | 1.1268 | 1.1238 | 1.1266 | 13025432.0 |
| 2004-11-24 11:25:00 | AAPL | Stock | 1.1263 | 1.1286 | 1.1257 | 1.1286 | 12350128.0 |
| 2004-11-24 11:30:00 | AAPL | Stock | 1.1284 | 1.1311 | 1.1273 | 1.1275 | 16927624.0 |
| 2004-11-24 11:35:00 | AAPL | Stock | 1.1275 | 1.1282 | 1.1229 | 1.1241 | 15520288.0 |
| 2004-11-24 11:40:00 | AAPL | Stock | 1.1243 | 1.1288 | 1.1241 | 1.1282 | 8300040.0 |
| 2004-11-24 11:45:00 | AAPL | Stock | 1.1284 | 1.1296 | 1.1264 | 1.1295 | 8377264.0 |
| 2004-11-24 11:50:00 | AAPL | Stock | 1.1289 | 1.1295 | 1.1277 | 1.1277 | 6586272.0 |
| 2004-11-24 11:55:00 | AAPL | Stock | 1.128 | 1.1295 | 1.1277 | 1.1293 | 5132288.0 |
| 2004-11-24 12:00:00 | AAPL | Stock | 1.1293 | 1.1304 | 1.1261 | 1.1279 | 14590016.0 |
| 2004-11-24 12:05:00 | AAPL | Stock | 1.1277 | 1.1291 | 1.1271 | 1.1289 | 8075480.0 |
| 2004-11-24 12:10:00 | AAPL | Stock | 1.1289 | 1.1291 | 1.1268 | 1.1271 | 3597328.0 |
| 2004-11-24 12:15:00 | AAPL | Stock | 1.1275 | 1.1284 | 1.1266 | 1.1273 | 7353752.0 |
> showing 50 of 181,070 rows — these rows as CSV