PREVIEW / stock_1min / 2013-03-08
file: by_date/stock_1min/2013/2013-03-08.parquet size: 13.5 MB rows: 997,550 symbols: 2,831
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-08 04:00:00 | AAPL | Stock | 15.3964 | 15.3964 | 15.3921 | 15.3921 | 25200.0 |
| 2013-03-08 04:42:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 5600.0 |
| 2013-03-08 05:03:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 2800.0 |
| 2013-03-08 05:19:00 | AAPL | Stock | 15.415 | 15.415 | 15.415 | 15.415 | 2800.0 |
| 2013-03-08 05:25:00 | AAPL | Stock | 15.4 | 15.4 | 15.4 | 15.4 | 2800.0 |
| 2013-03-08 05:26:00 | AAPL | Stock | 15.4 | 15.4 | 15.4 | 15.4 | 2800.0 |
| 2013-03-08 05:56:00 | AAPL | Stock | 15.3964 | 15.4196 | 15.3964 | 15.4196 | 5600.0 |
| 2013-03-08 06:00:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 2800.0 |
| 2013-03-08 06:21:00 | AAPL | Stock | 15.4189 | 15.4196 | 15.4189 | 15.4196 | 10500.0 |
| 2013-03-08 06:34:00 | AAPL | Stock | 15.4189 | 15.4196 | 15.4189 | 15.4196 | 12908.0 |
| 2013-03-08 06:39:00 | AAPL | Stock | 15.4161 | 15.4161 | 15.4161 | 15.4161 | 15400.0 |
| 2013-03-08 06:49:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 5600.0 |
| 2013-03-08 06:53:00 | AAPL | Stock | 15.4071 | 15.4071 | 15.4068 | 15.4068 | 18200.0 |
| 2013-03-08 07:00:00 | AAPL | Stock | 15.4089 | 15.4089 | 15.4089 | 15.4089 | 2800.0 |
| 2013-03-08 07:01:00 | AAPL | Stock | 15.4179 | 15.4179 | 15.4179 | 15.4179 | 5600.0 |
| 2013-03-08 07:02:00 | AAPL | Stock | 15.4232 | 15.4246 | 15.4232 | 15.4246 | 41132.0 |
| 2013-03-08 07:03:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 22400.0 |
| 2013-03-08 07:04:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 14000.0 |
| 2013-03-08 07:05:00 | AAPL | Stock | 15.4325 | 15.4339 | 15.4325 | 15.4325 | 66304.0 |
| 2013-03-08 07:10:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 4200.0 |
| 2013-03-08 07:12:00 | AAPL | Stock | 15.4389 | 15.4393 | 15.4389 | 15.4393 | 8400.0 |
| 2013-03-08 07:14:00 | AAPL | Stock | 15.4339 | 15.4464 | 15.4339 | 15.4464 | 72800.0 |
| 2013-03-08 07:15:00 | AAPL | Stock | 15.4525 | 15.4532 | 15.4346 | 15.4464 | 47600.0 |
| 2013-03-08 07:16:00 | AAPL | Stock | 15.4464 | 15.4464 | 15.4461 | 15.4464 | 17500.0 |
| 2013-03-08 07:17:00 | AAPL | Stock | 15.4496 | 15.4593 | 15.4496 | 15.4518 | 25200.0 |
| 2013-03-08 07:18:00 | AAPL | Stock | 15.4518 | 15.4518 | 15.4318 | 15.4318 | 26600.0 |
| 2013-03-08 07:20:00 | AAPL | Stock | 15.4332 | 15.4404 | 15.4293 | 15.4404 | 16240.0 |
| 2013-03-08 07:25:00 | AAPL | Stock | 15.4393 | 15.4439 | 15.4393 | 15.4439 | 14000.0 |
| 2013-03-08 07:26:00 | AAPL | Stock | 15.4304 | 15.4304 | 15.4289 | 15.4289 | 9800.0 |
| 2013-03-08 07:29:00 | AAPL | Stock | 15.4179 | 15.4179 | 15.4179 | 15.4179 | 14056.0 |
| 2013-03-08 07:30:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4214 | 15.4214 | 4760.0 |
| 2013-03-08 07:31:00 | AAPL | Stock | 15.4279 | 15.4286 | 15.4279 | 15.4286 | 11200.0 |
| 2013-03-08 07:34:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 11536.0 |
| 2013-03-08 07:35:00 | AAPL | Stock | 15.4321 | 15.4321 | 15.4321 | 15.4321 | 8400.0 |
| 2013-03-08 07:38:00 | AAPL | Stock | 15.4275 | 15.4304 | 15.4275 | 15.4304 | 16800.0 |
| 2013-03-08 07:40:00 | AAPL | Stock | 15.4232 | 15.4232 | 15.4232 | 15.4232 | 2800.0 |
| 2013-03-08 07:43:00 | AAPL | Stock | 15.4232 | 15.4232 | 15.4232 | 15.4232 | 11200.0 |
| 2013-03-08 07:47:00 | AAPL | Stock | 15.4182 | 15.4182 | 15.4107 | 15.4171 | 14476.0 |
| 2013-03-08 07:48:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 5600.0 |
| 2013-03-08 07:51:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 2800.0 |
| 2013-03-08 07:52:00 | AAPL | Stock | 15.4043 | 15.4057 | 15.3857 | 15.3857 | 83048.0 |
| 2013-03-08 07:53:00 | AAPL | Stock | 15.3857 | 15.3929 | 15.3786 | 15.3786 | 53760.0 |
| 2013-03-08 07:54:00 | AAPL | Stock | 15.3786 | 15.3857 | 15.365 | 15.365 | 74200.0 |
| 2013-03-08 07:55:00 | AAPL | Stock | 15.375 | 15.375 | 15.3582 | 15.3582 | 51800.0 |
| 2013-03-08 07:56:00 | AAPL | Stock | 15.3582 | 15.3582 | 15.3571 | 15.3571 | 42000.0 |
| 2013-03-08 07:58:00 | AAPL | Stock | 15.3643 | 15.3643 | 15.3589 | 15.3589 | 36400.0 |
| 2013-03-08 07:59:00 | AAPL | Stock | 15.3593 | 15.3593 | 15.3393 | 15.35 | 64960.0 |
| 2013-03-08 08:00:00 | AAPL | Stock | 15.3621 | 15.4429 | 15.35 | 15.3518 | 210616.0 |
| 2013-03-08 08:01:00 | AAPL | Stock | 15.3482 | 15.3482 | 15.3393 | 15.3396 | 33600.0 |
| 2013-03-08 08:02:00 | AAPL | Stock | 15.34 | 15.34 | 15.33 | 15.33 | 47600.0 |
> showing 50 of 997,550 rows — these rows as CSV