PREVIEW / stock_1min / 2011-01-03
file: by_date/stock_1min/2011/2011-01-03.parquet size: 13.6 MB rows: 1,021,817 symbols: 2,867
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-01-03 04:00:00 | AAPL | Stock | 11.5714 | 11.5714 | 11.5714 | 11.5714 | 16800.0 |
| 2011-01-03 04:11:00 | AAPL | Stock | 11.5839 | 11.5839 | 11.5839 | 11.5839 | 2800.0 |
| 2011-01-03 04:16:00 | AAPL | Stock | 11.5929 | 11.5929 | 11.5929 | 11.5929 | 2800.0 |
| 2011-01-03 04:17:00 | AAPL | Stock | 11.5929 | 11.5929 | 11.5929 | 11.5929 | 7280.0 |
| 2011-01-03 04:47:00 | AAPL | Stock | 11.5968 | 11.5968 | 11.5968 | 11.5968 | 2800.0 |
| 2011-01-03 04:48:00 | AAPL | Stock | 11.5968 | 11.5968 | 11.5968 | 11.5968 | 2800.0 |
| 2011-01-03 05:01:00 | AAPL | Stock | 11.6064 | 11.6064 | 11.6064 | 11.6064 | 2800.0 |
| 2011-01-03 05:35:00 | AAPL | Stock | 11.6371 | 11.6371 | 11.6371 | 11.6371 | 2800.0 |
| 2011-01-03 05:42:00 | AAPL | Stock | 11.6211 | 11.6211 | 11.6211 | 11.6211 | 2800.0 |
| 2011-01-03 05:43:00 | AAPL | Stock | 11.6186 | 11.6186 | 11.6179 | 11.6179 | 5600.0 |
| 2011-01-03 05:48:00 | AAPL | Stock | 11.6096 | 11.6096 | 11.6096 | 11.6096 | 2800.0 |
| 2011-01-03 06:24:00 | AAPL | Stock | 11.6339 | 11.6339 | 11.6339 | 11.6339 | 2800.0 |
| 2011-01-03 06:28:00 | AAPL | Stock | 11.62 | 11.62 | 11.62 | 11.62 | 2800.0 |
| 2011-01-03 06:49:00 | AAPL | Stock | 11.6236 | 11.6236 | 11.6236 | 11.6236 | 2800.0 |
| 2011-01-03 06:55:00 | AAPL | Stock | 11.6229 | 11.6229 | 11.6229 | 11.6229 | 5600.0 |
| 2011-01-03 07:01:00 | AAPL | Stock | 11.6143 | 11.6143 | 11.6143 | 11.6143 | 7000.0 |
| 2011-01-03 07:02:00 | AAPL | Stock | 11.6107 | 11.6107 | 11.5982 | 11.5982 | 14000.0 |
| 2011-01-03 07:03:00 | AAPL | Stock | 11.6214 | 11.6214 | 11.6139 | 11.6143 | 23128.0 |
| 2011-01-03 07:04:00 | AAPL | Stock | 11.6143 | 11.6143 | 11.6143 | 11.6143 | 2800.0 |
| 2011-01-03 07:06:00 | AAPL | Stock | 11.6121 | 11.6121 | 11.6121 | 11.6121 | 2800.0 |
| 2011-01-03 07:07:00 | AAPL | Stock | 11.6096 | 11.6096 | 11.6096 | 11.6096 | 12628.0 |
| 2011-01-03 07:08:00 | AAPL | Stock | 11.6036 | 11.6036 | 11.6036 | 11.6036 | 19600.0 |
| 2011-01-03 07:09:00 | AAPL | Stock | 11.5986 | 11.5986 | 11.5893 | 11.5893 | 16800.0 |
| 2011-01-03 07:10:00 | AAPL | Stock | 11.5886 | 11.5886 | 11.5882 | 11.5882 | 16156.0 |
| 2011-01-03 07:11:00 | AAPL | Stock | 11.5893 | 11.5893 | 11.585 | 11.585 | 5600.0 |
| 2011-01-03 07:13:00 | AAPL | Stock | 11.5893 | 11.5893 | 11.5893 | 11.5893 | 23576.0 |
| 2011-01-03 07:15:00 | AAPL | Stock | 11.5846 | 11.5846 | 11.5846 | 11.5846 | 2800.0 |
| 2011-01-03 07:16:00 | AAPL | Stock | 11.5893 | 11.5893 | 11.5846 | 11.5846 | 5600.0 |
| 2011-01-03 07:17:00 | AAPL | Stock | 11.5886 | 11.5893 | 11.5886 | 11.5886 | 8400.0 |
| 2011-01-03 07:18:00 | AAPL | Stock | 11.5886 | 11.5886 | 11.5886 | 11.5886 | 5600.0 |
| 2011-01-03 07:21:00 | AAPL | Stock | 11.5893 | 11.5893 | 11.5893 | 11.5893 | 10192.0 |
| 2011-01-03 07:22:00 | AAPL | Stock | 11.5889 | 11.5893 | 11.5889 | 11.5893 | 21840.0 |
| 2011-01-03 07:23:00 | AAPL | Stock | 11.5896 | 11.5896 | 11.5896 | 11.5896 | 2800.0 |
| 2011-01-03 07:25:00 | AAPL | Stock | 11.5979 | 11.5979 | 11.5979 | 11.5979 | 5600.0 |
| 2011-01-03 07:26:00 | AAPL | Stock | 11.5946 | 11.6 | 11.5946 | 11.6 | 11480.0 |
| 2011-01-03 07:33:00 | AAPL | Stock | 11.6007 | 11.6068 | 11.6007 | 11.6068 | 11200.0 |
| 2011-01-03 07:34:00 | AAPL | Stock | 11.6054 | 11.6071 | 11.6004 | 11.6071 | 25200.0 |
| 2011-01-03 07:35:00 | AAPL | Stock | 11.6071 | 11.6071 | 11.6071 | 11.6071 | 28000.0 |
| 2011-01-03 07:37:00 | AAPL | Stock | 11.6139 | 11.6139 | 11.6139 | 11.6139 | 5600.0 |
| 2011-01-03 07:41:00 | AAPL | Stock | 11.6121 | 11.6129 | 11.6121 | 11.6129 | 5600.0 |
| 2011-01-03 07:43:00 | AAPL | Stock | 11.6139 | 11.6143 | 11.6136 | 11.6143 | 70000.0 |
| 2011-01-03 07:45:00 | AAPL | Stock | 11.6236 | 11.6243 | 11.6236 | 11.6243 | 25340.0 |
| 2011-01-03 07:48:00 | AAPL | Stock | 11.6239 | 11.6239 | 11.6239 | 11.6239 | 5600.0 |
| 2011-01-03 07:52:00 | AAPL | Stock | 11.6161 | 11.6161 | 11.6161 | 11.6161 | 2800.0 |
| 2011-01-03 07:54:00 | AAPL | Stock | 11.6143 | 11.6196 | 11.6143 | 11.6193 | 11200.0 |
| 2011-01-03 07:55:00 | AAPL | Stock | 11.6193 | 11.6193 | 11.6193 | 11.6193 | 5600.0 |
| 2011-01-03 07:56:00 | AAPL | Stock | 11.6196 | 11.6196 | 11.6196 | 11.6196 | 2800.0 |
| 2011-01-03 07:58:00 | AAPL | Stock | 11.6193 | 11.625 | 11.6193 | 11.625 | 82404.0 |
| 2011-01-03 07:59:00 | AAPL | Stock | 11.6321 | 11.6321 | 11.6321 | 11.6321 | 14000.0 |
| 2011-01-03 08:00:00 | AAPL | Stock | 11.6182 | 11.6329 | 11.6143 | 11.6179 | 294336.0 |
> showing 50 of 1,021,817 rows — these rows as CSV