PREVIEW / stock_1min / 2007-11-29
file: by_date/stock_1min/2007/2007-11-29.parquet size: 11.9 MB rows: 972,566 symbols: 2,613
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 |
|---|---|---|---|---|---|---|---|
| 2007-11-29 04:36:00 | AAPL | Stock | 6.4625 | 6.4625 | 6.4625 | 6.4625 | 2800.0 |
| 2007-11-29 04:37:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4643 | 6.4643 | 2800.0 |
| 2007-11-29 04:55:00 | AAPL | Stock | 6.4461 | 6.4461 | 6.4461 | 6.4461 | 5600.0 |
| 2007-11-29 05:05:00 | AAPL | Stock | 6.4339 | 6.4339 | 6.4339 | 6.4339 | 11200.0 |
| 2007-11-29 05:22:00 | AAPL | Stock | 6.4304 | 6.4304 | 6.4304 | 6.4304 | 2800.0 |
| 2007-11-29 06:04:00 | AAPL | Stock | 6.4304 | 6.4304 | 6.4304 | 6.4304 | 2800.0 |
| 2007-11-29 06:12:00 | AAPL | Stock | 6.4218 | 6.4218 | 6.4218 | 6.4218 | 8400.0 |
| 2007-11-29 07:02:00 | AAPL | Stock | 6.4271 | 6.4271 | 6.4271 | 6.4271 | 2800.0 |
| 2007-11-29 07:04:00 | AAPL | Stock | 6.4143 | 6.4143 | 6.4143 | 6.4143 | 8120.0 |
| 2007-11-29 07:10:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 14000.0 |
| 2007-11-29 07:11:00 | AAPL | Stock | 6.4086 | 6.4086 | 6.4025 | 6.4071 | 8400.0 |
| 2007-11-29 07:12:00 | AAPL | Stock | 6.4071 | 6.4071 | 6.4071 | 6.4071 | 2800.0 |
| 2007-11-29 07:14:00 | AAPL | Stock | 6.4071 | 6.4071 | 6.4071 | 6.4071 | 5600.0 |
| 2007-11-29 07:18:00 | AAPL | Stock | 6.4264 | 6.4264 | 6.4264 | 6.4264 | 3500.0 |
| 2007-11-29 07:22:00 | AAPL | Stock | 6.4107 | 6.4107 | 6.4107 | 6.4107 | 8400.0 |
| 2007-11-29 07:31:00 | AAPL | Stock | 6.4114 | 6.4114 | 6.4114 | 6.4114 | 2800.0 |
| 2007-11-29 07:32:00 | AAPL | Stock | 6.4114 | 6.4114 | 6.4114 | 6.4114 | 5600.0 |
| 2007-11-29 07:43:00 | AAPL | Stock | 6.4107 | 6.4286 | 6.4107 | 6.4286 | 181944.0 |
| 2007-11-29 07:47:00 | AAPL | Stock | 6.425 | 6.4304 | 6.425 | 6.4304 | 40852.0 |
| 2007-11-29 07:48:00 | AAPL | Stock | 6.4304 | 6.4304 | 6.4304 | 6.4304 | 11200.0 |
| 2007-11-29 07:50:00 | AAPL | Stock | 6.4304 | 6.4304 | 6.4214 | 6.4214 | 11200.0 |
| 2007-11-29 07:51:00 | AAPL | Stock | 6.4304 | 6.4304 | 6.4304 | 6.4304 | 2800.0 |
| 2007-11-29 07:53:00 | AAPL | Stock | 6.4364 | 6.4364 | 6.4364 | 6.4364 | 5600.0 |
| 2007-11-29 07:54:00 | AAPL | Stock | 6.4443 | 6.4443 | 6.4443 | 6.4443 | 13720.0 |
| 2007-11-29 07:55:00 | AAPL | Stock | 6.4429 | 6.4429 | 6.4429 | 6.4429 | 14000.0 |
| 2007-11-29 07:56:00 | AAPL | Stock | 6.4429 | 6.4536 | 6.4429 | 6.4536 | 53200.0 |
| 2007-11-29 07:58:00 | AAPL | Stock | 6.45 | 6.4539 | 6.45 | 6.4539 | 14000.0 |
| 2007-11-29 08:00:00 | AAPL | Stock | 6.45 | 6.45 | 6.4329 | 6.4329 | 351064.0 |
| 2007-11-29 08:01:00 | AAPL | Stock | 6.4421 | 6.4421 | 6.4375 | 6.4375 | 25200.0 |
| 2007-11-29 08:02:00 | AAPL | Stock | 6.4411 | 6.4411 | 6.4411 | 6.4411 | 4200.0 |
| 2007-11-29 08:03:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4429 | 6.4429 | 25060.0 |
| 2007-11-29 08:04:00 | AAPL | Stock | 6.4439 | 6.4468 | 6.4429 | 6.4429 | 139972.0 |
| 2007-11-29 08:05:00 | AAPL | Stock | 6.4429 | 6.4429 | 6.4429 | 6.4429 | 98924.0 |
| 2007-11-29 08:06:00 | AAPL | Stock | 6.4425 | 6.4425 | 6.4339 | 6.4339 | 16800.0 |
| 2007-11-29 08:07:00 | AAPL | Stock | 6.4361 | 6.4375 | 6.4286 | 6.4371 | 101640.0 |
| 2007-11-29 08:08:00 | AAPL | Stock | 6.4289 | 6.4346 | 6.4286 | 6.4346 | 102676.0 |
| 2007-11-29 08:09:00 | AAPL | Stock | 6.4325 | 6.4379 | 6.4325 | 6.4364 | 19600.0 |
| 2007-11-29 08:10:00 | AAPL | Stock | 6.4375 | 6.4375 | 6.4364 | 6.4364 | 19600.0 |
| 2007-11-29 08:11:00 | AAPL | Stock | 6.4364 | 6.4364 | 6.4364 | 6.4364 | 6552.0 |
| 2007-11-29 08:13:00 | AAPL | Stock | 6.4368 | 6.4411 | 6.4368 | 6.4411 | 11200.0 |
| 2007-11-29 08:14:00 | AAPL | Stock | 6.4411 | 6.4464 | 6.4411 | 6.4446 | 67060.0 |
| 2007-11-29 08:15:00 | AAPL | Stock | 6.4432 | 6.4461 | 6.4429 | 6.4446 | 46480.0 |
| 2007-11-29 08:16:00 | AAPL | Stock | 6.4411 | 6.4446 | 6.4411 | 6.4446 | 18480.0 |
| 2007-11-29 08:17:00 | AAPL | Stock | 6.4411 | 6.4411 | 6.4375 | 6.4375 | 8400.0 |
| 2007-11-29 08:18:00 | AAPL | Stock | 6.4364 | 6.44 | 6.4357 | 6.4357 | 23772.0 |
| 2007-11-29 08:19:00 | AAPL | Stock | 6.4357 | 6.4364 | 6.4357 | 6.4364 | 25200.0 |
| 2007-11-29 08:20:00 | AAPL | Stock | 6.4364 | 6.4364 | 6.4286 | 6.4321 | 399084.0 |
| 2007-11-29 08:21:00 | AAPL | Stock | 6.4325 | 6.4325 | 6.4286 | 6.4286 | 72800.0 |
| 2007-11-29 08:22:00 | AAPL | Stock | 6.4304 | 6.4339 | 6.4257 | 6.4257 | 67424.0 |
| 2007-11-29 08:23:00 | AAPL | Stock | 6.4257 | 6.4286 | 6.4221 | 6.4221 | 398020.0 |
> showing 50 of 972,566 rows — these rows as CSV