PREVIEW / stock_1min / 2010-10-18
file: by_date/stock_1min/2010/2010-10-18.parquet size: 12.4 MB rows: 937,321 symbols: 2,838
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-10-18 04:00:00 | AAPL | Stock | 11.3182 | 11.3182 | 11.3182 | 11.3182 | 11060.0 |
| 2010-10-18 05:05:00 | AAPL | Stock | 11.2275 | 11.2275 | 11.2275 | 11.2275 | 4480.0 |
| 2010-10-18 05:50:00 | AAPL | Stock | 11.2789 | 11.2789 | 11.2789 | 11.2789 | 2800.0 |
| 2010-10-18 06:13:00 | AAPL | Stock | 11.2718 | 11.2718 | 11.2693 | 11.2693 | 8400.0 |
| 2010-10-18 06:20:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 3080.0 |
| 2010-10-18 06:39:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-10-18 06:42:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-10-18 07:00:00 | AAPL | Stock | 11.2854 | 11.2854 | 11.275 | 11.2854 | 19600.0 |
| 2010-10-18 07:01:00 | AAPL | Stock | 11.2996 | 11.2996 | 11.2929 | 11.2929 | 35840.0 |
| 2010-10-18 07:03:00 | AAPL | Stock | 11.2904 | 11.3 | 11.2904 | 11.3 | 44800.0 |
| 2010-10-18 07:04:00 | AAPL | Stock | 11.2964 | 11.2964 | 11.2964 | 11.2964 | 2800.0 |
| 2010-10-18 07:05:00 | AAPL | Stock | 11.3 | 11.3 | 11.2946 | 11.2946 | 29960.0 |
| 2010-10-18 07:06:00 | AAPL | Stock | 11.3 | 11.3036 | 11.3 | 11.3036 | 16800.0 |
| 2010-10-18 07:07:00 | AAPL | Stock | 11.3071 | 11.3071 | 11.3036 | 11.3036 | 25200.0 |
| 2010-10-18 07:08:00 | AAPL | Stock | 11.3036 | 11.3107 | 11.3036 | 11.3107 | 8400.0 |
| 2010-10-18 07:09:00 | AAPL | Stock | 11.3107 | 11.3143 | 11.3036 | 11.3036 | 93800.0 |
| 2010-10-18 07:11:00 | AAPL | Stock | 11.3125 | 11.3143 | 11.3125 | 11.3125 | 34048.0 |
| 2010-10-18 07:12:00 | AAPL | Stock | 11.2968 | 11.2968 | 11.2964 | 11.2964 | 11200.0 |
| 2010-10-18 07:13:00 | AAPL | Stock | 11.2914 | 11.3 | 11.2911 | 11.2946 | 51100.0 |
| 2010-10-18 07:14:00 | AAPL | Stock | 11.3 | 11.3 | 11.3 | 11.3 | 2800.0 |
| 2010-10-18 07:15:00 | AAPL | Stock | 11.2932 | 11.2932 | 11.2932 | 11.2932 | 2800.0 |
| 2010-10-18 07:16:00 | AAPL | Stock | 11.2996 | 11.3 | 11.2946 | 11.2946 | 30128.0 |
| 2010-10-18 07:17:00 | AAPL | Stock | 11.2932 | 11.2932 | 11.2714 | 11.2718 | 150360.0 |
| 2010-10-18 07:18:00 | AAPL | Stock | 11.2854 | 11.2857 | 11.2818 | 11.2857 | 93800.0 |
| 2010-10-18 07:19:00 | AAPL | Stock | 11.3014 | 11.3014 | 11.3014 | 11.3014 | 2800.0 |
| 2010-10-18 07:20:00 | AAPL | Stock | 11.305 | 11.305 | 11.305 | 11.305 | 2800.0 |
| 2010-10-18 07:21:00 | AAPL | Stock | 11.3021 | 11.3021 | 11.3021 | 11.3021 | 2800.0 |
| 2010-10-18 07:22:00 | AAPL | Stock | 11.2882 | 11.2882 | 11.2882 | 11.2882 | 2800.0 |
| 2010-10-18 07:24:00 | AAPL | Stock | 11.305 | 11.305 | 11.305 | 11.305 | 2800.0 |
| 2010-10-18 07:28:00 | AAPL | Stock | 11.3018 | 11.3018 | 11.2946 | 11.3018 | 22400.0 |
| 2010-10-18 07:29:00 | AAPL | Stock | 11.295 | 11.295 | 11.2943 | 11.2943 | 19600.0 |
| 2010-10-18 07:30:00 | AAPL | Stock | 11.2925 | 11.3 | 11.2925 | 11.3 | 27160.0 |
| 2010-10-18 07:32:00 | AAPL | Stock | 11.2961 | 11.2961 | 11.2961 | 11.2961 | 2800.0 |
| 2010-10-18 07:33:00 | AAPL | Stock | 11.2996 | 11.3125 | 11.2989 | 11.3121 | 102788.0 |
| 2010-10-18 07:34:00 | AAPL | Stock | 11.3118 | 11.3118 | 11.3071 | 11.3107 | 34160.0 |
| 2010-10-18 07:35:00 | AAPL | Stock | 11.3164 | 11.3179 | 11.3129 | 11.3129 | 36400.0 |
| 2010-10-18 07:36:00 | AAPL | Stock | 11.3161 | 11.3214 | 11.3125 | 11.3214 | 42420.0 |
| 2010-10-18 07:37:00 | AAPL | Stock | 11.3239 | 11.3239 | 11.3211 | 11.3239 | 8400.0 |
| 2010-10-18 07:38:00 | AAPL | Stock | 11.3211 | 11.3211 | 11.3207 | 11.3207 | 5600.0 |
| 2010-10-18 07:39:00 | AAPL | Stock | 11.3143 | 11.3143 | 11.3143 | 11.3143 | 8400.0 |
| 2010-10-18 07:40:00 | AAPL | Stock | 11.3211 | 11.3211 | 11.3211 | 11.3211 | 5320.0 |
| 2010-10-18 07:42:00 | AAPL | Stock | 11.3129 | 11.3214 | 11.3129 | 11.3214 | 8400.0 |
| 2010-10-18 07:44:00 | AAPL | Stock | 11.3286 | 11.33 | 11.3286 | 11.33 | 14000.0 |
| 2010-10-18 07:45:00 | AAPL | Stock | 11.3221 | 11.3221 | 11.3221 | 11.3221 | 5600.0 |
| 2010-10-18 07:46:00 | AAPL | Stock | 11.3304 | 11.3304 | 11.3304 | 11.3304 | 2800.0 |
| 2010-10-18 07:48:00 | AAPL | Stock | 11.3232 | 11.3314 | 11.3232 | 11.3236 | 25200.0 |
| 2010-10-18 07:49:00 | AAPL | Stock | 11.325 | 11.325 | 11.325 | 11.325 | 11200.0 |
| 2010-10-18 07:50:00 | AAPL | Stock | 11.3254 | 11.33 | 11.3214 | 11.33 | 151200.0 |
| 2010-10-18 07:51:00 | AAPL | Stock | 11.3214 | 11.3214 | 11.3214 | 11.3214 | 2800.0 |
| 2010-10-18 07:52:00 | AAPL | Stock | 11.3214 | 11.3271 | 11.3214 | 11.3214 | 117600.0 |
> showing 50 of 937,321 rows — these rows as CSV