PREVIEW / stock_1min / 2013-11-19
file: by_date/stock_1min/2013/2013-11-19.parquet size: 14.0 MB rows: 1,017,914 symbols: 2,874
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-19 05:56:00 | AAPL | Stock | 18.5114 | 18.5114 | 18.5107 | 18.5107 | 5600.0 |
| 2013-11-19 07:02:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5107 | 18.5107 | 2800.0 |
| 2013-11-19 07:08:00 | AAPL | Stock | 18.5268 | 18.5268 | 18.5268 | 18.5268 | 44800.0 |
| 2013-11-19 07:30:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5036 | 18.5036 | 22400.0 |
| 2013-11-19 07:31:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 4060.0 |
| 2013-11-19 07:39:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5107 | 18.5107 | 11200.0 |
| 2013-11-19 07:44:00 | AAPL | Stock | 18.5179 | 18.5179 | 18.5179 | 18.5179 | 2800.0 |
| 2013-11-19 07:46:00 | AAPL | Stock | 18.5211 | 18.5214 | 18.5211 | 18.5214 | 28000.0 |
| 2013-11-19 07:50:00 | AAPL | Stock | 18.5179 | 18.5179 | 18.5179 | 18.5179 | 2800.0 |
| 2013-11-19 07:52:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5089 | 18.5089 | 14000.0 |
| 2013-11-19 08:00:00 | AAPL | Stock | 18.5196 | 18.5268 | 18.5089 | 18.5268 | 55860.0 |
| 2013-11-19 08:01:00 | AAPL | Stock | 18.5339 | 18.5436 | 18.5082 | 18.5082 | 84112.0 |
| 2013-11-19 08:07:00 | AAPL | Stock | 18.5446 | 18.5446 | 18.5446 | 18.5446 | 3080.0 |
| 2013-11-19 08:10:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5357 | 18.5357 | 2800.0 |
| 2013-11-19 08:13:00 | AAPL | Stock | 18.5275 | 18.5275 | 18.5275 | 18.5275 | 2800.0 |
| 2013-11-19 08:14:00 | AAPL | Stock | 18.5275 | 18.5275 | 18.5275 | 18.5275 | 8400.0 |
| 2013-11-19 08:15:00 | AAPL | Stock | 18.5279 | 18.5375 | 18.5275 | 18.5375 | 28056.0 |
| 2013-11-19 08:19:00 | AAPL | Stock | 18.5536 | 18.5539 | 18.5525 | 18.5536 | 48720.0 |
| 2013-11-19 08:20:00 | AAPL | Stock | 18.5571 | 18.5571 | 18.5571 | 18.5571 | 2800.0 |
| 2013-11-19 08:23:00 | AAPL | Stock | 18.5618 | 18.5618 | 18.5571 | 18.5571 | 8400.0 |
| 2013-11-19 08:24:00 | AAPL | Stock | 18.5589 | 18.5589 | 18.5589 | 18.5589 | 2800.0 |
| 2013-11-19 08:27:00 | AAPL | Stock | 18.5625 | 18.5625 | 18.5593 | 18.5593 | 11228.0 |
| 2013-11-19 08:28:00 | AAPL | Stock | 18.5646 | 18.5664 | 18.5593 | 18.5593 | 16800.0 |
| 2013-11-19 08:29:00 | AAPL | Stock | 18.5589 | 18.5643 | 18.5589 | 18.5643 | 43400.0 |
| 2013-11-19 08:31:00 | AAPL | Stock | 18.5625 | 18.575 | 18.5625 | 18.575 | 150276.0 |
| 2013-11-19 08:32:00 | AAPL | Stock | 18.5746 | 18.5746 | 18.5704 | 18.5714 | 26600.0 |
| 2013-11-19 08:33:00 | AAPL | Stock | 18.5707 | 18.5707 | 18.5696 | 18.5696 | 5600.0 |
| 2013-11-19 08:34:00 | AAPL | Stock | 18.5714 | 18.5889 | 18.5714 | 18.5889 | 29400.0 |
| 2013-11-19 08:35:00 | AAPL | Stock | 18.5889 | 18.5929 | 18.5846 | 18.585 | 33600.0 |
| 2013-11-19 08:37:00 | AAPL | Stock | 18.6 | 18.6 | 18.6 | 18.6 | 2800.0 |
| 2013-11-19 08:38:00 | AAPL | Stock | 18.5854 | 18.5893 | 18.5786 | 18.5786 | 25228.0 |
| 2013-11-19 08:39:00 | AAPL | Stock | 18.5786 | 18.5786 | 18.5786 | 18.5786 | 5600.0 |
| 2013-11-19 08:40:00 | AAPL | Stock | 18.5779 | 18.5786 | 18.5779 | 18.5786 | 10696.0 |
| 2013-11-19 08:43:00 | AAPL | Stock | 18.5739 | 18.5739 | 18.5725 | 18.5725 | 5600.0 |
| 2013-11-19 08:44:00 | AAPL | Stock | 18.5721 | 18.5721 | 18.5721 | 18.5721 | 2800.0 |
| 2013-11-19 08:47:00 | AAPL | Stock | 18.5786 | 18.5786 | 18.5786 | 18.5786 | 2800.0 |
| 2013-11-19 08:49:00 | AAPL | Stock | 18.575 | 18.575 | 18.5714 | 18.5714 | 96600.0 |
| 2013-11-19 08:52:00 | AAPL | Stock | 18.5636 | 18.5696 | 18.5629 | 18.5696 | 11200.0 |
| 2013-11-19 08:53:00 | AAPL | Stock | 18.5625 | 18.5625 | 18.5625 | 18.5625 | 5600.0 |
| 2013-11-19 08:55:00 | AAPL | Stock | 18.5589 | 18.5589 | 18.5557 | 18.5557 | 8540.0 |
| 2013-11-19 08:56:00 | AAPL | Stock | 18.5571 | 18.5571 | 18.5571 | 18.5571 | 2800.0 |
| 2013-11-19 08:58:00 | AAPL | Stock | 18.5561 | 18.5571 | 18.5561 | 18.5571 | 11200.0 |
| 2013-11-19 09:00:00 | AAPL | Stock | 18.5671 | 18.5671 | 18.5671 | 18.5671 | 5600.0 |
| 2013-11-19 09:01:00 | AAPL | Stock | 18.5661 | 18.5661 | 18.5571 | 18.5571 | 11200.0 |
| 2013-11-19 09:03:00 | AAPL | Stock | 18.5682 | 18.5682 | 18.5682 | 18.5682 | 2800.0 |
| 2013-11-19 09:04:00 | AAPL | Stock | 18.5693 | 18.5693 | 18.5693 | 18.5693 | 2800.0 |
| 2013-11-19 09:05:00 | AAPL | Stock | 18.5654 | 18.5654 | 18.5654 | 18.5654 | 3500.0 |
| 2013-11-19 09:06:00 | AAPL | Stock | 18.57 | 18.5714 | 18.57 | 18.5711 | 27300.0 |
| 2013-11-19 09:07:00 | AAPL | Stock | 18.5771 | 18.5832 | 18.5768 | 18.5832 | 78960.0 |
| 2013-11-19 09:09:00 | AAPL | Stock | 18.5811 | 18.5811 | 18.5786 | 18.5786 | 10640.0 |
> showing 50 of 1,017,914 rows — these rows as CSV