PREVIEW / stock_1min / 2006-08-04
file: by_date/stock_1min/2006/2006-08-04.parquet size: 8.7 MB rows: 709,662 symbols: 1,895
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-04 04:06:00 | AAPL | Stock | 2.3018 | 2.3018 | 2.3 | 2.3 | 47600.0 |
| 2006-08-04 04:15:00 | AAPL | Stock | 2.2968 | 2.3143 | 2.2968 | 2.3089 | 36400.0 |
| 2006-08-04 04:16:00 | AAPL | Stock | 2.3207 | 2.3214 | 2.3207 | 2.3214 | 131628.0 |
| 2006-08-04 04:17:00 | AAPL | Stock | 2.3179 | 2.3179 | 2.3179 | 2.3179 | 2800.0 |
| 2006-08-04 04:19:00 | AAPL | Stock | 2.3182 | 2.3182 | 2.3179 | 2.3179 | 8400.0 |
| 2006-08-04 04:22:00 | AAPL | Stock | 2.3211 | 2.3214 | 2.3211 | 2.3211 | 39256.0 |
| 2006-08-04 04:23:00 | AAPL | Stock | 2.3214 | 2.3214 | 2.3107 | 2.3107 | 47600.0 |
| 2006-08-04 04:24:00 | AAPL | Stock | 2.3211 | 2.3214 | 2.3107 | 2.3107 | 96600.0 |
| 2006-08-04 04:25:00 | AAPL | Stock | 2.3107 | 2.3107 | 2.3107 | 2.3107 | 95200.0 |
| 2006-08-04 04:33:00 | AAPL | Stock | 2.3036 | 2.3036 | 2.3036 | 2.3036 | 2800.0 |
| 2006-08-04 04:34:00 | AAPL | Stock | 2.3036 | 2.3036 | 2.3036 | 2.3036 | 28000.0 |
| 2006-08-04 04:35:00 | AAPL | Stock | 2.3036 | 2.3036 | 2.3036 | 2.3036 | 28000.0 |
| 2006-08-04 04:40:00 | AAPL | Stock | 2.3104 | 2.3104 | 2.3036 | 2.3036 | 51828.0 |
| 2006-08-04 04:42:00 | AAPL | Stock | 2.31 | 2.31 | 2.3036 | 2.3036 | 28028.0 |
| 2006-08-04 04:49:00 | AAPL | Stock | 2.3011 | 2.3011 | 2.3011 | 2.3011 | 30800.0 |
| 2006-08-04 04:58:00 | AAPL | Stock | 2.2964 | 2.2964 | 2.2964 | 2.2964 | 28000.0 |
| 2006-08-04 05:00:00 | AAPL | Stock | 2.2929 | 2.2929 | 2.2929 | 2.2929 | 56000.0 |
| 2006-08-04 05:01:00 | AAPL | Stock | 2.2893 | 2.2893 | 2.2882 | 2.2882 | 22400.0 |
| 2006-08-04 05:02:00 | AAPL | Stock | 2.2893 | 2.2893 | 2.2893 | 2.2893 | 5600.0 |
| 2006-08-04 05:23:00 | AAPL | Stock | 2.2946 | 2.2946 | 2.2946 | 2.2946 | 8400.0 |
| 2006-08-04 05:28:00 | AAPL | Stock | 2.2964 | 2.2964 | 2.2964 | 2.2964 | 18172.0 |
| 2006-08-04 05:38:00 | AAPL | Stock | 2.2982 | 2.3 | 2.2982 | 2.3 | 13804.0 |
| 2006-08-04 05:47:00 | AAPL | Stock | 2.2993 | 2.2993 | 2.2993 | 2.2993 | 29428.0 |
| 2006-08-04 05:50:00 | AAPL | Stock | 2.3 | 2.3 | 2.3 | 2.3 | 2800.0 |
| 2006-08-04 05:52:00 | AAPL | Stock | 2.3018 | 2.3018 | 2.3018 | 2.3018 | 14000.0 |
| 2006-08-04 05:57:00 | AAPL | Stock | 2.3089 | 2.3125 | 2.3089 | 2.3125 | 5600.0 |
| 2006-08-04 05:58:00 | AAPL | Stock | 2.3143 | 2.3143 | 2.3143 | 2.3143 | 25200.0 |
| 2006-08-04 05:59:00 | AAPL | Stock | 2.3125 | 2.3125 | 2.3125 | 2.3125 | 2800.0 |
| 2006-08-04 06:30:00 | AAPL | Stock | 2.3089 | 2.3089 | 2.3089 | 2.3089 | 11200.0 |
| 2006-08-04 06:33:00 | AAPL | Stock | 2.3036 | 2.3036 | 2.3036 | 2.3036 | 2800.0 |
| 2006-08-04 06:43:00 | AAPL | Stock | 2.3071 | 2.3071 | 2.3071 | 2.3071 | 2800.0 |
| 2006-08-04 06:44:00 | AAPL | Stock | 2.3071 | 2.3071 | 2.3071 | 2.3071 | 11200.0 |
| 2006-08-04 06:47:00 | AAPL | Stock | 2.3071 | 2.3071 | 2.3071 | 2.3071 | 14000.0 |
| 2006-08-04 06:49:00 | AAPL | Stock | 2.3161 | 2.3161 | 2.3161 | 2.3161 | 2800.0 |
| 2006-08-04 06:51:00 | AAPL | Stock | 2.3071 | 2.3071 | 2.3071 | 2.3071 | 11200.0 |
| 2006-08-04 06:55:00 | AAPL | Stock | 2.3071 | 2.3071 | 2.3071 | 2.3071 | 26600.0 |
| 2006-08-04 06:56:00 | AAPL | Stock | 2.3071 | 2.3125 | 2.3036 | 2.3036 | 30744.0 |
| 2006-08-04 06:58:00 | AAPL | Stock | 2.3036 | 2.3036 | 2.3036 | 2.3036 | 2800.0 |
| 2006-08-04 07:00:00 | AAPL | Stock | 2.3036 | 2.3393 | 2.3036 | 2.325 | 247604.0 |
| 2006-08-04 07:01:00 | AAPL | Stock | 2.3357 | 2.3446 | 2.3357 | 2.3446 | 72996.0 |
| 2006-08-04 07:02:00 | AAPL | Stock | 2.35 | 2.3536 | 2.3393 | 2.3396 | 56000.0 |
| 2006-08-04 07:03:00 | AAPL | Stock | 2.3411 | 2.3536 | 2.3411 | 2.35 | 83132.0 |
| 2006-08-04 07:04:00 | AAPL | Stock | 2.3536 | 2.3536 | 2.3446 | 2.3464 | 100800.0 |
| 2006-08-04 07:05:00 | AAPL | Stock | 2.3464 | 2.3464 | 2.3446 | 2.3446 | 25200.0 |
| 2006-08-04 07:06:00 | AAPL | Stock | 2.3446 | 2.3464 | 2.3411 | 2.3461 | 81200.0 |
| 2006-08-04 07:07:00 | AAPL | Stock | 2.3464 | 2.3643 | 2.3464 | 2.3643 | 285068.0 |
| 2006-08-04 07:09:00 | AAPL | Stock | 2.3664 | 2.3664 | 2.3575 | 2.3661 | 231000.0 |
| 2006-08-04 07:10:00 | AAPL | Stock | 2.3696 | 2.3768 | 2.3696 | 2.3768 | 112000.0 |
| 2006-08-04 07:11:00 | AAPL | Stock | 2.3832 | 2.3857 | 2.38 | 2.3857 | 104300.0 |
| 2006-08-04 07:12:00 | AAPL | Stock | 2.3714 | 2.3714 | 2.3679 | 2.3704 | 64400.0 |
> showing 50 of 709,662 rows — these rows as CSV