PREVIEW / stock_5min / 2002-07-17
file: by_date/stock_5min/2002/2002-07-17.parquet size: 1.9 MB rows: 131,556 symbols: 1,440
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-17 08:00:00 | AAPL | Stock | 0.2964 | 0.2989 | 0.292 | 0.2979 | 789600.0 |
| 2002-07-17 08:05:00 | AAPL | Stock | 0.2964 | 0.2989 | 0.2964 | 0.2989 | 291200.0 |
| 2002-07-17 08:10:00 | AAPL | Stock | 0.2991 | 0.2991 | 0.2955 | 0.2991 | 459200.0 |
| 2002-07-17 08:15:00 | AAPL | Stock | 0.2966 | 0.2991 | 0.2911 | 0.2911 | 4300800.0 |
| 2002-07-17 08:20:00 | AAPL | Stock | 0.2946 | 0.2982 | 0.2929 | 0.2929 | 554400.0 |
| 2002-07-17 08:25:00 | AAPL | Stock | 0.2946 | 0.2946 | 0.2938 | 0.2938 | 655200.0 |
| 2002-07-17 08:30:00 | AAPL | Stock | 0.2945 | 0.2945 | 0.2913 | 0.292 | 3259200.0 |
| 2002-07-17 08:35:00 | AAPL | Stock | 0.2911 | 0.2988 | 0.291 | 0.2918 | 1551200.0 |
| 2002-07-17 08:40:00 | AAPL | Stock | 0.292 | 0.292 | 0.288 | 0.2902 | 1954400.0 |
| 2002-07-17 08:45:00 | AAPL | Stock | 0.2902 | 0.292 | 0.2893 | 0.2911 | 1814400.0 |
| 2002-07-17 08:50:00 | AAPL | Stock | 0.2911 | 0.2948 | 0.2893 | 0.2902 | 2620800.0 |
| 2002-07-17 08:55:00 | AAPL | Stock | 0.2911 | 0.292 | 0.2896 | 0.2902 | 2856000.0 |
| 2002-07-17 09:00:00 | AAPL | Stock | 0.29 | 0.2902 | 0.2898 | 0.2898 | 1932000.0 |
| 2002-07-17 09:05:00 | AAPL | Stock | 0.2898 | 0.2909 | 0.2893 | 0.2893 | 2016000.0 |
| 2002-07-17 09:10:00 | AAPL | Stock | 0.2893 | 0.2909 | 0.2886 | 0.2893 | 2200800.0 |
| 2002-07-17 09:15:00 | AAPL | Stock | 0.2893 | 0.3171 | 0.2884 | 0.2884 | 3640000.0 |
| 2002-07-17 09:20:00 | AAPL | Stock | 0.2909 | 0.2916 | 0.2884 | 0.2891 | 3505600.0 |
| 2002-07-17 09:25:00 | AAPL | Stock | 0.2877 | 0.2902 | 0.2857 | 0.2884 | 5415200.0 |
| 2002-07-17 09:30:00 | AAPL | Stock | 0.288 | 0.2889 | 0.2804 | 0.2841 | 62949600.0 |
| 2002-07-17 09:35:00 | AAPL | Stock | 0.2838 | 0.2843 | 0.2823 | 0.2823 | 57400000.0 |
| 2002-07-17 09:40:00 | AAPL | Stock | 0.2823 | 0.283 | 0.2795 | 0.2805 | 37223200.0 |
| 2002-07-17 09:45:00 | AAPL | Stock | 0.2805 | 0.282 | 0.2804 | 0.2804 | 27350400.0 |
| 2002-07-17 09:50:00 | AAPL | Stock | 0.2805 | 0.2814 | 0.2796 | 0.2804 | 23637600.0 |
| 2002-07-17 09:55:00 | AAPL | Stock | 0.2804 | 0.2814 | 0.2777 | 0.2786 | 46368000.0 |
| 2002-07-17 10:00:00 | AAPL | Stock | 0.2786 | 0.2813 | 0.2779 | 0.28 | 48899200.0 |
| 2002-07-17 10:05:00 | AAPL | Stock | 0.28 | 0.2827 | 0.2798 | 0.2827 | 23385600.0 |
| 2002-07-17 10:10:00 | AAPL | Stock | 0.2825 | 0.2832 | 0.2804 | 0.2804 | 36926400.0 |
| 2002-07-17 10:15:00 | AAPL | Stock | 0.2804 | 0.2813 | 0.2771 | 0.2784 | 27658400.0 |
| 2002-07-17 10:20:00 | AAPL | Stock | 0.2784 | 0.2793 | 0.2739 | 0.2755 | 24382400.0 |
| 2002-07-17 10:25:00 | AAPL | Stock | 0.2755 | 0.2777 | 0.2741 | 0.2777 | 19510400.0 |
| 2002-07-17 10:30:00 | AAPL | Stock | 0.2777 | 0.2793 | 0.2752 | 0.2755 | 19017600.0 |
| 2002-07-17 10:35:00 | AAPL | Stock | 0.2755 | 0.2771 | 0.2746 | 0.2746 | 20692000.0 |
| 2002-07-17 10:40:00 | AAPL | Stock | 0.2746 | 0.2752 | 0.2718 | 0.272 | 23688000.0 |
| 2002-07-17 10:45:00 | AAPL | Stock | 0.272 | 0.2741 | 0.2714 | 0.2738 | 27064800.0 |
| 2002-07-17 10:50:00 | AAPL | Stock | 0.2739 | 0.2777 | 0.2738 | 0.2773 | 18984000.0 |
| 2002-07-17 10:55:00 | AAPL | Stock | 0.2775 | 0.2777 | 0.2754 | 0.2768 | 15467200.0 |
| 2002-07-17 11:00:00 | AAPL | Stock | 0.2768 | 0.2789 | 0.2768 | 0.2789 | 13591200.0 |
| 2002-07-17 11:05:00 | AAPL | Stock | 0.2787 | 0.2791 | 0.2768 | 0.2784 | 16514400.0 |
| 2002-07-17 11:10:00 | AAPL | Stock | 0.2786 | 0.2804 | 0.2782 | 0.2802 | 11144000.0 |
| 2002-07-17 11:15:00 | AAPL | Stock | 0.2798 | 0.2802 | 0.2773 | 0.2773 | 16660000.0 |
| 2002-07-17 11:20:00 | AAPL | Stock | 0.2773 | 0.278 | 0.2768 | 0.2773 | 2273600.0 |
| 2002-07-17 11:25:00 | AAPL | Stock | 0.277 | 0.2773 | 0.2755 | 0.2759 | 15775200.0 |
| 2002-07-17 11:30:00 | AAPL | Stock | 0.2756 | 0.2759 | 0.2732 | 0.2757 | 26532800.0 |
| 2002-07-17 11:35:00 | AAPL | Stock | 0.2757 | 0.2768 | 0.2755 | 0.2761 | 6888000.0 |
| 2002-07-17 11:40:00 | AAPL | Stock | 0.2763 | 0.2777 | 0.2754 | 0.2759 | 5930400.0 |
| 2002-07-17 11:45:00 | AAPL | Stock | 0.2761 | 0.2768 | 0.2754 | 0.2761 | 6591200.0 |
| 2002-07-17 11:50:00 | AAPL | Stock | 0.2761 | 0.277 | 0.2754 | 0.277 | 4116000.0 |
| 2002-07-17 11:55:00 | AAPL | Stock | 0.2768 | 0.2777 | 0.2766 | 0.2768 | 10477600.0 |
| 2002-07-17 12:00:00 | AAPL | Stock | 0.2768 | 0.2779 | 0.2768 | 0.2768 | 4356800.0 |
| 2002-07-17 12:05:00 | AAPL | Stock | 0.2771 | 0.2775 | 0.2763 | 0.2766 | 6406400.0 |
> showing 50 of 131,556 rows — these rows as CSV