PREVIEW / stock_1min / 2008-10-06
file: by_date/stock_1min/2008/2008-10-06.parquet size: 14.7 MB rows: 1,124,348 symbols: 2,764
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-06 07:02:00 | AAPL | Stock | 3.3004 | 3.3004 | 3.3004 | 3.3004 | 6160.0 |
| 2008-10-06 07:13:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3286 | 3.3286 | 10780.0 |
| 2008-10-06 07:15:00 | AAPL | Stock | 3.3286 | 3.3286 | 3.3107 | 3.3111 | 66500.0 |
| 2008-10-06 07:16:00 | AAPL | Stock | 3.3111 | 3.3111 | 3.3111 | 3.3111 | 2800.0 |
| 2008-10-06 07:19:00 | AAPL | Stock | 3.3039 | 3.3129 | 3.3036 | 3.3125 | 27720.0 |
| 2008-10-06 07:21:00 | AAPL | Stock | 3.325 | 3.3304 | 3.3039 | 3.3039 | 30800.0 |
| 2008-10-06 07:22:00 | AAPL | Stock | 3.2979 | 3.2979 | 3.2975 | 3.2975 | 33600.0 |
| 2008-10-06 07:23:00 | AAPL | Stock | 3.2964 | 3.3036 | 3.2946 | 3.3036 | 64400.0 |
| 2008-10-06 07:25:00 | AAPL | Stock | 3.3036 | 3.3036 | 3.2943 | 3.2943 | 5600.0 |
| 2008-10-06 07:27:00 | AAPL | Stock | 3.2861 | 3.2861 | 3.2768 | 3.2768 | 11200.0 |
| 2008-10-06 07:28:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2946 | 3.2946 | 47432.0 |
| 2008-10-06 07:29:00 | AAPL | Stock | 3.2857 | 3.2946 | 3.2857 | 3.2857 | 22400.0 |
| 2008-10-06 07:30:00 | AAPL | Stock | 3.2861 | 3.2929 | 3.2857 | 3.2929 | 12740.0 |
| 2008-10-06 07:31:00 | AAPL | Stock | 3.2714 | 3.2714 | 3.2714 | 3.2714 | 2800.0 |
| 2008-10-06 07:33:00 | AAPL | Stock | 3.2943 | 3.2943 | 3.2943 | 3.2943 | 21000.0 |
| 2008-10-06 07:34:00 | AAPL | Stock | 3.2943 | 3.2946 | 3.2943 | 3.2946 | 14000.0 |
| 2008-10-06 07:35:00 | AAPL | Stock | 3.2943 | 3.2946 | 3.2943 | 3.2946 | 19600.0 |
| 2008-10-06 07:36:00 | AAPL | Stock | 3.2943 | 3.2946 | 3.2857 | 3.2857 | 123200.0 |
| 2008-10-06 07:38:00 | AAPL | Stock | 3.2939 | 3.2943 | 3.2939 | 3.2943 | 8400.0 |
| 2008-10-06 07:40:00 | AAPL | Stock | 3.2964 | 3.2964 | 3.2893 | 3.2893 | 41832.0 |
| 2008-10-06 07:41:00 | AAPL | Stock | 3.2964 | 3.2964 | 3.2964 | 3.2964 | 8400.0 |
| 2008-10-06 07:43:00 | AAPL | Stock | 3.3 | 3.3 | 3.3 | 3.3 | 14000.0 |
| 2008-10-06 07:44:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 32816.0 |
| 2008-10-06 07:47:00 | AAPL | Stock | 3.2993 | 3.3 | 3.2993 | 3.3 | 16800.0 |
| 2008-10-06 07:48:00 | AAPL | Stock | 3.3032 | 3.3107 | 3.3032 | 3.3107 | 35000.0 |
| 2008-10-06 07:49:00 | AAPL | Stock | 3.3186 | 3.3196 | 3.3186 | 3.3196 | 5600.0 |
| 2008-10-06 07:51:00 | AAPL | Stock | 3.3171 | 3.3193 | 3.3171 | 3.3193 | 13300.0 |
| 2008-10-06 07:52:00 | AAPL | Stock | 3.3193 | 3.3389 | 3.3075 | 3.3214 | 348880.0 |
| 2008-10-06 07:53:00 | AAPL | Stock | 3.33 | 3.33 | 3.33 | 3.33 | 14000.0 |
| 2008-10-06 07:54:00 | AAPL | Stock | 3.3393 | 3.3482 | 3.3393 | 3.3429 | 110740.0 |
| 2008-10-06 07:55:00 | AAPL | Stock | 3.3393 | 3.3393 | 3.3393 | 3.3393 | 5600.0 |
| 2008-10-06 07:56:00 | AAPL | Stock | 3.3429 | 3.3482 | 3.3429 | 3.3429 | 78400.0 |
| 2008-10-06 07:58:00 | AAPL | Stock | 3.35 | 3.3607 | 3.35 | 3.3554 | 61600.0 |
| 2008-10-06 07:59:00 | AAPL | Stock | 3.3554 | 3.3554 | 3.3429 | 3.3429 | 18200.0 |
| 2008-10-06 08:00:00 | AAPL | Stock | 3.35 | 3.3739 | 3.3393 | 3.3429 | 408268.0 |
| 2008-10-06 08:01:00 | AAPL | Stock | 3.34 | 3.3546 | 3.3393 | 3.3546 | 97048.0 |
| 2008-10-06 08:02:00 | AAPL | Stock | 3.3489 | 3.35 | 3.3393 | 3.3489 | 78512.0 |
| 2008-10-06 08:03:00 | AAPL | Stock | 3.3489 | 3.3489 | 3.3393 | 3.3429 | 149352.0 |
| 2008-10-06 08:04:00 | AAPL | Stock | 3.3429 | 3.3429 | 3.3375 | 3.3393 | 166012.0 |
| 2008-10-06 08:05:00 | AAPL | Stock | 3.3389 | 3.3393 | 3.325 | 3.325 | 130620.0 |
| 2008-10-06 08:06:00 | AAPL | Stock | 3.3229 | 3.3229 | 3.3071 | 3.3071 | 178752.0 |
| 2008-10-06 08:07:00 | AAPL | Stock | 3.3071 | 3.3146 | 3.3036 | 3.3039 | 153160.0 |
| 2008-10-06 08:08:00 | AAPL | Stock | 3.3039 | 3.3039 | 3.295 | 3.3036 | 126532.0 |
| 2008-10-06 08:09:00 | AAPL | Stock | 3.3071 | 3.3204 | 3.305 | 3.3136 | 64680.0 |
| 2008-10-06 08:10:00 | AAPL | Stock | 3.3139 | 3.3211 | 3.3104 | 3.3211 | 85372.0 |
| 2008-10-06 08:11:00 | AAPL | Stock | 3.3182 | 3.3275 | 3.3139 | 3.3225 | 158984.0 |
| 2008-10-06 08:12:00 | AAPL | Stock | 3.3264 | 3.3268 | 3.3218 | 3.325 | 53200.0 |
| 2008-10-06 08:13:00 | AAPL | Stock | 3.3268 | 3.3375 | 3.325 | 3.3332 | 68600.0 |
| 2008-10-06 08:14:00 | AAPL | Stock | 3.3393 | 3.3393 | 3.3339 | 3.3375 | 33180.0 |
| 2008-10-06 08:15:00 | AAPL | Stock | 3.3371 | 3.3739 | 3.3221 | 3.3286 | 1051428.0 |
> showing 50 of 1,124,348 rows — these rows as CSV