PREVIEW / stock_1min / 2004-06-10
file: by_date/stock_1min/2004/2004-06-10.parquet size: 5.4 MB rows: 458,846 symbols: 1,460
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-06-10 08:00:00 | AAPL | Stock | 0.5404 | 0.5404 | 0.5404 | 0.5404 | 16800.0 |
| 2004-06-10 08:30:00 | AAPL | Stock | 0.542 | 0.542 | 0.542 | 0.542 | 117600.0 |
| 2004-06-10 08:31:00 | AAPL | Stock | 0.5411 | 0.5411 | 0.5411 | 0.5411 | 145600.0 |
| 2004-06-10 08:36:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5413 | 0.5413 | 28000.0 |
| 2004-06-10 08:40:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5413 | 0.5413 | 14000.0 |
| 2004-06-10 08:46:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5413 | 0.5413 | 11200.0 |
| 2004-06-10 09:00:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5413 | 0.5413 | 16800.0 |
| 2004-06-10 09:09:00 | AAPL | Stock | 0.5405 | 0.5405 | 0.5404 | 0.5404 | 196000.0 |
| 2004-06-10 09:10:00 | AAPL | Stock | 0.5396 | 0.5396 | 0.5396 | 0.5396 | 11200.0 |
| 2004-06-10 09:17:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5413 | 0.5413 | 5600.0 |
| 2004-06-10 09:22:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5413 | 0.5413 | 5600.0 |
| 2004-06-10 09:26:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5413 | 0.5413 | 11200.0 |
| 2004-06-10 09:29:00 | AAPL | Stock | 0.5414 | 0.5414 | 0.54 | 0.5414 | 240800.0 |
| 2004-06-10 09:30:00 | AAPL | Stock | 0.5414 | 0.5418 | 0.5398 | 0.5414 | 3758384.0 |
| 2004-06-10 09:31:00 | AAPL | Stock | 0.5416 | 0.5425 | 0.5414 | 0.5423 | 3508624.0 |
| 2004-06-10 09:32:00 | AAPL | Stock | 0.5427 | 0.5446 | 0.5423 | 0.5446 | 1139040.0 |
| 2004-06-10 09:33:00 | AAPL | Stock | 0.5445 | 0.5446 | 0.5427 | 0.5436 | 2846816.0 |
| 2004-06-10 09:34:00 | AAPL | Stock | 0.5436 | 0.5438 | 0.5429 | 0.5438 | 946400.0 |
| 2004-06-10 09:35:00 | AAPL | Stock | 0.5436 | 0.5445 | 0.5434 | 0.5436 | 1126664.0 |
| 2004-06-10 09:36:00 | AAPL | Stock | 0.5438 | 0.5455 | 0.5438 | 0.5448 | 1550416.0 |
| 2004-06-10 09:37:00 | AAPL | Stock | 0.5455 | 0.5455 | 0.5446 | 0.5454 | 708120.0 |
| 2004-06-10 09:38:00 | AAPL | Stock | 0.545 | 0.5452 | 0.5443 | 0.5448 | 437304.0 |
| 2004-06-10 09:39:00 | AAPL | Stock | 0.5445 | 0.545 | 0.5436 | 0.5441 | 234192.0 |
| 2004-06-10 09:40:00 | AAPL | Stock | 0.5439 | 0.5446 | 0.5439 | 0.5441 | 184800.0 |
| 2004-06-10 09:41:00 | AAPL | Stock | 0.5441 | 0.5445 | 0.5438 | 0.5445 | 308000.0 |
| 2004-06-10 09:42:00 | AAPL | Stock | 0.5446 | 0.545 | 0.5416 | 0.545 | 3000032.0 |
| 2004-06-10 09:43:00 | AAPL | Stock | 0.5448 | 0.5463 | 0.5448 | 0.5463 | 736400.0 |
| 2004-06-10 09:44:00 | AAPL | Stock | 0.5461 | 0.5463 | 0.5454 | 0.5457 | 1572032.0 |
| 2004-06-10 09:45:00 | AAPL | Stock | 0.5459 | 0.5463 | 0.5457 | 0.5461 | 499800.0 |
| 2004-06-10 09:46:00 | AAPL | Stock | 0.5461 | 0.547 | 0.5461 | 0.5463 | 1368976.0 |
| 2004-06-10 09:47:00 | AAPL | Stock | 0.5464 | 0.547 | 0.5463 | 0.5466 | 709632.0 |
| 2004-06-10 09:48:00 | AAPL | Stock | 0.5464 | 0.5471 | 0.5464 | 0.5468 | 495320.0 |
| 2004-06-10 09:49:00 | AAPL | Stock | 0.547 | 0.5473 | 0.5461 | 0.5461 | 1024464.0 |
| 2004-06-10 09:50:00 | AAPL | Stock | 0.5461 | 0.5466 | 0.5457 | 0.5457 | 677656.0 |
| 2004-06-10 09:51:00 | AAPL | Stock | 0.5457 | 0.5463 | 0.5457 | 0.5459 | 754880.0 |
| 2004-06-10 09:52:00 | AAPL | Stock | 0.5459 | 0.5468 | 0.5459 | 0.5464 | 486360.0 |
| 2004-06-10 09:53:00 | AAPL | Stock | 0.5464 | 0.547 | 0.5464 | 0.547 | 893536.0 |
| 2004-06-10 09:54:00 | AAPL | Stock | 0.5468 | 0.547 | 0.5455 | 0.5459 | 864136.0 |
| 2004-06-10 09:55:00 | AAPL | Stock | 0.5459 | 0.5459 | 0.5454 | 0.5457 | 530936.0 |
| 2004-06-10 09:56:00 | AAPL | Stock | 0.5457 | 0.5461 | 0.5454 | 0.5455 | 364952.0 |
| 2004-06-10 09:57:00 | AAPL | Stock | 0.5455 | 0.547 | 0.5455 | 0.5466 | 476000.0 |
| 2004-06-10 09:58:00 | AAPL | Stock | 0.5468 | 0.5475 | 0.5468 | 0.5471 | 1199016.0 |
| 2004-06-10 09:59:00 | AAPL | Stock | 0.5473 | 0.5479 | 0.5473 | 0.5479 | 450800.0 |
| 2004-06-10 10:00:00 | AAPL | Stock | 0.548 | 0.55 | 0.5477 | 0.55 | 6019216.0 |
| 2004-06-10 10:01:00 | AAPL | Stock | 0.55 | 0.5502 | 0.5489 | 0.5491 | 1459752.0 |
| 2004-06-10 10:02:00 | AAPL | Stock | 0.5489 | 0.5493 | 0.548 | 0.5488 | 1483888.0 |
| 2004-06-10 10:03:00 | AAPL | Stock | 0.5486 | 0.5488 | 0.5484 | 0.5484 | 765408.0 |
| 2004-06-10 10:04:00 | AAPL | Stock | 0.5484 | 0.5491 | 0.5482 | 0.5488 | 1970864.0 |
| 2004-06-10 10:05:00 | AAPL | Stock | 0.5489 | 0.5496 | 0.5489 | 0.5491 | 1755600.0 |
| 2004-06-10 10:06:00 | AAPL | Stock | 0.5493 | 0.5493 | 0.5482 | 0.5493 | 7462000.0 |
> showing 50 of 458,846 rows — these rows as CSV