PREVIEW / stock_5min / 2003-10-29
file: by_date/stock_5min/2003/2003-10-29.parquet size: 2.2 MB rows: 163,189 symbols: 1,647
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-29 08:00:00 | AAPL | Stock | 0.4207 | 0.4207 | 0.4207 | 0.4207 | 22400.0 |
| 2003-10-29 08:55:00 | AAPL | Stock | 0.4207 | 0.4214 | 0.4207 | 0.4214 | 16800.0 |
| 2003-10-29 09:00:00 | AAPL | Stock | 0.4207 | 0.4207 | 0.4207 | 0.4207 | 89600.0 |
| 2003-10-29 09:15:00 | AAPL | Stock | 0.4207 | 0.4207 | 0.4207 | 0.4207 | 78400000.0 |
| 2003-10-29 09:20:00 | AAPL | Stock | 0.4207 | 0.4207 | 0.4205 | 0.4205 | 179200.0 |
| 2003-10-29 09:25:00 | AAPL | Stock | 0.4205 | 0.4205 | 0.4198 | 0.4198 | 560000.0 |
| 2003-10-29 09:30:00 | AAPL | Stock | 0.4198 | 0.4209 | 0.4186 | 0.4202 | 10517136.0 |
| 2003-10-29 09:35:00 | AAPL | Stock | 0.42 | 0.42 | 0.4188 | 0.4196 | 5249440.0 |
| 2003-10-29 09:40:00 | AAPL | Stock | 0.4195 | 0.4205 | 0.4191 | 0.4202 | 4989600.0 |
| 2003-10-29 09:45:00 | AAPL | Stock | 0.4202 | 0.4205 | 0.4191 | 0.4191 | 3441032.0 |
| 2003-10-29 09:50:00 | AAPL | Stock | 0.4196 | 0.4198 | 0.4184 | 0.4189 | 3218824.0 |
| 2003-10-29 09:55:00 | AAPL | Stock | 0.4189 | 0.42 | 0.4188 | 0.4193 | 3355856.0 |
| 2003-10-29 10:00:00 | AAPL | Stock | 0.4193 | 0.4196 | 0.4191 | 0.4196 | 3012800.0 |
| 2003-10-29 10:05:00 | AAPL | Stock | 0.4195 | 0.4209 | 0.4189 | 0.4207 | 3964800.0 |
| 2003-10-29 10:10:00 | AAPL | Stock | 0.4207 | 0.4209 | 0.4198 | 0.42 | 2744000.0 |
| 2003-10-29 10:15:00 | AAPL | Stock | 0.4202 | 0.4202 | 0.4182 | 0.4186 | 3868928.0 |
| 2003-10-29 10:20:00 | AAPL | Stock | 0.4186 | 0.4186 | 0.4168 | 0.4177 | 3255000.0 |
| 2003-10-29 10:25:00 | AAPL | Stock | 0.4179 | 0.4186 | 0.417 | 0.4184 | 2477496.0 |
| 2003-10-29 10:30:00 | AAPL | Stock | 0.4184 | 0.4186 | 0.4177 | 0.4177 | 733600.0 |
| 2003-10-29 10:35:00 | AAPL | Stock | 0.4177 | 0.4184 | 0.4177 | 0.4182 | 1167656.0 |
| 2003-10-29 10:40:00 | AAPL | Stock | 0.418 | 0.4189 | 0.4179 | 0.4188 | 1442504.0 |
| 2003-10-29 10:45:00 | AAPL | Stock | 0.4189 | 0.4204 | 0.4186 | 0.4204 | 2133544.0 |
| 2003-10-29 10:50:00 | AAPL | Stock | 0.4202 | 0.4221 | 0.4202 | 0.4218 | 1503768.0 |
| 2003-10-29 10:55:00 | AAPL | Stock | 0.4218 | 0.422 | 0.4213 | 0.422 | 1108800.0 |
| 2003-10-29 11:00:00 | AAPL | Stock | 0.4218 | 0.4218 | 0.4209 | 0.4211 | 823200.0 |
| 2003-10-29 11:05:00 | AAPL | Stock | 0.4209 | 0.4211 | 0.4202 | 0.4204 | 632800.0 |
| 2003-10-29 11:10:00 | AAPL | Stock | 0.4204 | 0.4205 | 0.4188 | 0.4195 | 966000.0 |
| 2003-10-29 11:15:00 | AAPL | Stock | 0.4195 | 0.4198 | 0.418 | 0.418 | 1114400.0 |
| 2003-10-29 11:20:00 | AAPL | Stock | 0.4182 | 0.42 | 0.4179 | 0.4196 | 2228800.0 |
| 2003-10-29 11:25:00 | AAPL | Stock | 0.4193 | 0.4209 | 0.4189 | 0.4207 | 3613120.0 |
| 2003-10-29 11:30:00 | AAPL | Stock | 0.4207 | 0.4207 | 0.4202 | 0.4207 | 3892000.0 |
| 2003-10-29 11:35:00 | AAPL | Stock | 0.4205 | 0.4209 | 0.4205 | 0.4205 | 1493352.0 |
| 2003-10-29 11:40:00 | AAPL | Stock | 0.4205 | 0.4207 | 0.4198 | 0.4205 | 694400.0 |
| 2003-10-29 11:45:00 | AAPL | Stock | 0.4202 | 0.4207 | 0.4202 | 0.4205 | 547736.0 |
| 2003-10-29 11:50:00 | AAPL | Stock | 0.4202 | 0.4205 | 0.4195 | 0.4195 | 739200.0 |
| 2003-10-29 11:55:00 | AAPL | Stock | 0.4198 | 0.4204 | 0.4191 | 0.4202 | 1380960.0 |
| 2003-10-29 12:00:00 | AAPL | Stock | 0.4204 | 0.4204 | 0.4198 | 0.4202 | 347200.0 |
| 2003-10-29 12:05:00 | AAPL | Stock | 0.4198 | 0.4202 | 0.4198 | 0.42 | 1086288.0 |
| 2003-10-29 12:10:00 | AAPL | Stock | 0.4198 | 0.4202 | 0.4198 | 0.42 | 1092000.0 |
| 2003-10-29 12:15:00 | AAPL | Stock | 0.4199 | 0.4205 | 0.4198 | 0.4204 | 1472800.0 |
| 2003-10-29 12:20:00 | AAPL | Stock | 0.4205 | 0.4205 | 0.4198 | 0.4198 | 683200.0 |
| 2003-10-29 12:25:00 | AAPL | Stock | 0.4198 | 0.4207 | 0.4198 | 0.4207 | 1859200.0 |
| 2003-10-29 12:30:00 | AAPL | Stock | 0.4207 | 0.4211 | 0.4204 | 0.4205 | 1618400.0 |
| 2003-10-29 12:35:00 | AAPL | Stock | 0.4206 | 0.4213 | 0.4205 | 0.4211 | 980000.0 |
| 2003-10-29 12:40:00 | AAPL | Stock | 0.4211 | 0.4216 | 0.4209 | 0.4213 | 1207080.0 |
| 2003-10-29 12:45:00 | AAPL | Stock | 0.4211 | 0.4211 | 0.4195 | 0.4196 | 1215200.0 |
| 2003-10-29 12:50:00 | AAPL | Stock | 0.4193 | 0.4193 | 0.4186 | 0.4189 | 725200.0 |
| 2003-10-29 12:55:00 | AAPL | Stock | 0.4188 | 0.4213 | 0.4188 | 0.4209 | 1008000.0 |
| 2003-10-29 13:00:00 | AAPL | Stock | 0.4209 | 0.4213 | 0.4205 | 0.4213 | 974400.0 |
| 2003-10-29 13:05:00 | AAPL | Stock | 0.4211 | 0.423 | 0.4211 | 0.4229 | 3339672.0 |
> showing 50 of 163,189 rows — these rows as CSV