PREVIEW / stock_5min / 2006-11-27
file: by_date/stock_5min/2006/2006-11-27.parquet size: 3.4 MB rows: 242,604 symbols: 2,457
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-27 06:50:00 | AAPL | Stock | 3.2725 | 3.2764 | 3.2725 | 3.2764 | 11200.0 |
| 2006-11-27 06:55:00 | AAPL | Stock | 3.2779 | 3.2857 | 3.2779 | 3.2857 | 75880.0 |
| 2006-11-27 07:00:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 23800.0 |
| 2006-11-27 07:10:00 | AAPL | Stock | 3.2857 | 3.2893 | 3.2857 | 3.2893 | 42000.0 |
| 2006-11-27 07:15:00 | AAPL | Stock | 3.2954 | 3.3032 | 3.295 | 3.2989 | 50400.0 |
| 2006-11-27 07:20:00 | AAPL | Stock | 3.3018 | 3.3025 | 3.3 | 3.3 | 47600.0 |
| 2006-11-27 07:25:00 | AAPL | Stock | 3.2964 | 3.2964 | 3.2936 | 3.2936 | 22400.0 |
| 2006-11-27 07:30:00 | AAPL | Stock | 3.2929 | 3.2993 | 3.2929 | 3.2993 | 39200.0 |
| 2006-11-27 07:35:00 | AAPL | Stock | 3.2993 | 3.2993 | 3.2911 | 3.2964 | 162400.0 |
| 2006-11-27 07:40:00 | AAPL | Stock | 3.2996 | 3.2996 | 3.2982 | 3.2982 | 103600.0 |
| 2006-11-27 07:45:00 | AAPL | Stock | 3.2971 | 3.2971 | 3.2971 | 3.2971 | 47600.0 |
| 2006-11-27 07:50:00 | AAPL | Stock | 3.2982 | 3.3036 | 3.2982 | 3.3036 | 241556.0 |
| 2006-11-27 07:55:00 | AAPL | Stock | 3.3039 | 3.3039 | 3.2989 | 3.2993 | 51576.0 |
| 2006-11-27 08:00:00 | AAPL | Stock | 3.3032 | 3.3082 | 3.2971 | 3.3068 | 1400000.0 |
| 2006-11-27 08:05:00 | AAPL | Stock | 3.3071 | 3.3089 | 3.3004 | 3.3032 | 868980.0 |
| 2006-11-27 08:10:00 | AAPL | Stock | 3.3007 | 3.3111 | 3.3007 | 3.3071 | 1248912.0 |
| 2006-11-27 08:15:00 | AAPL | Stock | 3.3071 | 3.3157 | 3.3071 | 3.3125 | 1594824.0 |
| 2006-11-27 08:20:00 | AAPL | Stock | 3.3125 | 3.3132 | 3.3071 | 3.3075 | 635320.0 |
| 2006-11-27 08:25:00 | AAPL | Stock | 3.3075 | 3.3089 | 3.3071 | 3.3089 | 179872.0 |
| 2006-11-27 08:30:00 | AAPL | Stock | 3.3071 | 3.3107 | 3.3071 | 3.3107 | 269276.0 |
| 2006-11-27 08:35:00 | AAPL | Stock | 3.3096 | 3.3107 | 3.3096 | 3.31 | 353472.0 |
| 2006-11-27 08:40:00 | AAPL | Stock | 3.3107 | 3.3107 | 3.3071 | 3.3071 | 435036.0 |
| 2006-11-27 08:45:00 | AAPL | Stock | 3.3057 | 3.3057 | 3.3 | 3.3007 | 906220.0 |
| 2006-11-27 08:50:00 | AAPL | Stock | 3.3039 | 3.3046 | 3.2975 | 3.2989 | 1653036.0 |
| 2006-11-27 08:55:00 | AAPL | Stock | 3.2982 | 3.3007 | 3.2946 | 3.3 | 585592.0 |
| 2006-11-27 09:00:00 | AAPL | Stock | 3.3 | 3.3029 | 3.2964 | 3.2989 | 404264.0 |
| 2006-11-27 09:05:00 | AAPL | Stock | 3.3007 | 3.3025 | 3.2982 | 3.3007 | 529900.0 |
| 2006-11-27 09:10:00 | AAPL | Stock | 3.3015 | 3.3046 | 3.2986 | 3.3018 | 1425284.0 |
| 2006-11-27 09:15:00 | AAPL | Stock | 3.3014 | 3.3025 | 3.2979 | 3.3011 | 310128.0 |
| 2006-11-27 09:20:00 | AAPL | Stock | 3.3011 | 3.3011 | 3.2918 | 3.2943 | 388276.0 |
| 2006-11-27 09:25:00 | AAPL | Stock | 3.2936 | 3.3046 | 3.2925 | 3.3036 | 1720852.0 |
| 2006-11-27 09:30:00 | AAPL | Stock | 3.3039 | 3.3171 | 3.2968 | 3.3146 | 41829200.0 |
| 2006-11-27 09:35:00 | AAPL | Stock | 3.3154 | 3.325 | 3.3075 | 3.3186 | 28144536.0 |
| 2006-11-27 09:40:00 | AAPL | Stock | 3.3182 | 3.3246 | 3.3143 | 3.3229 | 22876308.0 |
| 2006-11-27 09:45:00 | AAPL | Stock | 3.3221 | 3.3271 | 3.3164 | 3.3175 | 23424268.0 |
| 2006-11-27 09:50:00 | AAPL | Stock | 3.3179 | 3.3239 | 3.31 | 3.3104 | 22864576.0 |
| 2006-11-27 09:55:00 | AAPL | Stock | 3.31 | 3.3154 | 3.3054 | 3.3054 | 15217328.0 |
| 2006-11-27 10:00:00 | AAPL | Stock | 3.3061 | 3.3061 | 3.2879 | 3.2921 | 28781620.0 |
| 2006-11-27 10:05:00 | AAPL | Stock | 3.2921 | 3.2996 | 3.2875 | 3.2979 | 19996760.0 |
| 2006-11-27 10:10:00 | AAPL | Stock | 3.2982 | 3.2993 | 3.2771 | 3.2836 | 27441316.0 |
| 2006-11-27 10:15:00 | AAPL | Stock | 3.2829 | 3.2914 | 3.2729 | 3.2754 | 22887480.0 |
| 2006-11-27 10:20:00 | AAPL | Stock | 3.275 | 3.2889 | 3.2739 | 3.2889 | 20311676.0 |
| 2006-11-27 10:25:00 | AAPL | Stock | 3.2889 | 3.2918 | 3.2832 | 3.2843 | 16601228.0 |
| 2006-11-27 10:30:00 | AAPL | Stock | 3.2839 | 3.2875 | 3.2807 | 3.2811 | 11444468.0 |
| 2006-11-27 10:35:00 | AAPL | Stock | 3.2811 | 3.2821 | 3.2682 | 3.2776 | 22412096.0 |
| 2006-11-27 10:40:00 | AAPL | Stock | 3.2782 | 3.2804 | 3.2554 | 3.2607 | 26160680.0 |
| 2006-11-27 10:45:00 | AAPL | Stock | 3.2607 | 3.2754 | 3.2589 | 3.2643 | 16189208.0 |
| 2006-11-27 10:50:00 | AAPL | Stock | 3.2643 | 3.275 | 3.2632 | 3.2743 | 9894444.0 |
| 2006-11-27 10:55:00 | AAPL | Stock | 3.2746 | 3.2804 | 3.2725 | 3.2804 | 10414936.0 |
| 2006-11-27 11:00:00 | AAPL | Stock | 3.28 | 3.2839 | 3.2768 | 3.2796 | 11307520.0 |
> showing 50 of 242,604 rows — these rows as CSV