PREVIEW / stock_1min / 2011-07-14
file: by_date/stock_1min/2011/2011-07-14.parquet size: 13.2 MB rows: 987,325 symbols: 2,846
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-07-14 04:30:00 | AAPL | Stock | 12.7857 | 12.7907 | 12.7857 | 12.7907 | 10920.0 |
| 2011-07-14 04:39:00 | AAPL | Stock | 12.7893 | 12.7893 | 12.7893 | 12.7893 | 2800.0 |
| 2011-07-14 04:42:00 | AAPL | Stock | 12.7893 | 12.7893 | 12.7893 | 12.7893 | 2800.0 |
| 2011-07-14 05:33:00 | AAPL | Stock | 12.7761 | 12.7761 | 12.7714 | 12.7714 | 8400.0 |
| 2011-07-14 05:41:00 | AAPL | Stock | 12.735 | 12.735 | 12.7321 | 12.7321 | 5600.0 |
| 2011-07-14 06:04:00 | AAPL | Stock | 12.7707 | 12.7857 | 12.7707 | 12.7857 | 28000.0 |
| 2011-07-14 06:05:00 | AAPL | Stock | 12.7857 | 12.7857 | 12.7857 | 12.7857 | 5600.0 |
| 2011-07-14 06:12:00 | AAPL | Stock | 12.8118 | 12.8118 | 12.8118 | 12.8118 | 2800.0 |
| 2011-07-14 06:13:00 | AAPL | Stock | 12.8118 | 12.8121 | 12.8118 | 12.8121 | 38920.0 |
| 2011-07-14 06:21:00 | AAPL | Stock | 12.8125 | 12.8125 | 12.8107 | 12.8107 | 8400.0 |
| 2011-07-14 06:27:00 | AAPL | Stock | 12.8107 | 12.8107 | 12.8107 | 12.8107 | 2800.0 |
| 2011-07-14 06:33:00 | AAPL | Stock | 12.7975 | 12.7975 | 12.7975 | 12.7975 | 2800.0 |
| 2011-07-14 06:34:00 | AAPL | Stock | 12.7864 | 12.7864 | 12.7864 | 12.7864 | 33600.0 |
| 2011-07-14 06:35:00 | AAPL | Stock | 12.7868 | 12.7868 | 12.7868 | 12.7868 | 11200.0 |
| 2011-07-14 06:41:00 | AAPL | Stock | 12.7868 | 12.7868 | 12.7868 | 12.7868 | 2800.0 |
| 2011-07-14 06:42:00 | AAPL | Stock | 12.8036 | 12.8118 | 12.8036 | 12.8118 | 14000.0 |
| 2011-07-14 06:47:00 | AAPL | Stock | 12.8161 | 12.825 | 12.8161 | 12.825 | 33180.0 |
| 2011-07-14 06:48:00 | AAPL | Stock | 12.8268 | 12.8371 | 12.8268 | 12.8371 | 14000.0 |
| 2011-07-14 06:51:00 | AAPL | Stock | 12.8214 | 12.8214 | 12.8214 | 12.8214 | 5600.0 |
| 2011-07-14 07:00:00 | AAPL | Stock | 12.8221 | 12.8221 | 12.8221 | 12.8221 | 2800.0 |
| 2011-07-14 07:01:00 | AAPL | Stock | 12.8304 | 12.8304 | 12.8304 | 12.8304 | 2800.0 |
| 2011-07-14 07:02:00 | AAPL | Stock | 12.8357 | 12.8357 | 12.8357 | 12.8357 | 2800.0 |
| 2011-07-14 07:03:00 | AAPL | Stock | 12.8321 | 12.8321 | 12.8321 | 12.8321 | 2800.0 |
| 2011-07-14 07:04:00 | AAPL | Stock | 12.8393 | 12.8393 | 12.8321 | 12.8321 | 14000.0 |
| 2011-07-14 07:05:00 | AAPL | Stock | 12.8325 | 12.8325 | 12.8321 | 12.8321 | 30660.0 |
| 2011-07-14 07:06:00 | AAPL | Stock | 12.8321 | 12.8321 | 12.8268 | 12.8268 | 16800.0 |
| 2011-07-14 07:08:00 | AAPL | Stock | 12.8214 | 12.8214 | 12.8214 | 12.8214 | 2800.0 |
| 2011-07-14 07:09:00 | AAPL | Stock | 12.8214 | 12.8214 | 12.8114 | 12.8114 | 19600.0 |
| 2011-07-14 07:10:00 | AAPL | Stock | 12.8214 | 12.8214 | 12.8214 | 12.8214 | 19600.0 |
| 2011-07-14 07:11:00 | AAPL | Stock | 12.8221 | 12.8221 | 12.8221 | 12.8221 | 2800.0 |
| 2011-07-14 07:12:00 | AAPL | Stock | 12.83 | 12.8314 | 12.83 | 12.8314 | 22400.0 |
| 2011-07-14 07:13:00 | AAPL | Stock | 12.8339 | 12.8339 | 12.8339 | 12.8339 | 2800.0 |
| 2011-07-14 07:14:00 | AAPL | Stock | 12.8393 | 12.8471 | 12.8393 | 12.8471 | 33572.0 |
| 2011-07-14 07:15:00 | AAPL | Stock | 12.8471 | 12.8571 | 12.8471 | 12.8571 | 39200.0 |
| 2011-07-14 07:16:00 | AAPL | Stock | 12.8571 | 12.8796 | 12.8571 | 12.8796 | 16800.0 |
| 2011-07-14 07:18:00 | AAPL | Stock | 12.8768 | 12.8786 | 12.8671 | 12.8671 | 16800.0 |
| 2011-07-14 07:19:00 | AAPL | Stock | 12.8768 | 12.8768 | 12.875 | 12.875 | 5600.0 |
| 2011-07-14 07:20:00 | AAPL | Stock | 12.865 | 12.8796 | 12.865 | 12.8796 | 28000.0 |
| 2011-07-14 07:21:00 | AAPL | Stock | 12.875 | 12.8821 | 12.8646 | 12.875 | 114800.0 |
| 2011-07-14 07:22:00 | AAPL | Stock | 12.8682 | 12.8682 | 12.8682 | 12.8682 | 11200.0 |
| 2011-07-14 07:24:00 | AAPL | Stock | 12.8661 | 12.8661 | 12.8661 | 12.8661 | 5432.0 |
| 2011-07-14 07:25:00 | AAPL | Stock | 12.8714 | 12.8714 | 12.8714 | 12.8714 | 2800.0 |
| 2011-07-14 07:26:00 | AAPL | Stock | 12.8743 | 12.8746 | 12.8696 | 12.8696 | 14000.0 |
| 2011-07-14 07:27:00 | AAPL | Stock | 12.8668 | 12.8668 | 12.8661 | 12.8661 | 8400.0 |
| 2011-07-14 07:28:00 | AAPL | Stock | 12.8696 | 12.875 | 12.8696 | 12.8746 | 28000.0 |
| 2011-07-14 07:29:00 | AAPL | Stock | 12.8768 | 12.885 | 12.8768 | 12.885 | 11200.0 |
| 2011-07-14 07:30:00 | AAPL | Stock | 12.8904 | 12.8932 | 12.8857 | 12.8929 | 57372.0 |
| 2011-07-14 07:31:00 | AAPL | Stock | 12.8921 | 12.8929 | 12.8875 | 12.8929 | 95872.0 |
| 2011-07-14 07:32:00 | AAPL | Stock | 12.8929 | 12.9011 | 12.8929 | 12.8929 | 11200.0 |
| 2011-07-14 07:33:00 | AAPL | Stock | 12.8929 | 12.8929 | 12.8875 | 12.8929 | 75572.0 |
> showing 50 of 987,325 rows — these rows as CSV