PREVIEW / stock_1min / 2011-06-22
file: by_date/stock_1min/2011/2011-06-22.parquet size: 13.2 MB rows: 1,005,331 symbols: 2,870
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-22 06:09:00 | AAPL | Stock | 11.5939 | 11.5939 | 11.5939 | 11.5939 | 2800.0 |
| 2011-06-22 06:39:00 | AAPL | Stock | 11.6054 | 11.6054 | 11.6054 | 11.6054 | 2800.0 |
| 2011-06-22 06:55:00 | AAPL | Stock | 11.5825 | 11.5825 | 11.5825 | 11.5825 | 14000.0 |
| 2011-06-22 06:56:00 | AAPL | Stock | 11.5821 | 11.5821 | 11.5821 | 11.5821 | 14000.0 |
| 2011-06-22 07:01:00 | AAPL | Stock | 11.5825 | 11.5825 | 11.5804 | 11.5804 | 10780.0 |
| 2011-06-22 07:02:00 | AAPL | Stock | 11.5714 | 11.5714 | 11.57 | 11.5714 | 36456.0 |
| 2011-06-22 07:03:00 | AAPL | Stock | 11.5714 | 11.5714 | 11.5714 | 11.5714 | 14000.0 |
| 2011-06-22 07:04:00 | AAPL | Stock | 11.5714 | 11.5714 | 11.5714 | 11.5714 | 11200.0 |
| 2011-06-22 07:06:00 | AAPL | Stock | 11.5804 | 11.5814 | 11.5786 | 11.5786 | 19600.0 |
| 2011-06-22 07:08:00 | AAPL | Stock | 11.5782 | 11.5804 | 11.5754 | 11.5804 | 22400.0 |
| 2011-06-22 07:09:00 | AAPL | Stock | 11.5754 | 11.5754 | 11.5754 | 11.5754 | 27020.0 |
| 2011-06-22 07:13:00 | AAPL | Stock | 11.5771 | 11.5771 | 11.5771 | 11.5771 | 5600.0 |
| 2011-06-22 07:14:00 | AAPL | Stock | 11.5714 | 11.5714 | 11.5714 | 11.5714 | 8400.0 |
| 2011-06-22 07:19:00 | AAPL | Stock | 11.5571 | 11.5571 | 11.5571 | 11.5571 | 10080.0 |
| 2011-06-22 07:20:00 | AAPL | Stock | 11.5543 | 11.5543 | 11.5532 | 11.5536 | 22400.0 |
| 2011-06-22 07:27:00 | AAPL | Stock | 11.555 | 11.555 | 11.555 | 11.555 | 5600.0 |
| 2011-06-22 07:29:00 | AAPL | Stock | 11.5521 | 11.5521 | 11.5521 | 11.5521 | 12600.0 |
| 2011-06-22 07:30:00 | AAPL | Stock | 11.5607 | 11.5643 | 11.5607 | 11.5643 | 19600.0 |
| 2011-06-22 07:33:00 | AAPL | Stock | 11.5589 | 11.5589 | 11.5571 | 11.5571 | 8400.0 |
| 2011-06-22 07:35:00 | AAPL | Stock | 11.5571 | 11.5571 | 11.5554 | 11.5554 | 30800.0 |
| 2011-06-22 07:36:00 | AAPL | Stock | 11.5571 | 11.5571 | 11.5571 | 11.5571 | 2800.0 |
| 2011-06-22 07:41:00 | AAPL | Stock | 11.5675 | 11.5675 | 11.5675 | 11.5675 | 8400.0 |
| 2011-06-22 07:42:00 | AAPL | Stock | 11.5675 | 11.5675 | 11.5675 | 11.5675 | 8400.0 |
| 2011-06-22 07:43:00 | AAPL | Stock | 11.5661 | 11.5661 | 11.5661 | 11.5661 | 2800.0 |
| 2011-06-22 07:45:00 | AAPL | Stock | 11.5661 | 11.5661 | 11.5661 | 11.5661 | 22400.0 |
| 2011-06-22 07:46:00 | AAPL | Stock | 11.5661 | 11.5661 | 11.5661 | 11.5661 | 2800.0 |
| 2011-06-22 07:47:00 | AAPL | Stock | 11.5675 | 11.5796 | 11.5675 | 11.5786 | 28000.0 |
| 2011-06-22 07:48:00 | AAPL | Stock | 11.5843 | 11.5857 | 11.58 | 11.5857 | 90888.0 |
| 2011-06-22 07:49:00 | AAPL | Stock | 11.5843 | 11.5843 | 11.5843 | 11.5843 | 4088.0 |
| 2011-06-22 07:50:00 | AAPL | Stock | 11.5832 | 11.5857 | 11.5832 | 11.5857 | 67200.0 |
| 2011-06-22 07:51:00 | AAPL | Stock | 11.5893 | 11.6007 | 11.5893 | 11.6007 | 8400.0 |
| 2011-06-22 07:53:00 | AAPL | Stock | 11.5964 | 11.5964 | 11.5964 | 11.5964 | 16800.0 |
| 2011-06-22 07:54:00 | AAPL | Stock | 11.5929 | 11.5929 | 11.5929 | 11.5929 | 2800.0 |
| 2011-06-22 07:55:00 | AAPL | Stock | 11.5929 | 11.5929 | 11.5929 | 11.5929 | 2800.0 |
| 2011-06-22 07:56:00 | AAPL | Stock | 11.5957 | 11.5957 | 11.5957 | 11.5957 | 5600.0 |
| 2011-06-22 07:57:00 | AAPL | Stock | 11.5961 | 11.5961 | 11.5961 | 11.5961 | 14000.0 |
| 2011-06-22 07:58:00 | AAPL | Stock | 11.5964 | 11.5971 | 11.5964 | 11.5964 | 30800.0 |
| 2011-06-22 07:59:00 | AAPL | Stock | 11.6007 | 11.6007 | 11.6007 | 11.6007 | 2800.0 |
| 2011-06-22 08:00:00 | AAPL | Stock | 11.5968 | 11.5968 | 11.5836 | 11.59 | 62048.0 |
| 2011-06-22 08:01:00 | AAPL | Stock | 11.5971 | 11.5971 | 11.5893 | 11.5893 | 8400.0 |
| 2011-06-22 08:02:00 | AAPL | Stock | 11.5996 | 11.5996 | 11.5911 | 11.5964 | 36400.0 |
| 2011-06-22 08:03:00 | AAPL | Stock | 11.6007 | 11.6007 | 11.6007 | 11.6007 | 2800.0 |
| 2011-06-22 08:05:00 | AAPL | Stock | 11.6025 | 11.6054 | 11.6025 | 11.6054 | 15680.0 |
| 2011-06-22 08:06:00 | AAPL | Stock | 11.6061 | 11.6071 | 11.6061 | 11.6071 | 14000.0 |
| 2011-06-22 08:07:00 | AAPL | Stock | 11.6071 | 11.6111 | 11.6064 | 11.6071 | 57960.0 |
| 2011-06-22 08:08:00 | AAPL | Stock | 11.6079 | 11.6139 | 11.6079 | 11.6082 | 33880.0 |
| 2011-06-22 08:09:00 | AAPL | Stock | 11.6107 | 11.6143 | 11.6107 | 11.6125 | 23240.0 |
| 2011-06-22 08:10:00 | AAPL | Stock | 11.6143 | 11.6146 | 11.6075 | 11.6146 | 14000.0 |
| 2011-06-22 08:11:00 | AAPL | Stock | 11.6096 | 11.6125 | 11.6018 | 11.6071 | 136164.0 |
| 2011-06-22 08:12:00 | AAPL | Stock | 11.6064 | 11.6064 | 11.6064 | 11.6064 | 18536.0 |
> showing 50 of 1,005,331 rows — these rows as CSV