PREVIEW / stock_1min / 2013-10-15
file: by_date/stock_1min/2013/2013-10-15.parquet size: 13.6 MB rows: 999,934 symbols: 2,876
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-10-15 04:00:00 | AAPL | Stock | 17.6786 | 17.7321 | 17.6786 | 17.7321 | 5880.0 |
| 2013-10-15 04:22:00 | AAPL | Stock | 17.7696 | 17.7696 | 17.7696 | 17.7696 | 2800.0 |
| 2013-10-15 04:40:00 | AAPL | Stock | 17.7811 | 17.7829 | 17.7811 | 17.7829 | 5600.0 |
| 2013-10-15 05:01:00 | AAPL | Stock | 17.7743 | 17.7743 | 17.7743 | 17.7743 | 8400.0 |
| 2013-10-15 05:05:00 | AAPL | Stock | 17.775 | 17.775 | 17.775 | 17.775 | 2800.0 |
| 2013-10-15 05:11:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 2800.0 |
| 2013-10-15 05:12:00 | AAPL | Stock | 17.7996 | 17.7996 | 17.7996 | 17.7996 | 2800.0 |
| 2013-10-15 05:45:00 | AAPL | Stock | 17.7939 | 17.7939 | 17.7939 | 17.7939 | 6888.0 |
| 2013-10-15 05:52:00 | AAPL | Stock | 17.81 | 17.8107 | 17.81 | 17.8107 | 5600.0 |
| 2013-10-15 06:07:00 | AAPL | Stock | 17.8111 | 17.8179 | 17.8111 | 17.8179 | 22400.0 |
| 2013-10-15 06:27:00 | AAPL | Stock | 17.8057 | 17.8057 | 17.8057 | 17.8057 | 2800.0 |
| 2013-10-15 06:31:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8214 | 17.8214 | 2800.0 |
| 2013-10-15 06:32:00 | AAPL | Stock | 17.8118 | 17.8118 | 17.8107 | 17.8107 | 8400.0 |
| 2013-10-15 06:33:00 | AAPL | Stock | 17.8107 | 17.8107 | 17.8107 | 17.8107 | 5600.0 |
| 2013-10-15 06:46:00 | AAPL | Stock | 17.7911 | 17.7918 | 17.7893 | 17.7893 | 19600.0 |
| 2013-10-15 06:47:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7857 | 17.7857 | 37912.0 |
| 2013-10-15 06:54:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7857 | 17.7893 | 39200.0 |
| 2013-10-15 07:01:00 | AAPL | Stock | 17.7929 | 17.7964 | 17.7929 | 17.7961 | 16800.0 |
| 2013-10-15 07:02:00 | AAPL | Stock | 17.8036 | 17.8036 | 17.8036 | 17.8036 | 28000.0 |
| 2013-10-15 07:04:00 | AAPL | Stock | 17.8036 | 17.8036 | 17.8036 | 17.8036 | 2800.0 |
| 2013-10-15 07:06:00 | AAPL | Stock | 17.8039 | 17.8039 | 17.8039 | 17.8039 | 2800.0 |
| 2013-10-15 07:07:00 | AAPL | Stock | 17.8125 | 17.8125 | 17.8107 | 17.8107 | 22400.0 |
| 2013-10-15 07:08:00 | AAPL | Stock | 17.8036 | 17.8036 | 17.8036 | 17.8036 | 18228.0 |
| 2013-10-15 07:11:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7893 | 17.7893 | 5460.0 |
| 2013-10-15 07:14:00 | AAPL | Stock | 17.7943 | 17.7943 | 17.7943 | 17.7943 | 2800.0 |
| 2013-10-15 07:16:00 | AAPL | Stock | 17.7932 | 17.7939 | 17.7857 | 17.7857 | 51156.0 |
| 2013-10-15 07:17:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 16800.0 |
| 2013-10-15 07:18:00 | AAPL | Stock | 17.7864 | 17.8161 | 17.7864 | 17.8161 | 74200.0 |
| 2013-10-15 07:19:00 | AAPL | Stock | 17.8107 | 17.8214 | 17.8107 | 17.8214 | 34300.0 |
| 2013-10-15 07:21:00 | AAPL | Stock | 17.8179 | 17.8179 | 17.8179 | 17.8179 | 8400.0 |
| 2013-10-15 07:24:00 | AAPL | Stock | 17.8129 | 17.8129 | 17.8129 | 17.8129 | 5600.0 |
| 2013-10-15 07:25:00 | AAPL | Stock | 17.8129 | 17.8129 | 17.8093 | 17.8093 | 11200.0 |
| 2013-10-15 07:26:00 | AAPL | Stock | 17.8054 | 17.8054 | 17.8054 | 17.8054 | 2800.0 |
| 2013-10-15 07:27:00 | AAPL | Stock | 17.8054 | 17.8068 | 17.8054 | 17.8068 | 19600.0 |
| 2013-10-15 07:34:00 | AAPL | Stock | 17.7996 | 17.8036 | 17.7996 | 17.8036 | 42336.0 |
| 2013-10-15 07:35:00 | AAPL | Stock | 17.8036 | 17.8125 | 17.8036 | 17.8125 | 28000.0 |
| 2013-10-15 07:37:00 | AAPL | Stock | 17.8204 | 17.8204 | 17.8204 | 17.8204 | 5600.0 |
| 2013-10-15 07:41:00 | AAPL | Stock | 17.8139 | 17.8139 | 17.8139 | 17.8139 | 2800.0 |
| 2013-10-15 07:42:00 | AAPL | Stock | 17.8036 | 17.8036 | 17.8036 | 17.8036 | 28000.0 |
| 2013-10-15 07:43:00 | AAPL | Stock | 17.7921 | 17.7921 | 17.7893 | 17.7893 | 51772.0 |
| 2013-10-15 07:46:00 | AAPL | Stock | 17.7857 | 17.7861 | 17.7714 | 17.7714 | 28000.0 |
| 2013-10-15 07:47:00 | AAPL | Stock | 17.7861 | 17.7861 | 17.7857 | 17.7857 | 19600.0 |
| 2013-10-15 07:48:00 | AAPL | Stock | 17.7796 | 17.7796 | 17.7796 | 17.7796 | 22400.0 |
| 2013-10-15 07:49:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 21840.0 |
| 2013-10-15 07:50:00 | AAPL | Stock | 17.7771 | 17.7771 | 17.7768 | 17.7768 | 5600.0 |
| 2013-10-15 07:53:00 | AAPL | Stock | 17.7768 | 17.7768 | 17.7768 | 17.7768 | 5600.0 |
| 2013-10-15 07:54:00 | AAPL | Stock | 17.7721 | 17.7721 | 17.7714 | 17.7714 | 25284.0 |
| 2013-10-15 07:56:00 | AAPL | Stock | 17.7629 | 17.7714 | 17.75 | 17.75 | 59388.0 |
| 2013-10-15 07:57:00 | AAPL | Stock | 17.7486 | 17.7496 | 17.7486 | 17.7496 | 5600.0 |
| 2013-10-15 07:59:00 | AAPL | Stock | 17.7486 | 17.7496 | 17.7479 | 17.7479 | 19320.0 |
> showing 50 of 999,934 rows — these rows as CSV