PREVIEW / stock_5min / 2009-12-03
file: by_date/stock_5min/2009/2009-12-03.parquet size: 4.6 MB rows: 317,821 symbols: 3,423
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-12-03 04:15:00 | AAPL | Stock | 7.0664 | 7.0664 | 7.0664 | 7.0664 | 2800.0 |
| 2009-12-03 04:30:00 | AAPL | Stock | 7.0686 | 7.0686 | 7.0682 | 7.0682 | 9520.0 |
| 2009-12-03 04:35:00 | AAPL | Stock | 7.085 | 7.085 | 7.085 | 7.085 | 5600.0 |
| 2009-12-03 05:00:00 | AAPL | Stock | 7.0714 | 7.0714 | 7.0714 | 7.0714 | 6104.0 |
| 2009-12-03 05:10:00 | AAPL | Stock | 7.0696 | 7.0696 | 7.0696 | 7.0696 | 2800.0 |
| 2009-12-03 05:20:00 | AAPL | Stock | 7.0718 | 7.0718 | 7.0714 | 7.0714 | 25816.0 |
| 2009-12-03 05:50:00 | AAPL | Stock | 7.0832 | 7.0836 | 7.0832 | 7.0832 | 22540.0 |
| 2009-12-03 06:25:00 | AAPL | Stock | 7.0725 | 7.0725 | 7.0725 | 7.0725 | 13496.0 |
| 2009-12-03 06:55:00 | AAPL | Stock | 7.0582 | 7.0582 | 7.0582 | 7.0582 | 6160.0 |
| 2009-12-03 07:00:00 | AAPL | Stock | 7.0454 | 7.0454 | 7.0454 | 7.0454 | 2800.0 |
| 2009-12-03 07:05:00 | AAPL | Stock | 7.0625 | 7.0625 | 7.0618 | 7.0618 | 14000.0 |
| 2009-12-03 07:10:00 | AAPL | Stock | 7.0618 | 7.0632 | 7.0618 | 7.0629 | 35000.0 |
| 2009-12-03 07:15:00 | AAPL | Stock | 7.0711 | 7.0721 | 7.0696 | 7.0721 | 54936.0 |
| 2009-12-03 07:20:00 | AAPL | Stock | 7.0714 | 7.0732 | 7.0696 | 7.0732 | 44408.0 |
| 2009-12-03 07:30:00 | AAPL | Stock | 7.0629 | 7.0629 | 7.0625 | 7.0625 | 11816.0 |
| 2009-12-03 07:40:00 | AAPL | Stock | 7.0639 | 7.0639 | 7.0639 | 7.0639 | 13216.0 |
| 2009-12-03 07:50:00 | AAPL | Stock | 7.0679 | 7.0679 | 7.0625 | 7.0625 | 13300.0 |
| 2009-12-03 07:55:00 | AAPL | Stock | 7.0625 | 7.0679 | 7.0575 | 7.0575 | 47600.0 |
| 2009-12-03 08:00:00 | AAPL | Stock | 7.06 | 7.0714 | 7.0589 | 7.0625 | 521780.0 |
| 2009-12-03 08:05:00 | AAPL | Stock | 7.0593 | 7.0646 | 7.0579 | 7.0643 | 228200.0 |
| 2009-12-03 08:10:00 | AAPL | Stock | 7.0625 | 7.0641 | 7.0589 | 7.0621 | 94920.0 |
| 2009-12-03 08:15:00 | AAPL | Stock | 7.0611 | 7.0611 | 7.0586 | 7.0611 | 93856.0 |
| 2009-12-03 08:20:00 | AAPL | Stock | 7.0607 | 7.0607 | 7.0571 | 7.0607 | 70588.0 |
| 2009-12-03 08:25:00 | AAPL | Stock | 7.06 | 7.0679 | 7.0571 | 7.0639 | 243124.0 |
| 2009-12-03 08:30:00 | AAPL | Stock | 7.0629 | 7.0718 | 7.0629 | 7.0661 | 539672.0 |
| 2009-12-03 08:35:00 | AAPL | Stock | 7.0661 | 7.0661 | 7.0493 | 7.0493 | 360192.0 |
| 2009-12-03 08:40:00 | AAPL | Stock | 7.0482 | 7.0554 | 7.0393 | 7.0429 | 410368.0 |
| 2009-12-03 08:45:00 | AAPL | Stock | 7.0425 | 7.0532 | 7.0425 | 7.0493 | 127680.0 |
| 2009-12-03 08:50:00 | AAPL | Stock | 7.0482 | 7.0518 | 7.0482 | 7.0482 | 79240.0 |
| 2009-12-03 08:55:00 | AAPL | Stock | 7.0471 | 7.0471 | 7.0411 | 7.0414 | 285012.0 |
| 2009-12-03 09:00:00 | AAPL | Stock | 7.0411 | 7.0482 | 7.0393 | 7.0479 | 248052.0 |
| 2009-12-03 09:05:00 | AAPL | Stock | 7.045 | 7.0516 | 7.045 | 7.0464 | 202468.0 |
| 2009-12-03 09:10:00 | AAPL | Stock | 7.0482 | 7.0511 | 7.0464 | 7.0468 | 175028.0 |
| 2009-12-03 09:15:00 | AAPL | Stock | 7.0493 | 7.0546 | 7.0489 | 7.0536 | 294252.0 |
| 2009-12-03 09:20:00 | AAPL | Stock | 7.0539 | 7.0618 | 7.0496 | 7.0571 | 457072.0 |
| 2009-12-03 09:25:00 | AAPL | Stock | 7.0571 | 7.0571 | 7.0464 | 7.0532 | 429520.0 |
| 2009-12-03 09:30:00 | AAPL | Stock | 7.0536 | 7.0768 | 7.0504 | 7.0718 | 14442736.0 |
| 2009-12-03 09:35:00 | AAPL | Stock | 7.0718 | 7.085 | 7.0414 | 7.0471 | 15907444.0 |
| 2009-12-03 09:40:00 | AAPL | Stock | 7.0471 | 7.0636 | 7.0439 | 7.0554 | 9974720.0 |
| 2009-12-03 09:45:00 | AAPL | Stock | 7.0557 | 7.0846 | 7.055 | 7.0711 | 14341852.0 |
| 2009-12-03 09:50:00 | AAPL | Stock | 7.0714 | 7.0725 | 7.0571 | 7.0672 | 7844368.0 |
| 2009-12-03 09:55:00 | AAPL | Stock | 7.0668 | 7.0739 | 7.0557 | 7.0729 | 6988996.0 |
| 2009-12-03 10:00:00 | AAPL | Stock | 7.0718 | 7.0746 | 7.0296 | 7.0475 | 19590984.0 |
| 2009-12-03 10:05:00 | AAPL | Stock | 7.0478 | 7.0536 | 7.0382 | 7.0529 | 7720608.0 |
| 2009-12-03 10:10:00 | AAPL | Stock | 7.0519 | 7.0529 | 7.0179 | 7.0232 | 11332020.0 |
| 2009-12-03 10:15:00 | AAPL | Stock | 7.0214 | 7.0314 | 7.0132 | 7.0211 | 9557044.0 |
| 2009-12-03 10:20:00 | AAPL | Stock | 7.0204 | 7.0368 | 7.0186 | 7.0189 | 7021896.0 |
| 2009-12-03 10:25:00 | AAPL | Stock | 7.0204 | 7.0446 | 7.0096 | 7.0407 | 6754832.0 |
| 2009-12-03 10:30:00 | AAPL | Stock | 7.0404 | 7.0464 | 7.037 | 7.0421 | 5778444.0 |
| 2009-12-03 10:35:00 | AAPL | Stock | 7.0421 | 7.05 | 7.0357 | 7.0357 | 5273352.0 |
> showing 50 of 317,821 rows — these rows as CSV