PREVIEW / stock_5min / 2006-10-04
file: by_date/stock_5min/2006/2006-10-04.parquet size: 3.2 MB rows: 233,421 symbols: 2,397
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-10-04 08:00:00 | AAPL | Stock | 2.6532 | 2.6532 | 2.6532 | 2.6532 | 28000.0 |
| 2006-10-04 08:05:00 | AAPL | Stock | 2.6539 | 2.6586 | 2.65 | 2.6586 | 135800.0 |
| 2006-10-04 08:10:00 | AAPL | Stock | 2.6536 | 2.6554 | 2.6536 | 2.6554 | 105000.0 |
| 2006-10-04 08:15:00 | AAPL | Stock | 2.6554 | 2.6554 | 2.6493 | 2.6493 | 101080.0 |
| 2006-10-04 08:20:00 | AAPL | Stock | 2.6507 | 2.6521 | 2.6507 | 2.6521 | 77448.0 |
| 2006-10-04 08:25:00 | AAPL | Stock | 2.65 | 2.65 | 2.65 | 2.65 | 14000.0 |
| 2006-10-04 08:30:00 | AAPL | Stock | 2.6518 | 2.6521 | 2.6518 | 2.6521 | 59332.0 |
| 2006-10-04 08:35:00 | AAPL | Stock | 2.6521 | 2.6521 | 2.65 | 2.65 | 59220.0 |
| 2006-10-04 08:40:00 | AAPL | Stock | 2.65 | 2.6568 | 2.65 | 2.6536 | 76104.0 |
| 2006-10-04 08:45:00 | AAPL | Stock | 2.6561 | 2.6561 | 2.6536 | 2.6536 | 61600.0 |
| 2006-10-04 08:50:00 | AAPL | Stock | 2.655 | 2.6554 | 2.6536 | 2.6536 | 64400.0 |
| 2006-10-04 08:55:00 | AAPL | Stock | 2.6536 | 2.6543 | 2.6536 | 2.6536 | 35000.0 |
| 2006-10-04 09:00:00 | AAPL | Stock | 2.6536 | 2.6536 | 2.6532 | 2.6532 | 34440.0 |
| 2006-10-04 09:05:00 | AAPL | Stock | 2.6518 | 2.6521 | 2.65 | 2.65 | 61460.0 |
| 2006-10-04 09:10:00 | AAPL | Stock | 2.6504 | 2.6525 | 2.65 | 2.6525 | 72800.0 |
| 2006-10-04 09:15:00 | AAPL | Stock | 2.65 | 2.65 | 2.6464 | 2.6464 | 162848.0 |
| 2006-10-04 09:20:00 | AAPL | Stock | 2.6486 | 2.6486 | 2.6446 | 2.6464 | 179200.0 |
| 2006-10-04 09:25:00 | AAPL | Stock | 2.6446 | 2.6464 | 2.6386 | 2.6464 | 597156.0 |
| 2006-10-04 09:30:00 | AAPL | Stock | 2.6464 | 2.6475 | 2.6286 | 2.631 | 17430308.0 |
| 2006-10-04 09:35:00 | AAPL | Stock | 2.631 | 2.6354 | 2.6257 | 2.6354 | 14746256.0 |
| 2006-10-04 09:40:00 | AAPL | Stock | 2.635 | 2.6354 | 2.6232 | 2.6271 | 13659464.0 |
| 2006-10-04 09:45:00 | AAPL | Stock | 2.6268 | 2.6361 | 2.6261 | 2.6296 | 11818016.0 |
| 2006-10-04 09:50:00 | AAPL | Stock | 2.63 | 2.6314 | 2.6196 | 2.6214 | 20798064.0 |
| 2006-10-04 09:55:00 | AAPL | Stock | 2.6214 | 2.6246 | 2.6157 | 2.6164 | 10771376.0 |
| 2006-10-04 10:00:00 | AAPL | Stock | 2.6161 | 2.6243 | 2.6129 | 2.6229 | 17861732.0 |
| 2006-10-04 10:05:00 | AAPL | Stock | 2.6225 | 2.6268 | 2.6179 | 2.6257 | 11029676.0 |
| 2006-10-04 10:10:00 | AAPL | Stock | 2.625 | 2.635 | 2.6221 | 2.6329 | 15659952.0 |
| 2006-10-04 10:15:00 | AAPL | Stock | 2.6329 | 2.6429 | 2.6311 | 2.6411 | 17918852.0 |
| 2006-10-04 10:20:00 | AAPL | Stock | 2.6407 | 2.6607 | 2.6396 | 2.6561 | 22843716.0 |
| 2006-10-04 10:25:00 | AAPL | Stock | 2.6561 | 2.6589 | 2.6461 | 2.6486 | 19469128.0 |
| 2006-10-04 10:30:00 | AAPL | Stock | 2.6489 | 2.6561 | 2.6457 | 2.6557 | 16454984.0 |
| 2006-10-04 10:35:00 | AAPL | Stock | 2.6557 | 2.6561 | 2.6486 | 2.6504 | 9069452.0 |
| 2006-10-04 10:40:00 | AAPL | Stock | 2.6504 | 2.6536 | 2.6461 | 2.6507 | 8597736.0 |
| 2006-10-04 10:45:00 | AAPL | Stock | 2.6504 | 2.6518 | 2.6479 | 2.6493 | 6442968.0 |
| 2006-10-04 10:50:00 | AAPL | Stock | 2.6489 | 2.6525 | 2.6482 | 2.6493 | 9572584.0 |
| 2006-10-04 10:55:00 | AAPL | Stock | 2.6493 | 2.66 | 2.6479 | 2.6568 | 12601680.0 |
| 2006-10-04 11:00:00 | AAPL | Stock | 2.6561 | 2.6604 | 2.6532 | 2.6557 | 15417416.0 |
| 2006-10-04 11:05:00 | AAPL | Stock | 2.655 | 2.6607 | 2.6539 | 2.6596 | 10341996.0 |
| 2006-10-04 11:10:00 | AAPL | Stock | 2.6593 | 2.6668 | 2.6564 | 2.6589 | 13815200.0 |
| 2006-10-04 11:15:00 | AAPL | Stock | 2.6589 | 2.6704 | 2.6571 | 2.6696 | 17593156.0 |
| 2006-10-04 11:20:00 | AAPL | Stock | 2.6696 | 2.6868 | 2.6675 | 2.6814 | 28564032.0 |
| 2006-10-04 11:25:00 | AAPL | Stock | 2.6814 | 2.6821 | 2.6757 | 2.6786 | 19805828.0 |
| 2006-10-04 11:30:00 | AAPL | Stock | 2.6779 | 2.6789 | 2.6736 | 2.6782 | 11161528.0 |
| 2006-10-04 11:35:00 | AAPL | Stock | 2.6782 | 2.6786 | 2.6707 | 2.6714 | 8393364.0 |
| 2006-10-04 11:40:00 | AAPL | Stock | 2.6714 | 2.6736 | 2.6679 | 2.6689 | 9860144.0 |
| 2006-10-04 11:45:00 | AAPL | Stock | 2.6679 | 2.6721 | 2.665 | 2.6718 | 7434280.0 |
| 2006-10-04 11:50:00 | AAPL | Stock | 2.6714 | 2.6729 | 2.6679 | 2.6714 | 6540884.0 |
| 2006-10-04 11:55:00 | AAPL | Stock | 2.6718 | 2.6768 | 2.6711 | 2.6757 | 5636988.0 |
| 2006-10-04 12:00:00 | AAPL | Stock | 2.6754 | 2.6779 | 2.6704 | 2.6711 | 7816676.0 |
| 2006-10-04 12:05:00 | AAPL | Stock | 2.6707 | 2.6746 | 2.6664 | 2.6682 | 7676424.0 |
> showing 50 of 233,421 rows — these rows as CSV