PREVIEW / stock_1min / 2013-04-23
file: by_date/stock_1min/2013/2013-04-23.parquet size: 13.1 MB rows: 961,227 symbols: 2,811
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-04-23 04:17:00 | AAPL | Stock | 14.2643 | 14.2643 | 14.2643 | 14.2643 | 5600.0 |
| 2013-04-23 04:26:00 | AAPL | Stock | 14.2289 | 14.2289 | 14.2289 | 14.2289 | 6328.0 |
| 2013-04-23 04:39:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2382 | 14.2382 | 14000.0 |
| 2013-04-23 04:42:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2382 | 14.2382 | 19236.0 |
| 2013-04-23 04:43:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2382 | 14.2382 | 28000.0 |
| 2013-04-23 04:45:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2382 | 14.2382 | 27944.0 |
| 2013-04-23 04:46:00 | AAPL | Stock | 14.2375 | 14.2382 | 14.2375 | 14.2382 | 42000.0 |
| 2013-04-23 04:51:00 | AAPL | Stock | 14.2143 | 14.2143 | 14.2143 | 14.2143 | 5544.0 |
| 2013-04-23 04:52:00 | AAPL | Stock | 14.2175 | 14.2175 | 14.2175 | 14.2175 | 10836.0 |
| 2013-04-23 04:56:00 | AAPL | Stock | 14.2282 | 14.2282 | 14.2282 | 14.2282 | 5376.0 |
| 2013-04-23 05:04:00 | AAPL | Stock | 14.2382 | 14.2382 | 14.2382 | 14.2382 | 14000.0 |
| 2013-04-23 05:06:00 | AAPL | Stock | 14.2321 | 14.2386 | 14.2321 | 14.2386 | 16800.0 |
| 2013-04-23 05:12:00 | AAPL | Stock | 14.2429 | 14.2429 | 14.2429 | 14.2429 | 2800.0 |
| 2013-04-23 06:06:00 | AAPL | Stock | 14.2711 | 14.2711 | 14.2711 | 14.2711 | 2800.0 |
| 2013-04-23 06:34:00 | AAPL | Stock | 14.275 | 14.275 | 14.275 | 14.275 | 2800.0 |
| 2013-04-23 07:05:00 | AAPL | Stock | 14.2857 | 14.2943 | 14.2857 | 14.2943 | 24500.0 |
| 2013-04-23 07:06:00 | AAPL | Stock | 14.2943 | 14.3086 | 14.2943 | 14.3086 | 5600.0 |
| 2013-04-23 07:07:00 | AAPL | Stock | 14.3086 | 14.3086 | 14.2943 | 14.2943 | 8400.0 |
| 2013-04-23 07:12:00 | AAPL | Stock | 14.3118 | 14.3214 | 14.3118 | 14.3214 | 15176.0 |
| 2013-04-23 07:13:00 | AAPL | Stock | 14.3379 | 14.3379 | 14.3379 | 14.3379 | 2800.0 |
| 2013-04-23 07:15:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 3472.0 |
| 2013-04-23 07:16:00 | AAPL | Stock | 14.3254 | 14.3571 | 14.3254 | 14.3571 | 70952.0 |
| 2013-04-23 07:17:00 | AAPL | Stock | 14.3661 | 14.3929 | 14.3571 | 14.3929 | 65772.0 |
| 2013-04-23 07:18:00 | AAPL | Stock | 14.3929 | 14.4107 | 14.3889 | 14.3929 | 58800.0 |
| 2013-04-23 07:19:00 | AAPL | Stock | 14.3871 | 14.3871 | 14.3871 | 14.3871 | 2800.0 |
| 2013-04-23 07:20:00 | AAPL | Stock | 14.3804 | 14.3804 | 14.3804 | 14.3804 | 3024.0 |
| 2013-04-23 07:21:00 | AAPL | Stock | 14.3661 | 14.3661 | 14.3571 | 14.3571 | 37016.0 |
| 2013-04-23 07:22:00 | AAPL | Stock | 14.3657 | 14.3661 | 14.3571 | 14.3571 | 74200.0 |
| 2013-04-23 07:25:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 9660.0 |
| 2013-04-23 07:26:00 | AAPL | Stock | 14.3661 | 14.3661 | 14.3639 | 14.3639 | 14000.0 |
| 2013-04-23 07:28:00 | AAPL | Stock | 14.3657 | 14.3657 | 14.3657 | 14.3657 | 2800.0 |
| 2013-04-23 07:29:00 | AAPL | Stock | 14.3625 | 14.3625 | 14.3625 | 14.3625 | 2800.0 |
| 2013-04-23 07:31:00 | AAPL | Stock | 14.3571 | 14.365 | 14.3564 | 14.3564 | 74900.0 |
| 2013-04-23 07:32:00 | AAPL | Stock | 14.3661 | 14.3746 | 14.3661 | 14.3746 | 11200.0 |
| 2013-04-23 07:33:00 | AAPL | Stock | 14.3821 | 14.3929 | 14.3821 | 14.3893 | 85400.0 |
| 2013-04-23 07:34:00 | AAPL | Stock | 14.3929 | 14.4096 | 14.3929 | 14.4096 | 9968.0 |
| 2013-04-23 07:36:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3754 | 14.3754 | 32648.0 |
| 2013-04-23 07:37:00 | AAPL | Stock | 14.3904 | 14.3929 | 14.3904 | 14.3929 | 43400.0 |
| 2013-04-23 07:39:00 | AAPL | Stock | 14.3904 | 14.4018 | 14.3904 | 14.3929 | 55524.0 |
| 2013-04-23 07:41:00 | AAPL | Stock | 14.3957 | 14.4121 | 14.3957 | 14.4121 | 74480.0 |
| 2013-04-23 07:42:00 | AAPL | Stock | 14.41 | 14.4239 | 14.4018 | 14.4239 | 72520.0 |
| 2013-04-23 07:43:00 | AAPL | Stock | 14.4254 | 14.4371 | 14.4254 | 14.4289 | 79884.0 |
| 2013-04-23 07:44:00 | AAPL | Stock | 14.43 | 14.43 | 14.4279 | 14.43 | 187096.0 |
| 2013-04-23 07:45:00 | AAPL | Stock | 14.4289 | 14.4418 | 14.4289 | 14.4407 | 46676.0 |
| 2013-04-23 07:46:00 | AAPL | Stock | 14.4414 | 14.4446 | 14.4414 | 14.4446 | 90384.0 |
| 2013-04-23 07:47:00 | AAPL | Stock | 14.4293 | 14.4293 | 14.4161 | 14.4161 | 30800.0 |
| 2013-04-23 07:48:00 | AAPL | Stock | 14.4114 | 14.4168 | 14.4114 | 14.4168 | 16800.0 |
| 2013-04-23 07:49:00 | AAPL | Stock | 14.4196 | 14.4229 | 14.4196 | 14.4229 | 16800.0 |
| 2013-04-23 07:50:00 | AAPL | Stock | 14.4268 | 14.4286 | 14.4168 | 14.4168 | 83216.0 |
| 2013-04-23 07:51:00 | AAPL | Stock | 14.4271 | 14.4271 | 14.4268 | 14.4271 | 8400.0 |
> showing 50 of 961,227 rows — these rows as CSV