PREVIEW / stock_5min / 2005-07-25
file: by_date/stock_5min/2005/2005-07-25.parquet size: 2.8 MB rows: 201,467 symbols: 2,042
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-25 08:00:00 | AAPL | Stock | 1.5718 | 1.5811 | 1.5714 | 1.5714 | 87360.0 |
| 2005-07-25 08:05:00 | AAPL | Stock | 1.5768 | 1.5768 | 1.5743 | 1.575 | 48860.0 |
| 2005-07-25 08:15:00 | AAPL | Stock | 1.575 | 1.5775 | 1.575 | 1.5768 | 67900.0 |
| 2005-07-25 08:20:00 | AAPL | Stock | 1.5775 | 1.5775 | 1.5768 | 1.5768 | 25200.0 |
| 2005-07-25 08:25:00 | AAPL | Stock | 1.5768 | 1.5768 | 1.5768 | 1.5768 | 55300.0 |
| 2005-07-25 08:30:00 | AAPL | Stock | 1.5757 | 1.5757 | 1.5757 | 1.5757 | 84000.0 |
| 2005-07-25 08:35:00 | AAPL | Stock | 1.575 | 1.575 | 1.575 | 1.575 | 28000.0 |
| 2005-07-25 08:40:00 | AAPL | Stock | 1.575 | 1.575 | 1.575 | 1.575 | 5740.0 |
| 2005-07-25 08:45:00 | AAPL | Stock | 1.5736 | 1.5736 | 1.5721 | 1.5721 | 53340.0 |
| 2005-07-25 08:50:00 | AAPL | Stock | 1.5718 | 1.575 | 1.5714 | 1.575 | 72240.0 |
| 2005-07-25 08:55:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5714 | 1.5714 | 50400.0 |
| 2005-07-25 09:00:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.57 | 1.57 | 51800.0 |
| 2005-07-25 09:05:00 | AAPL | Stock | 1.5729 | 1.575 | 1.5729 | 1.5739 | 50400.0 |
| 2005-07-25 09:10:00 | AAPL | Stock | 1.5714 | 1.5746 | 1.57 | 1.5714 | 81480.0 |
| 2005-07-25 09:15:00 | AAPL | Stock | 1.5714 | 1.5729 | 1.5689 | 1.5729 | 67200.0 |
| 2005-07-25 09:20:00 | AAPL | Stock | 1.5689 | 1.5711 | 1.5689 | 1.5711 | 33600.0 |
| 2005-07-25 09:25:00 | AAPL | Stock | 1.5714 | 1.5743 | 1.5686 | 1.5714 | 260400.0 |
| 2005-07-25 09:30:00 | AAPL | Stock | 1.5711 | 1.5814 | 1.5696 | 1.5768 | 20833512.0 |
| 2005-07-25 09:35:00 | AAPL | Stock | 1.5779 | 1.5786 | 1.5714 | 1.5739 | 10859632.0 |
| 2005-07-25 09:40:00 | AAPL | Stock | 1.5736 | 1.575 | 1.5682 | 1.5682 | 9540048.0 |
| 2005-07-25 09:45:00 | AAPL | Stock | 1.5682 | 1.5761 | 1.5679 | 1.5746 | 6562556.0 |
| 2005-07-25 09:50:00 | AAPL | Stock | 1.5746 | 1.575 | 1.5707 | 1.5714 | 7771932.0 |
| 2005-07-25 09:55:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5646 | 1.5661 | 12033588.0 |
| 2005-07-25 10:00:00 | AAPL | Stock | 1.5657 | 1.5675 | 1.5646 | 1.5664 | 5702508.0 |
| 2005-07-25 10:05:00 | AAPL | Stock | 1.5661 | 1.5711 | 1.5661 | 1.5693 | 4190620.0 |
| 2005-07-25 10:10:00 | AAPL | Stock | 1.5689 | 1.5711 | 1.5679 | 1.5704 | 3682840.0 |
| 2005-07-25 10:15:00 | AAPL | Stock | 1.5704 | 1.5782 | 1.5704 | 1.5782 | 6726692.0 |
| 2005-07-25 10:20:00 | AAPL | Stock | 1.5782 | 1.5796 | 1.5754 | 1.5768 | 5923624.0 |
| 2005-07-25 10:25:00 | AAPL | Stock | 1.5757 | 1.5782 | 1.5689 | 1.57 | 8317904.0 |
| 2005-07-25 10:30:00 | AAPL | Stock | 1.5704 | 1.5704 | 1.5675 | 1.57 | 3386152.0 |
| 2005-07-25 10:35:00 | AAPL | Stock | 1.57 | 1.5714 | 1.5693 | 1.5704 | 3977988.0 |
| 2005-07-25 10:40:00 | AAPL | Stock | 1.5704 | 1.5718 | 1.5686 | 1.5696 | 5593728.0 |
| 2005-07-25 10:45:00 | AAPL | Stock | 1.5693 | 1.5736 | 1.5693 | 1.5718 | 6057520.0 |
| 2005-07-25 10:50:00 | AAPL | Stock | 1.5714 | 1.5721 | 1.5661 | 1.5664 | 5465432.0 |
| 2005-07-25 10:55:00 | AAPL | Stock | 1.5661 | 1.5689 | 1.5654 | 1.5686 | 2961812.0 |
| 2005-07-25 11:00:00 | AAPL | Stock | 1.5682 | 1.5704 | 1.5675 | 1.5679 | 3675392.0 |
| 2005-07-25 11:05:00 | AAPL | Stock | 1.5682 | 1.5696 | 1.5661 | 1.5682 | 2561412.0 |
| 2005-07-25 11:10:00 | AAPL | Stock | 1.5679 | 1.5689 | 1.5671 | 1.5685 | 897288.0 |
| 2005-07-25 11:15:00 | AAPL | Stock | 1.5686 | 1.57 | 1.5671 | 1.57 | 3931676.0 |
| 2005-07-25 11:20:00 | AAPL | Stock | 1.57 | 1.5704 | 1.5682 | 1.5696 | 1604428.0 |
| 2005-07-25 11:25:00 | AAPL | Stock | 1.5693 | 1.5696 | 1.5668 | 1.5679 | 1870148.0 |
| 2005-07-25 11:30:00 | AAPL | Stock | 1.5675 | 1.5689 | 1.565 | 1.5654 | 8344784.0 |
| 2005-07-25 11:35:00 | AAPL | Stock | 1.5654 | 1.5679 | 1.5636 | 1.5661 | 4981172.0 |
| 2005-07-25 11:40:00 | AAPL | Stock | 1.5664 | 1.5668 | 1.5643 | 1.5661 | 1980104.0 |
| 2005-07-25 11:45:00 | AAPL | Stock | 1.5657 | 1.5661 | 1.5629 | 1.5646 | 3062584.0 |
| 2005-07-25 11:50:00 | AAPL | Stock | 1.5643 | 1.5646 | 1.5621 | 1.5639 | 3596544.0 |
| 2005-07-25 11:55:00 | AAPL | Stock | 1.5639 | 1.5664 | 1.5636 | 1.5657 | 2844352.0 |
| 2005-07-25 12:00:00 | AAPL | Stock | 1.5654 | 1.5661 | 1.5621 | 1.5636 | 2935744.0 |
| 2005-07-25 12:05:00 | AAPL | Stock | 1.5636 | 1.5654 | 1.5636 | 1.5654 | 1366540.0 |
| 2005-07-25 12:10:00 | AAPL | Stock | 1.5646 | 1.5654 | 1.5636 | 1.5646 | 645876.0 |
> showing 50 of 201,467 rows — these rows as CSV