PREVIEW / stock_1min / 2011-02-07
file: by_date/stock_1min/2011/2011-02-07.parquet size: 13.0 MB rows: 966,444 symbols: 2,868
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-02-07 04:02:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 2800.0 |
| 2011-02-07 04:23:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 2800.0 |
| 2011-02-07 04:25:00 | AAPL | Stock | 12.4614 | 12.4643 | 12.4614 | 12.4643 | 11200.0 |
| 2011-02-07 04:32:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 5320.0 |
| 2011-02-07 04:33:00 | AAPL | Stock | 12.4832 | 12.4832 | 12.4832 | 12.4832 | 5600.0 |
| 2011-02-07 04:34:00 | AAPL | Stock | 12.49 | 12.49 | 12.49 | 12.49 | 5600.0 |
| 2011-02-07 04:35:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 2800.0 |
| 2011-02-07 04:43:00 | AAPL | Stock | 12.4668 | 12.4668 | 12.4668 | 12.4668 | 2800.0 |
| 2011-02-07 04:47:00 | AAPL | Stock | 12.48 | 12.48 | 12.48 | 12.48 | 2800.0 |
| 2011-02-07 04:55:00 | AAPL | Stock | 12.4736 | 12.4736 | 12.4736 | 12.4736 | 14000.0 |
| 2011-02-07 05:08:00 | AAPL | Stock | 12.4714 | 12.4714 | 12.4714 | 12.4714 | 14000.0 |
| 2011-02-07 05:32:00 | AAPL | Stock | 12.4546 | 12.4546 | 12.4546 | 12.4546 | 2800.0 |
| 2011-02-07 05:33:00 | AAPL | Stock | 12.4575 | 12.4575 | 12.4575 | 12.4575 | 2800.0 |
| 2011-02-07 06:00:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.4554 | 12.4554 | 2800.0 |
| 2011-02-07 06:01:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 2800.0 |
| 2011-02-07 06:02:00 | AAPL | Stock | 12.4518 | 12.4518 | 12.4518 | 12.4518 | 2800.0 |
| 2011-02-07 06:06:00 | AAPL | Stock | 12.4411 | 12.4411 | 12.4411 | 12.4411 | 14000.0 |
| 2011-02-07 06:48:00 | AAPL | Stock | 12.4321 | 12.4321 | 12.4321 | 12.4321 | 2800.0 |
| 2011-02-07 06:57:00 | AAPL | Stock | 12.4418 | 12.4421 | 12.4418 | 12.4421 | 11200.0 |
| 2011-02-07 07:01:00 | AAPL | Stock | 12.4429 | 12.4464 | 12.4429 | 12.4464 | 16800.0 |
| 2011-02-07 07:03:00 | AAPL | Stock | 12.4461 | 12.4461 | 12.4461 | 12.4461 | 2800.0 |
| 2011-02-07 07:04:00 | AAPL | Stock | 12.445 | 12.445 | 12.445 | 12.445 | 2800.0 |
| 2011-02-07 07:07:00 | AAPL | Stock | 12.4446 | 12.4446 | 12.4446 | 12.4446 | 2800.0 |
| 2011-02-07 07:08:00 | AAPL | Stock | 12.4375 | 12.4375 | 12.4375 | 12.4375 | 2800.0 |
| 2011-02-07 07:10:00 | AAPL | Stock | 12.4421 | 12.4421 | 12.4421 | 12.4421 | 2800.0 |
| 2011-02-07 07:11:00 | AAPL | Stock | 12.4446 | 12.4461 | 12.4446 | 12.4461 | 8400.0 |
| 2011-02-07 07:12:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 11200.0 |
| 2011-02-07 07:15:00 | AAPL | Stock | 12.4393 | 12.4393 | 12.4364 | 12.4364 | 14336.0 |
| 2011-02-07 07:17:00 | AAPL | Stock | 12.4371 | 12.4371 | 12.4371 | 12.4371 | 14000.0 |
| 2011-02-07 07:19:00 | AAPL | Stock | 12.4371 | 12.4371 | 12.4371 | 12.4371 | 8400.0 |
| 2011-02-07 07:21:00 | AAPL | Stock | 12.4379 | 12.4379 | 12.4379 | 12.4379 | 2800.0 |
| 2011-02-07 07:22:00 | AAPL | Stock | 12.4346 | 12.4346 | 12.4346 | 12.4346 | 2800.0 |
| 2011-02-07 07:23:00 | AAPL | Stock | 12.4379 | 12.4379 | 12.4286 | 12.4286 | 7000.0 |
| 2011-02-07 07:24:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 2800.0 |
| 2011-02-07 07:25:00 | AAPL | Stock | 12.4246 | 12.4246 | 12.4246 | 12.4246 | 2800.0 |
| 2011-02-07 07:26:00 | AAPL | Stock | 12.4246 | 12.4246 | 12.4246 | 12.4246 | 5600.0 |
| 2011-02-07 07:28:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 5600.0 |
| 2011-02-07 07:29:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4282 | 12.4282 | 6524.0 |
| 2011-02-07 07:31:00 | AAPL | Stock | 12.4282 | 12.4282 | 12.4282 | 12.4282 | 5600.0 |
| 2011-02-07 07:32:00 | AAPL | Stock | 12.4225 | 12.4225 | 12.4225 | 12.4225 | 2800.0 |
| 2011-02-07 07:34:00 | AAPL | Stock | 12.4232 | 12.4279 | 12.4196 | 12.4196 | 28000.0 |
| 2011-02-07 07:35:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 16800.0 |
| 2011-02-07 07:38:00 | AAPL | Stock | 12.4268 | 12.4286 | 12.4268 | 12.4286 | 25900.0 |
| 2011-02-07 07:39:00 | AAPL | Stock | 12.4286 | 12.4286 | 12.4286 | 12.4286 | 2800.0 |
| 2011-02-07 07:43:00 | AAPL | Stock | 12.4218 | 12.4218 | 12.4214 | 12.4214 | 16800.0 |
| 2011-02-07 07:45:00 | AAPL | Stock | 12.425 | 12.425 | 12.425 | 12.425 | 5600.0 |
| 2011-02-07 07:51:00 | AAPL | Stock | 12.4268 | 12.4268 | 12.4268 | 12.4268 | 3360.0 |
| 2011-02-07 07:52:00 | AAPL | Stock | 12.4236 | 12.4236 | 12.4179 | 12.4179 | 39760.0 |
| 2011-02-07 07:53:00 | AAPL | Stock | 12.4111 | 12.4111 | 12.4111 | 12.4111 | 8400.0 |
| 2011-02-07 07:54:00 | AAPL | Stock | 12.4171 | 12.4271 | 12.4171 | 12.425 | 8400.0 |
> showing 50 of 966,444 rows — these rows as CSV