PREVIEW / stock_1min / 2013-10-04
file: by_date/stock_1min/2013/2013-10-04.parquet size: 13.1 MB rows: 955,482 symbols: 2,864
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-04 04:03:00 | AAPL | Stock | 17.2814 | 17.2814 | 17.2814 | 17.2814 | 7840.0 |
| 2013-10-04 04:45:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3214 | 17.3214 | 30660.0 |
| 2013-10-04 05:26:00 | AAPL | Stock | 17.3375 | 17.3375 | 17.3375 | 17.3375 | 2800.0 |
| 2013-10-04 05:36:00 | AAPL | Stock | 17.3282 | 17.3282 | 17.3282 | 17.3282 | 13860.0 |
| 2013-10-04 05:46:00 | AAPL | Stock | 17.3396 | 17.3396 | 17.3396 | 17.3396 | 2800.0 |
| 2013-10-04 05:49:00 | AAPL | Stock | 17.3507 | 17.3536 | 17.3507 | 17.3536 | 30800.0 |
| 2013-10-04 06:03:00 | AAPL | Stock | 17.3457 | 17.3457 | 17.3457 | 17.3457 | 2800.0 |
| 2013-10-04 06:10:00 | AAPL | Stock | 17.3507 | 17.3507 | 17.3507 | 17.3507 | 2800.0 |
| 2013-10-04 06:12:00 | AAPL | Stock | 17.3457 | 17.3457 | 17.3457 | 17.3457 | 7000.0 |
| 2013-10-04 06:32:00 | AAPL | Stock | 17.3496 | 17.3496 | 17.3496 | 17.3496 | 2800.0 |
| 2013-10-04 06:35:00 | AAPL | Stock | 17.3525 | 17.3525 | 17.3525 | 17.3525 | 2800.0 |
| 2013-10-04 06:49:00 | AAPL | Stock | 17.3464 | 17.3464 | 17.3464 | 17.3464 | 2800.0 |
| 2013-10-04 06:50:00 | AAPL | Stock | 17.3518 | 17.3518 | 17.3518 | 17.3518 | 5600.0 |
| 2013-10-04 06:54:00 | AAPL | Stock | 17.3557 | 17.3557 | 17.3557 | 17.3557 | 7000.0 |
| 2013-10-04 06:57:00 | AAPL | Stock | 17.3532 | 17.3532 | 17.3532 | 17.3532 | 2800.0 |
| 2013-10-04 06:58:00 | AAPL | Stock | 17.3532 | 17.3557 | 17.3532 | 17.3557 | 7112.0 |
| 2013-10-04 06:59:00 | AAPL | Stock | 17.3557 | 17.3557 | 17.3557 | 17.3557 | 2800.0 |
| 2013-10-04 07:00:00 | AAPL | Stock | 17.35 | 17.3618 | 17.35 | 17.3571 | 8400.0 |
| 2013-10-04 07:02:00 | AAPL | Stock | 17.3571 | 17.3571 | 17.3571 | 17.3571 | 2800.0 |
| 2013-10-04 07:10:00 | AAPL | Stock | 17.3571 | 17.3571 | 17.3521 | 17.3521 | 8400.0 |
| 2013-10-04 07:14:00 | AAPL | Stock | 17.3511 | 17.3511 | 17.3436 | 17.3436 | 14000.0 |
| 2013-10-04 07:18:00 | AAPL | Stock | 17.3386 | 17.3386 | 17.3386 | 17.3386 | 5600.0 |
| 2013-10-04 07:19:00 | AAPL | Stock | 17.3357 | 17.3357 | 17.3357 | 17.3357 | 19600.0 |
| 2013-10-04 07:21:00 | AAPL | Stock | 17.3321 | 17.3321 | 17.3321 | 17.3321 | 2800.0 |
| 2013-10-04 07:25:00 | AAPL | Stock | 17.3321 | 17.3321 | 17.3271 | 17.3271 | 8400.0 |
| 2013-10-04 07:29:00 | AAPL | Stock | 17.3218 | 17.3218 | 17.3193 | 17.3193 | 19908.0 |
| 2013-10-04 07:30:00 | AAPL | Stock | 17.3125 | 17.3125 | 17.3036 | 17.3036 | 25928.0 |
| 2013-10-04 07:31:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3021 | 17.3021 | 16128.0 |
| 2013-10-04 07:32:00 | AAPL | Stock | 17.3036 | 17.305 | 17.2932 | 17.2932 | 35000.0 |
| 2013-10-04 07:33:00 | AAPL | Stock | 17.2914 | 17.2957 | 17.2914 | 17.2957 | 5600.0 |
| 2013-10-04 07:34:00 | AAPL | Stock | 17.2964 | 17.2964 | 17.2964 | 17.2964 | 16800.0 |
| 2013-10-04 07:44:00 | AAPL | Stock | 17.3 | 17.3 | 17.2964 | 17.2964 | 13692.0 |
| 2013-10-04 07:46:00 | AAPL | Stock | 17.2964 | 17.2964 | 17.2857 | 17.2857 | 24276.0 |
| 2013-10-04 07:57:00 | AAPL | Stock | 17.2964 | 17.2964 | 17.2964 | 17.2964 | 5684.0 |
| 2013-10-04 07:58:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 2800.0 |
| 2013-10-04 08:00:00 | AAPL | Stock | 17.3036 | 17.37 | 17.2914 | 17.3039 | 88900.0 |
| 2013-10-04 08:01:00 | AAPL | Stock | 17.3093 | 17.3107 | 17.3054 | 17.3107 | 49784.0 |
| 2013-10-04 08:02:00 | AAPL | Stock | 17.3054 | 17.3054 | 17.3054 | 17.3054 | 3080.0 |
| 2013-10-04 08:03:00 | AAPL | Stock | 17.25 | 17.3214 | 17.25 | 17.3179 | 51800.0 |
| 2013-10-04 08:04:00 | AAPL | Stock | 17.3196 | 17.3196 | 17.3196 | 17.3196 | 9912.0 |
| 2013-10-04 08:05:00 | AAPL | Stock | 17.3079 | 17.3079 | 17.3079 | 17.3079 | 2800.0 |
| 2013-10-04 08:06:00 | AAPL | Stock | 17.3086 | 17.3086 | 17.3071 | 17.3071 | 39200.0 |
| 2013-10-04 08:07:00 | AAPL | Stock | 17.3086 | 17.3086 | 17.3 | 17.3 | 82040.0 |
| 2013-10-04 08:09:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 14000.0 |
| 2013-10-04 08:10:00 | AAPL | Stock | 17.3143 | 17.3157 | 17.2929 | 17.2929 | 42812.0 |
| 2013-10-04 08:12:00 | AAPL | Stock | 17.3032 | 17.3032 | 17.3 | 17.3 | 5600.0 |
| 2013-10-04 08:13:00 | AAPL | Stock | 17.3032 | 17.3036 | 17.3014 | 17.3036 | 35840.0 |
| 2013-10-04 08:18:00 | AAPL | Stock | 17.3146 | 17.3146 | 17.3146 | 17.3146 | 2800.0 |
| 2013-10-04 08:20:00 | AAPL | Stock | 17.3107 | 17.3107 | 17.3107 | 17.3107 | 50400.0 |
| 2013-10-04 08:21:00 | AAPL | Stock | 17.3071 | 17.3107 | 17.3071 | 17.3107 | 9912.0 |
> showing 50 of 955,482 rows — these rows as CSV