PREVIEW / stock_5min / 2004-07-08
file: by_date/stock_5min/2004/2004-07-08.parquet size: 2.4 MB rows: 179,201 symbols: 1,804
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-07-08 08:10:00 | AAPL | Stock | 0.5355 | 0.5355 | 0.5339 | 0.5339 | 56000.0 |
| 2004-07-08 08:45:00 | AAPL | Stock | 0.5343 | 0.5343 | 0.5343 | 0.5343 | 11200.0 |
| 2004-07-08 09:00:00 | AAPL | Stock | 0.5355 | 0.5355 | 0.5355 | 0.5355 | 16800.0 |
| 2004-07-08 09:05:00 | AAPL | Stock | 0.5357 | 0.5357 | 0.5357 | 0.5357 | 16800.0 |
| 2004-07-08 09:10:00 | AAPL | Stock | 0.5357 | 0.5357 | 0.5357 | 0.5357 | 95200.0 |
| 2004-07-08 09:25:00 | AAPL | Stock | 0.5389 | 0.5396 | 0.5386 | 0.5386 | 127848.0 |
| 2004-07-08 09:30:00 | AAPL | Stock | 0.538 | 0.5402 | 0.5348 | 0.5373 | 8915704.0 |
| 2004-07-08 09:35:00 | AAPL | Stock | 0.5373 | 0.5395 | 0.5371 | 0.5382 | 3975832.0 |
| 2004-07-08 09:40:00 | AAPL | Stock | 0.538 | 0.542 | 0.5377 | 0.542 | 4409216.0 |
| 2004-07-08 09:45:00 | AAPL | Stock | 0.542 | 0.542 | 0.5409 | 0.5413 | 3172120.0 |
| 2004-07-08 09:50:00 | AAPL | Stock | 0.5413 | 0.5413 | 0.5393 | 0.5395 | 2867704.0 |
| 2004-07-08 09:55:00 | AAPL | Stock | 0.5395 | 0.5423 | 0.5395 | 0.5402 | 3093608.0 |
| 2004-07-08 10:00:00 | AAPL | Stock | 0.5404 | 0.5439 | 0.5402 | 0.5427 | 4497136.0 |
| 2004-07-08 10:05:00 | AAPL | Stock | 0.5425 | 0.5446 | 0.54 | 0.5402 | 5161632.0 |
| 2004-07-08 10:10:00 | AAPL | Stock | 0.5402 | 0.5438 | 0.5402 | 0.5413 | 2184056.0 |
| 2004-07-08 10:15:00 | AAPL | Stock | 0.5413 | 0.5436 | 0.5411 | 0.5411 | 1999592.0 |
| 2004-07-08 10:20:00 | AAPL | Stock | 0.5411 | 0.542 | 0.5402 | 0.5413 | 2062928.0 |
| 2004-07-08 10:25:00 | AAPL | Stock | 0.5413 | 0.5443 | 0.5409 | 0.543 | 1620584.0 |
| 2004-07-08 10:30:00 | AAPL | Stock | 0.543 | 0.5436 | 0.5413 | 0.5414 | 1901200.0 |
| 2004-07-08 10:35:00 | AAPL | Stock | 0.5414 | 0.5436 | 0.5414 | 0.5429 | 1852312.0 |
| 2004-07-08 10:40:00 | AAPL | Stock | 0.5427 | 0.5443 | 0.5423 | 0.543 | 2611896.0 |
| 2004-07-08 10:45:00 | AAPL | Stock | 0.543 | 0.5441 | 0.5425 | 0.5434 | 4895912.0 |
| 2004-07-08 10:50:00 | AAPL | Stock | 0.5432 | 0.5434 | 0.5418 | 0.5418 | 1646848.0 |
| 2004-07-08 10:55:00 | AAPL | Stock | 0.5418 | 0.5425 | 0.5418 | 0.5425 | 1077216.0 |
| 2004-07-08 11:00:00 | AAPL | Stock | 0.5425 | 0.5446 | 0.5423 | 0.5446 | 4014640.0 |
| 2004-07-08 11:05:00 | AAPL | Stock | 0.5445 | 0.5454 | 0.5439 | 0.5448 | 12960528.0 |
| 2004-07-08 11:10:00 | AAPL | Stock | 0.545 | 0.5455 | 0.5439 | 0.5455 | 2868880.0 |
| 2004-07-08 11:15:00 | AAPL | Stock | 0.5455 | 0.5464 | 0.5454 | 0.5463 | 5090568.0 |
| 2004-07-08 11:20:00 | AAPL | Stock | 0.5461 | 0.5464 | 0.5455 | 0.5457 | 1073016.0 |
| 2004-07-08 11:25:00 | AAPL | Stock | 0.5455 | 0.5463 | 0.5455 | 0.5459 | 845320.0 |
| 2004-07-08 11:30:00 | AAPL | Stock | 0.5459 | 0.5464 | 0.5459 | 0.5459 | 1659000.0 |
| 2004-07-08 11:35:00 | AAPL | Stock | 0.5461 | 0.5463 | 0.5443 | 0.5443 | 1409184.0 |
| 2004-07-08 11:40:00 | AAPL | Stock | 0.5445 | 0.5454 | 0.5445 | 0.5452 | 714280.0 |
| 2004-07-08 11:45:00 | AAPL | Stock | 0.545 | 0.5459 | 0.545 | 0.5457 | 1003352.0 |
| 2004-07-08 11:50:00 | AAPL | Stock | 0.5459 | 0.5463 | 0.5459 | 0.5461 | 6912920.0 |
| 2004-07-08 11:55:00 | AAPL | Stock | 0.5459 | 0.5461 | 0.5459 | 0.5461 | 1125600.0 |
| 2004-07-08 12:00:00 | AAPL | Stock | 0.5459 | 0.5468 | 0.5459 | 0.5461 | 2540496.0 |
| 2004-07-08 12:05:00 | AAPL | Stock | 0.5461 | 0.547 | 0.5461 | 0.5469 | 1464792.0 |
| 2004-07-08 12:10:00 | AAPL | Stock | 0.547 | 0.547 | 0.5466 | 0.5466 | 745360.0 |
| 2004-07-08 12:15:00 | AAPL | Stock | 0.5468 | 0.5479 | 0.5459 | 0.5461 | 1423296.0 |
| 2004-07-08 12:20:00 | AAPL | Stock | 0.5459 | 0.5463 | 0.5452 | 0.5463 | 1083544.0 |
| 2004-07-08 12:25:00 | AAPL | Stock | 0.5461 | 0.5466 | 0.5457 | 0.5457 | 838936.0 |
| 2004-07-08 12:30:00 | AAPL | Stock | 0.5459 | 0.5461 | 0.5455 | 0.5459 | 1461040.0 |
| 2004-07-08 12:35:00 | AAPL | Stock | 0.5461 | 0.5464 | 0.5457 | 0.5464 | 910336.0 |
| 2004-07-08 12:40:00 | AAPL | Stock | 0.5464 | 0.5468 | 0.5457 | 0.5461 | 838768.0 |
| 2004-07-08 12:45:00 | AAPL | Stock | 0.5463 | 0.5464 | 0.5461 | 0.5461 | 972160.0 |
| 2004-07-08 12:50:00 | AAPL | Stock | 0.5461 | 0.5461 | 0.542 | 0.5421 | 3190488.0 |
| 2004-07-08 12:55:00 | AAPL | Stock | 0.5421 | 0.5436 | 0.5416 | 0.543 | 2670304.0 |
| 2004-07-08 13:00:00 | AAPL | Stock | 0.5429 | 0.5438 | 0.5421 | 0.5421 | 1905848.0 |
| 2004-07-08 13:05:00 | AAPL | Stock | 0.5421 | 0.5432 | 0.542 | 0.5423 | 2095744.0 |
> showing 50 of 179,201 rows — these rows as CSV