PREVIEW / stock_5min / 2006-01-12
file: by_date/stock_5min/2006/2006-01-12.parquet size: 3.0 MB rows: 214,393 symbols: 2,160
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-01-12 04:25:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 2800.0 |
| 2006-01-12 04:30:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 5600.0 |
| 2006-01-12 05:20:00 | AAPL | Stock | 3.0268 | 3.0268 | 3.0268 | 3.0268 | 14000.0 |
| 2006-01-12 05:25:00 | AAPL | Stock | 3.0279 | 3.0286 | 3.0279 | 3.0286 | 61600.0 |
| 2006-01-12 05:40:00 | AAPL | Stock | 3.0354 | 3.0357 | 3.0354 | 3.0357 | 53900.0 |
| 2006-01-12 05:50:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 2800.0 |
| 2006-01-12 05:55:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0314 | 3.0357 | 35700.0 |
| 2006-01-12 06:20:00 | AAPL | Stock | 3.0375 | 3.0429 | 3.0375 | 3.0429 | 92400.0 |
| 2006-01-12 06:25:00 | AAPL | Stock | 3.0625 | 3.0625 | 3.0621 | 3.0621 | 25200.0 |
| 2006-01-12 06:30:00 | AAPL | Stock | 3.0482 | 3.0571 | 3.0482 | 3.0571 | 19600.0 |
| 2006-01-12 06:35:00 | AAPL | Stock | 3.0571 | 3.0571 | 3.0525 | 3.0525 | 5600.0 |
| 2006-01-12 06:40:00 | AAPL | Stock | 3.0525 | 3.0525 | 3.0525 | 3.0525 | 2800.0 |
| 2006-01-12 06:45:00 | AAPL | Stock | 3.0525 | 3.0525 | 3.0446 | 3.0446 | 44800.0 |
| 2006-01-12 06:50:00 | AAPL | Stock | 3.0461 | 3.0461 | 3.0461 | 3.0461 | 5600.0 |
| 2006-01-12 06:55:00 | AAPL | Stock | 3.0496 | 3.0496 | 3.0446 | 3.0446 | 22400.0 |
| 2006-01-12 07:00:00 | AAPL | Stock | 3.0379 | 3.0446 | 3.0357 | 3.0421 | 448000.0 |
| 2006-01-12 07:10:00 | AAPL | Stock | 3.0425 | 3.0425 | 3.0314 | 3.0339 | 179200.0 |
| 2006-01-12 07:15:00 | AAPL | Stock | 3.0321 | 3.0357 | 3.0286 | 3.0286 | 174216.0 |
| 2006-01-12 07:20:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 2800.0 |
| 2006-01-12 07:25:00 | AAPL | Stock | 3.0339 | 3.0357 | 3.0339 | 3.0357 | 61600.0 |
| 2006-01-12 07:35:00 | AAPL | Stock | 3.03 | 3.03 | 3.0289 | 3.0289 | 32676.0 |
| 2006-01-12 07:40:00 | AAPL | Stock | 3.0289 | 3.0289 | 3.0286 | 3.0286 | 66584.0 |
| 2006-01-12 07:45:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0232 | 3.0286 | 73416.0 |
| 2006-01-12 07:50:00 | AAPL | Stock | 3.025 | 3.0332 | 3.025 | 3.0329 | 43960.0 |
| 2006-01-12 07:55:00 | AAPL | Stock | 3.0325 | 3.0332 | 3.0321 | 3.0321 | 173600.0 |
| 2006-01-12 08:00:00 | AAPL | Stock | 3.0339 | 3.0529 | 3.0321 | 3.0511 | 6784176.0 |
| 2006-01-12 08:05:00 | AAPL | Stock | 3.0518 | 3.0607 | 3.0446 | 3.0568 | 3927840.0 |
| 2006-01-12 08:10:00 | AAPL | Stock | 3.0575 | 3.0575 | 3.0482 | 3.0486 | 1937124.0 |
| 2006-01-12 08:15:00 | AAPL | Stock | 3.0493 | 3.0564 | 3.0493 | 3.0514 | 1101632.0 |
| 2006-01-12 08:20:00 | AAPL | Stock | 3.0514 | 3.0529 | 3.05 | 3.0511 | 637644.0 |
| 2006-01-12 08:25:00 | AAPL | Stock | 3.0504 | 3.0511 | 3.0446 | 3.0457 | 1080072.0 |
| 2006-01-12 08:30:00 | AAPL | Stock | 3.0464 | 3.0464 | 3.0357 | 3.0382 | 1163932.0 |
| 2006-01-12 08:35:00 | AAPL | Stock | 3.0386 | 3.0443 | 3.0386 | 3.0421 | 986636.0 |
| 2006-01-12 08:40:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.035 | 3.0354 | 1811992.0 |
| 2006-01-12 08:45:00 | AAPL | Stock | 3.0354 | 3.0411 | 3.0318 | 3.0411 | 2074772.0 |
| 2006-01-12 08:50:00 | AAPL | Stock | 3.0354 | 3.0357 | 3.0293 | 3.0304 | 650048.0 |
| 2006-01-12 08:55:00 | AAPL | Stock | 3.0304 | 3.0343 | 3.0275 | 3.0304 | 1128036.0 |
| 2006-01-12 09:00:00 | AAPL | Stock | 3.0307 | 3.0321 | 3.0232 | 3.0232 | 1305472.0 |
| 2006-01-12 09:05:00 | AAPL | Stock | 3.0225 | 3.0304 | 3.0182 | 3.0246 | 2376192.0 |
| 2006-01-12 09:10:00 | AAPL | Stock | 3.025 | 3.0321 | 3.0229 | 3.0321 | 1472296.0 |
| 2006-01-12 09:15:00 | AAPL | Stock | 3.0332 | 3.035 | 3.0246 | 3.0311 | 1060472.0 |
| 2006-01-12 09:20:00 | AAPL | Stock | 3.0311 | 3.0339 | 3.0271 | 3.0286 | 807884.0 |
| 2006-01-12 09:25:00 | AAPL | Stock | 3.0286 | 3.0361 | 3.0225 | 3.0346 | 6005188.0 |
| 2006-01-12 09:30:00 | AAPL | Stock | 3.0346 | 3.0396 | 3.02 | 3.0236 | 56955528.0 |
| 2006-01-12 09:35:00 | AAPL | Stock | 3.0243 | 3.0393 | 3.0125 | 3.0254 | 35700140.0 |
| 2006-01-12 09:40:00 | AAPL | Stock | 3.0254 | 3.0346 | 3.0246 | 3.0268 | 21126924.0 |
| 2006-01-12 09:45:00 | AAPL | Stock | 3.027 | 3.0332 | 3.0236 | 3.0275 | 17709048.0 |
| 2006-01-12 09:50:00 | AAPL | Stock | 3.0275 | 3.0454 | 3.0179 | 3.0429 | 27993840.0 |
| 2006-01-12 09:55:00 | AAPL | Stock | 3.0425 | 3.0496 | 3.0393 | 3.0496 | 23926756.0 |
| 2006-01-12 10:00:00 | AAPL | Stock | 3.0493 | 3.0564 | 3.0454 | 3.0482 | 30439780.0 |
> showing 50 of 214,393 rows — these rows as CSV