PREVIEW / stock_1min / 2013-07-19
file: by_date/stock_1min/2013/2013-07-19.parquet size: 12.8 MB rows: 939,334 symbols: 2,810
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-07-19 05:26:00 | AAPL | Stock | 15.3514 | 15.3514 | 15.3514 | 15.3514 | 11200.0 |
| 2013-07-19 05:53:00 | AAPL | Stock | 15.3568 | 15.3568 | 15.3568 | 15.3568 | 2800.0 |
| 2013-07-19 06:45:00 | AAPL | Stock | 15.3857 | 15.3857 | 15.3857 | 15.3857 | 2800.0 |
| 2013-07-19 06:51:00 | AAPL | Stock | 15.3961 | 15.3961 | 15.3961 | 15.3961 | 2800.0 |
| 2013-07-19 07:03:00 | AAPL | Stock | 15.3839 | 15.3839 | 15.3839 | 15.3839 | 13300.0 |
| 2013-07-19 07:08:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 5600.0 |
| 2013-07-19 07:26:00 | AAPL | Stock | 15.3929 | 15.4004 | 15.3929 | 15.4004 | 11200.0 |
| 2013-07-19 08:00:00 | AAPL | Stock | 15.4086 | 15.4268 | 15.3839 | 15.4061 | 77560.0 |
| 2013-07-19 08:01:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 12600.0 |
| 2013-07-19 08:03:00 | AAPL | Stock | 15.4039 | 15.4039 | 15.4039 | 15.4039 | 3724.0 |
| 2013-07-19 08:04:00 | AAPL | Stock | 15.4086 | 15.4129 | 15.4086 | 15.4129 | 22400.0 |
| 2013-07-19 08:05:00 | AAPL | Stock | 15.4129 | 15.4129 | 15.4129 | 15.4129 | 14000.0 |
| 2013-07-19 08:12:00 | AAPL | Stock | 15.42 | 15.42 | 15.42 | 15.42 | 4200.0 |
| 2013-07-19 08:13:00 | AAPL | Stock | 15.4282 | 15.4282 | 15.4282 | 15.4282 | 2800.0 |
| 2013-07-19 08:16:00 | AAPL | Stock | 15.4414 | 15.4536 | 15.4414 | 15.4536 | 25200.0 |
| 2013-07-19 08:17:00 | AAPL | Stock | 15.4539 | 15.4561 | 15.4218 | 15.4218 | 72800.0 |
| 2013-07-19 08:20:00 | AAPL | Stock | 15.4264 | 15.4275 | 15.42 | 15.4225 | 78204.0 |
| 2013-07-19 08:21:00 | AAPL | Stock | 15.4114 | 15.4114 | 15.4111 | 15.4111 | 11200.0 |
| 2013-07-19 08:22:00 | AAPL | Stock | 15.45 | 15.45 | 15.45 | 15.45 | 2800.0 |
| 2013-07-19 08:23:00 | AAPL | Stock | 15.4164 | 15.4164 | 15.4164 | 15.4164 | 2800.0 |
| 2013-07-19 08:25:00 | AAPL | Stock | 15.425 | 15.425 | 15.425 | 15.425 | 2800.0 |
| 2013-07-19 08:28:00 | AAPL | Stock | 15.4286 | 15.4286 | 15.4286 | 15.4286 | 5600.0 |
| 2013-07-19 08:36:00 | AAPL | Stock | 15.4425 | 15.4425 | 15.4425 | 15.4425 | 8400.0 |
| 2013-07-19 08:39:00 | AAPL | Stock | 15.4464 | 15.4464 | 15.44 | 15.44 | 11200.0 |
| 2013-07-19 08:41:00 | AAPL | Stock | 15.4464 | 15.4464 | 15.4464 | 15.4464 | 16240.0 |
| 2013-07-19 08:42:00 | AAPL | Stock | 15.4529 | 15.4532 | 15.4521 | 15.4532 | 25200.0 |
| 2013-07-19 08:43:00 | AAPL | Stock | 15.4468 | 15.4468 | 15.4468 | 15.4468 | 5600.0 |
| 2013-07-19 08:44:00 | AAPL | Stock | 15.455 | 15.4554 | 15.455 | 15.4554 | 14812.0 |
| 2013-07-19 08:46:00 | AAPL | Stock | 15.4554 | 15.4554 | 15.4482 | 15.4482 | 25564.0 |
| 2013-07-19 08:47:00 | AAPL | Stock | 15.4464 | 15.4468 | 15.4464 | 15.4464 | 30800.0 |
| 2013-07-19 08:48:00 | AAPL | Stock | 15.455 | 15.4643 | 15.455 | 15.4643 | 36596.0 |
| 2013-07-19 08:49:00 | AAPL | Stock | 15.4679 | 15.4732 | 15.4643 | 15.4643 | 27720.0 |
| 2013-07-19 08:50:00 | AAPL | Stock | 15.4607 | 15.4643 | 15.4607 | 15.4643 | 20048.0 |
| 2013-07-19 08:51:00 | AAPL | Stock | 15.4679 | 15.4679 | 15.4679 | 15.4679 | 8400.0 |
| 2013-07-19 08:52:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4643 | 15.4643 | 2800.0 |
| 2013-07-19 08:53:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4643 | 15.4643 | 2800.0 |
| 2013-07-19 08:55:00 | AAPL | Stock | 15.4636 | 15.4636 | 15.4636 | 15.4636 | 2800.0 |
| 2013-07-19 08:56:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4518 | 15.4518 | 82572.0 |
| 2013-07-19 08:57:00 | AAPL | Stock | 15.4607 | 15.4607 | 15.4607 | 15.4607 | 2800.0 |
| 2013-07-19 08:58:00 | AAPL | Stock | 15.4607 | 15.4607 | 15.4607 | 15.4607 | 5600.0 |
| 2013-07-19 08:59:00 | AAPL | Stock | 15.4636 | 15.4643 | 15.4618 | 15.4643 | 116900.0 |
| 2013-07-19 09:00:00 | AAPL | Stock | 15.4536 | 15.4679 | 15.4536 | 15.4679 | 55244.0 |
| 2013-07-19 09:01:00 | AAPL | Stock | 15.4675 | 15.4675 | 15.4643 | 15.4643 | 14000.0 |
| 2013-07-19 09:02:00 | AAPL | Stock | 15.4732 | 15.4779 | 15.4646 | 15.4675 | 50120.0 |
| 2013-07-19 09:03:00 | AAPL | Stock | 15.4711 | 15.4711 | 15.4643 | 15.4646 | 39760.0 |
| 2013-07-19 09:04:00 | AAPL | Stock | 15.4643 | 15.4711 | 15.4643 | 15.4711 | 16800.0 |
| 2013-07-19 09:05:00 | AAPL | Stock | 15.4732 | 15.4746 | 15.4732 | 15.4746 | 19600.0 |
| 2013-07-19 09:06:00 | AAPL | Stock | 15.4679 | 15.4739 | 15.4643 | 15.4643 | 66920.0 |
| 2013-07-19 09:07:00 | AAPL | Stock | 15.4625 | 15.4625 | 15.4625 | 15.4625 | 28000.0 |
| 2013-07-19 09:11:00 | AAPL | Stock | 15.4618 | 15.4618 | 15.4539 | 15.4539 | 39200.0 |
> showing 50 of 939,334 rows — these rows as CSV