PREVIEW / stock_1min / 2010-08-09
file: by_date/stock_1min/2010/2010-08-09.parquet size: 11.9 MB rows: 910,117 symbols: 2,838
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-09 06:28:00 | AAPL | Stock | 9.2964 | 9.2964 | 9.2964 | 9.2964 | 2800.0 |
| 2010-08-09 06:39:00 | AAPL | Stock | 9.2607 | 9.2607 | 9.2607 | 9.2607 | 2800.0 |
| 2010-08-09 06:57:00 | AAPL | Stock | 9.2821 | 9.2821 | 9.2821 | 9.2821 | 14000.0 |
| 2010-08-09 07:01:00 | AAPL | Stock | 9.2611 | 9.2611 | 9.2589 | 9.2589 | 28000.0 |
| 2010-08-09 07:02:00 | AAPL | Stock | 9.2589 | 9.2589 | 9.2589 | 9.2589 | 2800.0 |
| 2010-08-09 07:12:00 | AAPL | Stock | 9.2611 | 9.2614 | 9.2611 | 9.2614 | 8400.0 |
| 2010-08-09 07:13:00 | AAPL | Stock | 9.2746 | 9.2746 | 9.2575 | 9.2575 | 5600.0 |
| 2010-08-09 07:33:00 | AAPL | Stock | 9.2714 | 9.2714 | 9.2714 | 9.2714 | 14000.0 |
| 2010-08-09 07:35:00 | AAPL | Stock | 9.2657 | 9.2657 | 9.2657 | 9.2657 | 2800.0 |
| 2010-08-09 07:36:00 | AAPL | Stock | 9.2814 | 9.2814 | 9.2814 | 9.2814 | 2800.0 |
| 2010-08-09 07:39:00 | AAPL | Stock | 9.2811 | 9.2811 | 9.2811 | 9.2811 | 2800.0 |
| 2010-08-09 07:40:00 | AAPL | Stock | 9.28 | 9.28 | 9.28 | 9.28 | 8792.0 |
| 2010-08-09 07:41:00 | AAPL | Stock | 9.2786 | 9.2821 | 9.2786 | 9.2821 | 36400.0 |
| 2010-08-09 07:44:00 | AAPL | Stock | 9.2786 | 9.2786 | 9.2786 | 9.2786 | 8400.0 |
| 2010-08-09 07:51:00 | AAPL | Stock | 9.2854 | 9.295 | 9.2854 | 9.2946 | 61600.0 |
| 2010-08-09 07:52:00 | AAPL | Stock | 9.2957 | 9.3036 | 9.2957 | 9.3036 | 76104.0 |
| 2010-08-09 07:54:00 | AAPL | Stock | 9.3071 | 9.3071 | 9.3071 | 9.3071 | 5600.0 |
| 2010-08-09 07:55:00 | AAPL | Stock | 9.3071 | 9.3071 | 9.3071 | 9.3071 | 5600.0 |
| 2010-08-09 07:56:00 | AAPL | Stock | 9.3075 | 9.3079 | 9.3071 | 9.3079 | 31808.0 |
| 2010-08-09 07:58:00 | AAPL | Stock | 9.3139 | 9.3143 | 9.3079 | 9.3079 | 19600.0 |
| 2010-08-09 08:00:00 | AAPL | Stock | 9.3132 | 9.3136 | 9.3093 | 9.3093 | 8400.0 |
| 2010-08-09 08:01:00 | AAPL | Stock | 9.3136 | 9.3179 | 9.3136 | 9.3179 | 58940.0 |
| 2010-08-09 08:02:00 | AAPL | Stock | 9.3175 | 9.3175 | 9.3171 | 9.3171 | 22148.0 |
| 2010-08-09 08:03:00 | AAPL | Stock | 9.3139 | 9.3179 | 9.3089 | 9.3179 | 104048.0 |
| 2010-08-09 08:04:00 | AAPL | Stock | 9.3179 | 9.3229 | 9.3179 | 9.3229 | 61012.0 |
| 2010-08-09 08:05:00 | AAPL | Stock | 9.3196 | 9.3286 | 9.3196 | 9.3254 | 35896.0 |
| 2010-08-09 08:06:00 | AAPL | Stock | 9.3254 | 9.3254 | 9.3196 | 9.3211 | 28000.0 |
| 2010-08-09 08:07:00 | AAPL | Stock | 9.3207 | 9.3207 | 9.3168 | 9.3168 | 25200.0 |
| 2010-08-09 08:08:00 | AAPL | Stock | 9.3179 | 9.3179 | 9.3168 | 9.3168 | 7336.0 |
| 2010-08-09 08:09:00 | AAPL | Stock | 9.3211 | 9.3261 | 9.3175 | 9.3261 | 67200.0 |
| 2010-08-09 08:10:00 | AAPL | Stock | 9.3286 | 9.3286 | 9.3282 | 9.3282 | 22400.0 |
| 2010-08-09 08:11:00 | AAPL | Stock | 9.3286 | 9.3286 | 9.325 | 9.325 | 48580.0 |
| 2010-08-09 08:12:00 | AAPL | Stock | 9.3221 | 9.3286 | 9.3221 | 9.3286 | 85736.0 |
| 2010-08-09 08:13:00 | AAPL | Stock | 9.3332 | 9.335 | 9.3304 | 9.3343 | 38136.0 |
| 2010-08-09 08:14:00 | AAPL | Stock | 9.3304 | 9.3321 | 9.3304 | 9.3304 | 70000.0 |
| 2010-08-09 08:15:00 | AAPL | Stock | 9.33 | 9.33 | 9.3229 | 9.3229 | 5600.0 |
| 2010-08-09 08:16:00 | AAPL | Stock | 9.3271 | 9.3293 | 9.3254 | 9.3289 | 15400.0 |
| 2010-08-09 08:17:00 | AAPL | Stock | 9.3264 | 9.3296 | 9.3257 | 9.3296 | 19040.0 |
| 2010-08-09 08:18:00 | AAPL | Stock | 9.3282 | 9.3286 | 9.3282 | 9.3286 | 14000.0 |
| 2010-08-09 08:19:00 | AAPL | Stock | 9.33 | 9.33 | 9.33 | 9.33 | 5600.0 |
| 2010-08-09 08:20:00 | AAPL | Stock | 9.3268 | 9.3268 | 9.3268 | 9.3268 | 2800.0 |
| 2010-08-09 08:21:00 | AAPL | Stock | 9.325 | 9.325 | 9.325 | 9.325 | 2800.0 |
| 2010-08-09 08:22:00 | AAPL | Stock | 9.325 | 9.325 | 9.325 | 9.325 | 8400.0 |
| 2010-08-09 08:23:00 | AAPL | Stock | 9.3246 | 9.3246 | 9.3214 | 9.3214 | 121380.0 |
| 2010-08-09 08:24:00 | AAPL | Stock | 9.3239 | 9.3243 | 9.3232 | 9.3232 | 32200.0 |
| 2010-08-09 08:25:00 | AAPL | Stock | 9.3239 | 9.3268 | 9.3236 | 9.3243 | 33600.0 |
| 2010-08-09 08:26:00 | AAPL | Stock | 9.3232 | 9.3232 | 9.32 | 9.32 | 59528.0 |
| 2010-08-09 08:27:00 | AAPL | Stock | 9.32 | 9.3232 | 9.3186 | 9.3186 | 34636.0 |
| 2010-08-09 08:28:00 | AAPL | Stock | 9.3214 | 9.3225 | 9.3182 | 9.3182 | 35560.0 |
| 2010-08-09 08:30:00 | AAPL | Stock | 9.3218 | 9.3218 | 9.3218 | 9.3218 | 2800.0 |
> showing 50 of 910,117 rows — these rows as CSV