PREVIEW / stock_1min / 2009-01-06
file: by_date/stock_1min/2009/2009-01-06.parquet size: 13.3 MB rows: 1,020,020 symbols: 2,697
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-06 05:44:00 | AAPL | Stock | 3.3925 | 3.3925 | 3.3925 | 3.3925 | 5600.0 |
| 2009-01-06 06:02:00 | AAPL | Stock | 3.4161 | 3.4161 | 3.4161 | 3.4161 | 19600.0 |
| 2009-01-06 07:01:00 | AAPL | Stock | 3.4357 | 3.4425 | 3.4357 | 3.4425 | 37632.0 |
| 2009-01-06 07:02:00 | AAPL | Stock | 3.4375 | 3.4561 | 3.4375 | 3.4561 | 50400.0 |
| 2009-01-06 07:03:00 | AAPL | Stock | 3.4561 | 3.4561 | 3.4561 | 3.4561 | 140000.0 |
| 2009-01-06 07:05:00 | AAPL | Stock | 3.4561 | 3.4643 | 3.4561 | 3.4643 | 33600.0 |
| 2009-01-06 07:06:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 179200.0 |
| 2009-01-06 07:07:00 | AAPL | Stock | 3.4643 | 3.4643 | 3.4643 | 3.4643 | 13860.0 |
| 2009-01-06 07:17:00 | AAPL | Stock | 3.4357 | 3.4357 | 3.4321 | 3.4321 | 140000.0 |
| 2009-01-06 07:18:00 | AAPL | Stock | 3.4357 | 3.4357 | 3.4357 | 3.4357 | 22288.0 |
| 2009-01-06 07:19:00 | AAPL | Stock | 3.4561 | 3.4561 | 3.4561 | 3.4561 | 4200.0 |
| 2009-01-06 07:20:00 | AAPL | Stock | 3.4357 | 3.4357 | 3.4271 | 3.4286 | 296044.0 |
| 2009-01-06 07:25:00 | AAPL | Stock | 3.4389 | 3.4389 | 3.4214 | 3.4214 | 16800.0 |
| 2009-01-06 07:26:00 | AAPL | Stock | 3.425 | 3.4386 | 3.425 | 3.4386 | 26600.0 |
| 2009-01-06 07:27:00 | AAPL | Stock | 3.4214 | 3.4232 | 3.4214 | 3.4232 | 28000.0 |
| 2009-01-06 07:28:00 | AAPL | Stock | 3.4354 | 3.4368 | 3.425 | 3.425 | 28000.0 |
| 2009-01-06 07:30:00 | AAPL | Stock | 3.4268 | 3.4268 | 3.4268 | 3.4268 | 2800.0 |
| 2009-01-06 07:31:00 | AAPL | Stock | 3.4268 | 3.4268 | 3.4268 | 3.4268 | 10920.0 |
| 2009-01-06 07:32:00 | AAPL | Stock | 3.4336 | 3.4336 | 3.4336 | 3.4336 | 2800.0 |
| 2009-01-06 07:33:00 | AAPL | Stock | 3.4239 | 3.4239 | 3.4236 | 3.4236 | 5600.0 |
| 2009-01-06 07:34:00 | AAPL | Stock | 3.4232 | 3.4236 | 3.4232 | 3.4236 | 35000.0 |
| 2009-01-06 07:35:00 | AAPL | Stock | 3.4236 | 3.4339 | 3.4236 | 3.4339 | 207620.0 |
| 2009-01-06 07:36:00 | AAPL | Stock | 3.4339 | 3.4339 | 3.4304 | 3.4304 | 35700.0 |
| 2009-01-06 07:37:00 | AAPL | Stock | 3.4321 | 3.4321 | 3.4321 | 3.4321 | 14000.0 |
| 2009-01-06 07:42:00 | AAPL | Stock | 3.435 | 3.4357 | 3.435 | 3.4357 | 47600.0 |
| 2009-01-06 07:47:00 | AAPL | Stock | 3.4357 | 3.4357 | 3.4357 | 3.4357 | 5600.0 |
| 2009-01-06 07:50:00 | AAPL | Stock | 3.4354 | 3.4354 | 3.4354 | 3.4354 | 5600.0 |
| 2009-01-06 07:51:00 | AAPL | Stock | 3.4354 | 3.4354 | 3.4354 | 3.4354 | 5376.0 |
| 2009-01-06 07:55:00 | AAPL | Stock | 3.4354 | 3.4354 | 3.4354 | 3.4354 | 6160.0 |
| 2009-01-06 07:56:00 | AAPL | Stock | 3.4343 | 3.4354 | 3.4343 | 3.4354 | 5600.0 |
| 2009-01-06 07:57:00 | AAPL | Stock | 3.4339 | 3.4354 | 3.4286 | 3.4339 | 88200.0 |
| 2009-01-06 07:59:00 | AAPL | Stock | 3.435 | 3.435 | 3.435 | 3.435 | 5600.0 |
| 2009-01-06 08:00:00 | AAPL | Stock | 3.4346 | 3.4354 | 3.4286 | 3.4336 | 471744.0 |
| 2009-01-06 08:01:00 | AAPL | Stock | 3.4332 | 3.4332 | 3.4289 | 3.4318 | 126000.0 |
| 2009-01-06 08:02:00 | AAPL | Stock | 3.4318 | 3.4318 | 3.4318 | 3.4318 | 16800.0 |
| 2009-01-06 08:03:00 | AAPL | Stock | 3.4318 | 3.4321 | 3.4318 | 3.4321 | 125720.0 |
| 2009-01-06 08:04:00 | AAPL | Stock | 3.4321 | 3.4321 | 3.4304 | 3.4321 | 173600.0 |
| 2009-01-06 08:05:00 | AAPL | Stock | 3.4321 | 3.4332 | 3.4318 | 3.4332 | 73080.0 |
| 2009-01-06 08:06:00 | AAPL | Stock | 3.4336 | 3.435 | 3.4329 | 3.4339 | 53200.0 |
| 2009-01-06 08:07:00 | AAPL | Stock | 3.4336 | 3.4357 | 3.4336 | 3.4343 | 160468.0 |
| 2009-01-06 08:08:00 | AAPL | Stock | 3.4354 | 3.4375 | 3.435 | 3.4375 | 207452.0 |
| 2009-01-06 08:09:00 | AAPL | Stock | 3.4375 | 3.4375 | 3.4357 | 3.4371 | 114800.0 |
| 2009-01-06 08:10:00 | AAPL | Stock | 3.4375 | 3.4375 | 3.4339 | 3.4346 | 132356.0 |
| 2009-01-06 08:11:00 | AAPL | Stock | 3.4346 | 3.4357 | 3.4321 | 3.4321 | 70532.0 |
| 2009-01-06 08:12:00 | AAPL | Stock | 3.4321 | 3.4339 | 3.4321 | 3.4321 | 32340.0 |
| 2009-01-06 08:13:00 | AAPL | Stock | 3.4354 | 3.4354 | 3.4354 | 3.4354 | 42140.0 |
| 2009-01-06 08:14:00 | AAPL | Stock | 3.4357 | 3.4393 | 3.4357 | 3.4393 | 113848.0 |
| 2009-01-06 08:15:00 | AAPL | Stock | 3.4393 | 3.4393 | 3.4386 | 3.4386 | 84840.0 |
| 2009-01-06 08:16:00 | AAPL | Stock | 3.4393 | 3.44 | 3.4393 | 3.44 | 23100.0 |
| 2009-01-06 08:17:00 | AAPL | Stock | 3.44 | 3.44 | 3.4375 | 3.4375 | 39760.0 |
> showing 50 of 1,020,020 rows — these rows as CSV