PREVIEW / stock_5min / 2007-06-04
file: by_date/stock_5min/2007/2007-06-04.parquet size: 4.0 MB rows: 294,423 symbols: 3,040
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-06-04 09:30:00 | AAPL | Stock | 4.2368 | 4.2411 | 4.2107 | 4.2236 | 28927388.0 |
| 2007-06-04 09:35:00 | AAPL | Stock | 4.2243 | 4.2639 | 4.2232 | 4.2546 | 28056196.0 |
| 2007-06-04 09:40:00 | AAPL | Stock | 4.2546 | 4.2821 | 4.2507 | 4.2693 | 32267368.0 |
| 2007-06-04 09:45:00 | AAPL | Stock | 4.2689 | 4.2957 | 4.2657 | 4.295 | 24898468.0 |
| 2007-06-04 09:50:00 | AAPL | Stock | 4.2936 | 4.3089 | 4.2818 | 4.2829 | 28352212.0 |
| 2007-06-04 09:55:00 | AAPL | Stock | 4.2832 | 4.3014 | 4.2771 | 4.2989 | 19653536.0 |
| 2007-06-04 10:00:00 | AAPL | Stock | 4.2993 | 4.2996 | 4.2804 | 4.2911 | 16105460.0 |
| 2007-06-04 10:05:00 | AAPL | Stock | 4.2918 | 4.3032 | 4.2846 | 4.2971 | 21236404.0 |
| 2007-06-04 10:10:00 | AAPL | Stock | 4.2964 | 4.3264 | 4.2964 | 4.3196 | 41208748.0 |
| 2007-06-04 10:15:00 | AAPL | Stock | 4.3196 | 4.3271 | 4.3143 | 4.3186 | 18354000.0 |
| 2007-06-04 10:20:00 | AAPL | Stock | 4.3186 | 4.3279 | 4.3146 | 4.3157 | 16993032.0 |
| 2007-06-04 10:25:00 | AAPL | Stock | 4.3154 | 4.3196 | 4.3104 | 4.3161 | 13056708.0 |
| 2007-06-04 10:30:00 | AAPL | Stock | 4.3161 | 4.3282 | 4.3161 | 4.3229 | 12204444.0 |
| 2007-06-04 10:35:00 | AAPL | Stock | 4.3229 | 4.3232 | 4.3093 | 4.3179 | 12004244.0 |
| 2007-06-04 10:40:00 | AAPL | Stock | 4.3179 | 4.3179 | 4.3025 | 4.3129 | 14529648.0 |
| 2007-06-04 10:45:00 | AAPL | Stock | 4.3125 | 4.3193 | 4.3036 | 4.3039 | 12385856.0 |
| 2007-06-04 10:50:00 | AAPL | Stock | 4.3043 | 4.3125 | 4.3 | 4.3068 | 11274116.0 |
| 2007-06-04 10:55:00 | AAPL | Stock | 4.3057 | 4.3114 | 4.3054 | 4.3079 | 8556072.0 |
| 2007-06-04 11:00:00 | AAPL | Stock | 4.3079 | 4.3107 | 4.3054 | 4.3068 | 8382752.0 |
| 2007-06-04 11:05:00 | AAPL | Stock | 4.3071 | 4.3161 | 4.3061 | 4.3157 | 8851304.0 |
| 2007-06-04 11:10:00 | AAPL | Stock | 4.3161 | 4.3164 | 4.3057 | 4.3107 | 7788172.0 |
| 2007-06-04 11:15:00 | AAPL | Stock | 4.3111 | 4.3114 | 4.3 | 4.3082 | 8424500.0 |
| 2007-06-04 11:20:00 | AAPL | Stock | 4.3082 | 4.3082 | 4.297 | 4.3 | 7957460.0 |
| 2007-06-04 11:25:00 | AAPL | Stock | 4.2993 | 4.3036 | 4.2936 | 4.3011 | 10380804.0 |
| 2007-06-04 11:30:00 | AAPL | Stock | 4.3011 | 4.3011 | 4.2929 | 4.2954 | 8236060.0 |
| 2007-06-04 11:35:00 | AAPL | Stock | 4.2957 | 4.3018 | 4.2918 | 4.2961 | 7639996.0 |
| 2007-06-04 11:40:00 | AAPL | Stock | 4.2961 | 4.2964 | 4.2854 | 4.2861 | 10706864.0 |
| 2007-06-04 11:45:00 | AAPL | Stock | 4.2857 | 4.2957 | 4.2839 | 4.295 | 9769256.0 |
| 2007-06-04 11:50:00 | AAPL | Stock | 4.295 | 4.3 | 4.2921 | 4.2961 | 7346584.0 |
| 2007-06-04 11:55:00 | AAPL | Stock | 4.295 | 4.2982 | 4.2911 | 4.2964 | 5841976.0 |
| 2007-06-04 12:00:00 | AAPL | Stock | 4.2964 | 4.3014 | 4.2954 | 4.2971 | 6918940.0 |
| 2007-06-04 12:05:00 | AAPL | Stock | 4.2971 | 4.2982 | 4.2896 | 4.2904 | 6031200.0 |
| 2007-06-04 12:10:00 | AAPL | Stock | 4.2907 | 4.2982 | 4.2893 | 4.2907 | 6370280.0 |
| 2007-06-04 12:15:00 | AAPL | Stock | 4.2893 | 4.2925 | 4.2864 | 4.2918 | 4936988.0 |
| 2007-06-04 12:20:00 | AAPL | Stock | 4.2918 | 4.2946 | 4.2286 | 4.2904 | 9052120.0 |
| 2007-06-04 12:25:00 | AAPL | Stock | 4.2911 | 4.2911 | 4.2286 | 4.2889 | 7317940.0 |
| 2007-06-04 12:30:00 | AAPL | Stock | 4.2889 | 4.29 | 4.2818 | 4.2864 | 11506964.0 |
| 2007-06-04 12:35:00 | AAPL | Stock | 4.2864 | 4.2904 | 4.2843 | 4.29 | 7612948.0 |
| 2007-06-04 12:40:00 | AAPL | Stock | 4.29 | 4.2921 | 4.2757 | 4.2768 | 10666460.0 |
| 2007-06-04 12:45:00 | AAPL | Stock | 4.2768 | 4.285 | 4.2757 | 4.2832 | 5275256.0 |
| 2007-06-04 12:50:00 | AAPL | Stock | 4.2825 | 4.2846 | 4.2804 | 4.2807 | 4380376.0 |
| 2007-06-04 12:55:00 | AAPL | Stock | 4.2805 | 4.2836 | 4.2761 | 4.2771 | 4099704.0 |
| 2007-06-04 13:00:00 | AAPL | Stock | 4.2771 | 4.2796 | 4.2714 | 4.2793 | 7090916.0 |
| 2007-06-04 13:05:00 | AAPL | Stock | 4.2793 | 4.2825 | 4.2786 | 4.2796 | 3743152.0 |
| 2007-06-04 13:10:00 | AAPL | Stock | 4.2796 | 4.2829 | 4.2771 | 4.2811 | 3532172.0 |
| 2007-06-04 13:15:00 | AAPL | Stock | 4.2818 | 4.2829 | 4.2761 | 4.2779 | 3340204.0 |
| 2007-06-04 13:20:00 | AAPL | Stock | 4.2775 | 4.2779 | 4.2696 | 4.2768 | 7576212.0 |
| 2007-06-04 13:25:00 | AAPL | Stock | 4.2768 | 4.2768 | 4.2704 | 4.2761 | 4185636.0 |
| 2007-06-04 13:30:00 | AAPL | Stock | 4.2764 | 4.2779 | 4.2721 | 4.2725 | 3870132.0 |
| 2007-06-04 13:35:00 | AAPL | Stock | 4.2721 | 4.2832 | 4.2721 | 4.2787 | 7446740.0 |
> showing 50 of 294,423 rows — these rows as CSV