PREVIEW / stock_1min / 2010-09-29
file: by_date/stock_1min/2010/2010-09-29.parquet size: 12.4 MB rows: 935,837 symbols: 2,821
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-29 05:17:00 | AAPL | Stock | 10.2682 | 10.2682 | 10.2682 | 10.2682 | 8400.0 |
| 2010-09-29 05:18:00 | AAPL | Stock | 10.2682 | 10.2682 | 10.2682 | 10.2682 | 2800.0 |
| 2010-09-29 05:43:00 | AAPL | Stock | 10.2643 | 10.2643 | 10.2643 | 10.2643 | 2800.0 |
| 2010-09-29 05:49:00 | AAPL | Stock | 10.2607 | 10.2607 | 10.2607 | 10.2607 | 2800.0 |
| 2010-09-29 06:00:00 | AAPL | Stock | 10.2607 | 10.2607 | 10.2607 | 10.2607 | 5600.0 |
| 2010-09-29 06:25:00 | AAPL | Stock | 10.2607 | 10.2607 | 10.2607 | 10.2607 | 2800.0 |
| 2010-09-29 06:44:00 | AAPL | Stock | 10.2643 | 10.2643 | 10.2643 | 10.2643 | 2800.0 |
| 2010-09-29 06:48:00 | AAPL | Stock | 10.2643 | 10.2643 | 10.2643 | 10.2643 | 11200.0 |
| 2010-09-29 07:17:00 | AAPL | Stock | 10.3 | 10.3 | 10.3 | 10.3 | 2800.0 |
| 2010-09-29 07:26:00 | AAPL | Stock | 10.2661 | 10.2661 | 10.2661 | 10.2661 | 5600.0 |
| 2010-09-29 07:27:00 | AAPL | Stock | 10.2679 | 10.2679 | 10.2679 | 10.2679 | 5600.0 |
| 2010-09-29 07:28:00 | AAPL | Stock | 10.2679 | 10.2679 | 10.2679 | 10.2679 | 2800.0 |
| 2010-09-29 07:29:00 | AAPL | Stock | 10.265 | 10.265 | 10.265 | 10.265 | 2800.0 |
| 2010-09-29 07:38:00 | AAPL | Stock | 10.2661 | 10.2661 | 10.2661 | 10.2661 | 4200.0 |
| 2010-09-29 07:45:00 | AAPL | Stock | 10.2654 | 10.2654 | 10.2654 | 10.2654 | 2800.0 |
| 2010-09-29 07:46:00 | AAPL | Stock | 10.2654 | 10.2654 | 10.2589 | 10.2589 | 15400.0 |
| 2010-09-29 07:47:00 | AAPL | Stock | 10.2625 | 10.2625 | 10.2625 | 10.2625 | 5600.0 |
| 2010-09-29 07:57:00 | AAPL | Stock | 10.2607 | 10.2607 | 10.2607 | 10.2607 | 2800.0 |
| 2010-09-29 07:59:00 | AAPL | Stock | 10.2654 | 10.2654 | 10.2654 | 10.2654 | 14000.0 |
| 2010-09-29 08:00:00 | AAPL | Stock | 10.2607 | 10.2725 | 10.2607 | 10.2725 | 8400.0 |
| 2010-09-29 08:01:00 | AAPL | Stock | 10.2718 | 10.2725 | 10.2718 | 10.2725 | 126560.0 |
| 2010-09-29 08:02:00 | AAPL | Stock | 10.2729 | 10.2818 | 10.2714 | 10.2818 | 90104.0 |
| 2010-09-29 08:03:00 | AAPL | Stock | 10.2839 | 10.2854 | 10.2818 | 10.2854 | 38724.0 |
| 2010-09-29 08:04:00 | AAPL | Stock | 10.2907 | 10.2907 | 10.285 | 10.2886 | 114128.0 |
| 2010-09-29 08:05:00 | AAPL | Stock | 10.2886 | 10.2886 | 10.2836 | 10.2864 | 147560.0 |
| 2010-09-29 08:06:00 | AAPL | Stock | 10.2886 | 10.2896 | 10.2861 | 10.2864 | 67620.0 |
| 2010-09-29 08:07:00 | AAPL | Stock | 10.2879 | 10.2879 | 10.2857 | 10.2879 | 193200.0 |
| 2010-09-29 08:08:00 | AAPL | Stock | 10.2879 | 10.2886 | 10.2857 | 10.2882 | 63700.0 |
| 2010-09-29 08:09:00 | AAPL | Stock | 10.2871 | 10.2886 | 10.2868 | 10.2886 | 85400.0 |
| 2010-09-29 08:10:00 | AAPL | Stock | 10.2886 | 10.2886 | 10.2857 | 10.2861 | 331408.0 |
| 2010-09-29 08:11:00 | AAPL | Stock | 10.2861 | 10.2882 | 10.2861 | 10.2882 | 14000.0 |
| 2010-09-29 08:12:00 | AAPL | Stock | 10.2882 | 10.2929 | 10.2882 | 10.2929 | 70560.0 |
| 2010-09-29 08:13:00 | AAPL | Stock | 10.2925 | 10.2993 | 10.2925 | 10.2971 | 121800.0 |
| 2010-09-29 08:14:00 | AAPL | Stock | 10.2964 | 10.2964 | 10.2964 | 10.2964 | 2800.0 |
| 2010-09-29 08:15:00 | AAPL | Stock | 10.2957 | 10.2982 | 10.2957 | 10.2982 | 28000.0 |
| 2010-09-29 08:16:00 | AAPL | Stock | 10.2975 | 10.2975 | 10.2975 | 10.2975 | 5600.0 |
| 2010-09-29 08:17:00 | AAPL | Stock | 10.2979 | 10.2993 | 10.2968 | 10.2993 | 61880.0 |
| 2010-09-29 08:18:00 | AAPL | Stock | 10.2989 | 10.3039 | 10.2989 | 10.3014 | 179340.0 |
| 2010-09-29 08:19:00 | AAPL | Stock | 10.3032 | 10.3032 | 10.3 | 10.3014 | 26180.0 |
| 2010-09-29 08:20:00 | AAPL | Stock | 10.3 | 10.3039 | 10.2996 | 10.3007 | 208460.0 |
| 2010-09-29 08:21:00 | AAPL | Stock | 10.3021 | 10.3082 | 10.3018 | 10.3071 | 120400.0 |
| 2010-09-29 08:22:00 | AAPL | Stock | 10.3025 | 10.3071 | 10.3025 | 10.3068 | 14000.0 |
| 2010-09-29 08:23:00 | AAPL | Stock | 10.3068 | 10.3068 | 10.3014 | 10.3014 | 28000.0 |
| 2010-09-29 08:24:00 | AAPL | Stock | 10.3039 | 10.3039 | 10.3014 | 10.3036 | 37772.0 |
| 2010-09-29 08:25:00 | AAPL | Stock | 10.3036 | 10.3036 | 10.2961 | 10.3 | 56840.0 |
| 2010-09-29 08:26:00 | AAPL | Stock | 10.2954 | 10.2954 | 10.2932 | 10.2932 | 25200.0 |
| 2010-09-29 08:29:00 | AAPL | Stock | 10.2918 | 10.3136 | 10.2918 | 10.2996 | 216636.0 |
| 2010-09-29 08:30:00 | AAPL | Stock | 10.2929 | 10.3214 | 10.2929 | 10.3157 | 291228.0 |
| 2010-09-29 08:31:00 | AAPL | Stock | 10.3132 | 10.3211 | 10.3025 | 10.3175 | 332976.0 |
| 2010-09-29 08:32:00 | AAPL | Stock | 10.3196 | 10.3325 | 10.315 | 10.3286 | 214200.0 |
> showing 50 of 935,837 rows — these rows as CSV