PREVIEW / stock_5min / 2006-11-16
file: by_date/stock_5min/2006/2006-11-16.parquet size: 3.3 MB rows: 238,766 symbols: 2,444
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-11-16 04:25:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0214 | 3.0214 | 2800.0 |
| 2006-11-16 07:10:00 | AAPL | Stock | 3.0189 | 3.0214 | 3.0179 | 3.0214 | 22792.0 |
| 2006-11-16 07:15:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 2800.0 |
| 2006-11-16 07:20:00 | AAPL | Stock | 3.0282 | 3.0282 | 3.0282 | 3.0282 | 14000.0 |
| 2006-11-16 07:25:00 | AAPL | Stock | 3.0279 | 3.0279 | 3.0279 | 3.0279 | 24920.0 |
| 2006-11-16 07:30:00 | AAPL | Stock | 3.0286 | 3.035 | 3.0286 | 3.035 | 22400.0 |
| 2006-11-16 07:40:00 | AAPL | Stock | 3.0254 | 3.0254 | 3.0254 | 3.0254 | 5600.0 |
| 2006-11-16 07:45:00 | AAPL | Stock | 3.0246 | 3.0246 | 3.0246 | 3.0246 | 2800.0 |
| 2006-11-16 07:50:00 | AAPL | Stock | 3.0214 | 3.025 | 3.0204 | 3.025 | 50120.0 |
| 2006-11-16 07:55:00 | AAPL | Stock | 3.0221 | 3.0221 | 3.0214 | 3.0214 | 106400.0 |
| 2006-11-16 08:00:00 | AAPL | Stock | 3.0214 | 3.0257 | 3.0179 | 3.0257 | 1073744.0 |
| 2006-11-16 08:05:00 | AAPL | Stock | 3.0268 | 3.0279 | 3.0246 | 3.0271 | 207900.0 |
| 2006-11-16 08:10:00 | AAPL | Stock | 3.0239 | 3.0243 | 3.0204 | 3.0243 | 279720.0 |
| 2006-11-16 08:15:00 | AAPL | Stock | 3.0243 | 3.025 | 3.0232 | 3.025 | 83468.0 |
| 2006-11-16 08:20:00 | AAPL | Stock | 3.0264 | 3.0275 | 3.025 | 3.0268 | 216300.0 |
| 2006-11-16 08:25:00 | AAPL | Stock | 3.0268 | 3.0268 | 3.0239 | 3.0239 | 204820.0 |
| 2006-11-16 08:30:00 | AAPL | Stock | 3.025 | 3.0336 | 3.0246 | 3.0304 | 1557500.0 |
| 2006-11-16 08:35:00 | AAPL | Stock | 3.0304 | 3.0336 | 3.0286 | 3.0321 | 527520.0 |
| 2006-11-16 08:40:00 | AAPL | Stock | 3.0307 | 3.0307 | 3.0268 | 3.0268 | 211680.0 |
| 2006-11-16 08:45:00 | AAPL | Stock | 3.0268 | 3.0321 | 3.0268 | 3.0321 | 377636.0 |
| 2006-11-16 08:50:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0289 | 3.0289 | 254716.0 |
| 2006-11-16 08:55:00 | AAPL | Stock | 3.0289 | 3.0304 | 3.0286 | 3.0286 | 321496.0 |
| 2006-11-16 09:00:00 | AAPL | Stock | 3.0286 | 3.03 | 3.0268 | 3.0282 | 82040.0 |
| 2006-11-16 09:05:00 | AAPL | Stock | 3.0304 | 3.0311 | 3.0271 | 3.0286 | 183400.0 |
| 2006-11-16 09:10:00 | AAPL | Stock | 3.0271 | 3.0271 | 3.025 | 3.0268 | 140000.0 |
| 2006-11-16 09:15:00 | AAPL | Stock | 3.0254 | 3.0286 | 3.0229 | 3.0286 | 350840.0 |
| 2006-11-16 09:20:00 | AAPL | Stock | 3.0275 | 3.0286 | 3.025 | 3.025 | 146720.0 |
| 2006-11-16 09:25:00 | AAPL | Stock | 3.0261 | 3.0321 | 3.0261 | 3.0321 | 1689464.0 |
| 2006-11-16 09:30:00 | AAPL | Stock | 3.0311 | 3.0321 | 3.0221 | 3.0261 | 21087612.0 |
| 2006-11-16 09:35:00 | AAPL | Stock | 3.0257 | 3.0354 | 3.025 | 3.0346 | 13980876.0 |
| 2006-11-16 09:40:00 | AAPL | Stock | 3.0346 | 3.0429 | 3.0268 | 3.0271 | 21166544.0 |
| 2006-11-16 09:45:00 | AAPL | Stock | 3.0275 | 3.0304 | 3.0236 | 3.0289 | 14031500.0 |
| 2006-11-16 09:50:00 | AAPL | Stock | 3.0289 | 3.0393 | 3.0275 | 3.0375 | 8900780.0 |
| 2006-11-16 09:55:00 | AAPL | Stock | 3.0375 | 3.0425 | 3.0371 | 3.0414 | 16317000.0 |
| 2006-11-16 10:00:00 | AAPL | Stock | 3.0411 | 3.0418 | 3.0329 | 3.0354 | 8628704.0 |
| 2006-11-16 10:05:00 | AAPL | Stock | 3.0357 | 3.0375 | 3.0325 | 3.0357 | 7994000.0 |
| 2006-11-16 10:10:00 | AAPL | Stock | 3.0357 | 3.0411 | 3.035 | 3.0411 | 8085952.0 |
| 2006-11-16 10:15:00 | AAPL | Stock | 3.0407 | 3.0489 | 3.0404 | 3.0486 | 15326668.0 |
| 2006-11-16 10:20:00 | AAPL | Stock | 3.0487 | 3.0518 | 3.0443 | 3.0507 | 10324804.0 |
| 2006-11-16 10:25:00 | AAPL | Stock | 3.0511 | 3.0514 | 3.045 | 3.0492 | 6552056.0 |
| 2006-11-16 10:30:00 | AAPL | Stock | 3.0496 | 3.0568 | 3.0468 | 3.0561 | 13321672.0 |
| 2006-11-16 10:35:00 | AAPL | Stock | 3.0561 | 3.06 | 3.0554 | 3.0557 | 13367032.0 |
| 2006-11-16 10:40:00 | AAPL | Stock | 3.0561 | 3.0575 | 3.055 | 3.055 | 10609396.0 |
| 2006-11-16 10:45:00 | AAPL | Stock | 3.0546 | 3.0589 | 3.0475 | 3.0482 | 9995244.0 |
| 2006-11-16 10:50:00 | AAPL | Stock | 3.0482 | 3.0496 | 3.0421 | 3.0457 | 11948188.0 |
| 2006-11-16 10:55:00 | AAPL | Stock | 3.0454 | 3.0486 | 3.0393 | 3.0471 | 7081956.0 |
| 2006-11-16 11:00:00 | AAPL | Stock | 3.0471 | 3.0496 | 3.0429 | 3.0457 | 4958296.0 |
| 2006-11-16 11:05:00 | AAPL | Stock | 3.0461 | 3.0518 | 3.0446 | 3.0511 | 5202008.0 |
| 2006-11-16 11:10:00 | AAPL | Stock | 3.0511 | 3.0514 | 3.0461 | 3.0493 | 5233004.0 |
| 2006-11-16 11:15:00 | AAPL | Stock | 3.05 | 3.0514 | 3.0436 | 3.0436 | 4775624.0 |
> showing 50 of 238,766 rows — these rows as CSV