PREVIEW / stock_1min / 2004-09-09
file: by_date/stock_1min/2004/2004-09-09.parquet size: 6.1 MB rows: 518,831 symbols: 1,501
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-09 08:00:00 | AAPL | Stock | 0.6366 | 0.6393 | 0.6366 | 0.6384 | 28000.0 |
| 2004-09-09 08:01:00 | AAPL | Stock | 0.6352 | 0.6393 | 0.632 | 0.6373 | 257600.0 |
| 2004-09-09 08:02:00 | AAPL | Stock | 0.6375 | 0.6382 | 0.6375 | 0.6382 | 16800.0 |
| 2004-09-09 08:03:00 | AAPL | Stock | 0.6382 | 0.6382 | 0.6382 | 0.6382 | 28000.0 |
| 2004-09-09 08:04:00 | AAPL | Stock | 0.64 | 0.6402 | 0.64 | 0.6402 | 44800.0 |
| 2004-09-09 08:05:00 | AAPL | Stock | 0.6389 | 0.6389 | 0.6357 | 0.6375 | 134960.0 |
| 2004-09-09 08:08:00 | AAPL | Stock | 0.6393 | 0.6393 | 0.6393 | 0.6393 | 11200.0 |
| 2004-09-09 08:09:00 | AAPL | Stock | 0.6402 | 0.6402 | 0.6402 | 0.6402 | 11200.0 |
| 2004-09-09 08:11:00 | AAPL | Stock | 0.6402 | 0.6409 | 0.6398 | 0.6409 | 67984.0 |
| 2004-09-09 08:13:00 | AAPL | Stock | 0.6391 | 0.6391 | 0.6389 | 0.6389 | 33600.0 |
| 2004-09-09 08:17:00 | AAPL | Stock | 0.6391 | 0.6393 | 0.6384 | 0.6384 | 128800.0 |
| 2004-09-09 08:20:00 | AAPL | Stock | 0.6377 | 0.6377 | 0.6377 | 0.6377 | 56000.0 |
| 2004-09-09 08:24:00 | AAPL | Stock | 0.6366 | 0.6366 | 0.6357 | 0.6366 | 398888.0 |
| 2004-09-09 08:27:00 | AAPL | Stock | 0.6366 | 0.6366 | 0.6366 | 0.6366 | 56000.0 |
| 2004-09-09 08:29:00 | AAPL | Stock | 0.6357 | 0.6366 | 0.6357 | 0.6357 | 100240.0 |
| 2004-09-09 08:30:00 | AAPL | Stock | 0.6357 | 0.6357 | 0.6357 | 0.6357 | 179760.0 |
| 2004-09-09 08:32:00 | AAPL | Stock | 0.6377 | 0.6377 | 0.6377 | 0.6377 | 27160.0 |
| 2004-09-09 08:34:00 | AAPL | Stock | 0.6382 | 0.6382 | 0.6382 | 0.6382 | 22400.0 |
| 2004-09-09 08:35:00 | AAPL | Stock | 0.6382 | 0.6411 | 0.6382 | 0.6411 | 357840.0 |
| 2004-09-09 08:43:00 | AAPL | Stock | 0.6409 | 0.6409 | 0.6409 | 0.6409 | 28000.0 |
| 2004-09-09 08:45:00 | AAPL | Stock | 0.6409 | 0.6409 | 0.6409 | 0.6409 | 28000.0 |
| 2004-09-09 08:51:00 | AAPL | Stock | 0.6409 | 0.6409 | 0.6409 | 0.6409 | 11200.0 |
| 2004-09-09 08:53:00 | AAPL | Stock | 0.6409 | 0.6409 | 0.6409 | 0.6409 | 5600.0 |
| 2004-09-09 08:57:00 | AAPL | Stock | 0.642 | 0.642 | 0.642 | 0.642 | 16800.0 |
| 2004-09-09 08:58:00 | AAPL | Stock | 0.642 | 0.642 | 0.642 | 0.642 | 11200.0 |
| 2004-09-09 09:01:00 | AAPL | Stock | 0.6429 | 0.643 | 0.6427 | 0.6429 | 249200.0 |
| 2004-09-09 09:07:00 | AAPL | Stock | 0.6429 | 0.6429 | 0.6429 | 0.6429 | 56000.0 |
| 2004-09-09 09:10:00 | AAPL | Stock | 0.6436 | 0.6436 | 0.6429 | 0.6429 | 179200.0 |
| 2004-09-09 09:11:00 | AAPL | Stock | 0.6413 | 0.6429 | 0.6413 | 0.6429 | 16800.0 |
| 2004-09-09 09:12:00 | AAPL | Stock | 0.6429 | 0.6434 | 0.6429 | 0.6434 | 22400.0 |
| 2004-09-09 09:13:00 | AAPL | Stock | 0.6434 | 0.6434 | 0.6434 | 0.6434 | 33600.0 |
| 2004-09-09 09:14:00 | AAPL | Stock | 0.6434 | 0.6434 | 0.6434 | 0.6434 | 28000.0 |
| 2004-09-09 09:18:00 | AAPL | Stock | 0.642 | 0.642 | 0.642 | 0.642 | 5600.0 |
| 2004-09-09 09:19:00 | AAPL | Stock | 0.6418 | 0.6491 | 0.6413 | 0.6491 | 3444000.0 |
| 2004-09-09 09:20:00 | AAPL | Stock | 0.6434 | 0.6434 | 0.6434 | 0.6434 | 5600.0 |
| 2004-09-09 09:26:00 | AAPL | Stock | 0.6429 | 0.6429 | 0.6429 | 0.6429 | 140000.0 |
| 2004-09-09 09:27:00 | AAPL | Stock | 0.6436 | 0.6438 | 0.6436 | 0.6438 | 78400.0 |
| 2004-09-09 09:28:00 | AAPL | Stock | 0.6438 | 0.6441 | 0.6438 | 0.6438 | 95200.0 |
| 2004-09-09 09:29:00 | AAPL | Stock | 0.6441 | 0.645 | 0.6429 | 0.645 | 485632.0 |
| 2004-09-09 09:30:00 | AAPL | Stock | 0.6446 | 0.6455 | 0.642 | 0.6425 | 4495008.0 |
| 2004-09-09 09:31:00 | AAPL | Stock | 0.6421 | 0.6443 | 0.6411 | 0.642 | 2343656.0 |
| 2004-09-09 09:32:00 | AAPL | Stock | 0.6414 | 0.6423 | 0.6413 | 0.6413 | 5353488.0 |
| 2004-09-09 09:33:00 | AAPL | Stock | 0.6413 | 0.6432 | 0.6413 | 0.6429 | 2188256.0 |
| 2004-09-09 09:34:00 | AAPL | Stock | 0.6429 | 0.6464 | 0.6429 | 0.6464 | 2660616.0 |
| 2004-09-09 09:35:00 | AAPL | Stock | 0.6459 | 0.6473 | 0.6454 | 0.6473 | 9075920.0 |
| 2004-09-09 09:36:00 | AAPL | Stock | 0.6473 | 0.6482 | 0.6457 | 0.6464 | 7645904.0 |
| 2004-09-09 09:37:00 | AAPL | Stock | 0.6461 | 0.6471 | 0.6461 | 0.6464 | 1295504.0 |
| 2004-09-09 09:38:00 | AAPL | Stock | 0.6464 | 0.6466 | 0.6463 | 0.6463 | 1428168.0 |
| 2004-09-09 09:39:00 | AAPL | Stock | 0.6463 | 0.6463 | 0.6421 | 0.6427 | 2670920.0 |
| 2004-09-09 09:40:00 | AAPL | Stock | 0.6429 | 0.6436 | 0.6418 | 0.643 | 3322984.0 |
> showing 50 of 518,831 rows — these rows as CSV