PREVIEW / stock_1min / 2011-10-12
file: by_date/stock_1min/2011/2011-10-12.parquet size: 13.3 MB rows: 993,719 symbols: 2,845
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-10-12 04:18:00 | AAPL | Stock | 14.375 | 14.375 | 14.375 | 14.375 | 10836.0 |
| 2011-10-12 04:19:00 | AAPL | Stock | 14.37 | 14.37 | 14.3571 | 14.3571 | 14000.0 |
| 2011-10-12 04:23:00 | AAPL | Stock | 14.3857 | 14.3857 | 14.3857 | 14.3857 | 16660.0 |
| 2011-10-12 04:24:00 | AAPL | Stock | 14.4196 | 14.4196 | 14.4196 | 14.4196 | 6496.0 |
| 2011-10-12 04:28:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 2800.0 |
| 2011-10-12 04:33:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 2800.0 |
| 2011-10-12 04:39:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 4200.0 |
| 2011-10-12 04:40:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 4200.0 |
| 2011-10-12 04:41:00 | AAPL | Stock | 14.4157 | 14.4157 | 14.4157 | 14.4157 | 11200.0 |
| 2011-10-12 04:42:00 | AAPL | Stock | 14.4157 | 14.4157 | 14.4157 | 14.4157 | 5684.0 |
| 2011-10-12 04:43:00 | AAPL | Stock | 14.4089 | 14.4089 | 14.4089 | 14.4089 | 5600.0 |
| 2011-10-12 04:45:00 | AAPL | Stock | 14.4082 | 14.4082 | 14.4082 | 14.4082 | 2800.0 |
| 2011-10-12 04:47:00 | AAPL | Stock | 14.4082 | 14.4082 | 14.4082 | 14.4082 | 2800.0 |
| 2011-10-12 04:54:00 | AAPL | Stock | 14.4082 | 14.4082 | 14.4082 | 14.4082 | 2800.0 |
| 2011-10-12 05:08:00 | AAPL | Stock | 14.4139 | 14.4157 | 14.4036 | 14.4157 | 16800.0 |
| 2011-10-12 05:11:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 22400.0 |
| 2011-10-12 05:17:00 | AAPL | Stock | 14.4461 | 14.4464 | 14.4461 | 14.4464 | 8400.0 |
| 2011-10-12 05:18:00 | AAPL | Stock | 14.4282 | 14.4282 | 14.4282 | 14.4282 | 2800.0 |
| 2011-10-12 05:23:00 | AAPL | Stock | 14.4146 | 14.4146 | 14.4146 | 14.4146 | 2800.0 |
| 2011-10-12 05:26:00 | AAPL | Stock | 14.4461 | 14.4464 | 14.4461 | 14.4464 | 34580.0 |
| 2011-10-12 05:33:00 | AAPL | Stock | 14.4196 | 14.4196 | 14.4196 | 14.4196 | 8400.0 |
| 2011-10-12 05:41:00 | AAPL | Stock | 14.4461 | 14.4482 | 14.4461 | 14.4482 | 28000.0 |
| 2011-10-12 05:49:00 | AAPL | Stock | 14.45 | 14.45 | 14.45 | 14.45 | 4480.0 |
| 2011-10-12 05:53:00 | AAPL | Stock | 14.4518 | 14.4518 | 14.4518 | 14.4518 | 2800.0 |
| 2011-10-12 06:02:00 | AAPL | Stock | 14.4518 | 14.4518 | 14.4464 | 14.4464 | 5600.0 |
| 2011-10-12 06:11:00 | AAPL | Stock | 14.4518 | 14.4518 | 14.4518 | 14.4518 | 2800.0 |
| 2011-10-12 06:16:00 | AAPL | Stock | 14.4518 | 14.4518 | 14.4518 | 14.4518 | 4200.0 |
| 2011-10-12 06:20:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4429 | 14.4429 | 8372.0 |
| 2011-10-12 06:22:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.4464 | 14.4464 | 8400.0 |
| 2011-10-12 06:28:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 5600.0 |
| 2011-10-12 06:34:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 2800.0 |
| 2011-10-12 06:35:00 | AAPL | Stock | 14.4286 | 14.4286 | 14.4286 | 14.4286 | 5600.0 |
| 2011-10-12 07:01:00 | AAPL | Stock | 14.4143 | 14.4143 | 14.3929 | 14.3929 | 55216.0 |
| 2011-10-12 07:02:00 | AAPL | Stock | 14.3929 | 14.4071 | 14.3929 | 14.3929 | 19376.0 |
| 2011-10-12 07:03:00 | AAPL | Stock | 14.4071 | 14.4071 | 14.3932 | 14.3932 | 8400.0 |
| 2011-10-12 07:04:00 | AAPL | Stock | 14.3932 | 14.4046 | 14.3929 | 14.4 | 28028.0 |
| 2011-10-12 07:05:00 | AAPL | Stock | 14.3961 | 14.3961 | 14.3929 | 14.3961 | 23800.0 |
| 2011-10-12 07:06:00 | AAPL | Stock | 14.4 | 14.4 | 14.3975 | 14.3982 | 14000.0 |
| 2011-10-12 07:07:00 | AAPL | Stock | 14.4 | 14.4 | 14.4 | 14.4 | 5600.0 |
| 2011-10-12 07:08:00 | AAPL | Stock | 14.4004 | 14.4107 | 14.4004 | 14.4107 | 25200.0 |
| 2011-10-12 07:09:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4107 | 14.4107 | 2800.0 |
| 2011-10-12 07:12:00 | AAPL | Stock | 14.4232 | 14.4239 | 14.4232 | 14.4239 | 30380.0 |
| 2011-10-12 07:14:00 | AAPL | Stock | 14.4214 | 14.4214 | 14.4214 | 14.4214 | 5600.0 |
| 2011-10-12 07:15:00 | AAPL | Stock | 14.4143 | 14.4143 | 14.4143 | 14.4143 | 7000.0 |
| 2011-10-12 07:16:00 | AAPL | Stock | 14.4143 | 14.4261 | 14.4107 | 14.4107 | 33880.0 |
| 2011-10-12 07:17:00 | AAPL | Stock | 14.4179 | 14.4179 | 14.4175 | 14.4179 | 11200.0 |
| 2011-10-12 07:19:00 | AAPL | Stock | 14.4264 | 14.4264 | 14.4236 | 14.4236 | 5600.0 |
| 2011-10-12 07:20:00 | AAPL | Stock | 14.4271 | 14.4354 | 14.4271 | 14.4354 | 76300.0 |
| 2011-10-12 07:21:00 | AAPL | Stock | 14.4293 | 14.4425 | 14.4293 | 14.4393 | 30800.0 |
| 2011-10-12 07:22:00 | AAPL | Stock | 14.4429 | 14.4464 | 14.4361 | 14.4361 | 22400.0 |
> showing 50 of 993,719 rows — these rows as CSV