PREVIEW / stock_1min / 2013-08-02
file: by_date/stock_1min/2013/2013-08-02.parquet size: 13.4 MB rows: 977,317 symbols: 2,847
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-08-02 05:12:00 | AAPL | Stock | 16.3232 | 16.3232 | 16.3232 | 16.3232 | 2800.0 |
| 2013-08-02 05:53:00 | AAPL | Stock | 16.3232 | 16.3232 | 16.3232 | 16.3232 | 2800.0 |
| 2013-08-02 07:21:00 | AAPL | Stock | 16.3179 | 16.3179 | 16.3179 | 16.3179 | 14000.0 |
| 2013-08-02 07:42:00 | AAPL | Stock | 16.3171 | 16.3204 | 16.3171 | 16.3204 | 8400.0 |
| 2013-08-02 07:55:00 | AAPL | Stock | 16.3154 | 16.3218 | 16.3046 | 16.3046 | 52080.0 |
| 2013-08-02 07:58:00 | AAPL | Stock | 16.305 | 16.3107 | 16.305 | 16.3107 | 28000.0 |
| 2013-08-02 08:00:00 | AAPL | Stock | 16.3079 | 16.3179 | 16.3079 | 16.3107 | 53592.0 |
| 2013-08-02 08:01:00 | AAPL | Stock | 16.3107 | 16.3129 | 16.3107 | 16.3129 | 107632.0 |
| 2013-08-02 08:03:00 | AAPL | Stock | 16.3161 | 16.3214 | 16.2143 | 16.3171 | 90440.0 |
| 2013-08-02 08:04:00 | AAPL | Stock | 16.3236 | 16.3236 | 16.3236 | 16.3236 | 3584.0 |
| 2013-08-02 08:08:00 | AAPL | Stock | 16.3304 | 16.3304 | 16.3304 | 16.3304 | 11200.0 |
| 2013-08-02 08:09:00 | AAPL | Stock | 16.3296 | 16.3296 | 16.3296 | 16.3296 | 2800.0 |
| 2013-08-02 08:10:00 | AAPL | Stock | 16.3232 | 16.3232 | 16.3232 | 16.3232 | 7140.0 |
| 2013-08-02 08:13:00 | AAPL | Stock | 16.3296 | 16.3296 | 16.3296 | 16.3296 | 2800.0 |
| 2013-08-02 08:14:00 | AAPL | Stock | 16.3271 | 16.3296 | 16.3257 | 16.3296 | 34132.0 |
| 2013-08-02 08:15:00 | AAPL | Stock | 16.3261 | 16.3261 | 16.3261 | 16.3261 | 2800.0 |
| 2013-08-02 08:16:00 | AAPL | Stock | 16.3257 | 16.3257 | 16.3214 | 16.3218 | 58464.0 |
| 2013-08-02 08:17:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3136 | 16.3136 | 71456.0 |
| 2013-08-02 08:18:00 | AAPL | Stock | 16.32 | 16.3214 | 16.32 | 16.3214 | 6020.0 |
| 2013-08-02 08:19:00 | AAPL | Stock | 16.3204 | 16.3214 | 16.3204 | 16.3214 | 28000.0 |
| 2013-08-02 08:21:00 | AAPL | Stock | 16.3211 | 16.3211 | 16.3211 | 16.3211 | 2800.0 |
| 2013-08-02 08:22:00 | AAPL | Stock | 16.3214 | 16.3304 | 16.3214 | 16.3304 | 60424.0 |
| 2013-08-02 08:24:00 | AAPL | Stock | 16.3325 | 16.3357 | 16.3325 | 16.3357 | 14000.0 |
| 2013-08-02 08:25:00 | AAPL | Stock | 16.3343 | 16.3571 | 16.3343 | 16.3564 | 72996.0 |
| 2013-08-02 08:26:00 | AAPL | Stock | 16.3571 | 16.3643 | 16.3571 | 16.3643 | 8400.0 |
| 2013-08-02 08:27:00 | AAPL | Stock | 16.3571 | 16.3611 | 16.3571 | 16.3611 | 28280.0 |
| 2013-08-02 08:28:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3571 | 16.3571 | 2800.0 |
| 2013-08-02 08:29:00 | AAPL | Stock | 16.3507 | 16.3571 | 16.3507 | 16.3571 | 9380.0 |
| 2013-08-02 08:30:00 | AAPL | Stock | 16.3571 | 16.3643 | 16.3207 | 16.3571 | 95172.0 |
| 2013-08-02 08:31:00 | AAPL | Stock | 16.34 | 16.355 | 16.3371 | 16.3429 | 53004.0 |
| 2013-08-02 08:32:00 | AAPL | Stock | 16.3371 | 16.3371 | 16.3261 | 16.3261 | 45248.0 |
| 2013-08-02 08:33:00 | AAPL | Stock | 16.3282 | 16.3282 | 16.3139 | 16.3139 | 153524.0 |
| 2013-08-02 08:34:00 | AAPL | Stock | 16.3139 | 16.3214 | 16.3136 | 16.3214 | 21000.0 |
| 2013-08-02 08:35:00 | AAPL | Stock | 16.3218 | 16.3354 | 16.3218 | 16.3311 | 58800.0 |
| 2013-08-02 08:36:00 | AAPL | Stock | 16.3325 | 16.3393 | 16.3286 | 16.3286 | 39480.0 |
| 2013-08-02 08:37:00 | AAPL | Stock | 16.3321 | 16.3321 | 16.3321 | 16.3321 | 2800.0 |
| 2013-08-02 08:38:00 | AAPL | Stock | 16.3375 | 16.3418 | 16.3375 | 16.3418 | 67172.0 |
| 2013-08-02 08:39:00 | AAPL | Stock | 16.3336 | 16.3339 | 16.3325 | 16.3329 | 28000.0 |
| 2013-08-02 08:40:00 | AAPL | Stock | 16.3329 | 16.3329 | 16.3225 | 16.3229 | 50400.0 |
| 2013-08-02 08:41:00 | AAPL | Stock | 16.3214 | 16.3246 | 16.3214 | 16.3214 | 11200.0 |
| 2013-08-02 08:42:00 | AAPL | Stock | 16.3264 | 16.3386 | 16.3264 | 16.3386 | 16800.0 |
| 2013-08-02 08:43:00 | AAPL | Stock | 16.3304 | 16.335 | 16.3304 | 16.335 | 22064.0 |
| 2013-08-02 08:44:00 | AAPL | Stock | 16.3357 | 16.3443 | 16.335 | 16.3371 | 33740.0 |
| 2013-08-02 08:45:00 | AAPL | Stock | 16.3429 | 16.3429 | 16.3429 | 16.3429 | 2800.0 |
| 2013-08-02 08:46:00 | AAPL | Stock | 16.34 | 16.3436 | 16.34 | 16.3436 | 8400.0 |
| 2013-08-02 08:47:00 | AAPL | Stock | 16.3404 | 16.3411 | 16.3357 | 16.3364 | 53172.0 |
| 2013-08-02 08:48:00 | AAPL | Stock | 16.3357 | 16.3364 | 16.3357 | 16.3364 | 14000.0 |
| 2013-08-02 08:49:00 | AAPL | Stock | 16.335 | 16.335 | 16.3275 | 16.3282 | 33600.0 |
| 2013-08-02 08:51:00 | AAPL | Stock | 16.3282 | 16.3314 | 16.3271 | 16.3314 | 95200.0 |
| 2013-08-02 08:52:00 | AAPL | Stock | 16.3307 | 16.3307 | 16.3307 | 16.3307 | 2800.0 |
> showing 50 of 977,317 rows — these rows as CSV