PREVIEW / stock_1min / 2011-04-29
file: by_date/stock_1min/2011/2011-04-29.parquet size: 13.0 MB rows: 961,362 symbols: 2,888
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-04-29 06:11:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 2800.0 |
| 2011-04-29 06:36:00 | AAPL | Stock | 12.3886 | 12.3886 | 12.3886 | 12.3886 | 2800.0 |
| 2011-04-29 06:37:00 | AAPL | Stock | 12.3718 | 12.3718 | 12.3718 | 12.3718 | 2800.0 |
| 2011-04-29 07:00:00 | AAPL | Stock | 12.385 | 12.385 | 12.385 | 12.385 | 5600.0 |
| 2011-04-29 07:15:00 | AAPL | Stock | 12.3875 | 12.3875 | 12.3875 | 12.3875 | 13300.0 |
| 2011-04-29 07:20:00 | AAPL | Stock | 12.3875 | 12.3875 | 12.3875 | 12.3875 | 2800.0 |
| 2011-04-29 07:24:00 | AAPL | Stock | 12.4018 | 12.4018 | 12.4018 | 12.4018 | 8400.0 |
| 2011-04-29 07:27:00 | AAPL | Stock | 12.4096 | 12.4096 | 12.4096 | 12.4096 | 2800.0 |
| 2011-04-29 07:30:00 | AAPL | Stock | 12.4236 | 12.4243 | 12.4221 | 12.4243 | 28000.0 |
| 2011-04-29 07:34:00 | AAPL | Stock | 12.4196 | 12.4196 | 12.4196 | 12.4196 | 28000.0 |
| 2011-04-29 07:35:00 | AAPL | Stock | 12.4129 | 12.4129 | 12.4129 | 12.4129 | 2800.0 |
| 2011-04-29 07:36:00 | AAPL | Stock | 12.4214 | 12.4261 | 12.4214 | 12.4261 | 21700.0 |
| 2011-04-29 07:37:00 | AAPL | Stock | 12.4257 | 12.4261 | 12.4257 | 12.4261 | 5600.0 |
| 2011-04-29 07:39:00 | AAPL | Stock | 12.4261 | 12.4261 | 12.4261 | 12.4261 | 25760.0 |
| 2011-04-29 07:40:00 | AAPL | Stock | 12.4261 | 12.4261 | 12.4261 | 12.4261 | 2800.0 |
| 2011-04-29 07:42:00 | AAPL | Stock | 12.4254 | 12.4254 | 12.4254 | 12.4254 | 2800.0 |
| 2011-04-29 07:51:00 | AAPL | Stock | 12.4211 | 12.4214 | 12.4211 | 12.4214 | 14000.0 |
| 2011-04-29 07:53:00 | AAPL | Stock | 12.4246 | 12.4246 | 12.4246 | 12.4246 | 2800.0 |
| 2011-04-29 07:54:00 | AAPL | Stock | 12.4257 | 12.4261 | 12.4257 | 12.4261 | 25900.0 |
| 2011-04-29 07:55:00 | AAPL | Stock | 12.4254 | 12.4254 | 12.4254 | 12.4254 | 2800.0 |
| 2011-04-29 07:56:00 | AAPL | Stock | 12.4257 | 12.4257 | 12.4257 | 12.4257 | 2800.0 |
| 2011-04-29 07:57:00 | AAPL | Stock | 12.4254 | 12.4286 | 12.4254 | 12.4286 | 38920.0 |
| 2011-04-29 07:58:00 | AAPL | Stock | 12.4279 | 12.4282 | 12.4279 | 12.4282 | 54600.0 |
| 2011-04-29 07:59:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 2800.0 |
| 2011-04-29 08:00:00 | AAPL | Stock | 12.4157 | 12.4282 | 12.4157 | 12.4282 | 74200.0 |
| 2011-04-29 08:04:00 | AAPL | Stock | 12.425 | 12.425 | 12.425 | 12.425 | 25200.0 |
| 2011-04-29 08:09:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4107 | 12.4107 | 11200.0 |
| 2011-04-29 08:14:00 | AAPL | Stock | 12.4171 | 12.4171 | 12.4171 | 12.4171 | 2800.0 |
| 2011-04-29 08:15:00 | AAPL | Stock | 12.4214 | 12.425 | 12.4214 | 12.425 | 179200.0 |
| 2011-04-29 08:18:00 | AAPL | Stock | 12.4179 | 12.4179 | 12.4179 | 12.4179 | 2800.0 |
| 2011-04-29 08:19:00 | AAPL | Stock | 12.4179 | 12.4179 | 12.4179 | 12.4179 | 5600.0 |
| 2011-04-29 08:20:00 | AAPL | Stock | 12.4232 | 12.4232 | 12.4179 | 12.4179 | 5600.0 |
| 2011-04-29 08:23:00 | AAPL | Stock | 12.4179 | 12.4179 | 12.4179 | 12.4179 | 2800.0 |
| 2011-04-29 08:24:00 | AAPL | Stock | 12.4179 | 12.4179 | 12.4179 | 12.4179 | 14000.0 |
| 2011-04-29 08:25:00 | AAPL | Stock | 12.4114 | 12.4114 | 12.4107 | 12.4107 | 24248.0 |
| 2011-04-29 08:27:00 | AAPL | Stock | 12.4143 | 12.4143 | 12.4143 | 12.4143 | 2800.0 |
| 2011-04-29 08:32:00 | AAPL | Stock | 12.4186 | 12.4186 | 12.4186 | 12.4186 | 8400.0 |
| 2011-04-29 08:33:00 | AAPL | Stock | 12.4186 | 12.4186 | 12.4186 | 12.4186 | 20048.0 |
| 2011-04-29 08:35:00 | AAPL | Stock | 12.4246 | 12.425 | 12.4246 | 12.4246 | 28000.0 |
| 2011-04-29 08:36:00 | AAPL | Stock | 12.4243 | 12.4243 | 12.4243 | 12.4243 | 8400.0 |
| 2011-04-29 08:42:00 | AAPL | Stock | 12.4179 | 12.4179 | 12.4179 | 12.4179 | 6300.0 |
| 2011-04-29 08:45:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 8400.0 |
| 2011-04-29 08:47:00 | AAPL | Stock | 12.4175 | 12.4175 | 12.4175 | 12.4175 | 2800.0 |
| 2011-04-29 08:50:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4175 | 12.4175 | 8960.0 |
| 2011-04-29 08:52:00 | AAPL | Stock | 12.4175 | 12.4175 | 12.4071 | 12.4071 | 35000.0 |
| 2011-04-29 08:53:00 | AAPL | Stock | 12.4071 | 12.4086 | 12.4071 | 12.4086 | 18200.0 |
| 2011-04-29 08:54:00 | AAPL | Stock | 12.4086 | 12.4086 | 12.4086 | 12.4086 | 2800.0 |
| 2011-04-29 08:56:00 | AAPL | Stock | 12.405 | 12.405 | 12.405 | 12.405 | 2800.0 |
| 2011-04-29 08:57:00 | AAPL | Stock | 12.4 | 12.4 | 12.4 | 12.4 | 12040.0 |
| 2011-04-29 08:58:00 | AAPL | Stock | 12.3964 | 12.3964 | 12.3929 | 12.3929 | 39200.0 |
> showing 50 of 961,362 rows — these rows as CSV