PREVIEW / stock_5min / 2006-12-21
file: by_date/stock_5min/2006/2006-12-21.parquet size: 3.3 MB rows: 240,072 symbols: 2,482
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 |
|---|---|---|---|---|---|---|---|
| 2006-12-21 07:05:00 | AAPL | Stock | 3.0071 | 3.0389 | 2.9821 | 3.0389 | 18200.0 |
| 2006-12-21 07:45:00 | AAPL | Stock | 3.0364 | 3.0364 | 3.0339 | 3.0339 | 11200.0 |
| 2006-12-21 07:50:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 2800.0 |
| 2006-12-21 07:55:00 | AAPL | Stock | 3.0318 | 3.0318 | 3.0318 | 3.0318 | 2800.0 |
| 2006-12-21 08:00:00 | AAPL | Stock | 3.0318 | 3.0321 | 3.03 | 3.0311 | 124600.0 |
| 2006-12-21 08:05:00 | AAPL | Stock | 3.0311 | 3.0321 | 3.0286 | 3.0321 | 89600.0 |
| 2006-12-21 08:10:00 | AAPL | Stock | 3.0321 | 3.0354 | 3.0321 | 3.0343 | 163240.0 |
| 2006-12-21 08:15:00 | AAPL | Stock | 3.0354 | 3.0357 | 3.0304 | 3.0354 | 86940.0 |
| 2006-12-21 08:20:00 | AAPL | Stock | 3.0339 | 3.0354 | 3.0286 | 3.0286 | 77392.0 |
| 2006-12-21 08:25:00 | AAPL | Stock | 3.0325 | 3.0336 | 3.0325 | 3.0336 | 35000.0 |
| 2006-12-21 08:30:00 | AAPL | Stock | 3.0321 | 3.0339 | 3.0286 | 3.03 | 241976.0 |
| 2006-12-21 08:35:00 | AAPL | Stock | 3.0296 | 3.0321 | 3.0286 | 3.0304 | 249340.0 |
| 2006-12-21 08:40:00 | AAPL | Stock | 3.0289 | 3.0307 | 3.0289 | 3.0289 | 28000.0 |
| 2006-12-21 08:45:00 | AAPL | Stock | 3.0289 | 3.0293 | 3.0289 | 3.0293 | 14000.0 |
| 2006-12-21 08:50:00 | AAPL | Stock | 3.03 | 3.03 | 3.0243 | 3.0243 | 96852.0 |
| 2006-12-21 09:00:00 | AAPL | Stock | 3.0275 | 3.0275 | 3.025 | 3.0257 | 112000.0 |
| 2006-12-21 09:05:00 | AAPL | Stock | 3.0257 | 3.0257 | 3.025 | 3.0254 | 44800.0 |
| 2006-12-21 09:10:00 | AAPL | Stock | 3.0257 | 3.0261 | 3.0254 | 3.0254 | 142240.0 |
| 2006-12-21 09:20:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0268 | 3.0271 | 66500.0 |
| 2006-12-21 09:25:00 | AAPL | Stock | 3.025 | 3.0271 | 3.025 | 3.0268 | 192220.0 |
| 2006-12-21 09:30:00 | AAPL | Stock | 3.0249 | 3.05 | 3.0114 | 3.0411 | 23140656.0 |
| 2006-12-21 09:35:00 | AAPL | Stock | 3.0407 | 3.0529 | 3.0404 | 3.0443 | 15974280.0 |
| 2006-12-21 09:40:00 | AAPL | Stock | 3.0443 | 3.0448 | 3.0268 | 3.0275 | 14014560.0 |
| 2006-12-21 09:45:00 | AAPL | Stock | 3.0275 | 3.0386 | 3.0232 | 3.0368 | 12504520.0 |
| 2006-12-21 09:50:00 | AAPL | Stock | 3.0368 | 3.0414 | 3.0293 | 3.0396 | 10249372.0 |
| 2006-12-21 09:55:00 | AAPL | Stock | 3.0386 | 3.0425 | 3.0332 | 3.0357 | 9905224.0 |
| 2006-12-21 10:00:00 | AAPL | Stock | 3.0357 | 3.0429 | 3.0307 | 3.039 | 10147592.0 |
| 2006-12-21 10:05:00 | AAPL | Stock | 3.0404 | 3.0404 | 3.0332 | 3.0354 | 8183000.0 |
| 2006-12-21 10:10:00 | AAPL | Stock | 3.0354 | 3.0393 | 3.0336 | 3.0354 | 8534456.0 |
| 2006-12-21 10:15:00 | AAPL | Stock | 3.0354 | 3.0371 | 3.0257 | 3.0286 | 9542848.0 |
| 2006-12-21 10:20:00 | AAPL | Stock | 3.0282 | 3.0339 | 3.0271 | 3.03 | 8080128.0 |
| 2006-12-21 10:25:00 | AAPL | Stock | 3.03 | 3.0393 | 3.0271 | 3.035 | 10202304.0 |
| 2006-12-21 10:30:00 | AAPL | Stock | 3.035 | 3.0382 | 3.0307 | 3.0339 | 4678772.0 |
| 2006-12-21 10:35:00 | AAPL | Stock | 3.0339 | 3.0357 | 3.0296 | 3.0307 | 3790220.0 |
| 2006-12-21 10:40:00 | AAPL | Stock | 3.0311 | 3.0357 | 3.0286 | 3.0343 | 4827620.0 |
| 2006-12-21 10:45:00 | AAPL | Stock | 3.0343 | 3.0379 | 3.0268 | 3.0279 | 8081276.0 |
| 2006-12-21 10:50:00 | AAPL | Stock | 3.0275 | 3.0279 | 3.0164 | 3.0182 | 10321780.0 |
| 2006-12-21 10:55:00 | AAPL | Stock | 3.0189 | 3.0218 | 3.0132 | 3.0161 | 9681672.0 |
| 2006-12-21 11:00:00 | AAPL | Stock | 3.0161 | 3.0179 | 3.0057 | 3.0066 | 12202708.0 |
| 2006-12-21 11:05:00 | AAPL | Stock | 3.0064 | 3.0114 | 3.0014 | 3.0107 | 15773072.0 |
| 2006-12-21 11:10:00 | AAPL | Stock | 3.0107 | 3.0161 | 3.0086 | 3.0146 | 7516348.0 |
| 2006-12-21 11:15:00 | AAPL | Stock | 3.0146 | 3.02 | 3.0114 | 3.0176 | 6019076.0 |
| 2006-12-21 11:20:00 | AAPL | Stock | 3.0182 | 3.0243 | 3.0175 | 3.0229 | 6863836.0 |
| 2006-12-21 11:25:00 | AAPL | Stock | 3.0225 | 3.0246 | 3.0182 | 3.0225 | 9378768.0 |
| 2006-12-21 11:30:00 | AAPL | Stock | 3.0225 | 3.0236 | 3.0193 | 3.0203 | 3283560.0 |
| 2006-12-21 11:35:00 | AAPL | Stock | 3.0204 | 3.0243 | 3.0189 | 3.0214 | 4931164.0 |
| 2006-12-21 11:40:00 | AAPL | Stock | 3.0214 | 3.0321 | 3.02 | 3.0307 | 9117976.0 |
| 2006-12-21 11:45:00 | AAPL | Stock | 3.0311 | 3.0325 | 3.0257 | 3.0318 | 5791296.0 |
| 2006-12-21 11:50:00 | AAPL | Stock | 3.0317 | 3.0318 | 3.0236 | 3.0279 | 5726336.0 |
| 2006-12-21 11:55:00 | AAPL | Stock | 3.0286 | 3.0293 | 3.0239 | 3.0257 | 3797892.0 |
> showing 50 of 240,072 rows — these rows as CSV