PREVIEW / stock_1min / 2011-06-06
file: by_date/stock_1min/2011/2011-06-06.parquet size: 13.7 MB rows: 1,031,423 symbols: 2,883
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-06 07:10:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-06-06 07:19:00 | AAPL | Stock | 12.3 | 12.3 | 12.3 | 12.3 | 11200.0 |
| 2011-06-06 07:21:00 | AAPL | Stock | 12.2964 | 12.2964 | 12.2964 | 12.2964 | 2800.0 |
| 2011-06-06 07:23:00 | AAPL | Stock | 12.2982 | 12.2982 | 12.2982 | 12.2982 | 11200.0 |
| 2011-06-06 07:24:00 | AAPL | Stock | 12.2982 | 12.2982 | 12.2982 | 12.2982 | 14000.0 |
| 2011-06-06 07:25:00 | AAPL | Stock | 12.2982 | 12.2982 | 12.2982 | 12.2982 | 2800.0 |
| 2011-06-06 07:27:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 2800.0 |
| 2011-06-06 07:29:00 | AAPL | Stock | 12.3104 | 12.3125 | 12.3104 | 12.3125 | 19600.0 |
| 2011-06-06 07:30:00 | AAPL | Stock | 12.3129 | 12.3129 | 12.3125 | 12.3125 | 8400.0 |
| 2011-06-06 07:31:00 | AAPL | Stock | 12.3114 | 12.325 | 12.3114 | 12.325 | 20160.0 |
| 2011-06-06 07:32:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.325 | 12.325 | 5600.0 |
| 2011-06-06 07:34:00 | AAPL | Stock | 12.325 | 12.325 | 12.325 | 12.325 | 5600.0 |
| 2011-06-06 07:35:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 5600.0 |
| 2011-06-06 07:36:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3214 | 12.3214 | 19600.0 |
| 2011-06-06 07:39:00 | AAPL | Stock | 12.3211 | 12.3211 | 12.3211 | 12.3211 | 5600.0 |
| 2011-06-06 07:42:00 | AAPL | Stock | 12.3011 | 12.3011 | 12.3011 | 12.3011 | 2800.0 |
| 2011-06-06 07:47:00 | AAPL | Stock | 12.3179 | 12.3179 | 12.3179 | 12.3179 | 2800.0 |
| 2011-06-06 07:48:00 | AAPL | Stock | 12.3114 | 12.3114 | 12.3114 | 12.3114 | 2800.0 |
| 2011-06-06 07:49:00 | AAPL | Stock | 12.3125 | 12.3125 | 12.3125 | 12.3125 | 2800.0 |
| 2011-06-06 07:50:00 | AAPL | Stock | 12.3175 | 12.3175 | 12.3125 | 12.3125 | 5600.0 |
| 2011-06-06 07:51:00 | AAPL | Stock | 12.3046 | 12.3046 | 12.3046 | 12.3046 | 2800.0 |
| 2011-06-06 07:55:00 | AAPL | Stock | 12.3125 | 12.3186 | 12.3125 | 12.3186 | 10360.0 |
| 2011-06-06 07:56:00 | AAPL | Stock | 12.3107 | 12.3107 | 12.3107 | 12.3107 | 7000.0 |
| 2011-06-06 07:57:00 | AAPL | Stock | 12.3071 | 12.3071 | 12.3071 | 12.3071 | 14000.0 |
| 2011-06-06 07:58:00 | AAPL | Stock | 12.3125 | 12.3125 | 12.3125 | 12.3125 | 2800.0 |
| 2011-06-06 07:59:00 | AAPL | Stock | 12.3121 | 12.3179 | 12.3121 | 12.3179 | 28000.0 |
| 2011-06-06 08:00:00 | AAPL | Stock | 12.3125 | 12.3214 | 12.3068 | 12.3214 | 184856.0 |
| 2011-06-06 08:01:00 | AAPL | Stock | 12.3179 | 12.3179 | 12.3043 | 12.3061 | 80080.0 |
| 2011-06-06 08:02:00 | AAPL | Stock | 12.3054 | 12.3054 | 12.3 | 12.3018 | 88032.0 |
| 2011-06-06 08:03:00 | AAPL | Stock | 12.3018 | 12.3018 | 12.2961 | 12.3018 | 39340.0 |
| 2011-06-06 08:04:00 | AAPL | Stock | 12.3 | 12.3143 | 12.2989 | 12.3143 | 26740.0 |
| 2011-06-06 08:05:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3054 | 12.3071 | 86800.0 |
| 2011-06-06 08:06:00 | AAPL | Stock | 12.3143 | 12.3211 | 12.3143 | 12.3211 | 52920.0 |
| 2011-06-06 08:07:00 | AAPL | Stock | 12.3204 | 12.3214 | 12.3204 | 12.3214 | 58688.0 |
| 2011-06-06 08:08:00 | AAPL | Stock | 12.3236 | 12.3279 | 12.3236 | 12.3279 | 32956.0 |
| 2011-06-06 08:09:00 | AAPL | Stock | 12.3339 | 12.3393 | 12.3339 | 12.3375 | 53340.0 |
| 2011-06-06 08:10:00 | AAPL | Stock | 12.3393 | 12.3475 | 12.3393 | 12.3475 | 22624.0 |
| 2011-06-06 08:11:00 | AAPL | Stock | 12.3429 | 12.3464 | 12.3332 | 12.3457 | 75040.0 |
| 2011-06-06 08:12:00 | AAPL | Stock | 12.3411 | 12.3411 | 12.3411 | 12.3411 | 2800.0 |
| 2011-06-06 08:13:00 | AAPL | Stock | 12.3407 | 12.3407 | 12.3339 | 12.3339 | 6468.0 |
| 2011-06-06 08:14:00 | AAPL | Stock | 12.3389 | 12.3389 | 12.3389 | 12.3389 | 8960.0 |
| 2011-06-06 08:15:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3375 | 12.3375 | 15960.0 |
| 2011-06-06 08:16:00 | AAPL | Stock | 12.3375 | 12.3375 | 12.3304 | 12.3304 | 179928.0 |
| 2011-06-06 08:17:00 | AAPL | Stock | 12.3336 | 12.3336 | 12.3336 | 12.3336 | 22400.0 |
| 2011-06-06 08:18:00 | AAPL | Stock | 12.3339 | 12.3339 | 12.3254 | 12.3254 | 14560.0 |
| 2011-06-06 08:20:00 | AAPL | Stock | 12.3357 | 12.3357 | 12.3357 | 12.3357 | 2800.0 |
| 2011-06-06 08:21:00 | AAPL | Stock | 12.3286 | 12.3393 | 12.3286 | 12.3393 | 106316.0 |
| 2011-06-06 08:22:00 | AAPL | Stock | 12.3371 | 12.3371 | 12.3311 | 12.3354 | 28000.0 |
| 2011-06-06 08:24:00 | AAPL | Stock | 12.3375 | 12.3393 | 12.3357 | 12.3357 | 51100.0 |
| 2011-06-06 08:25:00 | AAPL | Stock | 12.3332 | 12.3393 | 12.3332 | 12.3357 | 38276.0 |
> showing 50 of 1,031,423 rows — these rows as CSV