PREVIEW / stock_1min / 2014-01-27
file: by_date/stock_1min/2014/2014-01-27.parquet size: 16.3 MB rows: 1,143,178 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 |
|---|---|---|---|---|---|---|---|
| 2014-01-27 04:02:00 | AAPL | Stock | 19.6061 | 19.6061 | 19.6061 | 19.6061 | 16800.0 |
| 2014-01-27 04:14:00 | AAPL | Stock | 19.5989 | 19.6025 | 19.5989 | 19.6025 | 14000.0 |
| 2014-01-27 04:15:00 | AAPL | Stock | 19.6025 | 19.6025 | 19.6025 | 19.6025 | 8316.0 |
| 2014-01-27 04:18:00 | AAPL | Stock | 19.6068 | 19.6068 | 19.6068 | 19.6068 | 5320.0 |
| 2014-01-27 04:33:00 | AAPL | Stock | 19.6054 | 19.6054 | 19.6054 | 19.6054 | 2800.0 |
| 2014-01-27 04:35:00 | AAPL | Stock | 19.6211 | 19.6211 | 19.6211 | 19.6211 | 4284.0 |
| 2014-01-27 04:42:00 | AAPL | Stock | 19.625 | 19.625 | 19.625 | 19.625 | 2800.0 |
| 2014-01-27 04:46:00 | AAPL | Stock | 19.6189 | 19.6189 | 19.6143 | 19.6143 | 5600.0 |
| 2014-01-27 04:52:00 | AAPL | Stock | 19.6336 | 19.6336 | 19.6336 | 19.6336 | 4200.0 |
| 2014-01-27 04:55:00 | AAPL | Stock | 19.6404 | 19.6404 | 19.6361 | 19.6361 | 8400.0 |
| 2014-01-27 04:56:00 | AAPL | Stock | 19.6339 | 19.6339 | 19.6336 | 19.6336 | 17724.0 |
| 2014-01-27 05:02:00 | AAPL | Stock | 19.6361 | 19.6361 | 19.6361 | 19.6361 | 23324.0 |
| 2014-01-27 05:06:00 | AAPL | Stock | 19.6425 | 19.6425 | 19.6425 | 19.6425 | 5656.0 |
| 2014-01-27 05:10:00 | AAPL | Stock | 19.6393 | 19.6393 | 19.6393 | 19.6393 | 5600.0 |
| 2014-01-27 05:18:00 | AAPL | Stock | 19.635 | 19.635 | 19.635 | 19.635 | 2800.0 |
| 2014-01-27 05:22:00 | AAPL | Stock | 19.6257 | 19.6286 | 19.6254 | 19.6286 | 44800.0 |
| 2014-01-27 05:24:00 | AAPL | Stock | 19.6393 | 19.6393 | 19.6393 | 19.6393 | 14000.0 |
| 2014-01-27 05:50:00 | AAPL | Stock | 19.62 | 19.62 | 19.6146 | 19.6146 | 42000.0 |
| 2014-01-27 05:52:00 | AAPL | Stock | 19.6146 | 19.6189 | 19.6143 | 19.6189 | 8400.0 |
| 2014-01-27 06:00:00 | AAPL | Stock | 19.625 | 19.625 | 19.625 | 19.625 | 4424.0 |
| 2014-01-27 06:01:00 | AAPL | Stock | 19.6418 | 19.6418 | 19.6418 | 19.6418 | 2800.0 |
| 2014-01-27 06:02:00 | AAPL | Stock | 19.6268 | 19.6268 | 19.6268 | 19.6268 | 2800.0 |
| 2014-01-27 06:08:00 | AAPL | Stock | 19.6246 | 19.6246 | 19.6246 | 19.6246 | 2800.0 |
| 2014-01-27 06:11:00 | AAPL | Stock | 19.6221 | 19.6221 | 19.6221 | 19.6221 | 2800.0 |
| 2014-01-27 06:13:00 | AAPL | Stock | 19.6246 | 19.6246 | 19.6246 | 19.6246 | 2800.0 |
| 2014-01-27 06:14:00 | AAPL | Stock | 19.6221 | 19.6221 | 19.6143 | 19.6143 | 23296.0 |
| 2014-01-27 06:15:00 | AAPL | Stock | 19.6143 | 19.6143 | 19.6139 | 19.6139 | 5600.0 |
| 2014-01-27 06:16:00 | AAPL | Stock | 19.6107 | 19.6107 | 19.6107 | 19.6107 | 2800.0 |
| 2014-01-27 06:17:00 | AAPL | Stock | 19.6054 | 19.6054 | 19.6054 | 19.6054 | 2800.0 |
| 2014-01-27 06:18:00 | AAPL | Stock | 19.6054 | 19.6054 | 19.6054 | 19.6054 | 11200.0 |
| 2014-01-27 06:19:00 | AAPL | Stock | 19.6246 | 19.6246 | 19.6246 | 19.6246 | 2800.0 |
| 2014-01-27 06:30:00 | AAPL | Stock | 19.6393 | 19.6393 | 19.6393 | 19.6393 | 2800.0 |
| 2014-01-27 06:31:00 | AAPL | Stock | 19.6261 | 19.6261 | 19.6261 | 19.6261 | 5600.0 |
| 2014-01-27 06:32:00 | AAPL | Stock | 19.6393 | 19.6421 | 19.6393 | 19.6421 | 22400.0 |
| 2014-01-27 06:33:00 | AAPL | Stock | 19.6389 | 19.6389 | 19.625 | 19.625 | 30800.0 |
| 2014-01-27 06:34:00 | AAPL | Stock | 19.6282 | 19.6282 | 19.6282 | 19.6282 | 2800.0 |
| 2014-01-27 06:35:00 | AAPL | Stock | 19.6389 | 19.6425 | 19.6389 | 19.6425 | 14000.0 |
| 2014-01-27 06:36:00 | AAPL | Stock | 19.6432 | 19.6432 | 19.6432 | 19.6432 | 5376.0 |
| 2014-01-27 06:50:00 | AAPL | Stock | 19.6371 | 19.6429 | 19.6318 | 19.6429 | 32200.0 |
| 2014-01-27 06:51:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 2800.0 |
| 2014-01-27 06:54:00 | AAPL | Stock | 19.6536 | 19.6554 | 19.6536 | 19.6554 | 8400.0 |
| 2014-01-27 06:57:00 | AAPL | Stock | 19.6732 | 19.6732 | 19.6732 | 19.6732 | 2800.0 |
| 2014-01-27 06:59:00 | AAPL | Stock | 19.7032 | 19.7032 | 19.7032 | 19.7032 | 2800.0 |
| 2014-01-27 07:00:00 | AAPL | Stock | 19.6964 | 19.6964 | 19.6964 | 19.6964 | 2800.0 |
| 2014-01-27 07:01:00 | AAPL | Stock | 19.7054 | 19.7107 | 19.7036 | 19.7036 | 42000.0 |
| 2014-01-27 07:03:00 | AAPL | Stock | 19.7086 | 19.7107 | 19.7082 | 19.7082 | 15400.0 |
| 2014-01-27 07:04:00 | AAPL | Stock | 19.7107 | 19.7107 | 19.7107 | 19.7107 | 2800.0 |
| 2014-01-27 07:05:00 | AAPL | Stock | 19.71 | 19.7104 | 19.71 | 19.7104 | 9800.0 |
| 2014-01-27 07:06:00 | AAPL | Stock | 19.7054 | 19.7071 | 19.6857 | 19.6857 | 64400.0 |
| 2014-01-27 07:07:00 | AAPL | Stock | 19.6807 | 19.6807 | 19.6807 | 19.6807 | 2800.0 |
> showing 50 of 1,143,178 rows — these rows as CSV