PREVIEW / stock_1min / 2013-06-17
file: by_date/stock_1min/2013/2013-06-17.parquet size: 13.8 MB rows: 1,028,561 symbols: 2,849
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-06-17 04:00:00 | AAPL | Stock | 15.4361 | 15.4361 | 15.3571 | 15.4 | 19488.0 |
| 2013-06-17 04:06:00 | AAPL | Stock | 15.4464 | 15.4464 | 15.4464 | 15.4464 | 2800.0 |
| 2013-06-17 04:12:00 | AAPL | Stock | 15.4579 | 15.4661 | 15.4579 | 15.4661 | 12068.0 |
| 2013-06-17 04:34:00 | AAPL | Stock | 15.4657 | 15.4657 | 15.4657 | 15.4657 | 2800.0 |
| 2013-06-17 05:53:00 | AAPL | Stock | 15.4664 | 15.4664 | 15.4664 | 15.4664 | 2800.0 |
| 2013-06-17 06:03:00 | AAPL | Stock | 15.4679 | 15.4679 | 15.4679 | 15.4679 | 2800.0 |
| 2013-06-17 06:05:00 | AAPL | Stock | 15.4732 | 15.4732 | 15.4732 | 15.4732 | 2800.0 |
| 2013-06-17 06:29:00 | AAPL | Stock | 15.4664 | 15.4664 | 15.4664 | 15.4664 | 2800.0 |
| 2013-06-17 06:47:00 | AAPL | Stock | 15.4696 | 15.4696 | 15.4696 | 15.4696 | 2800.0 |
| 2013-06-17 06:53:00 | AAPL | Stock | 15.4704 | 15.4704 | 15.4704 | 15.4704 | 2800.0 |
| 2013-06-17 06:54:00 | AAPL | Stock | 15.4693 | 15.4693 | 15.4693 | 15.4693 | 2800.0 |
| 2013-06-17 06:56:00 | AAPL | Stock | 15.4664 | 15.4664 | 15.4664 | 15.4664 | 2800.0 |
| 2013-06-17 06:58:00 | AAPL | Stock | 15.4693 | 15.4693 | 15.4693 | 15.4693 | 9856.0 |
| 2013-06-17 07:00:00 | AAPL | Stock | 15.4671 | 15.4814 | 15.4671 | 15.4814 | 37856.0 |
| 2013-06-17 07:01:00 | AAPL | Stock | 15.48 | 15.48 | 15.4729 | 15.4729 | 13944.0 |
| 2013-06-17 07:05:00 | AAPL | Stock | 15.4786 | 15.4786 | 15.4786 | 15.4786 | 2800.0 |
| 2013-06-17 07:06:00 | AAPL | Stock | 15.4789 | 15.4789 | 15.4771 | 15.4771 | 11200.0 |
| 2013-06-17 07:09:00 | AAPL | Stock | 15.4679 | 15.4682 | 15.4664 | 15.4664 | 16800.0 |
| 2013-06-17 07:11:00 | AAPL | Stock | 15.4643 | 15.4643 | 15.4643 | 15.4643 | 7000.0 |
| 2013-06-17 07:13:00 | AAPL | Stock | 15.4582 | 15.4582 | 15.4579 | 15.4579 | 5600.0 |
| 2013-06-17 07:17:00 | AAPL | Stock | 15.4564 | 15.4564 | 15.4564 | 15.4564 | 2800.0 |
| 2013-06-17 07:18:00 | AAPL | Stock | 15.46 | 15.4604 | 15.46 | 15.4604 | 5600.0 |
| 2013-06-17 07:19:00 | AAPL | Stock | 15.4604 | 15.4625 | 15.4604 | 15.4625 | 8400.0 |
| 2013-06-17 07:21:00 | AAPL | Stock | 15.4618 | 15.4618 | 15.4618 | 15.4618 | 2800.0 |
| 2013-06-17 07:25:00 | AAPL | Stock | 15.4514 | 15.4514 | 15.4514 | 15.4514 | 2800.0 |
| 2013-06-17 07:29:00 | AAPL | Stock | 15.4554 | 15.4554 | 15.4554 | 15.4554 | 2800.0 |
| 2013-06-17 07:30:00 | AAPL | Stock | 15.4514 | 15.4514 | 15.4514 | 15.4514 | 14000.0 |
| 2013-06-17 07:31:00 | AAPL | Stock | 15.4571 | 15.4571 | 15.4571 | 15.4571 | 2800.0 |
| 2013-06-17 07:35:00 | AAPL | Stock | 15.4536 | 15.4539 | 15.4536 | 15.4539 | 16800.0 |
| 2013-06-17 07:36:00 | AAPL | Stock | 15.4532 | 15.4536 | 15.4532 | 15.4536 | 44800.0 |
| 2013-06-17 07:37:00 | AAPL | Stock | 15.4554 | 15.4554 | 15.4357 | 15.4357 | 59500.0 |
| 2013-06-17 07:39:00 | AAPL | Stock | 15.4361 | 15.4361 | 15.4361 | 15.4361 | 5600.0 |
| 2013-06-17 07:41:00 | AAPL | Stock | 15.4421 | 15.4554 | 15.4421 | 15.4554 | 74452.0 |
| 2013-06-17 07:42:00 | AAPL | Stock | 15.4589 | 15.4679 | 15.4589 | 15.4679 | 67200.0 |
| 2013-06-17 07:43:00 | AAPL | Stock | 15.4536 | 15.4536 | 15.4536 | 15.4536 | 5600.0 |
| 2013-06-17 07:44:00 | AAPL | Stock | 15.4493 | 15.4493 | 15.4393 | 15.4393 | 19600.0 |
| 2013-06-17 07:45:00 | AAPL | Stock | 15.4375 | 15.4375 | 15.4357 | 15.4357 | 11200.0 |
| 2013-06-17 07:46:00 | AAPL | Stock | 15.4304 | 15.4389 | 15.4304 | 15.4389 | 16800.0 |
| 2013-06-17 07:47:00 | AAPL | Stock | 15.4311 | 15.4336 | 15.4175 | 15.4179 | 33600.0 |
| 2013-06-17 07:48:00 | AAPL | Stock | 15.4179 | 15.4179 | 15.4179 | 15.4179 | 8400.0 |
| 2013-06-17 07:50:00 | AAPL | Stock | 15.42 | 15.4268 | 15.42 | 15.4268 | 11200.0 |
| 2013-06-17 07:51:00 | AAPL | Stock | 15.4257 | 15.4264 | 15.4257 | 15.4264 | 5600.0 |
| 2013-06-17 07:52:00 | AAPL | Stock | 15.4264 | 15.4304 | 15.4264 | 15.4304 | 44520.0 |
| 2013-06-17 07:53:00 | AAPL | Stock | 15.4357 | 15.4439 | 15.4357 | 15.4439 | 35700.0 |
| 2013-06-17 07:54:00 | AAPL | Stock | 15.4379 | 15.4379 | 15.4379 | 15.4379 | 2800.0 |
| 2013-06-17 07:57:00 | AAPL | Stock | 15.4446 | 15.4464 | 15.4436 | 15.4446 | 22120.0 |
| 2013-06-17 07:59:00 | AAPL | Stock | 15.4525 | 15.4536 | 15.4396 | 15.4396 | 16800.0 |
| 2013-06-17 08:00:00 | AAPL | Stock | 15.4421 | 15.4679 | 15.4179 | 15.4304 | 155792.0 |
| 2013-06-17 08:01:00 | AAPL | Stock | 15.4293 | 15.4293 | 15.4271 | 15.4286 | 28000.0 |
| 2013-06-17 08:02:00 | AAPL | Stock | 15.4339 | 15.4339 | 15.425 | 15.425 | 23912.0 |
> showing 50 of 1,028,561 rows — these rows as CSV