PREVIEW / stock_5min / 2001-04-24
file: by_date/stock_5min/2001/2001-04-24.parquet size: 1.5 MB rows: 102,247 symbols: 1,278
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-04-24 08:00:00 | AAPL | Stock | 0.433 | 0.433 | 0.433 | 0.433 | 22400.0 |
| 2001-04-24 08:25:00 | AAPL | Stock | 0.4304 | 0.4318 | 0.4304 | 0.4318 | 16800.0 |
| 2001-04-24 08:30:00 | AAPL | Stock | 0.4329 | 0.4329 | 0.4329 | 0.4329 | 44800.0 |
| 2001-04-24 08:35:00 | AAPL | Stock | 0.4329 | 0.4329 | 0.4329 | 0.4329 | 50400.0 |
| 2001-04-24 08:40:00 | AAPL | Stock | 0.4366 | 0.4366 | 0.4366 | 0.4366 | 168000.0 |
| 2001-04-24 08:45:00 | AAPL | Stock | 0.4364 | 0.4364 | 0.4364 | 0.4364 | 5600.0 |
| 2001-04-24 08:50:00 | AAPL | Stock | 0.4366 | 0.4366 | 0.4366 | 0.4366 | 44800.0 |
| 2001-04-24 08:55:00 | AAPL | Stock | 0.4364 | 0.4366 | 0.4364 | 0.4366 | 134400.0 |
| 2001-04-24 09:00:00 | AAPL | Stock | 0.4404 | 0.4404 | 0.4371 | 0.4371 | 11200.0 |
| 2001-04-24 09:05:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4348 | 0.4348 | 61600.0 |
| 2001-04-24 09:15:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.4348 | 0.4348 | 11200.0 |
| 2001-04-24 09:20:00 | AAPL | Stock | 0.4348 | 0.4357 | 0.4348 | 0.4357 | 100800.0 |
| 2001-04-24 09:25:00 | AAPL | Stock | 0.435 | 0.435 | 0.4341 | 0.4345 | 884800.0 |
| 2001-04-24 09:30:00 | AAPL | Stock | 0.4345 | 0.4373 | 0.4343 | 0.4352 | 8685600.0 |
| 2001-04-24 09:35:00 | AAPL | Stock | 0.4354 | 0.4438 | 0.4348 | 0.4393 | 10046400.0 |
| 2001-04-24 09:40:00 | AAPL | Stock | 0.4395 | 0.4395 | 0.4341 | 0.4346 | 8545600.0 |
| 2001-04-24 09:45:00 | AAPL | Stock | 0.4345 | 0.4404 | 0.4343 | 0.4404 | 12006400.0 |
| 2001-04-24 09:50:00 | AAPL | Stock | 0.4395 | 0.4421 | 0.437 | 0.4391 | 8271200.0 |
| 2001-04-24 09:55:00 | AAPL | Stock | 0.4402 | 0.4402 | 0.4339 | 0.4384 | 7789600.0 |
| 2001-04-24 10:00:00 | AAPL | Stock | 0.4384 | 0.4414 | 0.4355 | 0.4404 | 7229600.0 |
| 2001-04-24 10:05:00 | AAPL | Stock | 0.4409 | 0.4446 | 0.4375 | 0.4438 | 5202400.0 |
| 2001-04-24 10:10:00 | AAPL | Stock | 0.4438 | 0.4455 | 0.442 | 0.4427 | 7201600.0 |
| 2001-04-24 10:15:00 | AAPL | Stock | 0.4427 | 0.4464 | 0.4425 | 0.4439 | 8982400.0 |
| 2001-04-24 10:20:00 | AAPL | Stock | 0.4439 | 0.4464 | 0.4405 | 0.4463 | 6507200.0 |
| 2001-04-24 10:25:00 | AAPL | Stock | 0.4463 | 0.4464 | 0.4411 | 0.4411 | 4776800.0 |
| 2001-04-24 10:30:00 | AAPL | Stock | 0.4411 | 0.4463 | 0.4411 | 0.4463 | 4972800.0 |
| 2001-04-24 10:35:00 | AAPL | Stock | 0.4459 | 0.4464 | 0.4441 | 0.4452 | 4345600.0 |
| 2001-04-24 10:40:00 | AAPL | Stock | 0.4454 | 0.4454 | 0.4434 | 0.4434 | 3108000.0 |
| 2001-04-24 10:45:00 | AAPL | Stock | 0.4436 | 0.4446 | 0.4404 | 0.4446 | 2016000.0 |
| 2001-04-24 10:50:00 | AAPL | Stock | 0.4445 | 0.4461 | 0.4441 | 0.4448 | 1573600.0 |
| 2001-04-24 10:55:00 | AAPL | Stock | 0.4448 | 0.4448 | 0.4405 | 0.4407 | 4782400.0 |
| 2001-04-24 11:00:00 | AAPL | Stock | 0.4407 | 0.4425 | 0.4405 | 0.4414 | 2469600.0 |
| 2001-04-24 11:05:00 | AAPL | Stock | 0.4414 | 0.4425 | 0.4393 | 0.4411 | 2234400.0 |
| 2001-04-24 11:10:00 | AAPL | Stock | 0.4416 | 0.4416 | 0.4393 | 0.4395 | 1635200.0 |
| 2001-04-24 11:15:00 | AAPL | Stock | 0.4404 | 0.4404 | 0.4377 | 0.4391 | 5140800.0 |
| 2001-04-24 11:20:00 | AAPL | Stock | 0.4379 | 0.4402 | 0.4379 | 0.4391 | 1467200.0 |
| 2001-04-24 11:25:00 | AAPL | Stock | 0.4388 | 0.4395 | 0.4377 | 0.4384 | 2234400.0 |
| 2001-04-24 11:30:00 | AAPL | Stock | 0.4389 | 0.4398 | 0.4384 | 0.4391 | 1909600.0 |
| 2001-04-24 11:35:00 | AAPL | Stock | 0.4391 | 0.4391 | 0.4375 | 0.4382 | 3365600.0 |
| 2001-04-24 11:40:00 | AAPL | Stock | 0.4382 | 0.4382 | 0.4357 | 0.4364 | 8075200.0 |
| 2001-04-24 11:45:00 | AAPL | Stock | 0.4368 | 0.4398 | 0.4368 | 0.4371 | 2240000.0 |
| 2001-04-24 11:50:00 | AAPL | Stock | 0.4371 | 0.4384 | 0.4357 | 0.4361 | 4300800.0 |
| 2001-04-24 11:55:00 | AAPL | Stock | 0.4363 | 0.437 | 0.4332 | 0.4339 | 3449600.0 |
| 2001-04-24 12:00:00 | AAPL | Stock | 0.4338 | 0.4338 | 0.4295 | 0.4302 | 9122400.0 |
| 2001-04-24 12:05:00 | AAPL | Stock | 0.4304 | 0.4313 | 0.4296 | 0.4296 | 4295200.0 |
| 2001-04-24 12:10:00 | AAPL | Stock | 0.4296 | 0.4305 | 0.4293 | 0.4302 | 4312000.0 |
| 2001-04-24 12:15:00 | AAPL | Stock | 0.4302 | 0.4334 | 0.4296 | 0.4327 | 2480800.0 |
| 2001-04-24 12:20:00 | AAPL | Stock | 0.4327 | 0.4339 | 0.4313 | 0.4327 | 1713600.0 |
| 2001-04-24 12:25:00 | AAPL | Stock | 0.4332 | 0.4366 | 0.4332 | 0.435 | 3416000.0 |
| 2001-04-24 12:30:00 | AAPL | Stock | 0.4354 | 0.4354 | 0.4334 | 0.4339 | 2004800.0 |
> showing 50 of 102,247 rows — these rows as CSV