PREVIEW / stock_5min / 2004-01-12
file: by_date/stock_5min/2004/2004-01-12.parquet size: 2.4 MB rows: 173,088 symbols: 1,713
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-12 08:05:00 | AAPL | Stock | 0.4155 | 0.4155 | 0.4155 | 0.4155 | 50400.0 |
| 2004-01-12 08:10:00 | AAPL | Stock | 0.4191 | 0.4191 | 0.4134 | 0.4134 | 72800.0 |
| 2004-01-12 08:15:00 | AAPL | Stock | 0.4191 | 0.4191 | 0.4191 | 0.4191 | 100800.0 |
| 2004-01-12 08:20:00 | AAPL | Stock | 0.4191 | 0.4191 | 0.4191 | 0.4191 | 95200.0 |
| 2004-01-12 08:25:00 | AAPL | Stock | 0.417 | 0.417 | 0.417 | 0.417 | 11200.0 |
| 2004-01-12 08:30:00 | AAPL | Stock | 0.4189 | 0.4191 | 0.4189 | 0.4191 | 50400.0 |
| 2004-01-12 08:35:00 | AAPL | Stock | 0.4179 | 0.4196 | 0.4179 | 0.4196 | 196000.0 |
| 2004-01-12 08:50:00 | AAPL | Stock | 0.4177 | 0.4177 | 0.4177 | 0.4177 | 28000.0 |
| 2004-01-12 09:00:00 | AAPL | Stock | 0.417 | 0.417 | 0.417 | 0.417 | 72800.0 |
| 2004-01-12 09:05:00 | AAPL | Stock | 0.4163 | 0.4163 | 0.4109 | 0.4109 | 1607200.0 |
| 2004-01-12 09:10:00 | AAPL | Stock | 0.4136 | 0.4136 | 0.4136 | 0.4136 | 28000.0 |
| 2004-01-12 09:15:00 | AAPL | Stock | 0.4136 | 0.4136 | 0.4134 | 0.4136 | 89600.0 |
| 2004-01-12 09:20:00 | AAPL | Stock | 0.4146 | 0.4152 | 0.4146 | 0.4152 | 140000.0 |
| 2004-01-12 09:25:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4134 | 0.4152 | 1092000.0 |
| 2004-01-12 09:30:00 | AAPL | Stock | 0.4138 | 0.4182 | 0.4125 | 0.4163 | 12187056.0 |
| 2004-01-12 09:35:00 | AAPL | Stock | 0.4166 | 0.417 | 0.4155 | 0.4163 | 8516872.0 |
| 2004-01-12 09:40:00 | AAPL | Stock | 0.4163 | 0.4163 | 0.4148 | 0.4148 | 3774848.0 |
| 2004-01-12 09:45:00 | AAPL | Stock | 0.4148 | 0.4157 | 0.4146 | 0.415 | 3275216.0 |
| 2004-01-12 09:50:00 | AAPL | Stock | 0.415 | 0.4154 | 0.4138 | 0.4145 | 9461760.0 |
| 2004-01-12 09:55:00 | AAPL | Stock | 0.4152 | 0.4161 | 0.4145 | 0.4161 | 8275176.0 |
| 2004-01-12 10:00:00 | AAPL | Stock | 0.4161 | 0.4163 | 0.4154 | 0.4154 | 15480976.0 |
| 2004-01-12 10:05:00 | AAPL | Stock | 0.4154 | 0.417 | 0.4152 | 0.4164 | 20663216.0 |
| 2004-01-12 10:10:00 | AAPL | Stock | 0.4168 | 0.418 | 0.4166 | 0.4177 | 6544776.0 |
| 2004-01-12 10:15:00 | AAPL | Stock | 0.4175 | 0.419 | 0.4175 | 0.4189 | 10110184.0 |
| 2004-01-12 10:20:00 | AAPL | Stock | 0.4189 | 0.4214 | 0.4183 | 0.4205 | 26091184.0 |
| 2004-01-12 10:25:00 | AAPL | Stock | 0.4205 | 0.4241 | 0.4205 | 0.4238 | 20284152.0 |
| 2004-01-12 10:30:00 | AAPL | Stock | 0.4238 | 0.425 | 0.4236 | 0.4245 | 13966400.0 |
| 2004-01-12 10:35:00 | AAPL | Stock | 0.4245 | 0.4245 | 0.423 | 0.423 | 7063952.0 |
| 2004-01-12 10:40:00 | AAPL | Stock | 0.423 | 0.4238 | 0.4227 | 0.4236 | 7232344.0 |
| 2004-01-12 10:45:00 | AAPL | Stock | 0.4236 | 0.4241 | 0.423 | 0.4231 | 7094920.0 |
| 2004-01-12 10:50:00 | AAPL | Stock | 0.4232 | 0.4234 | 0.4223 | 0.4234 | 5747672.0 |
| 2004-01-12 10:55:00 | AAPL | Stock | 0.4234 | 0.425 | 0.4229 | 0.4238 | 5993568.0 |
| 2004-01-12 11:00:00 | AAPL | Stock | 0.4241 | 0.4248 | 0.4241 | 0.4245 | 4126920.0 |
| 2004-01-12 11:05:00 | AAPL | Stock | 0.4245 | 0.4245 | 0.4216 | 0.4232 | 5790400.0 |
| 2004-01-12 11:10:00 | AAPL | Stock | 0.4232 | 0.4241 | 0.423 | 0.4241 | 2627856.0 |
| 2004-01-12 11:15:00 | AAPL | Stock | 0.4239 | 0.4241 | 0.4238 | 0.4239 | 2778776.0 |
| 2004-01-12 11:20:00 | AAPL | Stock | 0.4239 | 0.4241 | 0.4234 | 0.4237 | 2804424.0 |
| 2004-01-12 11:25:00 | AAPL | Stock | 0.4234 | 0.4238 | 0.423 | 0.4232 | 2343096.0 |
| 2004-01-12 11:30:00 | AAPL | Stock | 0.423 | 0.4234 | 0.423 | 0.423 | 2759008.0 |
| 2004-01-12 11:35:00 | AAPL | Stock | 0.4232 | 0.4232 | 0.4225 | 0.423 | 2616096.0 |
| 2004-01-12 11:40:00 | AAPL | Stock | 0.4232 | 0.4232 | 0.4225 | 0.4232 | 5189072.0 |
| 2004-01-12 11:45:00 | AAPL | Stock | 0.4232 | 0.4236 | 0.4229 | 0.4232 | 3715600.0 |
| 2004-01-12 11:50:00 | AAPL | Stock | 0.4231 | 0.4234 | 0.4227 | 0.4234 | 11412240.0 |
| 2004-01-12 11:55:00 | AAPL | Stock | 0.4236 | 0.4243 | 0.4234 | 0.4239 | 3572408.0 |
| 2004-01-12 12:00:00 | AAPL | Stock | 0.4241 | 0.4248 | 0.4239 | 0.4248 | 2880080.0 |
| 2004-01-12 12:05:00 | AAPL | Stock | 0.4248 | 0.425 | 0.4245 | 0.4246 | 3077536.0 |
| 2004-01-12 12:10:00 | AAPL | Stock | 0.4246 | 0.4246 | 0.4245 | 0.4246 | 981232.0 |
| 2004-01-12 12:15:00 | AAPL | Stock | 0.4245 | 0.425 | 0.4241 | 0.4246 | 1779456.0 |
| 2004-01-12 12:20:00 | AAPL | Stock | 0.4246 | 0.425 | 0.4241 | 0.4248 | 2339232.0 |
| 2004-01-12 12:25:00 | AAPL | Stock | 0.4248 | 0.4255 | 0.4248 | 0.4252 | 4003216.0 |
> showing 50 of 173,088 rows — these rows as CSV