PREVIEW / stock_1min / 2001-07-16
file: by_date/stock_1min/2001/2001-07-16.parquet size: 3.2 MB rows: 262,987 symbols: 1,078
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-16 08:12:00 | AAPL | Stock | 0.4402 | 0.4425 | 0.4402 | 0.4425 | 56000.0 |
| 2001-07-16 08:34:00 | AAPL | Stock | 0.4286 | 0.4438 | 0.4286 | 0.4425 | 39200.0 |
| 2001-07-16 09:06:00 | AAPL | Stock | 0.4439 | 0.4439 | 0.4439 | 0.4439 | 56000.0 |
| 2001-07-16 09:24:00 | AAPL | Stock | 0.4446 | 0.4448 | 0.4446 | 0.4448 | 61600.0 |
| 2001-07-16 09:26:00 | AAPL | Stock | 0.4446 | 0.4446 | 0.4446 | 0.4446 | 56000.0 |
| 2001-07-16 09:27:00 | AAPL | Stock | 0.4445 | 0.4446 | 0.4445 | 0.4446 | 61600.0 |
| 2001-07-16 09:28:00 | AAPL | Stock | 0.4446 | 0.4446 | 0.4445 | 0.4445 | 196000.0 |
| 2001-07-16 09:30:00 | AAPL | Stock | 0.4443 | 0.4446 | 0.4436 | 0.4438 | 3320800.0 |
| 2001-07-16 09:31:00 | AAPL | Stock | 0.4438 | 0.4443 | 0.4425 | 0.4439 | 464800.0 |
| 2001-07-16 09:32:00 | AAPL | Stock | 0.4439 | 0.4461 | 0.4436 | 0.4461 | 1237600.0 |
| 2001-07-16 09:33:00 | AAPL | Stock | 0.4461 | 0.4468 | 0.4455 | 0.4457 | 4519200.0 |
| 2001-07-16 09:34:00 | AAPL | Stock | 0.4457 | 0.4464 | 0.4457 | 0.4464 | 638400.0 |
| 2001-07-16 09:35:00 | AAPL | Stock | 0.4464 | 0.4468 | 0.4446 | 0.4464 | 3315200.0 |
| 2001-07-16 09:36:00 | AAPL | Stock | 0.4463 | 0.4473 | 0.4461 | 0.4471 | 3203200.0 |
| 2001-07-16 09:37:00 | AAPL | Stock | 0.4473 | 0.4477 | 0.4471 | 0.4477 | 1215200.0 |
| 2001-07-16 09:38:00 | AAPL | Stock | 0.4477 | 0.4482 | 0.4471 | 0.4471 | 1411200.0 |
| 2001-07-16 09:39:00 | AAPL | Stock | 0.4471 | 0.4473 | 0.447 | 0.4473 | 784000.0 |
| 2001-07-16 09:40:00 | AAPL | Stock | 0.4473 | 0.4482 | 0.4468 | 0.4468 | 1041600.0 |
| 2001-07-16 09:41:00 | AAPL | Stock | 0.4464 | 0.4466 | 0.4443 | 0.4443 | 2402400.0 |
| 2001-07-16 09:42:00 | AAPL | Stock | 0.4443 | 0.4446 | 0.4432 | 0.4438 | 828800.0 |
| 2001-07-16 09:43:00 | AAPL | Stock | 0.4446 | 0.4454 | 0.4416 | 0.4418 | 834400.0 |
| 2001-07-16 09:44:00 | AAPL | Stock | 0.4414 | 0.4418 | 0.4404 | 0.4414 | 722400.0 |
| 2001-07-16 09:45:00 | AAPL | Stock | 0.4411 | 0.4425 | 0.44 | 0.442 | 3572800.0 |
| 2001-07-16 09:46:00 | AAPL | Stock | 0.4421 | 0.4429 | 0.4413 | 0.4414 | 548800.0 |
| 2001-07-16 09:47:00 | AAPL | Stock | 0.4414 | 0.4416 | 0.4404 | 0.4413 | 940800.0 |
| 2001-07-16 09:48:00 | AAPL | Stock | 0.4416 | 0.4416 | 0.4393 | 0.4393 | 666400.0 |
| 2001-07-16 09:49:00 | AAPL | Stock | 0.4393 | 0.4398 | 0.4391 | 0.4398 | 884800.0 |
| 2001-07-16 09:50:00 | AAPL | Stock | 0.4398 | 0.44 | 0.4393 | 0.4393 | 571200.0 |
| 2001-07-16 09:51:00 | AAPL | Stock | 0.4391 | 0.4393 | 0.4373 | 0.4377 | 1652000.0 |
| 2001-07-16 09:52:00 | AAPL | Stock | 0.4371 | 0.4371 | 0.4352 | 0.4359 | 2217600.0 |
| 2001-07-16 09:53:00 | AAPL | Stock | 0.4359 | 0.4361 | 0.4348 | 0.435 | 1086400.0 |
| 2001-07-16 09:54:00 | AAPL | Stock | 0.4352 | 0.4363 | 0.435 | 0.4361 | 2094400.0 |
| 2001-07-16 09:55:00 | AAPL | Stock | 0.4361 | 0.4366 | 0.4359 | 0.4363 | 1680000.0 |
| 2001-07-16 09:56:00 | AAPL | Stock | 0.4363 | 0.4371 | 0.4361 | 0.4366 | 1344000.0 |
| 2001-07-16 09:57:00 | AAPL | Stock | 0.4368 | 0.4368 | 0.4355 | 0.4359 | 2032800.0 |
| 2001-07-16 09:58:00 | AAPL | Stock | 0.4355 | 0.4366 | 0.4354 | 0.4363 | 319200.0 |
| 2001-07-16 09:59:00 | AAPL | Stock | 0.4355 | 0.4363 | 0.4341 | 0.4348 | 907200.0 |
| 2001-07-16 10:00:00 | AAPL | Stock | 0.4348 | 0.435 | 0.4339 | 0.4339 | 784000.0 |
| 2001-07-16 10:01:00 | AAPL | Stock | 0.4339 | 0.4339 | 0.4329 | 0.4338 | 1204000.0 |
| 2001-07-16 10:02:00 | AAPL | Stock | 0.4332 | 0.4343 | 0.433 | 0.4339 | 504000.0 |
| 2001-07-16 10:03:00 | AAPL | Stock | 0.4332 | 0.435 | 0.4332 | 0.435 | 761600.0 |
| 2001-07-16 10:04:00 | AAPL | Stock | 0.4348 | 0.4348 | 0.433 | 0.4345 | 946400.0 |
| 2001-07-16 10:05:00 | AAPL | Stock | 0.435 | 0.435 | 0.4341 | 0.4346 | 369600.0 |
| 2001-07-16 10:06:00 | AAPL | Stock | 0.4348 | 0.4357 | 0.4348 | 0.4348 | 470400.0 |
| 2001-07-16 10:07:00 | AAPL | Stock | 0.4357 | 0.4357 | 0.4334 | 0.4334 | 582400.0 |
| 2001-07-16 10:08:00 | AAPL | Stock | 0.4338 | 0.435 | 0.4334 | 0.4345 | 190400.0 |
| 2001-07-16 10:09:00 | AAPL | Stock | 0.4348 | 0.4352 | 0.4339 | 0.4341 | 302400.0 |
| 2001-07-16 10:10:00 | AAPL | Stock | 0.4343 | 0.4352 | 0.4343 | 0.4343 | 649600.0 |
| 2001-07-16 10:11:00 | AAPL | Stock | 0.4339 | 0.4341 | 0.4332 | 0.4334 | 240800.0 |
| 2001-07-16 10:12:00 | AAPL | Stock | 0.4332 | 0.4348 | 0.4332 | 0.4348 | 599200.0 |
> showing 50 of 262,987 rows — these rows as CSV