PREVIEW / stock_1min / 2013-11-20
file: by_date/stock_1min/2013/2013-11-20.parquet size: 13.8 MB rows: 1,005,504 symbols: 2,882
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-11-20 05:23:00 | AAPL | Stock | 18.5579 | 18.5579 | 18.5579 | 18.5579 | 2800.0 |
| 2013-11-20 06:12:00 | AAPL | Stock | 18.525 | 18.525 | 18.525 | 18.525 | 2800.0 |
| 2013-11-20 06:57:00 | AAPL | Stock | 18.5321 | 18.5321 | 18.5321 | 18.5321 | 2800.0 |
| 2013-11-20 07:05:00 | AAPL | Stock | 18.5321 | 18.5321 | 18.5321 | 18.5321 | 2800.0 |
| 2013-11-20 07:06:00 | AAPL | Stock | 18.5321 | 18.5321 | 18.5321 | 18.5321 | 2800.0 |
| 2013-11-20 07:08:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 3920.0 |
| 2013-11-20 07:38:00 | AAPL | Stock | 18.5364 | 18.5364 | 18.5364 | 18.5364 | 2800.0 |
| 2013-11-20 07:52:00 | AAPL | Stock | 18.5375 | 18.5375 | 18.505 | 18.505 | 49952.0 |
| 2013-11-20 07:57:00 | AAPL | Stock | 18.5321 | 18.5321 | 18.5321 | 18.5321 | 5600.0 |
| 2013-11-20 07:59:00 | AAPL | Stock | 18.5254 | 18.5321 | 18.5182 | 18.5182 | 35420.0 |
| 2013-11-20 08:00:00 | AAPL | Stock | 18.5336 | 18.5339 | 18.5189 | 18.5232 | 16996.0 |
| 2013-11-20 08:01:00 | AAPL | Stock | 18.5336 | 18.5357 | 18.5336 | 18.5357 | 27664.0 |
| 2013-11-20 08:02:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 8400.0 |
| 2013-11-20 08:03:00 | AAPL | Stock | 18.5446 | 18.5446 | 18.5446 | 18.5446 | 2800.0 |
| 2013-11-20 08:08:00 | AAPL | Stock | 18.5439 | 18.5536 | 18.5439 | 18.5536 | 22400.0 |
| 2013-11-20 08:09:00 | AAPL | Stock | 18.5596 | 18.5596 | 18.5596 | 18.5596 | 5600.0 |
| 2013-11-20 08:10:00 | AAPL | Stock | 18.5636 | 18.5636 | 18.5636 | 18.5636 | 6608.0 |
| 2013-11-20 08:12:00 | AAPL | Stock | 18.5536 | 18.5557 | 18.5536 | 18.5536 | 32340.0 |
| 2013-11-20 08:13:00 | AAPL | Stock | 18.5557 | 18.5571 | 18.5214 | 18.5214 | 76720.0 |
| 2013-11-20 08:17:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 5600.0 |
| 2013-11-20 08:21:00 | AAPL | Stock | 18.5529 | 18.5536 | 18.5529 | 18.5532 | 9800.0 |
| 2013-11-20 08:22:00 | AAPL | Stock | 18.5536 | 18.5536 | 18.5536 | 18.5536 | 2800.0 |
| 2013-11-20 08:26:00 | AAPL | Stock | 18.5632 | 18.5643 | 18.5632 | 18.5643 | 8400.0 |
| 2013-11-20 08:27:00 | AAPL | Stock | 18.5632 | 18.5632 | 18.5632 | 18.5632 | 6020.0 |
| 2013-11-20 08:29:00 | AAPL | Stock | 18.5607 | 18.5611 | 18.5536 | 18.5536 | 8400.0 |
| 2013-11-20 08:32:00 | AAPL | Stock | 18.5607 | 18.5607 | 18.5607 | 18.5607 | 2800.0 |
| 2013-11-20 08:33:00 | AAPL | Stock | 18.5607 | 18.5607 | 18.5607 | 18.5607 | 2800.0 |
| 2013-11-20 08:36:00 | AAPL | Stock | 18.5604 | 18.5607 | 18.5604 | 18.5607 | 8400.0 |
| 2013-11-20 08:38:00 | AAPL | Stock | 18.5671 | 18.5714 | 18.5671 | 18.5714 | 36400.0 |
| 2013-11-20 08:40:00 | AAPL | Stock | 18.5818 | 18.5818 | 18.5818 | 18.5818 | 5600.0 |
| 2013-11-20 08:41:00 | AAPL | Stock | 18.5818 | 18.5821 | 18.5818 | 18.5821 | 5600.0 |
| 2013-11-20 08:42:00 | AAPL | Stock | 18.58 | 18.58 | 18.5739 | 18.5739 | 5600.0 |
| 2013-11-20 08:43:00 | AAPL | Stock | 18.5714 | 18.5718 | 18.5714 | 18.5718 | 9604.0 |
| 2013-11-20 08:44:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5696 | 18.5696 | 5936.0 |
| 2013-11-20 08:47:00 | AAPL | Stock | 18.565 | 18.565 | 18.5625 | 18.5625 | 22400.0 |
| 2013-11-20 08:55:00 | AAPL | Stock | 18.5632 | 18.5632 | 18.5632 | 18.5632 | 5600.0 |
| 2013-11-20 08:57:00 | AAPL | Stock | 18.5679 | 18.5679 | 18.5679 | 18.5679 | 2800.0 |
| 2013-11-20 08:58:00 | AAPL | Stock | 18.5625 | 18.5625 | 18.5625 | 18.5625 | 3500.0 |
| 2013-11-20 09:00:00 | AAPL | Stock | 18.5625 | 18.5625 | 18.5621 | 18.5625 | 11200.0 |
| 2013-11-20 09:02:00 | AAPL | Stock | 18.565 | 18.565 | 18.5614 | 18.5614 | 54124.0 |
| 2013-11-20 09:03:00 | AAPL | Stock | 18.5696 | 18.5696 | 18.5696 | 18.5696 | 8400.0 |
| 2013-11-20 09:07:00 | AAPL | Stock | 18.5696 | 18.5696 | 18.5696 | 18.5696 | 13944.0 |
| 2013-11-20 09:10:00 | AAPL | Stock | 18.5786 | 18.5786 | 18.5764 | 18.5786 | 40908.0 |
| 2013-11-20 09:11:00 | AAPL | Stock | 18.5786 | 18.5786 | 18.5786 | 18.5786 | 7000.0 |
| 2013-11-20 09:12:00 | AAPL | Stock | 18.5786 | 18.5786 | 18.5786 | 18.5786 | 25200.0 |
| 2013-11-20 09:13:00 | AAPL | Stock | 18.5736 | 18.5736 | 18.5736 | 18.5736 | 2800.0 |
| 2013-11-20 09:14:00 | AAPL | Stock | 18.5714 | 18.5718 | 18.5714 | 18.5714 | 44240.0 |
| 2013-11-20 09:15:00 | AAPL | Stock | 18.5657 | 18.5657 | 18.5643 | 18.5643 | 25200.0 |
| 2013-11-20 09:16:00 | AAPL | Stock | 18.5611 | 18.5611 | 18.5611 | 18.5611 | 2800.0 |
| 2013-11-20 09:17:00 | AAPL | Stock | 18.5568 | 18.5607 | 18.5554 | 18.5607 | 25928.0 |
> showing 50 of 1,005,504 rows — these rows as CSV