PREVIEW / stock_1min / 2013-03-11
file: by_date/stock_1min/2013/2013-03-11.parquet size: 13.1 MB rows: 976,186 symbols: 2,806
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-03-11 05:59:00 | AAPL | Stock | 15.3589 | 15.3589 | 15.3589 | 15.3589 | 2800.0 |
| 2013-03-11 06:02:00 | AAPL | Stock | 15.3589 | 15.3589 | 15.3589 | 15.3589 | 8400.0 |
| 2013-03-11 06:17:00 | AAPL | Stock | 15.3393 | 15.3393 | 15.3393 | 15.3393 | 2800.0 |
| 2013-03-11 07:24:00 | AAPL | Stock | 15.3839 | 15.3839 | 15.3839 | 15.3839 | 5600.0 |
| 2013-03-11 07:33:00 | AAPL | Stock | 15.3618 | 15.3618 | 15.3571 | 15.3571 | 11200.0 |
| 2013-03-11 07:36:00 | AAPL | Stock | 15.3475 | 15.3475 | 15.3071 | 15.3214 | 35308.0 |
| 2013-03-11 07:37:00 | AAPL | Stock | 15.3321 | 15.3321 | 15.3214 | 15.3214 | 26292.0 |
| 2013-03-11 07:41:00 | AAPL | Stock | 15.3214 | 15.3271 | 15.3214 | 15.3271 | 6216.0 |
| 2013-03-11 07:42:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 2800.0 |
| 2013-03-11 07:43:00 | AAPL | Stock | 15.3071 | 15.3071 | 15.3036 | 15.3036 | 42000.0 |
| 2013-03-11 07:48:00 | AAPL | Stock | 15.3036 | 15.3036 | 15.25 | 15.2536 | 62804.0 |
| 2013-03-11 07:49:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2857 | 15.2857 | 2800.0 |
| 2013-03-11 07:51:00 | AAPL | Stock | 15.2857 | 15.2882 | 15.2857 | 15.2857 | 11788.0 |
| 2013-03-11 07:52:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.285 | 15.2857 | 11200.0 |
| 2013-03-11 07:55:00 | AAPL | Stock | 15.3018 | 15.3043 | 15.3018 | 15.3043 | 31612.0 |
| 2013-03-11 07:56:00 | AAPL | Stock | 15.3171 | 15.3171 | 15.3171 | 15.3171 | 2800.0 |
| 2013-03-11 07:58:00 | AAPL | Stock | 15.3157 | 15.3161 | 15.3157 | 15.3161 | 6188.0 |
| 2013-03-11 07:59:00 | AAPL | Stock | 15.32 | 15.3214 | 15.32 | 15.3214 | 5600.0 |
| 2013-03-11 08:00:00 | AAPL | Stock | 15.2786 | 15.3354 | 15.2786 | 15.3329 | 24640.0 |
| 2013-03-11 08:02:00 | AAPL | Stock | 15.3229 | 15.3229 | 15.3139 | 15.3214 | 33404.0 |
| 2013-03-11 08:03:00 | AAPL | Stock | 15.3229 | 15.3229 | 15.3179 | 15.3179 | 11200.0 |
| 2013-03-11 08:04:00 | AAPL | Stock | 15.3189 | 15.3189 | 15.3132 | 15.3171 | 42168.0 |
| 2013-03-11 08:05:00 | AAPL | Stock | 15.3211 | 15.3211 | 15.3171 | 15.3171 | 14000.0 |
| 2013-03-11 08:06:00 | AAPL | Stock | 15.3154 | 15.3154 | 15.3154 | 15.3154 | 2800.0 |
| 2013-03-11 08:07:00 | AAPL | Stock | 15.3139 | 15.3139 | 15.3139 | 15.3139 | 3696.0 |
| 2013-03-11 08:08:00 | AAPL | Stock | 15.3086 | 15.3214 | 15.3079 | 15.3214 | 27804.0 |
| 2013-03-11 08:09:00 | AAPL | Stock | 15.3189 | 15.3189 | 15.2857 | 15.2857 | 172816.0 |
| 2013-03-11 08:10:00 | AAPL | Stock | 15.3036 | 15.3211 | 15.3036 | 15.3211 | 22344.0 |
| 2013-03-11 08:11:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 5600.0 |
| 2013-03-11 08:12:00 | AAPL | Stock | 15.3225 | 15.3225 | 15.3214 | 15.3214 | 14168.0 |
| 2013-03-11 08:14:00 | AAPL | Stock | 15.3211 | 15.3211 | 15.3211 | 15.3211 | 2800.0 |
| 2013-03-11 08:15:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 5600.0 |
| 2013-03-11 08:16:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 8400.0 |
| 2013-03-11 08:17:00 | AAPL | Stock | 15.3304 | 15.3304 | 15.3214 | 15.3214 | 8400.0 |
| 2013-03-11 08:19:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 2800.0 |
| 2013-03-11 08:20:00 | AAPL | Stock | 15.3157 | 15.3157 | 15.3143 | 15.3143 | 11032.0 |
| 2013-03-11 08:21:00 | AAPL | Stock | 15.3221 | 15.3879 | 15.3214 | 15.3879 | 22960.0 |
| 2013-03-11 08:22:00 | AAPL | Stock | 15.3218 | 15.3257 | 15.3218 | 15.325 | 8400.0 |
| 2013-03-11 08:23:00 | AAPL | Stock | 15.3279 | 15.3321 | 15.325 | 15.325 | 84084.0 |
| 2013-03-11 08:24:00 | AAPL | Stock | 15.3254 | 15.3293 | 15.3143 | 15.3293 | 53200.0 |
| 2013-03-11 08:25:00 | AAPL | Stock | 15.3221 | 15.3221 | 15.3179 | 15.3179 | 19040.0 |
| 2013-03-11 08:27:00 | AAPL | Stock | 15.3271 | 15.3282 | 15.3271 | 15.3282 | 8400.0 |
| 2013-03-11 08:29:00 | AAPL | Stock | 15.3307 | 15.3318 | 15.3307 | 15.3314 | 18508.0 |
| 2013-03-11 08:30:00 | AAPL | Stock | 15.3232 | 15.3321 | 15.3232 | 15.3321 | 64344.0 |
| 2013-03-11 08:31:00 | AAPL | Stock | 15.3318 | 15.3318 | 15.3304 | 15.3304 | 22400.0 |
| 2013-03-11 08:32:00 | AAPL | Stock | 15.3218 | 15.3225 | 15.3214 | 15.3214 | 30660.0 |
| 2013-03-11 08:34:00 | AAPL | Stock | 15.3221 | 15.3221 | 15.3221 | 15.3221 | 2800.0 |
| 2013-03-11 08:36:00 | AAPL | Stock | 15.3275 | 15.3275 | 15.3275 | 15.3275 | 2800.0 |
| 2013-03-11 08:37:00 | AAPL | Stock | 15.3304 | 15.3318 | 15.3304 | 15.3318 | 11200.0 |
| 2013-03-11 08:38:00 | AAPL | Stock | 15.3318 | 15.3321 | 15.3304 | 15.3321 | 36400.0 |
> showing 50 of 976,186 rows — these rows as CSV