PREVIEW / stock_5min / 2007-02-01
file: by_date/stock_5min/2007/2007-02-01.parquet size: 3.4 MB rows: 244,080 symbols: 2,504
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-01 06:05:00 | AAPL | Stock | 3.0679 | 3.0679 | 3.0679 | 3.0679 | 2800.0 |
| 2007-02-01 07:05:00 | AAPL | Stock | 3.0836 | 3.0836 | 3.0836 | 3.0836 | 2800.0 |
| 2007-02-01 07:25:00 | AAPL | Stock | 3.0818 | 3.0821 | 3.0732 | 3.0732 | 42000.0 |
| 2007-02-01 07:35:00 | AAPL | Stock | 3.0714 | 3.0718 | 3.0714 | 3.0718 | 16800.0 |
| 2007-02-01 07:50:00 | AAPL | Stock | 3.0679 | 3.0714 | 3.0679 | 3.0714 | 42000.0 |
| 2007-02-01 08:00:00 | AAPL | Stock | 3.0796 | 3.0796 | 3.0704 | 3.0725 | 293356.0 |
| 2007-02-01 08:05:00 | AAPL | Stock | 3.0725 | 3.075 | 3.0725 | 3.0736 | 189784.0 |
| 2007-02-01 08:10:00 | AAPL | Stock | 3.0743 | 3.0746 | 3.0718 | 3.0732 | 180600.0 |
| 2007-02-01 08:15:00 | AAPL | Stock | 3.0732 | 3.0746 | 3.0732 | 3.0746 | 37520.0 |
| 2007-02-01 08:20:00 | AAPL | Stock | 3.0743 | 3.0746 | 3.0618 | 3.0618 | 15652.0 |
| 2007-02-01 08:25:00 | AAPL | Stock | 3.0725 | 3.0746 | 3.0714 | 3.0714 | 91252.0 |
| 2007-02-01 08:30:00 | AAPL | Stock | 3.0714 | 3.0732 | 3.0618 | 3.0714 | 336252.0 |
| 2007-02-01 08:35:00 | AAPL | Stock | 3.0721 | 3.0725 | 3.0704 | 3.0704 | 171920.0 |
| 2007-02-01 08:40:00 | AAPL | Stock | 3.0704 | 3.0704 | 3.0679 | 3.0679 | 206724.0 |
| 2007-02-01 08:45:00 | AAPL | Stock | 3.0679 | 3.0739 | 3.0679 | 3.0739 | 214704.0 |
| 2007-02-01 08:50:00 | AAPL | Stock | 3.0725 | 3.0736 | 3.0618 | 3.0714 | 266280.0 |
| 2007-02-01 08:55:00 | AAPL | Stock | 3.0721 | 3.0771 | 3.0721 | 3.0771 | 419916.0 |
| 2007-02-01 09:00:00 | AAPL | Stock | 3.0768 | 3.0771 | 3.075 | 3.075 | 95760.0 |
| 2007-02-01 09:05:00 | AAPL | Stock | 3.0764 | 3.0771 | 3.0764 | 3.0771 | 88060.0 |
| 2007-02-01 09:10:00 | AAPL | Stock | 3.0771 | 3.0786 | 3.0771 | 3.0779 | 210000.0 |
| 2007-02-01 09:15:00 | AAPL | Stock | 3.0771 | 3.0771 | 3.0714 | 3.0714 | 177240.0 |
| 2007-02-01 09:20:00 | AAPL | Stock | 3.0725 | 3.0725 | 3.0721 | 3.0725 | 77000.0 |
| 2007-02-01 09:25:00 | AAPL | Stock | 3.0718 | 3.0796 | 3.0714 | 3.0796 | 1213660.0 |
| 2007-02-01 09:30:00 | AAPL | Stock | 3.0793 | 3.0811 | 3.0732 | 3.0793 | 27040804.0 |
| 2007-02-01 09:35:00 | AAPL | Stock | 3.0793 | 3.08 | 3.0732 | 3.0779 | 18989908.0 |
| 2007-02-01 09:40:00 | AAPL | Stock | 3.0779 | 3.0789 | 3.0614 | 3.0629 | 25352768.0 |
| 2007-02-01 09:45:00 | AAPL | Stock | 3.0629 | 3.0718 | 3.0614 | 3.0679 | 19076820.0 |
| 2007-02-01 09:50:00 | AAPL | Stock | 3.0682 | 3.0704 | 3.0646 | 3.0693 | 11004028.0 |
| 2007-02-01 09:55:00 | AAPL | Stock | 3.0689 | 3.0714 | 3.0654 | 3.0704 | 12774468.0 |
| 2007-02-01 10:00:00 | AAPL | Stock | 3.0704 | 3.0714 | 3.0646 | 3.0675 | 13805008.0 |
| 2007-02-01 10:05:00 | AAPL | Stock | 3.0675 | 3.0711 | 3.0586 | 3.0589 | 18052440.0 |
| 2007-02-01 10:10:00 | AAPL | Stock | 3.0589 | 3.0604 | 3.0518 | 3.0546 | 19571804.0 |
| 2007-02-01 10:15:00 | AAPL | Stock | 3.0543 | 3.0643 | 3.0543 | 3.0579 | 13578068.0 |
| 2007-02-01 10:20:00 | AAPL | Stock | 3.0579 | 3.0604 | 3.0507 | 3.055 | 10212580.0 |
| 2007-02-01 10:25:00 | AAPL | Stock | 3.055 | 3.0596 | 3.055 | 3.056 | 6652744.0 |
| 2007-02-01 10:30:00 | AAPL | Stock | 3.0561 | 3.06 | 3.0539 | 3.0575 | 5936084.0 |
| 2007-02-01 10:35:00 | AAPL | Stock | 3.0579 | 3.0621 | 3.055 | 3.0593 | 6606964.0 |
| 2007-02-01 10:40:00 | AAPL | Stock | 3.0593 | 3.0679 | 3.0571 | 3.0661 | 13275500.0 |
| 2007-02-01 10:45:00 | AAPL | Stock | 3.0657 | 3.0668 | 3.0621 | 3.0639 | 6629504.0 |
| 2007-02-01 10:50:00 | AAPL | Stock | 3.0639 | 3.0639 | 3.0575 | 3.0582 | 5930652.0 |
| 2007-02-01 10:55:00 | AAPL | Stock | 3.0586 | 3.0589 | 3.0543 | 3.0554 | 5090652.0 |
| 2007-02-01 11:00:00 | AAPL | Stock | 3.0546 | 3.0561 | 3.0361 | 3.0368 | 17485664.0 |
| 2007-02-01 11:05:00 | AAPL | Stock | 3.0371 | 3.0411 | 3.0296 | 3.0407 | 22297212.0 |
| 2007-02-01 11:10:00 | AAPL | Stock | 3.0407 | 3.0421 | 3.0346 | 3.0381 | 11325188.0 |
| 2007-02-01 11:15:00 | AAPL | Stock | 3.0375 | 3.0382 | 3.0311 | 3.0336 | 9400132.0 |
| 2007-02-01 11:20:00 | AAPL | Stock | 3.0336 | 3.0361 | 3.0289 | 3.0321 | 10634568.0 |
| 2007-02-01 11:25:00 | AAPL | Stock | 3.0318 | 3.0429 | 3.0318 | 3.0421 | 7480312.0 |
| 2007-02-01 11:30:00 | AAPL | Stock | 3.0418 | 3.0482 | 3.0411 | 3.0443 | 9878708.0 |
| 2007-02-01 11:35:00 | AAPL | Stock | 3.0443 | 3.0468 | 3.0414 | 3.0432 | 5143180.0 |
| 2007-02-01 11:40:00 | AAPL | Stock | 3.0432 | 3.0454 | 3.0371 | 3.04 | 6403684.0 |
> showing 50 of 244,080 rows — these rows as CSV