PREVIEW / stock_5min / 2000-09-01
file: by_date/stock_5min/2000/2000-09-01.parquet size: 1.2 MB rows: 89,257 symbols: 1,220
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 |
|---|---|---|---|---|---|---|---|
| 2000-09-01 08:00:00 | AAPL | Stock | 1.0859 | 1.0887 | 1.0859 | 1.0887 | 1024800.0 |
| 2000-09-01 08:35:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 28000.0 |
| 2000-09-01 08:55:00 | AAPL | Stock | 1.096 | 1.0982 | 1.0949 | 1.0949 | 112000.0 |
| 2000-09-01 09:00:00 | AAPL | Stock | 1.0949 | 1.1049 | 1.0949 | 1.1038 | 168000.0 |
| 2000-09-01 09:05:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.0982 | 1.1027 | 179200.0 |
| 2000-09-01 09:10:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 5600.0 |
| 2000-09-01 09:15:00 | AAPL | Stock | 1.1027 | 1.1027 | 1.1027 | 1.1027 | 184800.0 |
| 2000-09-01 09:20:00 | AAPL | Stock | 1.1004 | 1.1004 | 1.1004 | 1.1004 | 56000.0 |
| 2000-09-01 09:25:00 | AAPL | Stock | 1.0982 | 1.0993 | 1.0915 | 1.0926 | 940800.0 |
| 2000-09-01 09:30:00 | AAPL | Stock | 1.0949 | 1.1004 | 1.0938 | 1.1004 | 5818400.0 |
| 2000-09-01 09:35:00 | AAPL | Stock | 1.1004 | 1.1038 | 1.0915 | 1.1027 | 5381600.0 |
| 2000-09-01 09:40:00 | AAPL | Stock | 1.1027 | 1.1038 | 1.0954 | 1.1016 | 5146400.0 |
| 2000-09-01 09:45:00 | AAPL | Stock | 1.1021 | 1.106 | 1.1004 | 1.1027 | 2167200.0 |
| 2000-09-01 09:50:00 | AAPL | Stock | 1.1049 | 1.1127 | 1.1027 | 1.1071 | 15584800.0 |
| 2000-09-01 09:55:00 | AAPL | Stock | 1.1071 | 1.1183 | 1.106 | 1.1183 | 5555200.0 |
| 2000-09-01 10:00:00 | AAPL | Stock | 1.1161 | 1.1295 | 1.115 | 1.1239 | 16144800.0 |
| 2000-09-01 10:05:00 | AAPL | Stock | 1.1239 | 1.1283 | 1.1217 | 1.1228 | 6949600.0 |
| 2000-09-01 10:10:00 | AAPL | Stock | 1.1228 | 1.1261 | 1.1217 | 1.1256 | 7252000.0 |
| 2000-09-01 10:15:00 | AAPL | Stock | 1.1261 | 1.1261 | 1.1205 | 1.1228 | 3808000.0 |
| 2000-09-01 10:20:00 | AAPL | Stock | 1.1239 | 1.125 | 1.1205 | 1.1217 | 3444000.0 |
| 2000-09-01 10:25:00 | AAPL | Stock | 1.1205 | 1.1228 | 1.1116 | 1.1127 | 6501600.0 |
| 2000-09-01 10:30:00 | AAPL | Stock | 1.1127 | 1.1127 | 1.1004 | 1.1004 | 3701600.0 |
| 2000-09-01 10:35:00 | AAPL | Stock | 1.1016 | 1.106 | 1.1004 | 1.1038 | 1948800.0 |
| 2000-09-01 10:40:00 | AAPL | Stock | 1.1038 | 1.106 | 1.0982 | 1.1004 | 5432000.0 |
| 2000-09-01 10:45:00 | AAPL | Stock | 1.1016 | 1.106 | 1.1004 | 1.106 | 4967200.0 |
| 2000-09-01 10:50:00 | AAPL | Stock | 1.1049 | 1.1083 | 1.1016 | 1.1066 | 3858400.0 |
| 2000-09-01 10:55:00 | AAPL | Stock | 1.106 | 1.1161 | 1.106 | 1.1116 | 2979200.0 |
| 2000-09-01 11:00:00 | AAPL | Stock | 1.1116 | 1.1161 | 1.1116 | 1.1138 | 4788000.0 |
| 2000-09-01 11:05:00 | AAPL | Stock | 1.115 | 1.1161 | 1.1127 | 1.1138 | 4144000.0 |
| 2000-09-01 11:10:00 | AAPL | Stock | 1.1127 | 1.1138 | 1.1116 | 1.1116 | 1668800.0 |
| 2000-09-01 11:15:00 | AAPL | Stock | 1.1127 | 1.1138 | 1.1116 | 1.1138 | 2240000.0 |
| 2000-09-01 11:20:00 | AAPL | Stock | 1.1138 | 1.1161 | 1.1127 | 1.1127 | 2100000.0 |
| 2000-09-01 11:25:00 | AAPL | Stock | 1.1161 | 1.1172 | 1.1105 | 1.1138 | 1484000.0 |
| 2000-09-01 11:30:00 | AAPL | Stock | 1.115 | 1.1222 | 1.1138 | 1.1205 | 2704800.0 |
| 2000-09-01 11:35:00 | AAPL | Stock | 1.1194 | 1.125 | 1.1183 | 1.1205 | 2256800.0 |
| 2000-09-01 11:40:00 | AAPL | Stock | 1.1205 | 1.1217 | 1.1161 | 1.1194 | 912800.0 |
| 2000-09-01 11:45:00 | AAPL | Stock | 1.1183 | 1.1228 | 1.1161 | 1.1228 | 1674400.0 |
| 2000-09-01 11:50:00 | AAPL | Stock | 1.1217 | 1.1239 | 1.1161 | 1.1228 | 1013600.0 |
| 2000-09-01 11:55:00 | AAPL | Stock | 1.1217 | 1.1261 | 1.1205 | 1.1239 | 4995200.0 |
| 2000-09-01 12:00:00 | AAPL | Stock | 1.1228 | 1.1228 | 1.1172 | 1.1172 | 2962400.0 |
| 2000-09-01 12:05:00 | AAPL | Stock | 1.1194 | 1.1205 | 1.1183 | 1.1194 | 1316000.0 |
| 2000-09-01 12:10:00 | AAPL | Stock | 1.1194 | 1.1194 | 1.1172 | 1.1172 | 1260000.0 |
| 2000-09-01 12:15:00 | AAPL | Stock | 1.1172 | 1.1183 | 1.115 | 1.1172 | 728000.0 |
| 2000-09-01 12:20:00 | AAPL | Stock | 1.1172 | 1.1194 | 1.115 | 1.1183 | 940800.0 |
| 2000-09-01 12:25:00 | AAPL | Stock | 1.1172 | 1.1194 | 1.115 | 1.1194 | 1652000.0 |
| 2000-09-01 12:30:00 | AAPL | Stock | 1.1183 | 1.1205 | 1.115 | 1.115 | 980000.0 |
| 2000-09-01 12:35:00 | AAPL | Stock | 1.1138 | 1.1161 | 1.1116 | 1.1138 | 884800.0 |
| 2000-09-01 12:40:00 | AAPL | Stock | 1.1127 | 1.115 | 1.1116 | 1.1127 | 660800.0 |
| 2000-09-01 12:45:00 | AAPL | Stock | 1.1127 | 1.1161 | 1.1127 | 1.1161 | 621600.0 |
| 2000-09-01 12:50:00 | AAPL | Stock | 1.115 | 1.1217 | 1.115 | 1.1194 | 2452800.0 |
> showing 50 of 89,257 rows — these rows as CSV