PREVIEW / stock_1min / 2013-11-12
file: by_date/stock_1min/2013/2013-11-12.parquet size: 13.7 MB rows: 1,008,126 symbols: 2,877
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-12 05:55:00 | AAPL | Stock | 18.4839 | 18.4839 | 18.4839 | 18.4839 | 2800.0 |
| 2013-11-12 05:56:00 | AAPL | Stock | 18.4821 | 18.4821 | 18.4821 | 18.4821 | 2800.0 |
| 2013-11-12 07:02:00 | AAPL | Stock | 18.4936 | 18.4936 | 18.4936 | 18.4936 | 12600.0 |
| 2013-11-12 07:12:00 | AAPL | Stock | 18.475 | 18.475 | 18.475 | 18.475 | 21560.0 |
| 2013-11-12 07:20:00 | AAPL | Stock | 18.4921 | 18.5 | 18.4921 | 18.5 | 39200.0 |
| 2013-11-12 07:21:00 | AAPL | Stock | 18.5 | 18.5089 | 18.5 | 18.5089 | 47600.0 |
| 2013-11-12 07:22:00 | AAPL | Stock | 18.5161 | 18.5161 | 18.5161 | 18.5161 | 5600.0 |
| 2013-11-12 07:24:00 | AAPL | Stock | 18.5089 | 18.5089 | 18.5089 | 18.5089 | 14000.0 |
| 2013-11-12 07:28:00 | AAPL | Stock | 18.5011 | 18.5011 | 18.5011 | 18.5011 | 8400.0 |
| 2013-11-12 07:30:00 | AAPL | Stock | 18.5025 | 18.5025 | 18.5018 | 18.5018 | 19600.0 |
| 2013-11-12 07:36:00 | AAPL | Stock | 18.5089 | 18.5089 | 18.5089 | 18.5089 | 8400.0 |
| 2013-11-12 07:39:00 | AAPL | Stock | 18.5129 | 18.5143 | 18.5129 | 18.5143 | 21000.0 |
| 2013-11-12 07:46:00 | AAPL | Stock | 18.5143 | 18.5143 | 18.5143 | 18.5143 | 2800.0 |
| 2013-11-12 07:50:00 | AAPL | Stock | 18.5204 | 18.5204 | 18.5204 | 18.5204 | 2800.0 |
| 2013-11-12 07:55:00 | AAPL | Stock | 18.5107 | 18.5107 | 18.5075 | 18.5075 | 39200.0 |
| 2013-11-12 07:58:00 | AAPL | Stock | 18.5021 | 18.5021 | 18.5018 | 18.5018 | 28000.0 |
| 2013-11-12 08:00:00 | AAPL | Stock | 18.4939 | 18.4939 | 18.4786 | 18.4786 | 21840.0 |
| 2013-11-12 08:01:00 | AAPL | Stock | 18.5018 | 18.5054 | 18.4961 | 18.4961 | 19320.0 |
| 2013-11-12 08:02:00 | AAPL | Stock | 18.5374 | 18.5374 | 18.505 | 18.505 | 1839600.0 |
| 2013-11-12 08:03:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 2940.0 |
| 2013-11-12 08:04:00 | AAPL | Stock | 18.5 | 18.5036 | 18.5 | 18.5004 | 14756.0 |
| 2013-11-12 08:06:00 | AAPL | Stock | 18.5089 | 18.5089 | 18.5089 | 18.5089 | 5600.0 |
| 2013-11-12 08:08:00 | AAPL | Stock | 18.5089 | 18.5139 | 18.5089 | 18.5139 | 6300.0 |
| 2013-11-12 08:09:00 | AAPL | Stock | 18.5107 | 18.5139 | 18.5107 | 18.5139 | 8624.0 |
| 2013-11-12 08:11:00 | AAPL | Stock | 18.5089 | 18.5089 | 18.5054 | 18.5054 | 22400.0 |
| 2013-11-12 08:12:00 | AAPL | Stock | 18.5004 | 18.5004 | 18.5 | 18.5 | 8400.0 |
| 2013-11-12 08:13:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 5880.0 |
| 2013-11-12 08:14:00 | AAPL | Stock | 18.4943 | 18.4943 | 18.49 | 18.4929 | 15400.0 |
| 2013-11-12 08:15:00 | AAPL | Stock | 18.4911 | 18.4929 | 18.4843 | 18.4843 | 119840.0 |
| 2013-11-12 08:16:00 | AAPL | Stock | 18.4961 | 18.4982 | 18.4961 | 18.4982 | 25200.0 |
| 2013-11-12 08:18:00 | AAPL | Stock | 18.4993 | 18.5 | 18.4989 | 18.5 | 30156.0 |
| 2013-11-12 08:19:00 | AAPL | Stock | 18.4964 | 18.5 | 18.4964 | 18.4979 | 65492.0 |
| 2013-11-12 08:20:00 | AAPL | Stock | 18.4979 | 18.4979 | 18.4979 | 18.4979 | 2800.0 |
| 2013-11-12 08:21:00 | AAPL | Stock | 18.4979 | 18.4979 | 18.4979 | 18.4979 | 2800.0 |
| 2013-11-12 08:22:00 | AAPL | Stock | 18.4979 | 18.4979 | 18.4979 | 18.4979 | 28000.0 |
| 2013-11-12 08:28:00 | AAPL | Stock | 18.5071 | 18.5157 | 18.5071 | 18.5157 | 9800.0 |
| 2013-11-12 08:29:00 | AAPL | Stock | 18.5036 | 18.5036 | 18.5 | 18.5 | 17360.0 |
| 2013-11-12 08:30:00 | AAPL | Stock | 18.5036 | 18.5036 | 18.5 | 18.5036 | 16800.0 |
| 2013-11-12 08:35:00 | AAPL | Stock | 18.4979 | 18.4979 | 18.4979 | 18.4979 | 2800.0 |
| 2013-11-12 08:36:00 | AAPL | Stock | 18.4964 | 18.4964 | 18.4964 | 18.4964 | 6440.0 |
| 2013-11-12 08:38:00 | AAPL | Stock | 18.4957 | 18.4957 | 18.4957 | 18.4957 | 2800.0 |
| 2013-11-12 08:40:00 | AAPL | Stock | 18.5061 | 18.5107 | 18.5061 | 18.5107 | 26516.0 |
| 2013-11-12 08:41:00 | AAPL | Stock | 18.5104 | 18.5104 | 18.5104 | 18.5104 | 5600.0 |
| 2013-11-12 08:42:00 | AAPL | Stock | 18.5093 | 18.5093 | 18.5093 | 18.5093 | 5600.0 |
| 2013-11-12 08:43:00 | AAPL | Stock | 18.5 | 18.5004 | 18.5 | 18.5004 | 5600.0 |
| 2013-11-12 08:44:00 | AAPL | Stock | 18.5089 | 18.5089 | 18.5089 | 18.5089 | 11200.0 |
| 2013-11-12 08:48:00 | AAPL | Stock | 18.5025 | 18.5025 | 18.5007 | 18.5007 | 28308.0 |
| 2013-11-12 08:51:00 | AAPL | Stock | 18.5007 | 18.5007 | 18.5007 | 18.5007 | 2800.0 |
| 2013-11-12 08:52:00 | AAPL | Stock | 18.4964 | 18.4964 | 18.4964 | 18.4964 | 5600.0 |
| 2013-11-12 09:00:00 | AAPL | Stock | 18.5086 | 18.5125 | 18.5071 | 18.5071 | 47600.0 |
> showing 50 of 1,008,126 rows — these rows as CSV