PREVIEW / stock_5min / 2005-04-28
file: by_date/stock_5min/2005/2005-04-28.parquet size: 2.7 MB rows: 193,981 symbols: 1,961
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-04-28 07:35:00 | AAPL | Stock | 1.3175 | 1.3175 | 1.3175 | 1.3175 | 14000.0 |
| 2005-04-28 07:40:00 | AAPL | Stock | 1.3032 | 1.3032 | 1.3032 | 1.3032 | 5600.0 |
| 2005-04-28 07:50:00 | AAPL | Stock | 1.2939 | 1.2939 | 1.2939 | 1.2939 | 12040.0 |
| 2005-04-28 08:00:00 | AAPL | Stock | 1.2982 | 1.3007 | 1.2929 | 1.2946 | 534996.0 |
| 2005-04-28 08:05:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2936 | 1.2939 | 65800.0 |
| 2005-04-28 08:10:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2954 | 1.2954 | 50400.0 |
| 2005-04-28 08:15:00 | AAPL | Stock | 1.2954 | 1.2982 | 1.2936 | 1.2975 | 713664.0 |
| 2005-04-28 08:20:00 | AAPL | Stock | 1.2971 | 1.2982 | 1.2954 | 1.2975 | 170800.0 |
| 2005-04-28 08:25:00 | AAPL | Stock | 1.2964 | 1.2975 | 1.2964 | 1.2968 | 86800.0 |
| 2005-04-28 08:30:00 | AAPL | Stock | 1.2964 | 1.2971 | 1.2929 | 1.295 | 753256.0 |
| 2005-04-28 08:35:00 | AAPL | Stock | 1.295 | 1.2964 | 1.2943 | 1.2961 | 237160.0 |
| 2005-04-28 08:40:00 | AAPL | Stock | 1.2961 | 1.3007 | 1.2961 | 1.2982 | 472920.0 |
| 2005-04-28 08:45:00 | AAPL | Stock | 1.2982 | 1.3014 | 1.2979 | 1.3 | 647248.0 |
| 2005-04-28 08:50:00 | AAPL | Stock | 1.2982 | 1.2993 | 1.2982 | 1.2982 | 271600.0 |
| 2005-04-28 08:55:00 | AAPL | Stock | 1.2986 | 1.3014 | 1.2982 | 1.3014 | 538020.0 |
| 2005-04-28 09:00:00 | AAPL | Stock | 1.3014 | 1.3036 | 1.3 | 1.3014 | 715400.0 |
| 2005-04-28 09:05:00 | AAPL | Stock | 1.3018 | 1.3025 | 1.3 | 1.3025 | 340340.0 |
| 2005-04-28 09:10:00 | AAPL | Stock | 1.3025 | 1.3032 | 1.3 | 1.3 | 622020.0 |
| 2005-04-28 09:15:00 | AAPL | Stock | 1.3 | 1.3 | 1.2964 | 1.2982 | 178472.0 |
| 2005-04-28 09:20:00 | AAPL | Stock | 1.2986 | 1.3007 | 1.2971 | 1.2971 | 220920.0 |
| 2005-04-28 09:25:00 | AAPL | Stock | 1.2964 | 1.2982 | 1.2946 | 1.2968 | 1152620.0 |
| 2005-04-28 09:30:00 | AAPL | Stock | 1.2961 | 1.2979 | 1.2879 | 1.2943 | 17228680.0 |
| 2005-04-28 09:35:00 | AAPL | Stock | 1.2943 | 1.295 | 1.2875 | 1.2886 | 10064600.0 |
| 2005-04-28 09:40:00 | AAPL | Stock | 1.2889 | 1.2939 | 1.2886 | 1.2893 | 9634184.0 |
| 2005-04-28 09:45:00 | AAPL | Stock | 1.2893 | 1.2907 | 1.2768 | 1.2768 | 17433220.0 |
| 2005-04-28 09:50:00 | AAPL | Stock | 1.2768 | 1.2829 | 1.2761 | 1.2779 | 9156700.0 |
| 2005-04-28 09:55:00 | AAPL | Stock | 1.2771 | 1.2811 | 1.2732 | 1.2789 | 16072700.0 |
| 2005-04-28 10:00:00 | AAPL | Stock | 1.2786 | 1.2875 | 1.2768 | 1.2839 | 10587892.0 |
| 2005-04-28 10:05:00 | AAPL | Stock | 1.2839 | 1.2875 | 1.2793 | 1.2818 | 8121484.0 |
| 2005-04-28 10:10:00 | AAPL | Stock | 1.2814 | 1.2832 | 1.28 | 1.2804 | 5637016.0 |
| 2005-04-28 10:15:00 | AAPL | Stock | 1.2804 | 1.2825 | 1.2771 | 1.28 | 9555532.0 |
| 2005-04-28 10:20:00 | AAPL | Stock | 1.28 | 1.2871 | 1.2779 | 1.2843 | 8719480.0 |
| 2005-04-28 10:25:00 | AAPL | Stock | 1.2839 | 1.285 | 1.2814 | 1.2839 | 3812228.0 |
| 2005-04-28 10:30:00 | AAPL | Stock | 1.2839 | 1.2893 | 1.2829 | 1.2846 | 9796780.0 |
| 2005-04-28 10:35:00 | AAPL | Stock | 1.285 | 1.2864 | 1.2811 | 1.2821 | 7507920.0 |
| 2005-04-28 10:40:00 | AAPL | Stock | 1.2818 | 1.2832 | 1.2803 | 1.2814 | 6770428.0 |
| 2005-04-28 10:45:00 | AAPL | Stock | 1.2818 | 1.2832 | 1.2796 | 1.2807 | 4247432.0 |
| 2005-04-28 10:50:00 | AAPL | Stock | 1.2804 | 1.2811 | 1.2761 | 1.2768 | 10061548.0 |
| 2005-04-28 10:55:00 | AAPL | Stock | 1.2764 | 1.2825 | 1.2761 | 1.2804 | 8786036.0 |
| 2005-04-28 11:00:00 | AAPL | Stock | 1.2804 | 1.2811 | 1.2754 | 1.2768 | 8450820.0 |
| 2005-04-28 11:05:00 | AAPL | Stock | 1.2771 | 1.2796 | 1.2757 | 1.2775 | 4662112.0 |
| 2005-04-28 11:10:00 | AAPL | Stock | 1.2775 | 1.2796 | 1.2768 | 1.2779 | 3760148.0 |
| 2005-04-28 11:15:00 | AAPL | Stock | 1.2782 | 1.2825 | 1.2779 | 1.2821 | 3963820.0 |
| 2005-04-28 11:20:00 | AAPL | Stock | 1.2825 | 1.2846 | 1.2793 | 1.28 | 3503164.0 |
| 2005-04-28 11:25:00 | AAPL | Stock | 1.28 | 1.28 | 1.2775 | 1.2782 | 3628128.0 |
| 2005-04-28 11:30:00 | AAPL | Stock | 1.2782 | 1.2786 | 1.2728 | 1.2729 | 11132156.0 |
| 2005-04-28 11:35:00 | AAPL | Stock | 1.2729 | 1.2757 | 1.2707 | 1.2736 | 8702064.0 |
| 2005-04-28 11:40:00 | AAPL | Stock | 1.2736 | 1.275 | 1.2711 | 1.2739 | 7029232.0 |
| 2005-04-28 11:45:00 | AAPL | Stock | 1.2736 | 1.2746 | 1.27 | 1.2714 | 6611976.0 |
| 2005-04-28 11:50:00 | AAPL | Stock | 1.2714 | 1.2875 | 1.2657 | 1.2696 | 12700912.0 |
> showing 50 of 193,981 rows — these rows as CSV