PREVIEW / stock_5min / 2001-07-03
file: by_date/stock_5min/2001/2001-07-03.parquet size: 980 KB rows: 62,752 symbols: 1,279
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-03 09:25:00 | AAPL | Stock | 0.4232 | 0.4232 | 0.4214 | 0.4214 | 61600.0 |
| 2001-07-03 09:30:00 | AAPL | Stock | 0.4198 | 0.4236 | 0.4196 | 0.4229 | 10068800.0 |
| 2001-07-03 09:35:00 | AAPL | Stock | 0.4218 | 0.4259 | 0.4216 | 0.4255 | 3718400.0 |
| 2001-07-03 09:40:00 | AAPL | Stock | 0.4261 | 0.4288 | 0.4245 | 0.4268 | 4345600.0 |
| 2001-07-03 09:45:00 | AAPL | Stock | 0.4268 | 0.4277 | 0.4246 | 0.4266 | 4177600.0 |
| 2001-07-03 09:50:00 | AAPL | Stock | 0.4266 | 0.428 | 0.4254 | 0.4259 | 6938400.0 |
| 2001-07-03 09:55:00 | AAPL | Stock | 0.4282 | 0.4304 | 0.4275 | 0.4302 | 5280800.0 |
| 2001-07-03 10:00:00 | AAPL | Stock | 0.4302 | 0.4318 | 0.43 | 0.4307 | 4328800.0 |
| 2001-07-03 10:05:00 | AAPL | Stock | 0.4304 | 0.4311 | 0.427 | 0.4286 | 1971200.0 |
| 2001-07-03 10:10:00 | AAPL | Stock | 0.4289 | 0.4309 | 0.4275 | 0.4302 | 1943200.0 |
| 2001-07-03 10:15:00 | AAPL | Stock | 0.4295 | 0.43 | 0.4261 | 0.427 | 3259200.0 |
| 2001-07-03 10:20:00 | AAPL | Stock | 0.4279 | 0.428 | 0.4259 | 0.427 | 1540000.0 |
| 2001-07-03 10:25:00 | AAPL | Stock | 0.427 | 0.4295 | 0.4257 | 0.4273 | 2055200.0 |
| 2001-07-03 10:30:00 | AAPL | Stock | 0.4273 | 0.4282 | 0.4261 | 0.4266 | 1299200.0 |
| 2001-07-03 10:35:00 | AAPL | Stock | 0.4261 | 0.4273 | 0.4252 | 0.4273 | 1820000.0 |
| 2001-07-03 10:40:00 | AAPL | Stock | 0.4273 | 0.4279 | 0.4263 | 0.427 | 2184000.0 |
| 2001-07-03 10:45:00 | AAPL | Stock | 0.4275 | 0.4282 | 0.4268 | 0.4279 | 2856000.0 |
| 2001-07-03 10:50:00 | AAPL | Stock | 0.4279 | 0.4279 | 0.4271 | 0.4271 | 873600.0 |
| 2001-07-03 10:55:00 | AAPL | Stock | 0.4271 | 0.4296 | 0.427 | 0.4293 | 3343200.0 |
| 2001-07-03 11:00:00 | AAPL | Stock | 0.4286 | 0.4295 | 0.4277 | 0.4282 | 2307200.0 |
| 2001-07-03 11:05:00 | AAPL | Stock | 0.4277 | 0.43 | 0.4277 | 0.4286 | 1803200.0 |
| 2001-07-03 11:10:00 | AAPL | Stock | 0.4289 | 0.4298 | 0.4277 | 0.4277 | 1047200.0 |
| 2001-07-03 11:15:00 | AAPL | Stock | 0.4271 | 0.4273 | 0.4264 | 0.4264 | 1904000.0 |
| 2001-07-03 11:20:00 | AAPL | Stock | 0.4263 | 0.4277 | 0.4252 | 0.4273 | 5258400.0 |
| 2001-07-03 11:25:00 | AAPL | Stock | 0.4273 | 0.428 | 0.4268 | 0.4268 | 800800.0 |
| 2001-07-03 11:30:00 | AAPL | Stock | 0.4259 | 0.4286 | 0.4259 | 0.428 | 705600.0 |
| 2001-07-03 11:35:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.428 | 0.428 | 240800.0 |
| 2001-07-03 11:40:00 | AAPL | Stock | 0.428 | 0.4284 | 0.4279 | 0.4279 | 1030400.0 |
| 2001-07-03 11:45:00 | AAPL | Stock | 0.4279 | 0.4286 | 0.4275 | 0.4279 | 778400.0 |
| 2001-07-03 11:50:00 | AAPL | Stock | 0.4286 | 0.4286 | 0.4275 | 0.4284 | 1024800.0 |
| 2001-07-03 11:55:00 | AAPL | Stock | 0.4277 | 0.4291 | 0.4271 | 0.4291 | 2492000.0 |
| 2001-07-03 12:00:00 | AAPL | Stock | 0.4291 | 0.4291 | 0.4263 | 0.4268 | 845600.0 |
| 2001-07-03 12:05:00 | AAPL | Stock | 0.4263 | 0.4277 | 0.4259 | 0.4268 | 1332800.0 |
| 2001-07-03 12:10:00 | AAPL | Stock | 0.4266 | 0.4277 | 0.4266 | 0.4268 | 1047200.0 |
| 2001-07-03 12:15:00 | AAPL | Stock | 0.4263 | 0.427 | 0.4259 | 0.4263 | 2066400.0 |
| 2001-07-03 12:20:00 | AAPL | Stock | 0.4264 | 0.4286 | 0.4255 | 0.4273 | 7554400.0 |
| 2001-07-03 12:25:00 | AAPL | Stock | 0.4271 | 0.4277 | 0.427 | 0.4273 | 1506400.0 |
| 2001-07-03 12:30:00 | AAPL | Stock | 0.427 | 0.4279 | 0.427 | 0.4273 | 2195200.0 |
| 2001-07-03 12:35:00 | AAPL | Stock | 0.4275 | 0.4275 | 0.4268 | 0.4271 | 1646400.0 |
| 2001-07-03 12:40:00 | AAPL | Stock | 0.4261 | 0.4273 | 0.4261 | 0.4268 | 1652000.0 |
| 2001-07-03 12:45:00 | AAPL | Stock | 0.4261 | 0.4273 | 0.4259 | 0.4261 | 1506400.0 |
| 2001-07-03 12:50:00 | AAPL | Stock | 0.4261 | 0.4268 | 0.4239 | 0.4239 | 1601600.0 |
| 2001-07-03 12:55:00 | AAPL | Stock | 0.4239 | 0.4266 | 0.4232 | 0.425 | 2077600.0 |
| 2001-07-03 13:00:00 | AAPL | Stock | 0.4257 | 0.4259 | 0.4257 | 0.4257 | 302400.0 |
| 2001-07-03 08:00:00 | MSFT | Stock | 35.29 | 35.29 | 35.29 | 35.29 | 400.0 |
| 2001-07-03 08:15:00 | MSFT | Stock | 35.24 | 35.24 | 35.24 | 35.24 | 2000.0 |
| 2001-07-03 08:25:00 | MSFT | Stock | 35.15 | 35.15 | 35.15 | 35.15 | 2000.0 |
| 2001-07-03 08:30:00 | MSFT | Stock | 35.15 | 35.15 | 35.15 | 35.15 | 1800.0 |
| 2001-07-03 08:40:00 | MSFT | Stock | 35.2 | 35.2 | 35.2 | 35.2 | 200.0 |
| 2001-07-03 08:45:00 | MSFT | Stock | 35.19 | 35.19 | 35.19 | 35.19 | 800.0 |
> showing 50 of 62,752 rows — these rows as CSV