PREVIEW / stock_30min / 2006-09-21
file: by_date/stock_30min/2006/2006-09-21.parquet size: 913 KB rows: 49,326 symbols: 2,354
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-09-21 07:30:00 | AAPL | Stock | 2.6911 | 2.6911 | 2.6893 | 2.6893 | 84000.0 |
| 2006-09-21 08:00:00 | AAPL | Stock | 2.6964 | 2.7018 | 2.6911 | 2.6975 | 983052.0 |
| 2006-09-21 08:30:00 | AAPL | Stock | 2.6975 | 2.7 | 2.6964 | 2.6986 | 499352.0 |
| 2006-09-21 09:00:00 | AAPL | Stock | 2.6982 | 2.7 | 2.6854 | 2.6854 | 1305416.0 |
| 2006-09-21 09:30:00 | AAPL | Stock | 2.6875 | 2.7075 | 2.6789 | 2.6879 | 92882160.0 |
| 2006-09-21 10:00:00 | AAPL | Stock | 2.6879 | 2.6946 | 2.6736 | 2.6921 | 74088000.0 |
| 2006-09-21 10:30:00 | AAPL | Stock | 2.6921 | 2.7075 | 2.6839 | 2.7004 | 61857376.0 |
| 2006-09-21 11:00:00 | AAPL | Stock | 2.7004 | 2.7164 | 2.6996 | 2.7071 | 61334616.0 |
| 2006-09-21 11:30:00 | AAPL | Stock | 2.7074 | 2.7082 | 2.6957 | 2.7025 | 52049032.0 |
| 2006-09-21 12:00:00 | AAPL | Stock | 2.7029 | 2.7046 | 2.6864 | 2.6921 | 57674064.0 |
| 2006-09-21 12:30:00 | AAPL | Stock | 2.6922 | 2.6939 | 2.6711 | 2.6796 | 47186244.0 |
| 2006-09-21 13:00:00 | AAPL | Stock | 2.6796 | 2.6879 | 2.6707 | 2.6786 | 38514252.0 |
| 2006-09-21 13:30:00 | AAPL | Stock | 2.6782 | 2.6782 | 2.6611 | 2.6626 | 49918512.0 |
| 2006-09-21 14:00:00 | AAPL | Stock | 2.6639 | 2.6714 | 2.6561 | 2.6589 | 58462908.0 |
| 2006-09-21 14:30:00 | AAPL | Stock | 2.6586 | 2.6696 | 2.6546 | 2.6554 | 45469928.0 |
| 2006-09-21 15:00:00 | AAPL | Stock | 2.6554 | 2.6604 | 2.6436 | 2.6499 | 70065072.0 |
| 2006-09-21 15:30:00 | AAPL | Stock | 2.6496 | 2.6693 | 2.6496 | 2.6639 | 75135732.0 |
| 2006-09-21 16:00:00 | AAPL | Stock | 2.6643 | 2.6693 | 2.6629 | 2.6661 | 2467612.0 |
| 2006-09-21 16:30:00 | AAPL | Stock | 2.6661 | 2.6675 | 2.6661 | 2.6675 | 199500.0 |
| 2006-09-21 17:00:00 | AAPL | Stock | 2.6675 | 2.6686 | 2.6675 | 2.6686 | 87220.0 |
| 2006-09-21 17:30:00 | AAPL | Stock | 2.6664 | 2.6675 | 2.6657 | 2.6657 | 282632.0 |
| 2006-09-21 18:00:00 | AAPL | Stock | 2.6657 | 2.6657 | 2.6646 | 2.6646 | 70840.0 |
| 2006-09-21 19:00:00 | AAPL | Stock | 2.665 | 2.665 | 2.6643 | 2.6643 | 28000.0 |
| 2006-09-21 19:30:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6643 | 2.6643 | 8960.0 |
| 2006-09-21 08:00:00 | MSFT | Stock | 27.26 | 27.3 | 27.17 | 27.27 | 18249.0 |
| 2006-09-21 08:30:00 | MSFT | Stock | 27.28 | 27.3 | 27.18 | 27.19 | 41445.0 |
| 2006-09-21 09:00:00 | MSFT | Stock | 27.19 | 27.24 | 27.14 | 27.22 | 58262.0 |
| 2006-09-21 09:30:00 | MSFT | Stock | 27.24 | 27.25 | 27.11 | 27.11 | 4578550.0 |
| 2006-09-21 10:00:00 | MSFT | Stock | 27.11 | 27.12 | 27.0 | 27.08 | 5625948.0 |
| 2006-09-21 10:30:00 | MSFT | Stock | 27.09 | 27.22 | 27.05 | 27.13 | 4264764.0 |
| 2006-09-21 11:00:00 | MSFT | Stock | 27.13 | 27.18 | 27.05 | 27.06 | 3504348.0 |
| 2006-09-21 11:30:00 | MSFT | Stock | 27.052 | 27.06 | 26.96 | 27.01 | 3273664.0 |
| 2006-09-21 12:00:00 | MSFT | Stock | 27.01 | 27.09 | 26.95 | 27.07 | 3341407.0 |
| 2006-09-21 12:30:00 | MSFT | Stock | 27.09 | 27.12 | 27.01 | 27.07 | 2635565.0 |
| 2006-09-21 13:00:00 | MSFT | Stock | 27.07 | 27.08 | 26.96 | 26.96 | 4947393.0 |
| 2006-09-21 13:30:00 | MSFT | Stock | 26.96 | 27.05 | 26.91 | 26.98 | 2882575.0 |
| 2006-09-21 14:00:00 | MSFT | Stock | 26.98 | 27.04 | 26.91 | 26.96 | 2896307.0 |
| 2006-09-21 14:30:00 | MSFT | Stock | 26.96 | 27.02 | 26.89 | 26.9 | 3596208.0 |
| 2006-09-21 15:00:00 | MSFT | Stock | 26.9 | 26.97 | 26.87 | 26.94 | 3886793.0 |
| 2006-09-21 15:30:00 | MSFT | Stock | 26.95 | 26.95 | 26.85 | 26.89 | 9717142.0 |
| 2006-09-21 16:00:00 | MSFT | Stock | 26.89 | 26.95 | 26.88 | 26.93 | 86803.0 |
| 2006-09-21 16:30:00 | MSFT | Stock | 26.92 | 26.94 | 26.9 | 26.94 | 35529.0 |
| 2006-09-21 17:00:00 | MSFT | Stock | 26.94 | 26.94 | 26.94 | 26.94 | 3454.0 |
| 2006-09-21 17:30:00 | MSFT | Stock | 26.9 | 26.9 | 26.89 | 26.89 | 16171.0 |
| 2006-09-21 18:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.9 | 26.9 | 900.0 |
| 2006-09-21 08:00:00 | NVDA | Stock | 0.521 | 0.521 | 0.517 | 0.517 | 240000.0 |
| 2006-09-21 08:30:00 | NVDA | Stock | 0.5197 | 0.52 | 0.518 | 0.5183 | 370800.0 |
| 2006-09-21 09:00:00 | NVDA | Stock | 0.5192 | 0.52 | 0.5155 | 0.5165 | 522000.0 |
| 2006-09-21 09:30:00 | NVDA | Stock | 0.5157 | 0.5175 | 0.5073 | 0.5107 | 61537920.0 |
| 2006-09-21 10:00:00 | NVDA | Stock | 0.5105 | 0.5148 | 0.5077 | 0.5127 | 62028300.0 |
> showing 50 of 49,326 rows — these rows as CSV