PREVIEW / stock_5min / 2008-04-18
file: by_date/stock_5min/2008/2008-04-18.parquet size: 4.4 MB rows: 311,979 symbols: 3,291
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-18 04:55:00 | AAPL | Stock | 5.6071 | 5.6071 | 5.6071 | 5.6071 | 2800.0 |
| 2008-04-18 05:40:00 | AAPL | Stock | 5.5907 | 5.5907 | 5.5907 | 5.5907 | 5600.0 |
| 2008-04-18 06:05:00 | AAPL | Stock | 5.5893 | 5.5893 | 5.5821 | 5.5821 | 5600.0 |
| 2008-04-18 06:25:00 | AAPL | Stock | 5.6107 | 5.6107 | 5.6046 | 5.6046 | 5600.0 |
| 2008-04-18 07:05:00 | AAPL | Stock | 5.6107 | 5.6107 | 5.6107 | 5.6107 | 10080.0 |
| 2008-04-18 07:10:00 | AAPL | Stock | 5.6071 | 5.6329 | 5.6071 | 5.6329 | 64680.0 |
| 2008-04-18 07:15:00 | AAPL | Stock | 5.6357 | 5.6571 | 5.6357 | 5.6571 | 33124.0 |
| 2008-04-18 07:20:00 | AAPL | Stock | 5.6571 | 5.6571 | 5.6571 | 5.6571 | 2800.0 |
| 2008-04-18 07:25:00 | AAPL | Stock | 5.65 | 5.6504 | 5.65 | 5.6504 | 30800.0 |
| 2008-04-18 07:30:00 | AAPL | Stock | 5.6554 | 5.66 | 5.6536 | 5.6539 | 75572.0 |
| 2008-04-18 07:35:00 | AAPL | Stock | 5.6529 | 5.6607 | 5.6518 | 5.6607 | 95340.0 |
| 2008-04-18 07:40:00 | AAPL | Stock | 5.6643 | 5.6643 | 5.6607 | 5.6611 | 135100.0 |
| 2008-04-18 07:45:00 | AAPL | Stock | 5.6746 | 5.6768 | 5.6611 | 5.6611 | 35980.0 |
| 2008-04-18 07:50:00 | AAPL | Stock | 5.6614 | 5.675 | 5.6611 | 5.6679 | 263732.0 |
| 2008-04-18 07:55:00 | AAPL | Stock | 5.6714 | 5.6786 | 5.6714 | 5.6786 | 74200.0 |
| 2008-04-18 08:00:00 | AAPL | Stock | 5.6782 | 5.6857 | 5.6611 | 5.6786 | 1066324.0 |
| 2008-04-18 08:05:00 | AAPL | Stock | 5.6786 | 5.6957 | 5.6217 | 5.6217 | 1111880.0 |
| 2008-04-18 08:10:00 | AAPL | Stock | 5.6875 | 5.6921 | 5.6786 | 5.6786 | 890512.0 |
| 2008-04-18 08:15:00 | AAPL | Stock | 5.6807 | 5.6829 | 5.6757 | 5.6757 | 727524.0 |
| 2008-04-18 08:20:00 | AAPL | Stock | 5.6775 | 5.6775 | 5.6679 | 5.6689 | 570080.0 |
| 2008-04-18 08:25:00 | AAPL | Stock | 5.6689 | 5.67 | 5.6682 | 5.6696 | 270956.0 |
| 2008-04-18 08:30:00 | AAPL | Stock | 5.67 | 5.67 | 5.6636 | 5.6671 | 173432.0 |
| 2008-04-18 08:35:00 | AAPL | Stock | 5.6671 | 5.6743 | 5.6636 | 5.6696 | 255136.0 |
| 2008-04-18 08:40:00 | AAPL | Stock | 5.6696 | 5.6704 | 5.6625 | 5.6639 | 266868.0 |
| 2008-04-18 08:45:00 | AAPL | Stock | 5.6629 | 5.6654 | 5.6554 | 5.66 | 441840.0 |
| 2008-04-18 08:50:00 | AAPL | Stock | 5.6604 | 5.6679 | 5.6604 | 5.6625 | 140504.0 |
| 2008-04-18 08:55:00 | AAPL | Stock | 5.6611 | 5.6693 | 5.6611 | 5.6693 | 306208.0 |
| 2008-04-18 09:00:00 | AAPL | Stock | 5.6668 | 5.6754 | 5.6668 | 5.675 | 1389304.0 |
| 2008-04-18 09:05:00 | AAPL | Stock | 5.6736 | 5.675 | 5.6689 | 5.6689 | 527352.0 |
| 2008-04-18 09:10:00 | AAPL | Stock | 5.6657 | 5.6693 | 5.6611 | 5.6675 | 344428.0 |
| 2008-04-18 09:15:00 | AAPL | Stock | 5.6679 | 5.6757 | 5.6679 | 5.6732 | 532980.0 |
| 2008-04-18 09:20:00 | AAPL | Stock | 5.6732 | 5.6764 | 5.6732 | 5.6736 | 646464.0 |
| 2008-04-18 09:25:00 | AAPL | Stock | 5.6736 | 5.6818 | 5.6579 | 5.68 | 2021376.0 |
| 2008-04-18 09:30:00 | AAPL | Stock | 5.68 | 5.6964 | 5.6754 | 5.6884 | 60937156.0 |
| 2008-04-18 09:35:00 | AAPL | Stock | 5.6893 | 5.7025 | 5.6786 | 5.6839 | 29463000.0 |
| 2008-04-18 09:40:00 | AAPL | Stock | 5.6832 | 5.6911 | 5.6564 | 5.6579 | 27812316.0 |
| 2008-04-18 09:45:00 | AAPL | Stock | 5.6586 | 5.6875 | 5.6564 | 5.6854 | 19432812.0 |
| 2008-04-18 09:50:00 | AAPL | Stock | 5.6846 | 5.6911 | 5.6725 | 5.6907 | 15321068.0 |
| 2008-04-18 09:55:00 | AAPL | Stock | 5.6911 | 5.6911 | 5.6714 | 5.6757 | 15646540.0 |
| 2008-04-18 10:00:00 | AAPL | Stock | 5.6757 | 5.6786 | 5.6632 | 5.6639 | 15453228.0 |
| 2008-04-18 10:05:00 | AAPL | Stock | 5.6643 | 5.6729 | 5.66 | 5.665 | 11399388.0 |
| 2008-04-18 10:10:00 | AAPL | Stock | 5.6654 | 5.68 | 5.6639 | 5.6679 | 11636828.0 |
| 2008-04-18 10:15:00 | AAPL | Stock | 5.6679 | 5.6904 | 5.6668 | 5.6882 | 14678104.0 |
| 2008-04-18 10:20:00 | AAPL | Stock | 5.6882 | 5.6954 | 5.6861 | 5.6893 | 13435492.0 |
| 2008-04-18 10:25:00 | AAPL | Stock | 5.69 | 5.69 | 5.6746 | 5.6793 | 11980696.0 |
| 2008-04-18 10:30:00 | AAPL | Stock | 5.6796 | 5.6904 | 5.6754 | 5.6886 | 12150236.0 |
| 2008-04-18 10:35:00 | AAPL | Stock | 5.6893 | 5.6964 | 5.6857 | 5.6932 | 11844420.0 |
| 2008-04-18 10:40:00 | AAPL | Stock | 5.6934 | 5.7096 | 5.6868 | 5.7071 | 18023460.0 |
| 2008-04-18 10:45:00 | AAPL | Stock | 5.7075 | 5.7268 | 5.7068 | 5.7257 | 35156044.0 |
| 2008-04-18 10:50:00 | AAPL | Stock | 5.7257 | 5.7304 | 5.7193 | 5.7247 | 20809152.0 |
> showing 50 of 311,979 rows — these rows as CSV