PREVIEW / stock_1min / 2008-05-23
file: by_date/stock_1min/2008/2008-05-23.parquet size: 11.9 MB rows: 961,458 symbols: 2,674
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-23 04:16:00 | AAPL | Stock | 6.4079 | 6.4079 | 6.4079 | 6.4079 | 25200.0 |
| 2008-05-23 04:22:00 | AAPL | Stock | 6.4086 | 6.4086 | 6.3739 | 6.3739 | 30800.0 |
| 2008-05-23 04:30:00 | AAPL | Stock | 6.4214 | 6.425 | 6.4214 | 6.425 | 78400.0 |
| 2008-05-23 05:19:00 | AAPL | Stock | 6.4268 | 6.4268 | 6.4268 | 6.4268 | 2800.0 |
| 2008-05-23 05:22:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 2800.0 |
| 2008-05-23 05:37:00 | AAPL | Stock | 6.4179 | 6.4179 | 6.4179 | 6.4179 | 2800.0 |
| 2008-05-23 05:50:00 | AAPL | Stock | 6.3982 | 6.3982 | 6.3982 | 6.3982 | 13468.0 |
| 2008-05-23 06:09:00 | AAPL | Stock | 6.4286 | 6.4286 | 6.4286 | 6.4286 | 2800.0 |
| 2008-05-23 06:34:00 | AAPL | Stock | 6.4125 | 6.4125 | 6.4125 | 6.4125 | 112000.0 |
| 2008-05-23 06:35:00 | AAPL | Stock | 6.4246 | 6.4246 | 6.4246 | 6.4246 | 5852.0 |
| 2008-05-23 06:39:00 | AAPL | Stock | 6.4246 | 6.425 | 6.4246 | 6.425 | 111300.0 |
| 2008-05-23 06:40:00 | AAPL | Stock | 6.4282 | 6.4286 | 6.4282 | 6.4286 | 135800.0 |
| 2008-05-23 06:41:00 | AAPL | Stock | 6.4289 | 6.4289 | 6.4286 | 6.4286 | 100800.0 |
| 2008-05-23 06:42:00 | AAPL | Stock | 6.4286 | 6.4286 | 6.4286 | 6.4286 | 2800.0 |
| 2008-05-23 06:43:00 | AAPL | Stock | 6.4214 | 6.4214 | 6.4214 | 6.4214 | 2800.0 |
| 2008-05-23 06:45:00 | AAPL | Stock | 6.425 | 6.425 | 6.425 | 6.425 | 14000.0 |
| 2008-05-23 06:51:00 | AAPL | Stock | 6.4339 | 6.4339 | 6.4339 | 6.4339 | 6440.0 |
| 2008-05-23 06:54:00 | AAPL | Stock | 6.4321 | 6.4357 | 6.4321 | 6.4357 | 15960.0 |
| 2008-05-23 07:01:00 | AAPL | Stock | 6.4179 | 6.4186 | 6.4179 | 6.4186 | 19600.0 |
| 2008-05-23 07:03:00 | AAPL | Stock | 6.4196 | 6.4196 | 6.4196 | 6.4196 | 56000.0 |
| 2008-05-23 07:04:00 | AAPL | Stock | 6.4214 | 6.4232 | 6.4196 | 6.4214 | 56000.0 |
| 2008-05-23 07:07:00 | AAPL | Stock | 6.4254 | 6.4254 | 6.425 | 6.425 | 14000.0 |
| 2008-05-23 07:09:00 | AAPL | Stock | 6.4357 | 6.4393 | 6.4357 | 6.4393 | 16800.0 |
| 2008-05-23 07:11:00 | AAPL | Stock | 6.4454 | 6.4457 | 6.4393 | 6.4393 | 56000.0 |
| 2008-05-23 07:12:00 | AAPL | Stock | 6.4457 | 6.4464 | 6.4393 | 6.4393 | 24332.0 |
| 2008-05-23 07:13:00 | AAPL | Stock | 6.4429 | 6.4461 | 6.4429 | 6.4461 | 28000.0 |
| 2008-05-23 07:14:00 | AAPL | Stock | 6.4461 | 6.4461 | 6.4393 | 6.4393 | 109200.0 |
| 2008-05-23 07:15:00 | AAPL | Stock | 6.4393 | 6.4464 | 6.4393 | 6.4464 | 33600.0 |
| 2008-05-23 07:17:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4464 | 6.4464 | 16800.0 |
| 2008-05-23 07:18:00 | AAPL | Stock | 6.4461 | 6.4464 | 6.4461 | 6.4464 | 7000.0 |
| 2008-05-23 07:19:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4461 | 6.4461 | 16800.0 |
| 2008-05-23 07:20:00 | AAPL | Stock | 6.4436 | 6.4436 | 6.4393 | 6.4393 | 11200.0 |
| 2008-05-23 07:21:00 | AAPL | Stock | 6.4429 | 6.4429 | 6.4429 | 6.4429 | 2800.0 |
| 2008-05-23 07:26:00 | AAPL | Stock | 6.4357 | 6.4425 | 6.4357 | 6.4425 | 14000.0 |
| 2008-05-23 07:27:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4457 | 6.4457 | 81200.0 |
| 2008-05-23 07:28:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4464 | 6.4464 | 92568.0 |
| 2008-05-23 07:29:00 | AAPL | Stock | 6.4554 | 6.4554 | 6.45 | 6.45 | 33600.0 |
| 2008-05-23 07:31:00 | AAPL | Stock | 6.45 | 6.45 | 6.45 | 6.45 | 8400.0 |
| 2008-05-23 07:32:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4464 | 6.4464 | 14000.0 |
| 2008-05-23 07:33:00 | AAPL | Stock | 6.4482 | 6.4482 | 6.4471 | 6.4471 | 16800.0 |
| 2008-05-23 07:35:00 | AAPL | Stock | 6.4507 | 6.4507 | 6.4504 | 6.4504 | 5600.0 |
| 2008-05-23 07:36:00 | AAPL | Stock | 6.455 | 6.4554 | 6.4511 | 6.4554 | 36092.0 |
| 2008-05-23 07:37:00 | AAPL | Stock | 6.4554 | 6.4643 | 6.4554 | 6.4643 | 375200.0 |
| 2008-05-23 07:38:00 | AAPL | Stock | 6.4614 | 6.4643 | 6.4614 | 6.4643 | 126308.0 |
| 2008-05-23 07:39:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4643 | 6.4643 | 39200.0 |
| 2008-05-23 07:40:00 | AAPL | Stock | 6.4643 | 6.4654 | 6.4614 | 6.4614 | 23380.0 |
| 2008-05-23 07:41:00 | AAPL | Stock | 6.4675 | 6.4675 | 6.4675 | 6.4675 | 5600.0 |
| 2008-05-23 07:42:00 | AAPL | Stock | 6.465 | 6.4661 | 6.465 | 6.4661 | 8400.0 |
| 2008-05-23 07:43:00 | AAPL | Stock | 6.4675 | 6.4679 | 6.4636 | 6.4643 | 44800.0 |
| 2008-05-23 07:44:00 | AAPL | Stock | 6.4661 | 6.4661 | 6.4643 | 6.4643 | 61600.0 |
> showing 50 of 961,458 rows — these rows as CSV