PREVIEW / stock_5min / 2007-05-02
file: by_date/stock_5min/2007/2007-05-02.parquet size: 3.8 MB rows: 277,610 symbols: 2,695
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-05-02 09:30:00 | AAPL | Stock | 3.5589 | 3.5625 | 3.5525 | 3.5621 | 10865848.0 |
| 2007-05-02 09:35:00 | AAPL | Stock | 3.5625 | 3.5782 | 3.5571 | 3.5779 | 16617468.0 |
| 2007-05-02 09:40:00 | AAPL | Stock | 3.5782 | 3.5825 | 3.5721 | 3.5789 | 13738900.0 |
| 2007-05-02 09:45:00 | AAPL | Stock | 3.5793 | 3.5829 | 3.5711 | 3.5714 | 12573316.0 |
| 2007-05-02 09:50:00 | AAPL | Stock | 3.5721 | 3.575 | 3.5693 | 3.5693 | 7026404.0 |
| 2007-05-02 09:55:00 | AAPL | Stock | 3.5693 | 3.5771 | 3.5693 | 3.5739 | 7759920.0 |
| 2007-05-02 10:00:00 | AAPL | Stock | 3.5739 | 3.5786 | 3.5732 | 3.5782 | 6720308.0 |
| 2007-05-02 10:05:00 | AAPL | Stock | 3.5786 | 3.5786 | 3.5725 | 3.5757 | 7015316.0 |
| 2007-05-02 10:10:00 | AAPL | Stock | 3.5757 | 3.5786 | 3.5714 | 3.5775 | 6243552.0 |
| 2007-05-02 10:15:00 | AAPL | Stock | 3.5775 | 3.58 | 3.5725 | 3.5771 | 6098624.0 |
| 2007-05-02 10:20:00 | AAPL | Stock | 3.5768 | 3.5771 | 3.5614 | 3.5654 | 11006184.0 |
| 2007-05-02 10:25:00 | AAPL | Stock | 3.5657 | 3.5664 | 3.5614 | 3.5657 | 4373936.0 |
| 2007-05-02 10:30:00 | AAPL | Stock | 3.5657 | 3.5714 | 3.5632 | 3.5704 | 5699932.0 |
| 2007-05-02 10:35:00 | AAPL | Stock | 3.5703 | 3.5714 | 3.5664 | 3.57 | 6001968.0 |
| 2007-05-02 10:40:00 | AAPL | Stock | 3.5704 | 3.5714 | 3.5664 | 3.5675 | 5594008.0 |
| 2007-05-02 10:45:00 | AAPL | Stock | 3.5675 | 3.5704 | 3.5671 | 3.5675 | 5746580.0 |
| 2007-05-02 10:50:00 | AAPL | Stock | 3.5675 | 3.5682 | 3.565 | 3.565 | 6297872.0 |
| 2007-05-02 10:55:00 | AAPL | Stock | 3.5654 | 3.5671 | 3.5646 | 3.5654 | 4298224.0 |
| 2007-05-02 11:00:00 | AAPL | Stock | 3.5657 | 3.5668 | 3.5614 | 3.5646 | 6725348.0 |
| 2007-05-02 11:05:00 | AAPL | Stock | 3.5646 | 3.5689 | 3.5632 | 3.5643 | 6105456.0 |
| 2007-05-02 11:10:00 | AAPL | Stock | 3.5639 | 3.5643 | 3.5571 | 3.5604 | 7492968.0 |
| 2007-05-02 11:15:00 | AAPL | Stock | 3.5603 | 3.5654 | 3.56 | 3.5646 | 4732140.0 |
| 2007-05-02 11:20:00 | AAPL | Stock | 3.5643 | 3.5661 | 3.5629 | 3.5643 | 4731804.0 |
| 2007-05-02 11:25:00 | AAPL | Stock | 3.5643 | 3.5654 | 3.5632 | 3.5632 | 3454360.0 |
| 2007-05-02 11:30:00 | AAPL | Stock | 3.5636 | 3.5643 | 3.5625 | 3.5629 | 2592940.0 |
| 2007-05-02 11:35:00 | AAPL | Stock | 3.5632 | 3.5643 | 3.5607 | 3.5643 | 3655540.0 |
| 2007-05-02 11:40:00 | AAPL | Stock | 3.5643 | 3.5643 | 3.5625 | 3.5636 | 5513816.0 |
| 2007-05-02 11:45:00 | AAPL | Stock | 3.5639 | 3.5646 | 3.5625 | 3.5646 | 3682000.0 |
| 2007-05-02 11:50:00 | AAPL | Stock | 3.5646 | 3.5696 | 3.5646 | 3.5693 | 5186692.0 |
| 2007-05-02 11:55:00 | AAPL | Stock | 3.5693 | 3.5711 | 3.5675 | 3.5689 | 3527468.0 |
| 2007-05-02 12:00:00 | AAPL | Stock | 3.5689 | 3.5696 | 3.5661 | 3.5689 | 2892848.0 |
| 2007-05-02 12:05:00 | AAPL | Stock | 3.5689 | 3.5711 | 3.5682 | 3.5707 | 3026716.0 |
| 2007-05-02 12:10:00 | AAPL | Stock | 3.5707 | 3.575 | 3.57 | 3.5739 | 5894700.0 |
| 2007-05-02 12:15:00 | AAPL | Stock | 3.5739 | 3.5768 | 3.5732 | 3.5764 | 4442116.0 |
| 2007-05-02 12:20:00 | AAPL | Stock | 3.5761 | 3.58 | 3.5718 | 3.5764 | 9476712.0 |
| 2007-05-02 12:25:00 | AAPL | Stock | 3.5764 | 3.5765 | 3.5718 | 3.5729 | 3453324.0 |
| 2007-05-02 12:30:00 | AAPL | Stock | 3.5729 | 3.5768 | 3.5721 | 3.5739 | 4631284.0 |
| 2007-05-02 12:35:00 | AAPL | Stock | 3.574 | 3.575 | 3.5711 | 3.5732 | 3035592.0 |
| 2007-05-02 12:40:00 | AAPL | Stock | 3.5732 | 3.5761 | 3.5711 | 3.5717 | 3290028.0 |
| 2007-05-02 12:45:00 | AAPL | Stock | 3.5714 | 3.5768 | 3.5711 | 3.5736 | 2106496.0 |
| 2007-05-02 12:50:00 | AAPL | Stock | 3.5736 | 3.5757 | 3.5725 | 3.5754 | 2758308.0 |
| 2007-05-02 12:55:00 | AAPL | Stock | 3.5754 | 3.5757 | 3.5725 | 3.5736 | 1677984.0 |
| 2007-05-02 13:00:00 | AAPL | Stock | 3.5739 | 3.5779 | 3.5736 | 3.5743 | 2988664.0 |
| 2007-05-02 13:05:00 | AAPL | Stock | 3.5739 | 3.5761 | 3.5714 | 3.5743 | 3212972.0 |
| 2007-05-02 13:10:00 | AAPL | Stock | 3.5739 | 3.575 | 3.5725 | 3.5746 | 2002336.0 |
| 2007-05-02 13:15:00 | AAPL | Stock | 3.575 | 3.575 | 3.5732 | 3.575 | 1781332.0 |
| 2007-05-02 13:20:00 | AAPL | Stock | 3.5746 | 3.5796 | 3.5743 | 3.5793 | 5451292.0 |
| 2007-05-02 13:25:00 | AAPL | Stock | 3.5789 | 3.58 | 3.5786 | 3.5786 | 3746680.0 |
| 2007-05-02 13:30:00 | AAPL | Stock | 3.5786 | 3.5804 | 3.5786 | 3.5789 | 2887892.0 |
| 2007-05-02 13:35:00 | AAPL | Stock | 3.5796 | 3.58 | 3.5786 | 3.58 | 1432760.0 |
> showing 50 of 277,610 rows — these rows as CSV