PREVIEW / stock_1min / 2010-09-10
file: by_date/stock_1min/2010/2010-09-10.parquet size: 11.5 MB rows: 878,499 symbols: 2,794
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-10 04:06:00 | AAPL | Stock | 9.4375 | 9.4375 | 9.4375 | 9.4375 | 2800.0 |
| 2010-09-10 06:09:00 | AAPL | Stock | 9.4286 | 9.4286 | 9.4286 | 9.4286 | 2800.0 |
| 2010-09-10 07:04:00 | AAPL | Stock | 9.4357 | 9.4357 | 9.4321 | 9.4321 | 28000.0 |
| 2010-09-10 07:19:00 | AAPL | Stock | 9.4275 | 9.4275 | 9.4275 | 9.4275 | 4900.0 |
| 2010-09-10 07:20:00 | AAPL | Stock | 9.4286 | 9.4286 | 9.4286 | 9.4286 | 14700.0 |
| 2010-09-10 07:26:00 | AAPL | Stock | 9.4289 | 9.4293 | 9.4286 | 9.4289 | 25200.0 |
| 2010-09-10 07:27:00 | AAPL | Stock | 9.4286 | 9.4286 | 9.4286 | 9.4286 | 5600.0 |
| 2010-09-10 07:29:00 | AAPL | Stock | 9.4282 | 9.4282 | 9.42 | 9.42 | 8400.0 |
| 2010-09-10 07:35:00 | AAPL | Stock | 9.4257 | 9.4257 | 9.4257 | 9.4257 | 2800.0 |
| 2010-09-10 07:36:00 | AAPL | Stock | 9.4196 | 9.4196 | 9.4196 | 9.4196 | 4200.0 |
| 2010-09-10 07:41:00 | AAPL | Stock | 9.4136 | 9.4136 | 9.4136 | 9.4136 | 5600.0 |
| 2010-09-10 07:45:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 11200.0 |
| 2010-09-10 07:46:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 8400.0 |
| 2010-09-10 07:48:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 8400.0 |
| 2010-09-10 07:50:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 2800.0 |
| 2010-09-10 07:51:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 10584.0 |
| 2010-09-10 07:52:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 7784.0 |
| 2010-09-10 07:53:00 | AAPL | Stock | 9.4171 | 9.4171 | 9.4161 | 9.4171 | 25200.0 |
| 2010-09-10 08:00:00 | AAPL | Stock | 9.4132 | 9.4132 | 9.4107 | 9.4107 | 42000.0 |
| 2010-09-10 08:01:00 | AAPL | Stock | 9.41 | 9.415 | 9.4096 | 9.4139 | 128800.0 |
| 2010-09-10 08:02:00 | AAPL | Stock | 9.4161 | 9.4161 | 9.4104 | 9.4107 | 26432.0 |
| 2010-09-10 08:03:00 | AAPL | Stock | 9.4111 | 9.4154 | 9.4107 | 9.4154 | 26880.0 |
| 2010-09-10 08:04:00 | AAPL | Stock | 9.4161 | 9.4161 | 9.4104 | 9.4104 | 33600.0 |
| 2010-09-10 08:05:00 | AAPL | Stock | 9.4157 | 9.4164 | 9.4129 | 9.4129 | 31444.0 |
| 2010-09-10 08:06:00 | AAPL | Stock | 9.4125 | 9.4146 | 9.4125 | 9.4146 | 8400.0 |
| 2010-09-10 08:07:00 | AAPL | Stock | 9.4146 | 9.4146 | 9.4146 | 9.4146 | 2800.0 |
| 2010-09-10 08:08:00 | AAPL | Stock | 9.4139 | 9.4146 | 9.4139 | 9.4146 | 16800.0 |
| 2010-09-10 08:09:00 | AAPL | Stock | 9.4136 | 9.4136 | 9.4111 | 9.4111 | 14000.0 |
| 2010-09-10 08:11:00 | AAPL | Stock | 9.4125 | 9.4125 | 9.4125 | 9.4125 | 8400.0 |
| 2010-09-10 08:12:00 | AAPL | Stock | 9.4125 | 9.4125 | 9.4125 | 9.4125 | 11200.0 |
| 2010-09-10 08:13:00 | AAPL | Stock | 9.4154 | 9.4161 | 9.4143 | 9.4161 | 44128.0 |
| 2010-09-10 08:14:00 | AAPL | Stock | 9.4143 | 9.4143 | 9.4143 | 9.4143 | 11200.0 |
| 2010-09-10 08:16:00 | AAPL | Stock | 9.4129 | 9.4129 | 9.4071 | 9.4071 | 68600.0 |
| 2010-09-10 08:18:00 | AAPL | Stock | 9.4107 | 9.4107 | 9.4107 | 9.4107 | 9996.0 |
| 2010-09-10 08:19:00 | AAPL | Stock | 9.4146 | 9.415 | 9.4146 | 9.415 | 11200.0 |
| 2010-09-10 08:21:00 | AAPL | Stock | 9.4146 | 9.4146 | 9.4146 | 9.4146 | 2800.0 |
| 2010-09-10 08:22:00 | AAPL | Stock | 9.4146 | 9.415 | 9.4143 | 9.4143 | 14000.0 |
| 2010-09-10 08:25:00 | AAPL | Stock | 9.4125 | 9.4125 | 9.4111 | 9.4118 | 14000.0 |
| 2010-09-10 08:27:00 | AAPL | Stock | 9.4132 | 9.4139 | 9.4118 | 9.4139 | 16800.0 |
| 2010-09-10 08:28:00 | AAPL | Stock | 9.4143 | 9.4143 | 9.4139 | 9.4139 | 8400.0 |
| 2010-09-10 08:29:00 | AAPL | Stock | 9.4139 | 9.4139 | 9.4125 | 9.4125 | 28000.0 |
| 2010-09-10 08:30:00 | AAPL | Stock | 9.4146 | 9.415 | 9.4125 | 9.4125 | 11200.0 |
| 2010-09-10 08:31:00 | AAPL | Stock | 9.4125 | 9.4275 | 9.4107 | 9.4268 | 154700.0 |
| 2010-09-10 08:32:00 | AAPL | Stock | 9.4154 | 9.4279 | 9.4121 | 9.4275 | 159292.0 |
| 2010-09-10 08:33:00 | AAPL | Stock | 9.4275 | 9.4329 | 9.4257 | 9.4307 | 190652.0 |
| 2010-09-10 08:34:00 | AAPL | Stock | 9.4329 | 9.4329 | 9.4279 | 9.4286 | 121800.0 |
| 2010-09-10 08:35:00 | AAPL | Stock | 9.4286 | 9.4332 | 9.4286 | 9.4332 | 76860.0 |
| 2010-09-10 08:36:00 | AAPL | Stock | 9.4325 | 9.4329 | 9.4293 | 9.4293 | 14000.0 |
| 2010-09-10 08:37:00 | AAPL | Stock | 9.4325 | 9.4329 | 9.4286 | 9.4286 | 64400.0 |
| 2010-09-10 08:38:00 | AAPL | Stock | 9.4307 | 9.4386 | 9.4286 | 9.4354 | 188524.0 |
> showing 50 of 878,499 rows — these rows as CSV