PREVIEW / stock_1min / 2013-10-07
file: by_date/stock_1min/2013/2013-10-07.parquet size: 13.3 MB rows: 974,782 symbols: 2,876
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-10-07 04:00:00 | AAPL | Stock | 17.33 | 17.33 | 17.3054 | 17.3054 | 178920.0 |
| 2013-10-07 04:03:00 | AAPL | Stock | 17.325 | 17.325 | 17.3214 | 17.3214 | 25200.0 |
| 2013-10-07 04:04:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3054 | 17.3054 | 8400.0 |
| 2013-10-07 04:05:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3214 | 17.3214 | 2800.0 |
| 2013-10-07 04:06:00 | AAPL | Stock | 17.2936 | 17.3214 | 17.2936 | 17.3214 | 25200.0 |
| 2013-10-07 04:07:00 | AAPL | Stock | 17.3218 | 17.3218 | 17.3025 | 17.3025 | 55300.0 |
| 2013-10-07 04:08:00 | AAPL | Stock | 17.2936 | 17.2936 | 17.2896 | 17.2911 | 30800.0 |
| 2013-10-07 04:10:00 | AAPL | Stock | 17.2946 | 17.2946 | 17.2946 | 17.2946 | 5600.0 |
| 2013-10-07 04:14:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 2800.0 |
| 2013-10-07 04:17:00 | AAPL | Stock | 17.2911 | 17.2911 | 17.2911 | 17.2911 | 5600.0 |
| 2013-10-07 04:22:00 | AAPL | Stock | 17.3057 | 17.3057 | 17.3057 | 17.3057 | 2800.0 |
| 2013-10-07 04:23:00 | AAPL | Stock | 17.3136 | 17.3161 | 17.3136 | 17.3161 | 10360.0 |
| 2013-10-07 04:24:00 | AAPL | Stock | 17.3179 | 17.3214 | 17.3179 | 17.3214 | 5600.0 |
| 2013-10-07 04:30:00 | AAPL | Stock | 17.3104 | 17.3104 | 17.3104 | 17.3104 | 28000.0 |
| 2013-10-07 04:31:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3214 | 17.3214 | 2800.0 |
| 2013-10-07 04:33:00 | AAPL | Stock | 17.3289 | 17.3293 | 17.3289 | 17.3293 | 28000.0 |
| 2013-10-07 04:35:00 | AAPL | Stock | 17.3214 | 17.3332 | 17.3214 | 17.3332 | 27944.0 |
| 2013-10-07 04:37:00 | AAPL | Stock | 17.3129 | 17.3129 | 17.3129 | 17.3129 | 11200.0 |
| 2013-10-07 04:39:00 | AAPL | Stock | 17.3218 | 17.3218 | 17.3214 | 17.3214 | 142520.0 |
| 2013-10-07 04:40:00 | AAPL | Stock | 17.3143 | 17.3214 | 17.3143 | 17.3214 | 12320.0 |
| 2013-10-07 04:41:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3214 | 17.3214 | 2800.0 |
| 2013-10-07 04:44:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3214 | 17.3214 | 2800.0 |
| 2013-10-07 04:55:00 | AAPL | Stock | 17.3196 | 17.3375 | 17.3196 | 17.3375 | 53592.0 |
| 2013-10-07 04:56:00 | AAPL | Stock | 17.3386 | 17.3504 | 17.3386 | 17.3504 | 16744.0 |
| 2013-10-07 05:09:00 | AAPL | Stock | 17.3268 | 17.3268 | 17.325 | 17.325 | 9800.0 |
| 2013-10-07 05:29:00 | AAPL | Stock | 17.3271 | 17.3271 | 17.3271 | 17.3271 | 2800.0 |
| 2013-10-07 05:30:00 | AAPL | Stock | 17.3464 | 17.3464 | 17.3464 | 17.3464 | 61236.0 |
| 2013-10-07 05:36:00 | AAPL | Stock | 17.3296 | 17.3296 | 17.3296 | 17.3296 | 14000.0 |
| 2013-10-07 05:47:00 | AAPL | Stock | 17.3454 | 17.3464 | 17.3454 | 17.3464 | 33600.0 |
| 2013-10-07 05:48:00 | AAPL | Stock | 17.3464 | 17.3464 | 17.3464 | 17.3464 | 53620.0 |
| 2013-10-07 05:49:00 | AAPL | Stock | 17.3582 | 17.3582 | 17.3582 | 17.3582 | 5600.0 |
| 2013-10-07 05:51:00 | AAPL | Stock | 17.3721 | 17.3739 | 17.3721 | 17.3739 | 26600.0 |
| 2013-10-07 05:52:00 | AAPL | Stock | 17.3739 | 17.3739 | 17.3739 | 17.3739 | 34580.0 |
| 2013-10-07 05:54:00 | AAPL | Stock | 17.3911 | 17.3929 | 17.3911 | 17.3929 | 16660.0 |
| 2013-10-07 05:55:00 | AAPL | Stock | 17.3929 | 17.3929 | 17.3929 | 17.3929 | 2800.0 |
| 2013-10-07 05:56:00 | AAPL | Stock | 17.3929 | 17.3929 | 17.3857 | 17.3929 | 8400.0 |
| 2013-10-07 05:57:00 | AAPL | Stock | 17.3929 | 17.3932 | 17.3929 | 17.3929 | 8400.0 |
| 2013-10-07 05:58:00 | AAPL | Stock | 17.3925 | 17.3925 | 17.3925 | 17.3925 | 13020.0 |
| 2013-10-07 05:59:00 | AAPL | Stock | 17.3886 | 17.3886 | 17.3886 | 17.3886 | 4704.0 |
| 2013-10-07 06:05:00 | AAPL | Stock | 17.3779 | 17.3779 | 17.3779 | 17.3779 | 2800.0 |
| 2013-10-07 06:10:00 | AAPL | Stock | 17.3625 | 17.3775 | 17.3625 | 17.3775 | 28868.0 |
| 2013-10-07 06:11:00 | AAPL | Stock | 17.3636 | 17.3636 | 17.3636 | 17.3636 | 2800.0 |
| 2013-10-07 06:12:00 | AAPL | Stock | 17.3579 | 17.3579 | 17.3579 | 17.3579 | 2800.0 |
| 2013-10-07 06:16:00 | AAPL | Stock | 17.3579 | 17.3579 | 17.3579 | 17.3579 | 5320.0 |
| 2013-10-07 06:17:00 | AAPL | Stock | 17.3539 | 17.3539 | 17.3539 | 17.3539 | 14000.0 |
| 2013-10-07 06:20:00 | AAPL | Stock | 17.3546 | 17.3546 | 17.3546 | 17.3546 | 2800.0 |
| 2013-10-07 06:25:00 | AAPL | Stock | 17.3661 | 17.3661 | 17.3661 | 17.3661 | 2800.0 |
| 2013-10-07 06:31:00 | AAPL | Stock | 17.3607 | 17.3607 | 17.3607 | 17.3607 | 2800.0 |
| 2013-10-07 06:36:00 | AAPL | Stock | 17.3704 | 17.3704 | 17.3704 | 17.3704 | 2800.0 |
| 2013-10-07 06:41:00 | AAPL | Stock | 17.3675 | 17.3675 | 17.3675 | 17.3675 | 2800.0 |
> showing 50 of 974,782 rows — these rows as CSV