PREVIEW / stock_5min / 2001-09-27
file: by_date/stock_5min/2001/2001-09-27.parquet size: 1.6 MB rows: 108,654 symbols: 1,338
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 |
|---|---|---|---|---|---|---|---|
| 2001-09-27 08:30:00 | AAPL | Stock | 0.2695 | 0.2695 | 0.2695 | 0.2695 | 140000.0 |
| 2001-09-27 08:35:00 | AAPL | Stock | 0.2713 | 0.2713 | 0.2713 | 0.2713 | 168000.0 |
| 2001-09-27 08:45:00 | AAPL | Stock | 0.2705 | 0.2705 | 0.2705 | 0.2705 | 100800.0 |
| 2001-09-27 09:15:00 | AAPL | Stock | 0.2732 | 0.275 | 0.2703 | 0.2704 | 291200.0 |
| 2001-09-27 09:20:00 | AAPL | Stock | 0.2705 | 0.2714 | 0.2705 | 0.2714 | 173600.0 |
| 2001-09-27 09:25:00 | AAPL | Stock | 0.272 | 0.2721 | 0.2713 | 0.272 | 750400.0 |
| 2001-09-27 09:30:00 | AAPL | Stock | 0.2723 | 0.2768 | 0.2714 | 0.2768 | 7655200.0 |
| 2001-09-27 09:35:00 | AAPL | Stock | 0.2768 | 0.2777 | 0.2741 | 0.2759 | 5420800.0 |
| 2001-09-27 09:40:00 | AAPL | Stock | 0.2755 | 0.2768 | 0.2755 | 0.2755 | 12885600.0 |
| 2001-09-27 09:45:00 | AAPL | Stock | 0.2757 | 0.2777 | 0.2752 | 0.2777 | 4200000.0 |
| 2001-09-27 09:50:00 | AAPL | Stock | 0.2777 | 0.278 | 0.2768 | 0.2771 | 6160000.0 |
| 2001-09-27 09:55:00 | AAPL | Stock | 0.2773 | 0.2777 | 0.2768 | 0.2771 | 3382400.0 |
| 2001-09-27 10:00:00 | AAPL | Stock | 0.2771 | 0.2798 | 0.2759 | 0.2798 | 3880800.0 |
| 2001-09-27 10:05:00 | AAPL | Stock | 0.28 | 0.2804 | 0.2768 | 0.277 | 5549600.0 |
| 2001-09-27 10:10:00 | AAPL | Stock | 0.277 | 0.2777 | 0.2766 | 0.2773 | 3964800.0 |
| 2001-09-27 10:15:00 | AAPL | Stock | 0.2773 | 0.2786 | 0.277 | 0.2775 | 2777600.0 |
| 2001-09-27 10:20:00 | AAPL | Stock | 0.2775 | 0.2779 | 0.277 | 0.2771 | 2592800.0 |
| 2001-09-27 10:25:00 | AAPL | Stock | 0.2773 | 0.2777 | 0.2768 | 0.2768 | 3757600.0 |
| 2001-09-27 10:30:00 | AAPL | Stock | 0.2768 | 0.277 | 0.2764 | 0.2768 | 5028800.0 |
| 2001-09-27 10:35:00 | AAPL | Stock | 0.2764 | 0.2768 | 0.2761 | 0.2761 | 4060000.0 |
| 2001-09-27 10:40:00 | AAPL | Stock | 0.2763 | 0.2773 | 0.2763 | 0.2764 | 4368000.0 |
| 2001-09-27 10:45:00 | AAPL | Stock | 0.2764 | 0.2771 | 0.2763 | 0.2771 | 7599200.0 |
| 2001-09-27 10:50:00 | AAPL | Stock | 0.277 | 0.278 | 0.277 | 0.2775 | 2105600.0 |
| 2001-09-27 10:55:00 | AAPL | Stock | 0.2775 | 0.2788 | 0.2771 | 0.2784 | 3253600.0 |
| 2001-09-27 11:00:00 | AAPL | Stock | 0.2784 | 0.2784 | 0.2773 | 0.2777 | 3864000.0 |
| 2001-09-27 11:05:00 | AAPL | Stock | 0.2777 | 0.2782 | 0.2773 | 0.2773 | 1069600.0 |
| 2001-09-27 11:10:00 | AAPL | Stock | 0.2773 | 0.2773 | 0.2768 | 0.2768 | 980000.0 |
| 2001-09-27 11:15:00 | AAPL | Stock | 0.2768 | 0.2777 | 0.2768 | 0.2773 | 1836800.0 |
| 2001-09-27 11:20:00 | AAPL | Stock | 0.2775 | 0.2777 | 0.2771 | 0.2775 | 1422400.0 |
| 2001-09-27 11:25:00 | AAPL | Stock | 0.2775 | 0.2782 | 0.2773 | 0.2773 | 1730400.0 |
| 2001-09-27 11:30:00 | AAPL | Stock | 0.2775 | 0.2784 | 0.2773 | 0.2782 | 5656000.0 |
| 2001-09-27 11:35:00 | AAPL | Stock | 0.2782 | 0.2791 | 0.2782 | 0.2782 | 3589600.0 |
| 2001-09-27 11:40:00 | AAPL | Stock | 0.278 | 0.2795 | 0.278 | 0.2795 | 2783200.0 |
| 2001-09-27 11:45:00 | AAPL | Stock | 0.2791 | 0.2803 | 0.2791 | 0.2796 | 2581600.0 |
| 2001-09-27 11:50:00 | AAPL | Stock | 0.2793 | 0.2795 | 0.2786 | 0.2788 | 6764800.0 |
| 2001-09-27 11:55:00 | AAPL | Stock | 0.2788 | 0.2788 | 0.2782 | 0.2782 | 2055200.0 |
| 2001-09-27 12:00:00 | AAPL | Stock | 0.2782 | 0.2796 | 0.2782 | 0.2796 | 3656800.0 |
| 2001-09-27 12:05:00 | AAPL | Stock | 0.2793 | 0.2802 | 0.2793 | 0.28 | 1506400.0 |
| 2001-09-27 12:10:00 | AAPL | Stock | 0.2804 | 0.2804 | 0.2791 | 0.2791 | 1792000.0 |
| 2001-09-27 12:15:00 | AAPL | Stock | 0.2791 | 0.2791 | 0.2782 | 0.2782 | 6384000.0 |
| 2001-09-27 12:20:00 | AAPL | Stock | 0.278 | 0.2795 | 0.278 | 0.2795 | 711200.0 |
| 2001-09-27 12:25:00 | AAPL | Stock | 0.2791 | 0.2798 | 0.2791 | 0.2796 | 1282400.0 |
| 2001-09-27 12:30:00 | AAPL | Stock | 0.2796 | 0.2796 | 0.2775 | 0.2775 | 4356800.0 |
| 2001-09-27 12:35:00 | AAPL | Stock | 0.2779 | 0.278 | 0.2768 | 0.277 | 12376000.0 |
| 2001-09-27 12:40:00 | AAPL | Stock | 0.2771 | 0.2775 | 0.2768 | 0.277 | 487200.0 |
| 2001-09-27 12:45:00 | AAPL | Stock | 0.2771 | 0.2771 | 0.2768 | 0.2768 | 1349600.0 |
| 2001-09-27 12:50:00 | AAPL | Stock | 0.277 | 0.2771 | 0.2768 | 0.277 | 492800.0 |
| 2001-09-27 12:55:00 | AAPL | Stock | 0.277 | 0.2775 | 0.2768 | 0.2771 | 1892800.0 |
| 2001-09-27 13:00:00 | AAPL | Stock | 0.277 | 0.2775 | 0.277 | 0.2771 | 1842400.0 |
| 2001-09-27 13:05:00 | AAPL | Stock | 0.2773 | 0.2773 | 0.277 | 0.2771 | 375200.0 |
> showing 50 of 108,654 rows — these rows as CSV