PREVIEW / stock_5min / 2006-12-19
file: by_date/stock_5min/2006/2006-12-19.parquet size: 3.4 MB rows: 243,670 symbols: 2,492
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-19 07:35:00 | AAPL | Stock | 3.035 | 3.0357 | 3.035 | 3.0357 | 42000.0 |
| 2006-12-19 07:40:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0446 | 3.0446 | 28000.0 |
| 2006-12-19 07:45:00 | AAPL | Stock | 3.0368 | 3.0368 | 3.0364 | 3.0364 | 42000.0 |
| 2006-12-19 07:55:00 | AAPL | Stock | 3.0379 | 3.0379 | 3.0379 | 3.0379 | 8400.0 |
| 2006-12-19 08:00:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0304 | 3.0325 | 842492.0 |
| 2006-12-19 08:05:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0268 | 3.03 | 471100.0 |
| 2006-12-19 08:10:00 | AAPL | Stock | 3.0268 | 3.0336 | 3.0268 | 3.0311 | 148540.0 |
| 2006-12-19 08:15:00 | AAPL | Stock | 3.0321 | 3.0329 | 3.0275 | 3.0286 | 186200.0 |
| 2006-12-19 08:20:00 | AAPL | Stock | 3.0286 | 3.0329 | 3.0286 | 3.0321 | 207200.0 |
| 2006-12-19 08:25:00 | AAPL | Stock | 3.0321 | 3.0364 | 3.0321 | 3.0357 | 361060.0 |
| 2006-12-19 08:30:00 | AAPL | Stock | 3.0329 | 3.0329 | 3.0286 | 3.0321 | 421036.0 |
| 2006-12-19 08:35:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0214 | 3.0214 | 420280.0 |
| 2006-12-19 08:40:00 | AAPL | Stock | 3.0214 | 3.0236 | 3.0186 | 3.02 | 538496.0 |
| 2006-12-19 08:45:00 | AAPL | Stock | 3.0211 | 3.0314 | 3.0179 | 3.0286 | 820680.0 |
| 2006-12-19 08:50:00 | AAPL | Stock | 3.0286 | 3.0304 | 3.0286 | 3.0304 | 124040.0 |
| 2006-12-19 08:55:00 | AAPL | Stock | 3.0304 | 3.0311 | 3.0268 | 3.0275 | 359184.0 |
| 2006-12-19 09:00:00 | AAPL | Stock | 3.0279 | 3.0279 | 3.0214 | 3.0232 | 747824.0 |
| 2006-12-19 09:05:00 | AAPL | Stock | 3.0218 | 3.0229 | 3.02 | 3.0218 | 241220.0 |
| 2006-12-19 09:10:00 | AAPL | Stock | 3.0218 | 3.0218 | 3.0207 | 3.0214 | 173740.0 |
| 2006-12-19 09:15:00 | AAPL | Stock | 3.0218 | 3.0268 | 3.0214 | 3.0268 | 87136.0 |
| 2006-12-19 09:20:00 | AAPL | Stock | 3.025 | 3.0257 | 3.0236 | 3.025 | 167104.0 |
| 2006-12-19 09:25:00 | AAPL | Stock | 3.0246 | 3.0268 | 3.0207 | 3.025 | 1834644.0 |
| 2006-12-19 09:30:00 | AAPL | Stock | 3.0261 | 3.0275 | 3.0036 | 3.0157 | 34993364.0 |
| 2006-12-19 09:35:00 | AAPL | Stock | 3.0154 | 3.0193 | 2.9889 | 2.9893 | 24988656.0 |
| 2006-12-19 09:40:00 | AAPL | Stock | 2.9896 | 3.0032 | 2.9864 | 2.9914 | 27721512.0 |
| 2006-12-19 09:45:00 | AAPL | Stock | 2.9918 | 3.0071 | 2.9907 | 3.0068 | 18288760.0 |
| 2006-12-19 09:50:00 | AAPL | Stock | 3.0071 | 3.0264 | 3.005 | 3.0254 | 23196656.0 |
| 2006-12-19 09:55:00 | AAPL | Stock | 3.0257 | 3.03 | 3.0196 | 3.0239 | 19177424.0 |
| 2006-12-19 10:00:00 | AAPL | Stock | 3.0239 | 3.0343 | 3.0232 | 3.0332 | 19624500.0 |
| 2006-12-19 10:05:00 | AAPL | Stock | 3.0332 | 3.0525 | 3.0239 | 3.0454 | 27673044.0 |
| 2006-12-19 10:10:00 | AAPL | Stock | 3.0461 | 3.0636 | 3.0425 | 3.0629 | 23498916.0 |
| 2006-12-19 10:15:00 | AAPL | Stock | 3.0625 | 3.0646 | 3.0239 | 3.0536 | 22772400.0 |
| 2006-12-19 10:20:00 | AAPL | Stock | 3.0529 | 3.0568 | 3.0468 | 3.0527 | 13689704.0 |
| 2006-12-19 10:25:00 | AAPL | Stock | 3.0529 | 3.0596 | 3.0493 | 3.0525 | 11625852.0 |
| 2006-12-19 10:30:00 | AAPL | Stock | 3.0521 | 3.0529 | 3.0439 | 3.0464 | 8341816.0 |
| 2006-12-19 10:35:00 | AAPL | Stock | 3.0464 | 3.0518 | 3.0429 | 3.045 | 8841700.0 |
| 2006-12-19 10:40:00 | AAPL | Stock | 3.0446 | 3.045 | 3.0329 | 3.0339 | 17988068.0 |
| 2006-12-19 10:45:00 | AAPL | Stock | 3.0339 | 3.0396 | 3.0329 | 3.0357 | 10750544.0 |
| 2006-12-19 10:50:00 | AAPL | Stock | 3.0361 | 3.0493 | 3.035 | 3.0446 | 13437340.0 |
| 2006-12-19 10:55:00 | AAPL | Stock | 3.0446 | 3.0589 | 3.0421 | 3.0586 | 19803084.0 |
| 2006-12-19 11:00:00 | AAPL | Stock | 3.0579 | 3.0707 | 3.055 | 3.065 | 22041992.0 |
| 2006-12-19 11:05:00 | AAPL | Stock | 3.065 | 3.0654 | 3.0582 | 3.0589 | 10464580.0 |
| 2006-12-19 11:10:00 | AAPL | Stock | 3.0586 | 3.0632 | 3.0539 | 3.0546 | 7304640.0 |
| 2006-12-19 11:15:00 | AAPL | Stock | 3.0546 | 3.0593 | 3.0486 | 3.0496 | 12177004.0 |
| 2006-12-19 11:20:00 | AAPL | Stock | 3.0496 | 3.0529 | 3.0471 | 3.0482 | 7243404.0 |
| 2006-12-19 11:25:00 | AAPL | Stock | 3.0482 | 3.05 | 3.04 | 3.045 | 10553536.0 |
| 2006-12-19 11:30:00 | AAPL | Stock | 3.045 | 3.0486 | 3.0436 | 3.0482 | 6436864.0 |
| 2006-12-19 11:35:00 | AAPL | Stock | 3.0486 | 3.0529 | 3.0429 | 3.0529 | 7559076.0 |
| 2006-12-19 11:40:00 | AAPL | Stock | 3.0529 | 3.0568 | 3.0518 | 3.0557 | 7110152.0 |
| 2006-12-19 11:45:00 | AAPL | Stock | 3.0557 | 3.0596 | 3.045 | 3.0589 | 6666128.0 |
> showing 50 of 243,670 rows — these rows as CSV