PREVIEW / stock_1min / 2009-01-05
file: by_date/stock_1min/2009/2009-01-05.parquet size: 12.8 MB rows: 987,650 symbols: 2,711
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-05 07:26:00 | AAPL | Stock | 3.2486 | 3.2486 | 3.2486 | 3.2486 | 11200.0 |
| 2009-01-05 07:34:00 | AAPL | Stock | 3.2568 | 3.2568 | 3.2568 | 3.2568 | 28000.0 |
| 2009-01-05 07:35:00 | AAPL | Stock | 3.2568 | 3.2568 | 3.2568 | 3.2568 | 22400.0 |
| 2009-01-05 07:36:00 | AAPL | Stock | 3.2429 | 3.2429 | 3.2411 | 3.2411 | 65100.0 |
| 2009-01-05 07:37:00 | AAPL | Stock | 3.2411 | 3.2411 | 3.2261 | 3.2261 | 33040.0 |
| 2009-01-05 08:00:00 | AAPL | Stock | 3.2332 | 3.2411 | 3.2325 | 3.2411 | 18844.0 |
| 2009-01-05 08:01:00 | AAPL | Stock | 3.2393 | 3.2393 | 3.2357 | 3.2357 | 15960.0 |
| 2009-01-05 08:02:00 | AAPL | Stock | 3.2329 | 3.2329 | 3.2325 | 3.2325 | 5600.0 |
| 2009-01-05 08:03:00 | AAPL | Stock | 3.2325 | 3.2325 | 3.2325 | 3.2325 | 21784.0 |
| 2009-01-05 08:04:00 | AAPL | Stock | 3.2354 | 3.2354 | 3.2354 | 3.2354 | 19320.0 |
| 2009-01-05 08:05:00 | AAPL | Stock | 3.2325 | 3.2325 | 3.2325 | 3.2325 | 51800.0 |
| 2009-01-05 08:06:00 | AAPL | Stock | 3.2325 | 3.2325 | 3.2321 | 3.2321 | 27356.0 |
| 2009-01-05 08:07:00 | AAPL | Stock | 3.2304 | 3.2304 | 3.23 | 3.23 | 8400.0 |
| 2009-01-05 08:08:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 14000.0 |
| 2009-01-05 08:09:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 7196.0 |
| 2009-01-05 08:10:00 | AAPL | Stock | 3.2318 | 3.2318 | 3.2318 | 3.2318 | 5460.0 |
| 2009-01-05 08:11:00 | AAPL | Stock | 3.2268 | 3.2279 | 3.2268 | 3.2279 | 36120.0 |
| 2009-01-05 08:12:00 | AAPL | Stock | 3.225 | 3.2257 | 3.225 | 3.2257 | 14000.0 |
| 2009-01-05 08:13:00 | AAPL | Stock | 3.225 | 3.2254 | 3.225 | 3.2254 | 14700.0 |
| 2009-01-05 08:14:00 | AAPL | Stock | 3.225 | 3.23 | 3.225 | 3.23 | 29120.0 |
| 2009-01-05 08:15:00 | AAPL | Stock | 3.2264 | 3.2264 | 3.2257 | 3.2257 | 11480.0 |
| 2009-01-05 08:16:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2286 | 3.2286 | 2800.0 |
| 2009-01-05 08:19:00 | AAPL | Stock | 3.2257 | 3.2261 | 3.2232 | 3.2232 | 45220.0 |
| 2009-01-05 08:20:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2107 | 3.2111 | 163380.0 |
| 2009-01-05 08:21:00 | AAPL | Stock | 3.215 | 3.215 | 3.215 | 3.215 | 2800.0 |
| 2009-01-05 08:22:00 | AAPL | Stock | 3.2207 | 3.2207 | 3.2179 | 3.2179 | 27300.0 |
| 2009-01-05 08:24:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2214 | 3.2214 | 50120.0 |
| 2009-01-05 08:25:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2175 | 3.2175 | 15400.0 |
| 2009-01-05 08:26:00 | AAPL | Stock | 3.2179 | 3.2196 | 3.2164 | 3.2196 | 40600.0 |
| 2009-01-05 08:27:00 | AAPL | Stock | 3.2168 | 3.2168 | 3.2164 | 3.2164 | 16800.0 |
| 2009-01-05 08:28:00 | AAPL | Stock | 3.2168 | 3.2168 | 3.2168 | 3.2168 | 8400.0 |
| 2009-01-05 08:29:00 | AAPL | Stock | 3.2211 | 3.2214 | 3.2211 | 3.2211 | 26040.0 |
| 2009-01-05 08:30:00 | AAPL | Stock | 3.2211 | 3.2946 | 3.2211 | 3.2946 | 950936.0 |
| 2009-01-05 08:31:00 | AAPL | Stock | 3.2929 | 3.3114 | 3.2329 | 3.3114 | 2257164.0 |
| 2009-01-05 08:32:00 | AAPL | Stock | 3.3168 | 3.3357 | 3.3039 | 3.3114 | 2772280.0 |
| 2009-01-05 08:33:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.2793 | 3.2868 | 1841784.0 |
| 2009-01-05 08:34:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2518 | 3.2525 | 2402316.0 |
| 2009-01-05 08:35:00 | AAPL | Stock | 3.2525 | 3.295 | 3.2504 | 3.2775 | 962864.0 |
| 2009-01-05 08:36:00 | AAPL | Stock | 3.2768 | 3.2811 | 3.2689 | 3.2768 | 722232.0 |
| 2009-01-05 08:37:00 | AAPL | Stock | 3.2786 | 3.3071 | 3.2771 | 3.2961 | 1179920.0 |
| 2009-01-05 08:38:00 | AAPL | Stock | 3.2946 | 3.2964 | 3.2796 | 3.2964 | 1226792.0 |
| 2009-01-05 08:39:00 | AAPL | Stock | 3.2961 | 3.2971 | 3.2864 | 3.2936 | 841036.0 |
| 2009-01-05 08:40:00 | AAPL | Stock | 3.295 | 3.2996 | 3.2904 | 3.2979 | 1050448.0 |
| 2009-01-05 08:41:00 | AAPL | Stock | 3.2982 | 3.3125 | 3.2982 | 3.3014 | 798280.0 |
| 2009-01-05 08:42:00 | AAPL | Stock | 3.3018 | 3.3107 | 3.2982 | 3.3082 | 690172.0 |
| 2009-01-05 08:43:00 | AAPL | Stock | 3.3079 | 3.3425 | 3.3079 | 3.3418 | 2532712.0 |
| 2009-01-05 08:44:00 | AAPL | Stock | 3.3393 | 3.3429 | 3.325 | 3.3261 | 1111348.0 |
| 2009-01-05 08:45:00 | AAPL | Stock | 3.325 | 3.3286 | 3.3196 | 3.3214 | 670292.0 |
| 2009-01-05 08:46:00 | AAPL | Stock | 3.3214 | 3.325 | 3.3168 | 3.325 | 633472.0 |
| 2009-01-05 08:47:00 | AAPL | Stock | 3.3246 | 3.3304 | 3.3207 | 3.3304 | 802984.0 |
> showing 50 of 987,650 rows — these rows as CSV