PREVIEW / stock_1min / 2012-11-01
file: by_date/stock_1min/2012/2012-11-01.parquet size: 13.0 MB rows: 968,723 symbols: 2,814
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-01 05:59:00 | AAPL | Stock | 21.25 | 21.25 | 21.25 | 21.25 | 4144.0 |
| 2012-11-01 06:20:00 | AAPL | Stock | 21.2404 | 21.2411 | 21.2404 | 21.2411 | 5936.0 |
| 2012-11-01 07:09:00 | AAPL | Stock | 21.2854 | 21.2854 | 21.2854 | 21.2854 | 2800.0 |
| 2012-11-01 07:11:00 | AAPL | Stock | 21.2843 | 21.2857 | 21.2843 | 21.2857 | 8400.0 |
| 2012-11-01 07:12:00 | AAPL | Stock | 21.2821 | 21.2821 | 21.2786 | 21.2786 | 16492.0 |
| 2012-11-01 07:14:00 | AAPL | Stock | 21.2679 | 21.2679 | 21.2679 | 21.2679 | 5600.0 |
| 2012-11-01 07:20:00 | AAPL | Stock | 21.2964 | 21.2964 | 21.2964 | 21.2964 | 2800.0 |
| 2012-11-01 07:24:00 | AAPL | Stock | 21.3 | 21.3 | 21.3 | 21.3 | 2800.0 |
| 2012-11-01 07:39:00 | AAPL | Stock | 21.3032 | 21.3036 | 21.3032 | 21.3036 | 19124.0 |
| 2012-11-01 07:47:00 | AAPL | Stock | 21.325 | 21.3304 | 21.325 | 21.3304 | 16800.0 |
| 2012-11-01 07:56:00 | AAPL | Stock | 21.3207 | 21.3207 | 21.3207 | 21.3207 | 2800.0 |
| 2012-11-01 08:00:00 | AAPL | Stock | 21.3161 | 21.3211 | 21.2879 | 21.2879 | 25984.0 |
| 2012-11-01 08:01:00 | AAPL | Stock | 21.3089 | 21.3089 | 21.3089 | 21.3089 | 2800.0 |
| 2012-11-01 08:03:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2686 | 21.2686 | 25060.0 |
| 2012-11-01 08:04:00 | AAPL | Stock | 21.275 | 21.275 | 21.275 | 21.275 | 2800.0 |
| 2012-11-01 08:05:00 | AAPL | Stock | 21.2821 | 21.2857 | 21.2732 | 21.2857 | 20188.0 |
| 2012-11-01 08:06:00 | AAPL | Stock | 21.2918 | 21.2946 | 21.2918 | 21.2946 | 14000.0 |
| 2012-11-01 08:07:00 | AAPL | Stock | 21.2993 | 21.2993 | 21.295 | 21.295 | 5600.0 |
| 2012-11-01 08:08:00 | AAPL | Stock | 21.2989 | 21.2989 | 21.2946 | 21.2946 | 22400.0 |
| 2012-11-01 08:09:00 | AAPL | Stock | 21.2929 | 21.2946 | 21.2929 | 21.2929 | 16800.0 |
| 2012-11-01 08:10:00 | AAPL | Stock | 21.2986 | 21.2986 | 21.2964 | 21.2964 | 9800.0 |
| 2012-11-01 08:11:00 | AAPL | Stock | 21.2996 | 21.3 | 21.2996 | 21.3 | 5600.0 |
| 2012-11-01 08:12:00 | AAPL | Stock | 21.3004 | 21.3004 | 21.3004 | 21.3004 | 2800.0 |
| 2012-11-01 08:13:00 | AAPL | Stock | 21.3004 | 21.3004 | 21.3004 | 21.3004 | 2800.0 |
| 2012-11-01 08:15:00 | AAPL | Stock | 21.2929 | 21.3061 | 21.2929 | 21.3061 | 36400.0 |
| 2012-11-01 08:16:00 | AAPL | Stock | 21.3107 | 21.3186 | 21.3079 | 21.3168 | 37800.0 |
| 2012-11-01 08:17:00 | AAPL | Stock | 21.3179 | 21.3336 | 21.3179 | 21.3218 | 86016.0 |
| 2012-11-01 08:18:00 | AAPL | Stock | 21.3246 | 21.3246 | 21.3168 | 21.3168 | 11200.0 |
| 2012-11-01 08:19:00 | AAPL | Stock | 21.3168 | 21.3168 | 21.3168 | 21.3168 | 15400.0 |
| 2012-11-01 08:20:00 | AAPL | Stock | 21.3168 | 21.3168 | 21.3168 | 21.3168 | 5600.0 |
| 2012-11-01 08:21:00 | AAPL | Stock | 21.3171 | 21.3211 | 21.3171 | 21.3207 | 8400.0 |
| 2012-11-01 08:22:00 | AAPL | Stock | 21.3207 | 21.3329 | 21.32 | 21.3318 | 42000.0 |
| 2012-11-01 08:23:00 | AAPL | Stock | 21.3336 | 21.3343 | 21.3179 | 21.3179 | 48776.0 |
| 2012-11-01 08:24:00 | AAPL | Stock | 21.3168 | 21.3214 | 21.3168 | 21.3211 | 32200.0 |
| 2012-11-01 08:25:00 | AAPL | Stock | 21.3168 | 21.3168 | 21.3168 | 21.3168 | 11200.0 |
| 2012-11-01 08:30:00 | AAPL | Stock | 21.3211 | 21.3214 | 21.3082 | 21.3082 | 33180.0 |
| 2012-11-01 08:31:00 | AAPL | Stock | 21.3211 | 21.3214 | 21.3211 | 21.3214 | 14336.0 |
| 2012-11-01 08:32:00 | AAPL | Stock | 21.33 | 21.3304 | 21.33 | 21.3304 | 5600.0 |
| 2012-11-01 08:33:00 | AAPL | Stock | 21.3371 | 21.3418 | 21.3371 | 21.3418 | 17220.0 |
| 2012-11-01 08:34:00 | AAPL | Stock | 21.3314 | 21.3425 | 21.3214 | 21.3425 | 93772.0 |
| 2012-11-01 08:36:00 | AAPL | Stock | 21.3386 | 21.3393 | 21.3386 | 21.3393 | 14924.0 |
| 2012-11-01 08:37:00 | AAPL | Stock | 21.3464 | 21.3464 | 21.3464 | 21.3464 | 40880.0 |
| 2012-11-01 08:39:00 | AAPL | Stock | 21.3393 | 21.3393 | 21.3393 | 21.3393 | 5180.0 |
| 2012-11-01 08:40:00 | AAPL | Stock | 21.3375 | 21.3375 | 21.3375 | 21.3375 | 2800.0 |
| 2012-11-01 08:41:00 | AAPL | Stock | 21.3429 | 21.3514 | 21.3393 | 21.3429 | 49700.0 |
| 2012-11-01 08:42:00 | AAPL | Stock | 21.3432 | 21.3432 | 21.3432 | 21.3432 | 5600.0 |
| 2012-11-01 08:43:00 | AAPL | Stock | 21.3518 | 21.3518 | 21.35 | 21.35 | 10360.0 |
| 2012-11-01 08:44:00 | AAPL | Stock | 21.3393 | 21.3446 | 21.3393 | 21.3446 | 32200.0 |
| 2012-11-01 08:45:00 | AAPL | Stock | 21.3439 | 21.3439 | 21.3436 | 21.3436 | 8680.0 |
| 2012-11-01 08:46:00 | AAPL | Stock | 21.3393 | 21.3393 | 21.3393 | 21.3393 | 11200.0 |
> showing 50 of 968,723 rows — these rows as CSV