PREVIEW / stock_5min / 2002-03-28
file: by_date/stock_5min/2002/2002-03-28.parquet size: 1.8 MB rows: 122,862 symbols: 1,401
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-28 08:00:00 | AAPL | Stock | 0.4195 | 0.4352 | 0.4195 | 0.4341 | 520800.0 |
| 2002-03-28 08:05:00 | AAPL | Stock | 0.4344 | 0.4404 | 0.4344 | 0.4404 | 795200.0 |
| 2002-03-28 08:10:00 | AAPL | Stock | 0.4411 | 0.4418 | 0.4404 | 0.4407 | 554400.0 |
| 2002-03-28 08:15:00 | AAPL | Stock | 0.4404 | 0.4404 | 0.4398 | 0.4398 | 56000.0 |
| 2002-03-28 08:40:00 | AAPL | Stock | 0.4242 | 0.4242 | 0.4241 | 0.4241 | 28000.0 |
| 2002-03-28 09:00:00 | AAPL | Stock | 0.4214 | 0.4214 | 0.4214 | 0.4214 | 33600.0 |
| 2002-03-28 09:25:00 | AAPL | Stock | 0.4207 | 0.4221 | 0.42 | 0.4221 | 280000.0 |
| 2002-03-28 09:30:00 | AAPL | Stock | 0.4232 | 0.4239 | 0.42 | 0.4204 | 4575200.0 |
| 2002-03-28 09:35:00 | AAPL | Stock | 0.4204 | 0.4216 | 0.42 | 0.4213 | 1747200.0 |
| 2002-03-28 09:40:00 | AAPL | Stock | 0.4213 | 0.4221 | 0.4189 | 0.4196 | 2480800.0 |
| 2002-03-28 09:45:00 | AAPL | Stock | 0.4198 | 0.4213 | 0.4193 | 0.4206 | 1461600.0 |
| 2002-03-28 09:50:00 | AAPL | Stock | 0.4205 | 0.4234 | 0.4205 | 0.4225 | 7554400.0 |
| 2002-03-28 09:55:00 | AAPL | Stock | 0.4225 | 0.4225 | 0.4211 | 0.4216 | 1512000.0 |
| 2002-03-28 10:00:00 | AAPL | Stock | 0.4216 | 0.4236 | 0.4214 | 0.4235 | 2251200.0 |
| 2002-03-28 10:05:00 | AAPL | Stock | 0.4227 | 0.4236 | 0.4225 | 0.423 | 1215200.0 |
| 2002-03-28 10:10:00 | AAPL | Stock | 0.4232 | 0.4235 | 0.4225 | 0.4229 | 660800.0 |
| 2002-03-28 10:15:00 | AAPL | Stock | 0.4229 | 0.4243 | 0.4227 | 0.4239 | 1657600.0 |
| 2002-03-28 10:20:00 | AAPL | Stock | 0.4239 | 0.4245 | 0.4232 | 0.4245 | 924000.0 |
| 2002-03-28 10:25:00 | AAPL | Stock | 0.425 | 0.4264 | 0.4239 | 0.4261 | 1450400.0 |
| 2002-03-28 10:30:00 | AAPL | Stock | 0.4263 | 0.4264 | 0.4259 | 0.4263 | 672000.0 |
| 2002-03-28 10:35:00 | AAPL | Stock | 0.4261 | 0.4264 | 0.4245 | 0.4252 | 1159200.0 |
| 2002-03-28 10:40:00 | AAPL | Stock | 0.4248 | 0.4257 | 0.4241 | 0.4245 | 1293600.0 |
| 2002-03-28 10:45:00 | AAPL | Stock | 0.4241 | 0.4243 | 0.4238 | 0.4238 | 576800.0 |
| 2002-03-28 10:50:00 | AAPL | Stock | 0.4239 | 0.4241 | 0.4232 | 0.4238 | 616000.0 |
| 2002-03-28 10:55:00 | AAPL | Stock | 0.4236 | 0.4255 | 0.4236 | 0.4254 | 1327200.0 |
| 2002-03-28 11:00:00 | AAPL | Stock | 0.4254 | 0.4257 | 0.4246 | 0.4255 | 509600.0 |
| 2002-03-28 11:05:00 | AAPL | Stock | 0.4257 | 0.4257 | 0.4238 | 0.4241 | 756000.0 |
| 2002-03-28 11:10:00 | AAPL | Stock | 0.4254 | 0.4254 | 0.4236 | 0.4248 | 442400.0 |
| 2002-03-28 11:15:00 | AAPL | Stock | 0.4248 | 0.425 | 0.4245 | 0.4246 | 677600.0 |
| 2002-03-28 11:20:00 | AAPL | Stock | 0.4246 | 0.4246 | 0.4241 | 0.4243 | 246400.0 |
| 2002-03-28 11:25:00 | AAPL | Stock | 0.4243 | 0.4243 | 0.4232 | 0.4232 | 666400.0 |
| 2002-03-28 11:30:00 | AAPL | Stock | 0.4234 | 0.4236 | 0.4216 | 0.422 | 1450400.0 |
| 2002-03-28 11:35:00 | AAPL | Stock | 0.4221 | 0.4229 | 0.4218 | 0.4218 | 330400.0 |
| 2002-03-28 11:40:00 | AAPL | Stock | 0.4218 | 0.4218 | 0.4214 | 0.4216 | 571200.0 |
| 2002-03-28 11:45:00 | AAPL | Stock | 0.4218 | 0.423 | 0.4218 | 0.423 | 688800.0 |
| 2002-03-28 11:50:00 | AAPL | Stock | 0.423 | 0.4232 | 0.4223 | 0.4225 | 123200.0 |
| 2002-03-28 11:55:00 | AAPL | Stock | 0.4225 | 0.4241 | 0.422 | 0.422 | 1422400.0 |
| 2002-03-28 12:00:00 | AAPL | Stock | 0.422 | 0.423 | 0.422 | 0.4225 | 487200.0 |
| 2002-03-28 12:05:00 | AAPL | Stock | 0.423 | 0.423 | 0.4225 | 0.423 | 308000.0 |
| 2002-03-28 12:10:00 | AAPL | Stock | 0.423 | 0.4232 | 0.4227 | 0.423 | 369600.0 |
| 2002-03-28 12:15:00 | AAPL | Stock | 0.4227 | 0.4248 | 0.4227 | 0.4236 | 851200.0 |
| 2002-03-28 12:20:00 | AAPL | Stock | 0.4236 | 0.4239 | 0.4227 | 0.4234 | 515200.0 |
| 2002-03-28 12:25:00 | AAPL | Stock | 0.423 | 0.4241 | 0.4227 | 0.4239 | 6658400.0 |
| 2002-03-28 12:30:00 | AAPL | Stock | 0.4241 | 0.4246 | 0.4234 | 0.4246 | 515200.0 |
| 2002-03-28 12:35:00 | AAPL | Stock | 0.4245 | 0.425 | 0.4245 | 0.425 | 263200.0 |
| 2002-03-28 12:40:00 | AAPL | Stock | 0.4246 | 0.4248 | 0.4246 | 0.4246 | 324800.0 |
| 2002-03-28 12:45:00 | AAPL | Stock | 0.4246 | 0.4255 | 0.4245 | 0.4248 | 946400.0 |
| 2002-03-28 12:50:00 | AAPL | Stock | 0.4255 | 0.4255 | 0.4246 | 0.425 | 453600.0 |
| 2002-03-28 12:55:00 | AAPL | Stock | 0.425 | 0.4259 | 0.4232 | 0.4239 | 3892000.0 |
| 2002-03-28 13:00:00 | AAPL | Stock | 0.4239 | 0.4241 | 0.4211 | 0.4214 | 2710400.0 |
> showing 50 of 122,862 rows — these rows as CSV