PREVIEW / stock_5min / 2011-07-06
file: by_date/stock_5min/2011/2011-07-06.parquet size: 4.8 MB rows: 332,238 symbols: 3,533
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-06 04:20:00 | AAPL | Stock | 12.4129 | 12.4129 | 12.4129 | 12.4129 | 2800.0 |
| 2011-07-06 05:05:00 | AAPL | Stock | 12.4325 | 12.4325 | 12.4325 | 12.4325 | 2800.0 |
| 2011-07-06 05:20:00 | AAPL | Stock | 12.4089 | 12.4089 | 12.4089 | 12.4089 | 2800.0 |
| 2011-07-06 05:25:00 | AAPL | Stock | 12.4089 | 12.4089 | 12.4089 | 12.4089 | 2800.0 |
| 2011-07-06 06:10:00 | AAPL | Stock | 12.4375 | 12.4375 | 12.4375 | 12.4375 | 2800.0 |
| 2011-07-06 06:35:00 | AAPL | Stock | 12.4218 | 12.4218 | 12.4214 | 12.4214 | 11900.0 |
| 2011-07-06 06:45:00 | AAPL | Stock | 12.4239 | 12.4239 | 12.4239 | 12.4239 | 2800.0 |
| 2011-07-06 06:50:00 | AAPL | Stock | 12.4214 | 12.4432 | 12.4214 | 12.4432 | 14000.0 |
| 2011-07-06 07:00:00 | AAPL | Stock | 12.4639 | 12.4925 | 12.4639 | 12.4889 | 30800.0 |
| 2011-07-06 07:05:00 | AAPL | Stock | 12.4511 | 12.4511 | 12.45 | 12.45 | 25200.0 |
| 2011-07-06 07:10:00 | AAPL | Stock | 12.4436 | 12.4436 | 12.4436 | 12.4436 | 5600.0 |
| 2011-07-06 07:15:00 | AAPL | Stock | 12.4432 | 12.4432 | 12.4357 | 12.4357 | 30240.0 |
| 2011-07-06 07:25:00 | AAPL | Stock | 12.4464 | 12.4607 | 12.4464 | 12.4607 | 25200.0 |
| 2011-07-06 07:30:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 19600.0 |
| 2011-07-06 07:35:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4404 | 12.4404 | 11200.0 |
| 2011-07-06 07:40:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4393 | 12.4393 | 14000.0 |
| 2011-07-06 07:50:00 | AAPL | Stock | 12.4386 | 12.4386 | 12.4321 | 12.4339 | 26460.0 |
| 2011-07-06 07:55:00 | AAPL | Stock | 12.4346 | 12.4346 | 12.4346 | 12.4346 | 5600.0 |
| 2011-07-06 08:00:00 | AAPL | Stock | 12.4446 | 12.4536 | 12.4361 | 12.45 | 119280.0 |
| 2011-07-06 08:05:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4339 | 12.4339 | 155260.0 |
| 2011-07-06 08:10:00 | AAPL | Stock | 12.4389 | 12.4389 | 12.4325 | 12.4357 | 16940.0 |
| 2011-07-06 08:15:00 | AAPL | Stock | 12.4357 | 12.4375 | 12.4357 | 12.4375 | 33880.0 |
| 2011-07-06 08:20:00 | AAPL | Stock | 12.4364 | 12.4375 | 12.4321 | 12.4321 | 42112.0 |
| 2011-07-06 08:25:00 | AAPL | Stock | 12.4339 | 12.4371 | 12.4336 | 12.4368 | 21924.0 |
| 2011-07-06 08:30:00 | AAPL | Stock | 12.4354 | 12.4354 | 12.4354 | 12.4354 | 2800.0 |
| 2011-07-06 08:35:00 | AAPL | Stock | 12.4357 | 12.4375 | 12.4339 | 12.4339 | 56840.0 |
| 2011-07-06 08:40:00 | AAPL | Stock | 12.4343 | 12.4393 | 12.4339 | 12.4393 | 52220.0 |
| 2011-07-06 08:45:00 | AAPL | Stock | 12.4429 | 12.4446 | 12.4393 | 12.44 | 42784.0 |
| 2011-07-06 08:50:00 | AAPL | Stock | 12.4439 | 12.4857 | 12.4414 | 12.4857 | 371028.0 |
| 2011-07-06 08:55:00 | AAPL | Stock | 12.4857 | 12.4857 | 12.4732 | 12.4768 | 121296.0 |
| 2011-07-06 09:00:00 | AAPL | Stock | 12.4786 | 12.4864 | 12.4661 | 12.4804 | 216272.0 |
| 2011-07-06 09:05:00 | AAPL | Stock | 12.4718 | 12.4718 | 12.4546 | 12.455 | 108864.0 |
| 2011-07-06 09:10:00 | AAPL | Stock | 12.4589 | 12.4604 | 12.4539 | 12.4604 | 14000.0 |
| 2011-07-06 09:15:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4639 | 12.4639 | 11200.0 |
| 2011-07-06 09:20:00 | AAPL | Stock | 12.4643 | 12.4679 | 12.4643 | 12.4643 | 26096.0 |
| 2011-07-06 09:25:00 | AAPL | Stock | 12.4643 | 12.4675 | 12.4571 | 12.4643 | 100800.0 |
| 2011-07-06 09:30:00 | AAPL | Stock | 12.4625 | 12.4875 | 12.4321 | 12.4611 | 12524456.0 |
| 2011-07-06 09:35:00 | AAPL | Stock | 12.4589 | 12.4768 | 12.4371 | 12.4379 | 8914500.0 |
| 2011-07-06 09:40:00 | AAPL | Stock | 12.439 | 12.4671 | 12.4321 | 12.4382 | 7097188.0 |
| 2011-07-06 09:45:00 | AAPL | Stock | 12.4368 | 12.4532 | 12.4257 | 12.4289 | 9573872.0 |
| 2011-07-06 09:50:00 | AAPL | Stock | 12.4289 | 12.4375 | 12.41 | 12.4211 | 7148988.0 |
| 2011-07-06 09:55:00 | AAPL | Stock | 12.4225 | 12.4343 | 12.4179 | 12.4318 | 3519152.0 |
| 2011-07-06 10:00:00 | AAPL | Stock | 12.4314 | 12.4421 | 12.3929 | 12.3993 | 9894024.0 |
| 2011-07-06 10:05:00 | AAPL | Stock | 12.4 | 12.4043 | 12.3825 | 12.4018 | 6480180.0 |
| 2011-07-06 10:10:00 | AAPL | Stock | 12.4019 | 12.4179 | 12.3964 | 12.4061 | 5759460.0 |
| 2011-07-06 10:15:00 | AAPL | Stock | 12.4057 | 12.42 | 12.4007 | 12.4132 | 4873960.0 |
| 2011-07-06 10:20:00 | AAPL | Stock | 12.4114 | 12.4371 | 12.4096 | 12.437 | 4806312.0 |
| 2011-07-06 10:25:00 | AAPL | Stock | 12.4369 | 12.4371 | 12.4261 | 12.4267 | 3501960.0 |
| 2011-07-06 10:30:00 | AAPL | Stock | 12.4286 | 12.4454 | 12.4279 | 12.4441 | 3085768.0 |
| 2011-07-06 10:35:00 | AAPL | Stock | 12.4432 | 12.4525 | 12.4343 | 12.4464 | 4154668.0 |
> showing 50 of 332,238 rows — these rows as CSV