PREVIEW / stock_1min / 2013-06-11
file: by_date/stock_1min/2013/2013-06-11.parquet size: 13.5 MB rows: 1,000,445 symbols: 2,825
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-11 04:01:00 | AAPL | Stock | 15.6764 | 15.6764 | 15.6764 | 15.6764 | 4200.0 |
| 2013-06-11 04:02:00 | AAPL | Stock | 15.6764 | 15.6764 | 15.6764 | 15.6764 | 4200.0 |
| 2013-06-11 06:02:00 | AAPL | Stock | 15.6036 | 15.6036 | 15.6036 | 15.6036 | 2800.0 |
| 2013-06-11 06:10:00 | AAPL | Stock | 15.6032 | 15.6032 | 15.6032 | 15.6032 | 2800.0 |
| 2013-06-11 06:43:00 | AAPL | Stock | 15.5821 | 15.5821 | 15.5714 | 15.5714 | 19600.0 |
| 2013-06-11 06:45:00 | AAPL | Stock | 15.5607 | 15.5607 | 15.5607 | 15.5607 | 2800.0 |
| 2013-06-11 06:46:00 | AAPL | Stock | 15.5607 | 15.5607 | 15.5607 | 15.5607 | 2800.0 |
| 2013-06-11 06:47:00 | AAPL | Stock | 15.5489 | 15.5489 | 15.5429 | 15.5429 | 22400.0 |
| 2013-06-11 06:48:00 | AAPL | Stock | 15.5361 | 15.5382 | 15.5354 | 15.5354 | 24920.0 |
| 2013-06-11 06:50:00 | AAPL | Stock | 15.5339 | 15.5339 | 15.5339 | 15.5339 | 2800.0 |
| 2013-06-11 06:56:00 | AAPL | Stock | 15.5464 | 15.5464 | 15.5464 | 15.5464 | 2800.0 |
| 2013-06-11 06:57:00 | AAPL | Stock | 15.5429 | 15.5429 | 15.5429 | 15.5429 | 5600.0 |
| 2013-06-11 07:01:00 | AAPL | Stock | 15.5371 | 15.5371 | 15.5371 | 15.5371 | 2800.0 |
| 2013-06-11 07:02:00 | AAPL | Stock | 15.5446 | 15.5446 | 15.5371 | 15.5371 | 15540.0 |
| 2013-06-11 07:04:00 | AAPL | Stock | 15.5489 | 15.5532 | 15.5489 | 15.5532 | 14000.0 |
| 2013-06-11 07:05:00 | AAPL | Stock | 15.5625 | 15.5625 | 15.5625 | 15.5625 | 2800.0 |
| 2013-06-11 07:10:00 | AAPL | Stock | 15.555 | 15.555 | 15.555 | 15.555 | 2800.0 |
| 2013-06-11 07:11:00 | AAPL | Stock | 15.5529 | 15.5554 | 15.5529 | 15.5554 | 5600.0 |
| 2013-06-11 07:16:00 | AAPL | Stock | 15.5489 | 15.5489 | 15.5489 | 15.5489 | 8400.0 |
| 2013-06-11 07:17:00 | AAPL | Stock | 15.5489 | 15.5493 | 15.5489 | 15.5493 | 5600.0 |
| 2013-06-11 07:18:00 | AAPL | Stock | 15.5454 | 15.5454 | 15.5411 | 15.5411 | 30800.0 |
| 2013-06-11 07:19:00 | AAPL | Stock | 15.5357 | 15.5357 | 15.5357 | 15.5357 | 13020.0 |
| 2013-06-11 07:20:00 | AAPL | Stock | 15.5321 | 15.5321 | 15.525 | 15.525 | 28840.0 |
| 2013-06-11 07:23:00 | AAPL | Stock | 15.525 | 15.5268 | 15.525 | 15.5261 | 17080.0 |
| 2013-06-11 07:24:00 | AAPL | Stock | 15.525 | 15.525 | 15.525 | 15.525 | 11200.0 |
| 2013-06-11 07:26:00 | AAPL | Stock | 15.5339 | 15.5339 | 15.5339 | 15.5339 | 2800.0 |
| 2013-06-11 07:30:00 | AAPL | Stock | 15.5496 | 15.5496 | 15.5489 | 15.5489 | 5600.0 |
| 2013-06-11 07:31:00 | AAPL | Stock | 15.5489 | 15.5489 | 15.5489 | 15.5489 | 2800.0 |
| 2013-06-11 07:33:00 | AAPL | Stock | 15.5464 | 15.5464 | 15.5464 | 15.5464 | 11200.0 |
| 2013-06-11 07:34:00 | AAPL | Stock | 15.5382 | 15.5382 | 15.5382 | 15.5382 | 5600.0 |
| 2013-06-11 07:35:00 | AAPL | Stock | 15.5375 | 15.5375 | 15.5375 | 15.5375 | 5600.0 |
| 2013-06-11 07:36:00 | AAPL | Stock | 15.5375 | 15.5375 | 15.5375 | 15.5375 | 2800.0 |
| 2013-06-11 07:37:00 | AAPL | Stock | 15.5536 | 15.5607 | 15.5536 | 15.5607 | 5600.0 |
| 2013-06-11 07:38:00 | AAPL | Stock | 15.5607 | 15.5618 | 15.5607 | 15.5618 | 5600.0 |
| 2013-06-11 07:39:00 | AAPL | Stock | 15.5618 | 15.5618 | 15.5618 | 15.5618 | 8680.0 |
| 2013-06-11 07:40:00 | AAPL | Stock | 15.5604 | 15.5611 | 15.5604 | 15.5611 | 8008.0 |
| 2013-06-11 07:41:00 | AAPL | Stock | 15.5536 | 15.5536 | 15.5536 | 15.5536 | 2800.0 |
| 2013-06-11 07:42:00 | AAPL | Stock | 15.5571 | 15.5571 | 15.5571 | 15.5571 | 2800.0 |
| 2013-06-11 07:48:00 | AAPL | Stock | 15.5604 | 15.5604 | 15.5604 | 15.5604 | 2800.0 |
| 2013-06-11 07:51:00 | AAPL | Stock | 15.5614 | 15.5714 | 15.5614 | 15.5714 | 24808.0 |
| 2013-06-11 07:53:00 | AAPL | Stock | 15.5714 | 15.5786 | 15.5714 | 15.5786 | 11200.0 |
| 2013-06-11 07:54:00 | AAPL | Stock | 15.5779 | 15.5786 | 15.5779 | 15.5786 | 5600.0 |
| 2013-06-11 07:55:00 | AAPL | Stock | 15.5718 | 15.5718 | 15.5714 | 15.5714 | 5600.0 |
| 2013-06-11 07:56:00 | AAPL | Stock | 15.5707 | 15.5764 | 15.5707 | 15.5764 | 19740.0 |
| 2013-06-11 07:57:00 | AAPL | Stock | 15.5714 | 15.5714 | 15.5714 | 15.5714 | 11200.0 |
| 2013-06-11 07:58:00 | AAPL | Stock | 15.5679 | 15.5679 | 15.5679 | 15.5679 | 2800.0 |
| 2013-06-11 07:59:00 | AAPL | Stock | 15.5718 | 15.5764 | 15.5718 | 15.5764 | 9520.0 |
| 2013-06-11 08:00:00 | AAPL | Stock | 15.5714 | 15.5893 | 15.5189 | 15.5893 | 183148.0 |
| 2013-06-11 08:01:00 | AAPL | Stock | 15.6036 | 15.6036 | 15.6036 | 15.6036 | 2800.0 |
| 2013-06-11 08:02:00 | AAPL | Stock | 15.5757 | 15.5779 | 15.5757 | 15.5779 | 14700.0 |
> showing 50 of 1,000,445 rows — these rows as CSV