PREVIEW / stock_1min / 2007-01-16
file: by_date/stock_1min/2007/2007-01-16.parquet size: 9.4 MB rows: 754,314 symbols: 2,044
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-16 04:15:00 | AAPL | Stock | 3.4114 | 3.4114 | 3.4114 | 3.4114 | 11200.0 |
| 2007-01-16 05:36:00 | AAPL | Stock | 3.4175 | 3.4175 | 3.4175 | 3.4175 | 2800.0 |
| 2007-01-16 05:38:00 | AAPL | Stock | 3.4257 | 3.4257 | 3.4257 | 3.4257 | 2800.0 |
| 2007-01-16 05:40:00 | AAPL | Stock | 3.4214 | 3.4214 | 3.4214 | 3.4214 | 2800.0 |
| 2007-01-16 05:56:00 | AAPL | Stock | 3.4046 | 3.4046 | 3.4046 | 3.4046 | 8400.0 |
| 2007-01-16 05:58:00 | AAPL | Stock | 3.4018 | 3.4018 | 3.4018 | 3.4018 | 5600.0 |
| 2007-01-16 06:06:00 | AAPL | Stock | 3.4229 | 3.4229 | 3.4229 | 3.4229 | 2800.0 |
| 2007-01-16 06:25:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4143 | 3.4143 | 5600.0 |
| 2007-01-16 06:53:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 8400.0 |
| 2007-01-16 06:57:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 8400.0 |
| 2007-01-16 07:00:00 | AAPL | Stock | 3.4179 | 3.4179 | 3.4179 | 3.4179 | 2800.0 |
| 2007-01-16 07:01:00 | AAPL | Stock | 3.4079 | 3.4079 | 3.4071 | 3.4071 | 39200.0 |
| 2007-01-16 07:02:00 | AAPL | Stock | 3.4089 | 3.4089 | 3.4089 | 3.4089 | 5600.0 |
| 2007-01-16 07:03:00 | AAPL | Stock | 3.4089 | 3.4089 | 3.4089 | 3.4089 | 5600.0 |
| 2007-01-16 07:06:00 | AAPL | Stock | 3.4089 | 3.4089 | 3.4089 | 3.4089 | 2800.0 |
| 2007-01-16 07:07:00 | AAPL | Stock | 3.4071 | 3.4071 | 3.4071 | 3.4071 | 42000.0 |
| 2007-01-16 07:17:00 | AAPL | Stock | 3.4089 | 3.4089 | 3.4089 | 3.4089 | 14000.0 |
| 2007-01-16 07:20:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4143 | 3.4143 | 2800.0 |
| 2007-01-16 07:22:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 5600.0 |
| 2007-01-16 07:24:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 2800.0 |
| 2007-01-16 07:26:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4143 | 3.4143 | 28000.0 |
| 2007-01-16 07:28:00 | AAPL | Stock | 3.4143 | 3.4171 | 3.4143 | 3.4171 | 56000.0 |
| 2007-01-16 07:30:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4143 | 3.4143 | 14000.0 |
| 2007-01-16 07:35:00 | AAPL | Stock | 3.4179 | 3.4211 | 3.4179 | 3.4211 | 142800.0 |
| 2007-01-16 07:36:00 | AAPL | Stock | 3.4179 | 3.4214 | 3.4179 | 3.4211 | 319200.0 |
| 2007-01-16 07:37:00 | AAPL | Stock | 3.4211 | 3.4232 | 3.4211 | 3.4232 | 117600.0 |
| 2007-01-16 07:38:00 | AAPL | Stock | 3.4214 | 3.4214 | 3.4214 | 3.4214 | 28000.0 |
| 2007-01-16 07:39:00 | AAPL | Stock | 3.4225 | 3.4225 | 3.4225 | 3.4225 | 2800.0 |
| 2007-01-16 07:40:00 | AAPL | Stock | 3.4214 | 3.4214 | 3.4211 | 3.4211 | 168000.0 |
| 2007-01-16 07:41:00 | AAPL | Stock | 3.4146 | 3.4146 | 3.4143 | 3.4146 | 64400.0 |
| 2007-01-16 07:42:00 | AAPL | Stock | 3.4196 | 3.4196 | 3.4196 | 3.4196 | 11200.0 |
| 2007-01-16 07:44:00 | AAPL | Stock | 3.4196 | 3.4196 | 3.4196 | 3.4196 | 2800.0 |
| 2007-01-16 07:45:00 | AAPL | Stock | 3.4154 | 3.4154 | 3.4143 | 3.4143 | 42000.0 |
| 2007-01-16 07:51:00 | AAPL | Stock | 3.4146 | 3.4146 | 3.4143 | 3.4143 | 28000.0 |
| 2007-01-16 07:54:00 | AAPL | Stock | 3.4146 | 3.4146 | 3.4143 | 3.4143 | 116480.0 |
| 2007-01-16 07:55:00 | AAPL | Stock | 3.4129 | 3.4129 | 3.4075 | 3.4075 | 58800.0 |
| 2007-01-16 07:57:00 | AAPL | Stock | 3.4125 | 3.4125 | 3.4125 | 3.4125 | 28000.0 |
| 2007-01-16 07:58:00 | AAPL | Stock | 3.4093 | 3.4096 | 3.4071 | 3.4071 | 167972.0 |
| 2007-01-16 08:00:00 | AAPL | Stock | 3.4157 | 3.4193 | 3.4075 | 3.4136 | 513436.0 |
| 2007-01-16 08:01:00 | AAPL | Stock | 3.4136 | 3.4168 | 3.4107 | 3.4143 | 332780.0 |
| 2007-01-16 08:02:00 | AAPL | Stock | 3.4107 | 3.4143 | 3.4107 | 3.4118 | 142996.0 |
| 2007-01-16 08:03:00 | AAPL | Stock | 3.4132 | 3.4143 | 3.4107 | 3.4132 | 174300.0 |
| 2007-01-16 08:04:00 | AAPL | Stock | 3.4132 | 3.4136 | 3.4111 | 3.4114 | 84560.0 |
| 2007-01-16 08:05:00 | AAPL | Stock | 3.4132 | 3.4143 | 3.4107 | 3.4129 | 118496.0 |
| 2007-01-16 08:06:00 | AAPL | Stock | 3.4129 | 3.4129 | 3.4107 | 3.4107 | 135380.0 |
| 2007-01-16 08:07:00 | AAPL | Stock | 3.4118 | 3.4125 | 3.4107 | 3.4107 | 274400.0 |
| 2007-01-16 08:08:00 | AAPL | Stock | 3.4107 | 3.4125 | 3.4107 | 3.4125 | 109760.0 |
| 2007-01-16 08:09:00 | AAPL | Stock | 3.4129 | 3.4175 | 3.4125 | 3.4175 | 179340.0 |
| 2007-01-16 08:10:00 | AAPL | Stock | 3.4161 | 3.4196 | 3.4161 | 3.4179 | 215460.0 |
| 2007-01-16 08:11:00 | AAPL | Stock | 3.4179 | 3.4193 | 3.4143 | 3.4161 | 387800.0 |
> showing 50 of 754,314 rows — these rows as CSV