PREVIEW / stock_5min / 2008-05-09
file: by_date/stock_5min/2008/2008-05-09.parquet size: 4.3 MB rows: 310,475 symbols: 3,271
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-09 07:15:00 | AAPL | Stock | 6.5661 | 6.5661 | 6.5661 | 6.5661 | 2800.0 |
| 2008-05-09 07:25:00 | AAPL | Stock | 6.5857 | 6.5857 | 6.5714 | 6.5857 | 8400.0 |
| 2008-05-09 07:35:00 | AAPL | Stock | 6.5786 | 6.5786 | 6.575 | 6.575 | 22400.0 |
| 2008-05-09 07:40:00 | AAPL | Stock | 6.5714 | 6.5714 | 6.5714 | 6.5714 | 5600.0 |
| 2008-05-09 07:45:00 | AAPL | Stock | 6.5679 | 6.5714 | 6.5571 | 6.5571 | 65800.0 |
| 2008-05-09 07:50:00 | AAPL | Stock | 6.5571 | 6.5571 | 6.5571 | 6.5571 | 5600.0 |
| 2008-05-09 08:00:00 | AAPL | Stock | 6.5561 | 6.5607 | 6.5532 | 6.5543 | 196952.0 |
| 2008-05-09 08:05:00 | AAPL | Stock | 6.5543 | 6.5607 | 6.5529 | 6.5593 | 367388.0 |
| 2008-05-09 08:10:00 | AAPL | Stock | 6.56 | 6.5607 | 6.5571 | 6.5593 | 125076.0 |
| 2008-05-09 08:15:00 | AAPL | Stock | 6.56 | 6.5607 | 6.5571 | 6.5589 | 304276.0 |
| 2008-05-09 08:20:00 | AAPL | Stock | 6.5586 | 6.5714 | 6.5575 | 6.5714 | 203140.0 |
| 2008-05-09 08:25:00 | AAPL | Stock | 6.57 | 6.57 | 6.5607 | 6.5607 | 329420.0 |
| 2008-05-09 08:30:00 | AAPL | Stock | 6.5589 | 6.5675 | 6.5589 | 6.5675 | 270732.0 |
| 2008-05-09 08:35:00 | AAPL | Stock | 6.5679 | 6.5757 | 6.5675 | 6.5754 | 596932.0 |
| 2008-05-09 08:40:00 | AAPL | Stock | 6.5768 | 6.5804 | 6.575 | 6.575 | 434140.0 |
| 2008-05-09 08:45:00 | AAPL | Stock | 6.5757 | 6.5775 | 6.5739 | 6.575 | 270564.0 |
| 2008-05-09 08:50:00 | AAPL | Stock | 6.575 | 6.575 | 6.5714 | 6.5714 | 426916.0 |
| 2008-05-09 08:55:00 | AAPL | Stock | 6.5714 | 6.5761 | 6.5682 | 6.5729 | 468580.0 |
| 2008-05-09 09:00:00 | AAPL | Stock | 6.5732 | 6.5746 | 6.5714 | 6.5721 | 235116.0 |
| 2008-05-09 09:05:00 | AAPL | Stock | 6.5714 | 6.5743 | 6.5686 | 6.5714 | 326760.0 |
| 2008-05-09 09:10:00 | AAPL | Stock | 6.57 | 6.5714 | 6.5696 | 6.5711 | 206920.0 |
| 2008-05-09 09:15:00 | AAPL | Stock | 6.5696 | 6.575 | 6.5696 | 6.5739 | 137088.0 |
| 2008-05-09 09:20:00 | AAPL | Stock | 6.5743 | 6.5743 | 6.5614 | 6.5643 | 333340.0 |
| 2008-05-09 09:25:00 | AAPL | Stock | 6.5643 | 6.5671 | 6.5357 | 6.5361 | 1170372.0 |
| 2008-05-09 09:30:00 | AAPL | Stock | 6.5379 | 6.5621 | 6.5325 | 6.5589 | 25148648.0 |
| 2008-05-09 09:35:00 | AAPL | Stock | 6.559 | 6.5679 | 6.5379 | 6.5607 | 20145412.0 |
| 2008-05-09 09:40:00 | AAPL | Stock | 6.5607 | 6.5714 | 6.5457 | 6.5521 | 16622424.0 |
| 2008-05-09 09:45:00 | AAPL | Stock | 6.5518 | 6.5646 | 6.5436 | 6.5639 | 16550800.0 |
| 2008-05-09 09:50:00 | AAPL | Stock | 6.565 | 6.5707 | 6.5568 | 6.5657 | 10799180.0 |
| 2008-05-09 09:55:00 | AAPL | Stock | 6.5657 | 6.5696 | 6.5493 | 6.5507 | 12152392.0 |
| 2008-05-09 10:00:00 | AAPL | Stock | 6.5507 | 6.5793 | 6.5504 | 6.5771 | 14304304.0 |
| 2008-05-09 10:05:00 | AAPL | Stock | 6.5775 | 6.5789 | 6.5643 | 6.5761 | 10487708.0 |
| 2008-05-09 10:10:00 | AAPL | Stock | 6.5757 | 6.5771 | 6.5625 | 6.5689 | 8045380.0 |
| 2008-05-09 10:15:00 | AAPL | Stock | 6.5693 | 6.5804 | 6.5582 | 6.5679 | 11979128.0 |
| 2008-05-09 10:20:00 | AAPL | Stock | 6.5679 | 6.5682 | 6.55 | 6.5593 | 9921072.0 |
| 2008-05-09 10:25:00 | AAPL | Stock | 6.5593 | 6.5621 | 6.5471 | 6.5507 | 10736348.0 |
| 2008-05-09 10:30:00 | AAPL | Stock | 6.5511 | 6.5561 | 6.525 | 6.5382 | 18083912.0 |
| 2008-05-09 10:35:00 | AAPL | Stock | 6.5379 | 6.5464 | 6.5286 | 6.5393 | 12826968.0 |
| 2008-05-09 10:40:00 | AAPL | Stock | 6.5393 | 6.5625 | 6.5357 | 6.5593 | 13803188.0 |
| 2008-05-09 10:45:00 | AAPL | Stock | 6.5604 | 6.5779 | 6.5539 | 6.5657 | 16052344.0 |
| 2008-05-09 10:50:00 | AAPL | Stock | 6.5668 | 6.5714 | 6.5518 | 6.5546 | 8823752.0 |
| 2008-05-09 10:55:00 | AAPL | Stock | 6.5546 | 6.5611 | 6.545 | 6.55 | 11415992.0 |
| 2008-05-09 11:00:00 | AAPL | Stock | 6.55 | 6.555 | 6.5396 | 6.5454 | 8340220.0 |
| 2008-05-09 11:05:00 | AAPL | Stock | 6.5454 | 6.5554 | 6.545 | 6.5527 | 6921208.0 |
| 2008-05-09 11:10:00 | AAPL | Stock | 6.5529 | 6.5529 | 6.5386 | 6.5411 | 4900784.0 |
| 2008-05-09 11:15:00 | AAPL | Stock | 6.5421 | 6.5464 | 6.5343 | 6.5414 | 7569604.0 |
| 2008-05-09 11:20:00 | AAPL | Stock | 6.5414 | 6.5432 | 6.5332 | 6.5393 | 7005544.0 |
| 2008-05-09 11:25:00 | AAPL | Stock | 6.5393 | 6.5479 | 6.5375 | 6.5396 | 6074824.0 |
| 2008-05-09 11:30:00 | AAPL | Stock | 6.54 | 6.5429 | 6.5186 | 6.5256 | 11900476.0 |
| 2008-05-09 11:35:00 | AAPL | Stock | 6.5257 | 6.5318 | 6.5189 | 6.5225 | 5982592.0 |
> showing 50 of 310,475 rows — these rows as CSV