PREVIEW / stock_5min / 2004-07-12
file: by_date/stock_5min/2004/2004-07-12.parquet size: 2.3 MB rows: 173,769 symbols: 1,810
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-07-12 09:05:00 | AAPL | Stock | 0.5375 | 0.5375 | 0.5375 | 0.5375 | 280000.0 |
| 2004-07-12 09:20:00 | AAPL | Stock | 0.5355 | 0.5359 | 0.5355 | 0.5359 | 27720.0 |
| 2004-07-12 09:25:00 | AAPL | Stock | 0.537 | 0.537 | 0.5363 | 0.5364 | 224000.0 |
| 2004-07-12 09:30:00 | AAPL | Stock | 0.5359 | 0.5364 | 0.5343 | 0.5355 | 7351120.0 |
| 2004-07-12 09:35:00 | AAPL | Stock | 0.5354 | 0.5357 | 0.5321 | 0.5329 | 3622584.0 |
| 2004-07-12 09:40:00 | AAPL | Stock | 0.533 | 0.5343 | 0.5321 | 0.5332 | 4161136.0 |
| 2004-07-12 09:45:00 | AAPL | Stock | 0.533 | 0.5339 | 0.5321 | 0.533 | 7446488.0 |
| 2004-07-12 09:50:00 | AAPL | Stock | 0.5332 | 0.5332 | 0.5289 | 0.5296 | 8272320.0 |
| 2004-07-12 09:55:00 | AAPL | Stock | 0.5298 | 0.5298 | 0.5279 | 0.528 | 10373832.0 |
| 2004-07-12 10:00:00 | AAPL | Stock | 0.528 | 0.5286 | 0.5271 | 0.5271 | 10498320.0 |
| 2004-07-12 10:05:00 | AAPL | Stock | 0.5271 | 0.5271 | 0.5248 | 0.5266 | 11100712.0 |
| 2004-07-12 10:10:00 | AAPL | Stock | 0.5266 | 0.5286 | 0.5266 | 0.5279 | 5347720.0 |
| 2004-07-12 10:15:00 | AAPL | Stock | 0.5277 | 0.5291 | 0.5277 | 0.5279 | 13820016.0 |
| 2004-07-12 10:20:00 | AAPL | Stock | 0.5279 | 0.5286 | 0.5264 | 0.527 | 7453376.0 |
| 2004-07-12 10:25:00 | AAPL | Stock | 0.5268 | 0.5271 | 0.5257 | 0.5264 | 8293152.0 |
| 2004-07-12 10:30:00 | AAPL | Stock | 0.5268 | 0.527 | 0.5248 | 0.525 | 9713088.0 |
| 2004-07-12 10:35:00 | AAPL | Stock | 0.5261 | 0.5261 | 0.5239 | 0.5248 | 6891864.0 |
| 2004-07-12 10:40:00 | AAPL | Stock | 0.5248 | 0.5268 | 0.5243 | 0.5261 | 3852072.0 |
| 2004-07-12 10:45:00 | AAPL | Stock | 0.5259 | 0.5266 | 0.5252 | 0.5266 | 5212424.0 |
| 2004-07-12 10:50:00 | AAPL | Stock | 0.5263 | 0.5268 | 0.5255 | 0.5255 | 3815168.0 |
| 2004-07-12 10:55:00 | AAPL | Stock | 0.5254 | 0.5271 | 0.5254 | 0.5268 | 2246048.0 |
| 2004-07-12 11:00:00 | AAPL | Stock | 0.5268 | 0.5288 | 0.5268 | 0.527 | 6160168.0 |
| 2004-07-12 11:05:00 | AAPL | Stock | 0.5268 | 0.5271 | 0.5261 | 0.5268 | 4298784.0 |
| 2004-07-12 11:10:00 | AAPL | Stock | 0.5268 | 0.5275 | 0.5259 | 0.5259 | 8363768.0 |
| 2004-07-12 11:15:00 | AAPL | Stock | 0.5257 | 0.5259 | 0.523 | 0.5234 | 8893584.0 |
| 2004-07-12 11:20:00 | AAPL | Stock | 0.5234 | 0.5257 | 0.5232 | 0.5248 | 4845904.0 |
| 2004-07-12 11:25:00 | AAPL | Stock | 0.5248 | 0.5257 | 0.5239 | 0.525 | 3946040.0 |
| 2004-07-12 11:30:00 | AAPL | Stock | 0.525 | 0.5264 | 0.525 | 0.5252 | 4811184.0 |
| 2004-07-12 11:35:00 | AAPL | Stock | 0.5254 | 0.5254 | 0.5238 | 0.5239 | 5630576.0 |
| 2004-07-12 11:40:00 | AAPL | Stock | 0.5243 | 0.5243 | 0.5236 | 0.5236 | 989912.0 |
| 2004-07-12 11:45:00 | AAPL | Stock | 0.5238 | 0.5239 | 0.5213 | 0.5214 | 11701256.0 |
| 2004-07-12 11:50:00 | AAPL | Stock | 0.5214 | 0.5218 | 0.5188 | 0.5213 | 13672176.0 |
| 2004-07-12 11:55:00 | AAPL | Stock | 0.5211 | 0.5221 | 0.5205 | 0.5216 | 14741664.0 |
| 2004-07-12 12:00:00 | AAPL | Stock | 0.5218 | 0.5218 | 0.5202 | 0.5202 | 6470856.0 |
| 2004-07-12 12:05:00 | AAPL | Stock | 0.52 | 0.5211 | 0.5195 | 0.5204 | 6656328.0 |
| 2004-07-12 12:10:00 | AAPL | Stock | 0.5204 | 0.5204 | 0.5189 | 0.5202 | 6989808.0 |
| 2004-07-12 12:15:00 | AAPL | Stock | 0.5202 | 0.5202 | 0.5189 | 0.5196 | 8291248.0 |
| 2004-07-12 12:20:00 | AAPL | Stock | 0.5196 | 0.5204 | 0.5188 | 0.5188 | 8183952.0 |
| 2004-07-12 12:25:00 | AAPL | Stock | 0.5188 | 0.5209 | 0.5188 | 0.52 | 9118032.0 |
| 2004-07-12 12:30:00 | AAPL | Stock | 0.5204 | 0.5214 | 0.52 | 0.5205 | 4454016.0 |
| 2004-07-12 12:35:00 | AAPL | Stock | 0.5207 | 0.5225 | 0.5205 | 0.5211 | 5064808.0 |
| 2004-07-12 12:40:00 | AAPL | Stock | 0.5214 | 0.5218 | 0.5205 | 0.5214 | 2166696.0 |
| 2004-07-12 12:45:00 | AAPL | Stock | 0.5216 | 0.5223 | 0.5214 | 0.5223 | 3272136.0 |
| 2004-07-12 12:50:00 | AAPL | Stock | 0.5223 | 0.5223 | 0.5216 | 0.522 | 3141488.0 |
| 2004-07-12 12:55:00 | AAPL | Stock | 0.522 | 0.5223 | 0.5214 | 0.5221 | 1547448.0 |
| 2004-07-12 13:00:00 | AAPL | Stock | 0.5223 | 0.5232 | 0.5221 | 0.5232 | 5298888.0 |
| 2004-07-12 13:05:00 | AAPL | Stock | 0.5232 | 0.5234 | 0.5213 | 0.5216 | 4743144.0 |
| 2004-07-12 13:10:00 | AAPL | Stock | 0.5216 | 0.5223 | 0.5213 | 0.5221 | 2258760.0 |
| 2004-07-12 13:15:00 | AAPL | Stock | 0.5222 | 0.5223 | 0.5214 | 0.5214 | 1205792.0 |
| 2004-07-12 13:20:00 | AAPL | Stock | 0.5213 | 0.5218 | 0.5213 | 0.5218 | 710080.0 |
> showing 50 of 173,769 rows — these rows as CSV