PREVIEW / stock_5min / 2005-08-24
file: by_date/stock_5min/2005/2005-08-24.parquet size: 2.7 MB rows: 200,001 symbols: 2,064
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-24 08:05:00 | AAPL | Stock | 1.625 | 1.625 | 1.625 | 1.625 | 14000.0 |
| 2005-08-24 08:10:00 | AAPL | Stock | 1.6232 | 1.625 | 1.6232 | 1.6232 | 32760.0 |
| 2005-08-24 08:15:00 | AAPL | Stock | 1.625 | 1.6279 | 1.625 | 1.6279 | 70000.0 |
| 2005-08-24 08:30:00 | AAPL | Stock | 1.6275 | 1.6275 | 1.6254 | 1.6254 | 196000.0 |
| 2005-08-24 08:35:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.6254 | 1.6254 | 36400.0 |
| 2005-08-24 08:40:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.625 | 1.625 | 54600.0 |
| 2005-08-24 08:45:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.6254 | 1.6254 | 13664.0 |
| 2005-08-24 08:50:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.625 | 1.625 | 78400.0 |
| 2005-08-24 08:55:00 | AAPL | Stock | 1.6254 | 1.6336 | 1.6254 | 1.6336 | 476000.0 |
| 2005-08-24 09:00:00 | AAPL | Stock | 1.6254 | 1.6254 | 1.6232 | 1.6232 | 71540.0 |
| 2005-08-24 09:05:00 | AAPL | Stock | 1.6232 | 1.6232 | 1.6232 | 1.6232 | 2800.0 |
| 2005-08-24 09:15:00 | AAPL | Stock | 1.6239 | 1.6246 | 1.6236 | 1.6246 | 19600.0 |
| 2005-08-24 09:20:00 | AAPL | Stock | 1.625 | 1.625 | 1.6232 | 1.625 | 172648.0 |
| 2005-08-24 09:25:00 | AAPL | Stock | 1.6254 | 1.6289 | 1.6246 | 1.6286 | 394800.0 |
| 2005-08-24 09:30:00 | AAPL | Stock | 1.6286 | 1.6429 | 1.6282 | 1.6425 | 16360820.0 |
| 2005-08-24 09:35:00 | AAPL | Stock | 1.6429 | 1.6468 | 1.6343 | 1.6385 | 14209272.0 |
| 2005-08-24 09:40:00 | AAPL | Stock | 1.6382 | 1.6436 | 1.6357 | 1.6396 | 10203564.0 |
| 2005-08-24 09:45:00 | AAPL | Stock | 1.6396 | 1.6454 | 1.6379 | 1.6436 | 8915508.0 |
| 2005-08-24 09:50:00 | AAPL | Stock | 1.6436 | 1.6539 | 1.6436 | 1.6529 | 18151840.0 |
| 2005-08-24 09:55:00 | AAPL | Stock | 1.6529 | 1.6529 | 1.645 | 1.6511 | 11336220.0 |
| 2005-08-24 10:00:00 | AAPL | Stock | 1.6511 | 1.6604 | 1.6496 | 1.6554 | 14074816.0 |
| 2005-08-24 10:05:00 | AAPL | Stock | 1.655 | 1.6589 | 1.65 | 1.6514 | 8766240.0 |
| 2005-08-24 10:10:00 | AAPL | Stock | 1.6511 | 1.6557 | 1.6504 | 1.6554 | 9187276.0 |
| 2005-08-24 10:15:00 | AAPL | Stock | 1.6546 | 1.6586 | 1.6529 | 1.6529 | 4889220.0 |
| 2005-08-24 10:20:00 | AAPL | Stock | 1.6529 | 1.6536 | 1.6482 | 1.6482 | 4552884.0 |
| 2005-08-24 10:25:00 | AAPL | Stock | 1.6482 | 1.6511 | 1.6457 | 1.6496 | 7129528.0 |
| 2005-08-24 10:30:00 | AAPL | Stock | 1.6504 | 1.6564 | 1.6486 | 1.6564 | 9311092.0 |
| 2005-08-24 10:35:00 | AAPL | Stock | 1.6561 | 1.6661 | 1.6561 | 1.6639 | 15773352.0 |
| 2005-08-24 10:40:00 | AAPL | Stock | 1.6646 | 1.6689 | 1.6607 | 1.6679 | 11230660.0 |
| 2005-08-24 10:45:00 | AAPL | Stock | 1.6679 | 1.6771 | 1.6679 | 1.6725 | 16278416.0 |
| 2005-08-24 10:50:00 | AAPL | Stock | 1.6725 | 1.6736 | 1.6682 | 1.6711 | 11128824.0 |
| 2005-08-24 10:55:00 | AAPL | Stock | 1.6714 | 1.6725 | 1.6693 | 1.6711 | 6755588.0 |
| 2005-08-24 11:00:00 | AAPL | Stock | 1.6711 | 1.6714 | 1.6671 | 1.6682 | 6856836.0 |
| 2005-08-24 11:05:00 | AAPL | Stock | 1.6682 | 1.6707 | 1.6664 | 1.6682 | 9065336.0 |
| 2005-08-24 11:10:00 | AAPL | Stock | 1.6686 | 1.6714 | 1.6679 | 1.6693 | 7431200.0 |
| 2005-08-24 11:15:00 | AAPL | Stock | 1.6696 | 1.6729 | 1.6689 | 1.6714 | 7826364.0 |
| 2005-08-24 11:20:00 | AAPL | Stock | 1.6714 | 1.6768 | 1.6704 | 1.6757 | 7293244.0 |
| 2005-08-24 11:25:00 | AAPL | Stock | 1.6754 | 1.6764 | 1.67 | 1.6711 | 4631760.0 |
| 2005-08-24 11:30:00 | AAPL | Stock | 1.6711 | 1.6718 | 1.6686 | 1.6693 | 3347764.0 |
| 2005-08-24 11:35:00 | AAPL | Stock | 1.6693 | 1.6711 | 1.6682 | 1.6686 | 3872064.0 |
| 2005-08-24 11:40:00 | AAPL | Stock | 1.6682 | 1.6721 | 1.6679 | 1.6693 | 5301548.0 |
| 2005-08-24 11:45:00 | AAPL | Stock | 1.6689 | 1.6736 | 1.6685 | 1.6714 | 5639676.0 |
| 2005-08-24 11:50:00 | AAPL | Stock | 1.6714 | 1.6732 | 1.67 | 1.6704 | 2637656.0 |
| 2005-08-24 11:55:00 | AAPL | Stock | 1.6704 | 1.6768 | 1.67 | 1.6764 | 9641800.0 |
| 2005-08-24 12:00:00 | AAPL | Stock | 1.6761 | 1.6764 | 1.6721 | 1.6729 | 3191188.0 |
| 2005-08-24 12:05:00 | AAPL | Stock | 1.6729 | 1.6739 | 1.6725 | 1.6736 | 2602320.0 |
| 2005-08-24 12:10:00 | AAPL | Stock | 1.6736 | 1.6768 | 1.6714 | 1.6764 | 3450804.0 |
| 2005-08-24 12:15:00 | AAPL | Stock | 1.6764 | 1.6768 | 1.6746 | 1.675 | 2469964.0 |
| 2005-08-24 12:20:00 | AAPL | Stock | 1.675 | 1.6768 | 1.675 | 1.6768 | 2907100.0 |
| 2005-08-24 12:25:00 | AAPL | Stock | 1.6767 | 1.6786 | 1.6761 | 1.6786 | 11436796.0 |
> showing 50 of 200,001 rows — these rows as CSV