PREVIEW / stock_1min / 2012-06-07
file: by_date/stock_1min/2012/2012-06-07.parquet size: 12.9 MB rows: 966,526 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 |
|---|---|---|---|---|---|---|---|
| 2012-06-07 04:07:00 | AAPL | Stock | 20.445 | 20.445 | 20.445 | 20.445 | 2800.0 |
| 2012-06-07 04:09:00 | AAPL | Stock | 20.445 | 20.445 | 20.445 | 20.445 | 2800.0 |
| 2012-06-07 04:13:00 | AAPL | Stock | 20.4286 | 20.4286 | 20.4286 | 20.4286 | 2800.0 |
| 2012-06-07 05:25:00 | AAPL | Stock | 20.4857 | 20.4857 | 20.4857 | 20.4857 | 2800.0 |
| 2012-06-07 05:40:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 2800.0 |
| 2012-06-07 05:41:00 | AAPL | Stock | 20.4661 | 20.4661 | 20.4661 | 20.4661 | 11200.0 |
| 2012-06-07 05:47:00 | AAPL | Stock | 20.4925 | 20.4925 | 20.4925 | 20.4925 | 2800.0 |
| 2012-06-07 05:50:00 | AAPL | Stock | 20.4946 | 20.4946 | 20.4946 | 20.4946 | 2800.0 |
| 2012-06-07 05:58:00 | AAPL | Stock | 20.5157 | 20.5157 | 20.5157 | 20.5157 | 2800.0 |
| 2012-06-07 06:13:00 | AAPL | Stock | 20.475 | 20.475 | 20.475 | 20.475 | 2800.0 |
| 2012-06-07 06:15:00 | AAPL | Stock | 20.475 | 20.475 | 20.475 | 20.475 | 2800.0 |
| 2012-06-07 06:41:00 | AAPL | Stock | 20.4682 | 20.4682 | 20.4682 | 20.4682 | 2800.0 |
| 2012-06-07 06:44:00 | AAPL | Stock | 20.4646 | 20.4646 | 20.4646 | 20.4646 | 2800.0 |
| 2012-06-07 06:59:00 | AAPL | Stock | 20.4643 | 20.4786 | 20.4643 | 20.4786 | 7000.0 |
| 2012-06-07 07:00:00 | AAPL | Stock | 20.4821 | 20.5179 | 20.4736 | 20.5046 | 75600.0 |
| 2012-06-07 07:01:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5179 | 20.5179 | 2800.0 |
| 2012-06-07 07:02:00 | AAPL | Stock | 20.5161 | 20.535 | 20.5161 | 20.535 | 8400.0 |
| 2012-06-07 07:03:00 | AAPL | Stock | 20.4904 | 20.4904 | 20.4846 | 20.4846 | 16800.0 |
| 2012-06-07 07:04:00 | AAPL | Stock | 20.5004 | 20.5125 | 20.5004 | 20.5089 | 18200.0 |
| 2012-06-07 07:05:00 | AAPL | Stock | 20.5093 | 20.5125 | 20.5089 | 20.5089 | 29400.0 |
| 2012-06-07 07:06:00 | AAPL | Stock | 20.5264 | 20.5625 | 20.5264 | 20.5621 | 112224.0 |
| 2012-06-07 07:07:00 | AAPL | Stock | 20.5411 | 20.5579 | 20.5393 | 20.5396 | 19600.0 |
| 2012-06-07 07:08:00 | AAPL | Stock | 20.5375 | 20.5375 | 20.5375 | 20.5375 | 5600.0 |
| 2012-06-07 07:10:00 | AAPL | Stock | 20.5493 | 20.5493 | 20.5493 | 20.5493 | 5040.0 |
| 2012-06-07 07:11:00 | AAPL | Stock | 20.5357 | 20.5536 | 20.5357 | 20.5529 | 14000.0 |
| 2012-06-07 07:12:00 | AAPL | Stock | 20.5361 | 20.5361 | 20.5357 | 20.5357 | 25900.0 |
| 2012-06-07 07:13:00 | AAPL | Stock | 20.5475 | 20.5475 | 20.5475 | 20.5475 | 9800.0 |
| 2012-06-07 07:14:00 | AAPL | Stock | 20.545 | 20.545 | 20.5382 | 20.5382 | 17500.0 |
| 2012-06-07 07:17:00 | AAPL | Stock | 20.5529 | 20.5529 | 20.5529 | 20.5529 | 2800.0 |
| 2012-06-07 07:22:00 | AAPL | Stock | 20.5496 | 20.5496 | 20.5496 | 20.5496 | 2800.0 |
| 2012-06-07 07:24:00 | AAPL | Stock | 20.56 | 20.5604 | 20.5475 | 20.555 | 54852.0 |
| 2012-06-07 07:25:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.5536 | 20.5536 | 2800.0 |
| 2012-06-07 07:27:00 | AAPL | Stock | 20.5489 | 20.5489 | 20.5489 | 20.5489 | 2800.0 |
| 2012-06-07 07:28:00 | AAPL | Stock | 20.5536 | 20.5568 | 20.5536 | 20.5568 | 12796.0 |
| 2012-06-07 07:29:00 | AAPL | Stock | 20.5582 | 20.5593 | 20.5582 | 20.5586 | 16240.0 |
| 2012-06-07 07:30:00 | AAPL | Stock | 20.5589 | 20.5589 | 20.5589 | 20.5589 | 8400.0 |
| 2012-06-07 07:31:00 | AAPL | Stock | 20.5579 | 20.5714 | 20.5579 | 20.5714 | 40292.0 |
| 2012-06-07 07:33:00 | AAPL | Stock | 20.5764 | 20.5786 | 20.5764 | 20.5786 | 5600.0 |
| 2012-06-07 07:34:00 | AAPL | Stock | 20.575 | 20.575 | 20.575 | 20.575 | 2800.0 |
| 2012-06-07 07:36:00 | AAPL | Stock | 20.5714 | 20.5714 | 20.5604 | 20.5607 | 25200.0 |
| 2012-06-07 07:39:00 | AAPL | Stock | 20.5664 | 20.5686 | 20.5664 | 20.5686 | 28000.0 |
| 2012-06-07 07:40:00 | AAPL | Stock | 20.5743 | 20.5743 | 20.5679 | 20.5679 | 8400.0 |
| 2012-06-07 07:41:00 | AAPL | Stock | 20.5707 | 20.5707 | 20.5593 | 20.5593 | 8400.0 |
| 2012-06-07 07:43:00 | AAPL | Stock | 20.5589 | 20.5589 | 20.5543 | 20.5543 | 11200.0 |
| 2012-06-07 07:44:00 | AAPL | Stock | 20.5571 | 20.5571 | 20.5571 | 20.5571 | 2800.0 |
| 2012-06-07 07:45:00 | AAPL | Stock | 20.5561 | 20.5561 | 20.5561 | 20.5561 | 2800.0 |
| 2012-06-07 07:48:00 | AAPL | Stock | 20.5714 | 20.5743 | 20.5686 | 20.5743 | 50400.0 |
| 2012-06-07 07:49:00 | AAPL | Stock | 20.5804 | 20.5839 | 20.5804 | 20.5839 | 22316.0 |
| 2012-06-07 07:50:00 | AAPL | Stock | 20.5836 | 20.5911 | 20.5836 | 20.5911 | 64876.0 |
| 2012-06-07 07:51:00 | AAPL | Stock | 20.5946 | 20.5946 | 20.5946 | 20.5946 | 2800.0 |
> showing 50 of 966,526 rows — these rows as CSV