PREVIEW / stock_1min / 2014-05-21
file: by_date/stock_1min/2014/2014-05-21.parquet size: 13.8 MB rows: 1,027,717 symbols: 2,873
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-21 04:02:00 | AAPL | Stock | 21.5893 | 21.5893 | 21.5889 | 21.5889 | 11200.0 |
| 2014-05-21 05:15:00 | AAPL | Stock | 21.6 | 21.6 | 21.6 | 21.6 | 2800.0 |
| 2014-05-21 05:34:00 | AAPL | Stock | 21.6286 | 21.6286 | 21.6286 | 21.6286 | 2800.0 |
| 2014-05-21 07:04:00 | AAPL | Stock | 21.5821 | 21.5821 | 21.5786 | 21.5786 | 12236.0 |
| 2014-05-21 07:05:00 | AAPL | Stock | 21.5771 | 21.5771 | 21.575 | 21.575 | 19600.0 |
| 2014-05-21 07:06:00 | AAPL | Stock | 21.6054 | 21.6071 | 21.6054 | 21.6071 | 12460.0 |
| 2014-05-21 07:12:00 | AAPL | Stock | 21.5893 | 21.5893 | 21.5804 | 21.5821 | 25200.0 |
| 2014-05-21 07:17:00 | AAPL | Stock | 21.5964 | 21.5964 | 21.5857 | 21.5857 | 16800.0 |
| 2014-05-21 07:22:00 | AAPL | Stock | 21.5882 | 21.5893 | 21.5882 | 21.5893 | 26880.0 |
| 2014-05-21 07:29:00 | AAPL | Stock | 21.5982 | 21.5982 | 21.5982 | 21.5982 | 8400.0 |
| 2014-05-21 07:48:00 | AAPL | Stock | 21.6071 | 21.6071 | 21.6071 | 21.6071 | 8400.0 |
| 2014-05-21 07:53:00 | AAPL | Stock | 21.6139 | 21.6139 | 21.6139 | 21.6139 | 5600.0 |
| 2014-05-21 07:56:00 | AAPL | Stock | 21.6171 | 21.6179 | 21.6171 | 21.6179 | 5600.0 |
| 2014-05-21 07:57:00 | AAPL | Stock | 21.6171 | 21.6171 | 21.6171 | 21.6171 | 18900.0 |
| 2014-05-21 07:58:00 | AAPL | Stock | 21.6107 | 21.6107 | 21.6107 | 21.6107 | 5600.0 |
| 2014-05-21 07:59:00 | AAPL | Stock | 21.6107 | 21.6107 | 21.6107 | 21.6107 | 2800.0 |
| 2014-05-21 08:00:00 | AAPL | Stock | 21.5986 | 21.6186 | 21.5786 | 21.5893 | 88200.0 |
| 2014-05-21 08:02:00 | AAPL | Stock | 21.5839 | 21.5839 | 21.5825 | 21.5825 | 16800.0 |
| 2014-05-21 08:03:00 | AAPL | Stock | 21.5839 | 21.5839 | 21.5736 | 21.5771 | 86464.0 |
| 2014-05-21 08:04:00 | AAPL | Stock | 21.5736 | 21.5757 | 21.5539 | 21.5539 | 44744.0 |
| 2014-05-21 08:05:00 | AAPL | Stock | 21.5514 | 21.5739 | 21.5468 | 21.5739 | 23800.0 |
| 2014-05-21 08:06:00 | AAPL | Stock | 21.5746 | 21.5746 | 21.5746 | 21.5746 | 19572.0 |
| 2014-05-21 08:07:00 | AAPL | Stock | 21.5879 | 21.5879 | 21.5879 | 21.5879 | 2800.0 |
| 2014-05-21 08:08:00 | AAPL | Stock | 21.5714 | 21.5861 | 21.5714 | 21.5861 | 5600.0 |
| 2014-05-21 08:11:00 | AAPL | Stock | 21.5732 | 21.5732 | 21.5732 | 21.5732 | 11200.0 |
| 2014-05-21 08:12:00 | AAPL | Stock | 21.5768 | 21.5768 | 21.5768 | 21.5768 | 30800.0 |
| 2014-05-21 08:15:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5714 | 21.5714 | 2800.0 |
| 2014-05-21 08:16:00 | AAPL | Stock | 21.5804 | 21.5804 | 21.5804 | 21.5804 | 2800.0 |
| 2014-05-21 08:17:00 | AAPL | Stock | 21.5804 | 21.5804 | 21.5804 | 21.5804 | 18200.0 |
| 2014-05-21 08:21:00 | AAPL | Stock | 21.5714 | 21.5786 | 21.5714 | 21.5786 | 27580.0 |
| 2014-05-21 08:22:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5714 | 21.5714 | 2800.0 |
| 2014-05-21 08:24:00 | AAPL | Stock | 21.5654 | 21.5664 | 21.5643 | 21.5643 | 26600.0 |
| 2014-05-21 08:26:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5714 | 21.5714 | 4900.0 |
| 2014-05-21 08:27:00 | AAPL | Stock | 21.5632 | 21.5714 | 21.5632 | 21.5714 | 33600.0 |
| 2014-05-21 08:28:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5632 | 21.5632 | 66164.0 |
| 2014-05-21 08:31:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5714 | 21.5714 | 4200.0 |
| 2014-05-21 08:33:00 | AAPL | Stock | 21.5711 | 21.5714 | 21.5711 | 21.5714 | 5600.0 |
| 2014-05-21 08:34:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5714 | 21.5714 | 8400.0 |
| 2014-05-21 08:41:00 | AAPL | Stock | 21.5625 | 21.5643 | 21.5614 | 21.5614 | 18200.0 |
| 2014-05-21 08:42:00 | AAPL | Stock | 21.5643 | 21.5668 | 21.5643 | 21.5668 | 30352.0 |
| 2014-05-21 08:43:00 | AAPL | Stock | 21.57 | 21.57 | 21.57 | 21.57 | 2800.0 |
| 2014-05-21 08:46:00 | AAPL | Stock | 21.5643 | 21.5643 | 21.5643 | 21.5643 | 2800.0 |
| 2014-05-21 08:47:00 | AAPL | Stock | 21.5704 | 21.5714 | 21.5704 | 21.5704 | 9212.0 |
| 2014-05-21 08:48:00 | AAPL | Stock | 21.5743 | 21.5893 | 21.5743 | 21.5893 | 35000.0 |
| 2014-05-21 08:49:00 | AAPL | Stock | 21.5871 | 21.5871 | 21.5871 | 21.5871 | 2800.0 |
| 2014-05-21 08:50:00 | AAPL | Stock | 21.5893 | 21.5939 | 21.5893 | 21.5907 | 22428.0 |
| 2014-05-21 08:51:00 | AAPL | Stock | 21.5975 | 21.5975 | 21.5975 | 21.5975 | 4200.0 |
| 2014-05-21 08:52:00 | AAPL | Stock | 21.59 | 21.5968 | 21.59 | 21.5968 | 14000.0 |
| 2014-05-21 08:54:00 | AAPL | Stock | 21.5846 | 21.5846 | 21.5846 | 21.5846 | 2800.0 |
| 2014-05-21 08:56:00 | AAPL | Stock | 21.5889 | 21.5893 | 21.5889 | 21.5893 | 8400.0 |
> showing 50 of 1,027,717 rows — these rows as CSV