PREVIEW / stock_30min / 2005-10-27
file: by_date/stock_30min/2005/2005-10-27.parquet size: 860 KB rows: 46,162 symbols: 2,106
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-10-27 08:00:00 | AAPL | Stock | 2.0339 | 2.0357 | 2.0214 | 2.0286 | 309120.0 |
| 2005-10-27 08:30:00 | AAPL | Stock | 2.0289 | 2.0314 | 2.0268 | 2.0293 | 95200.0 |
| 2005-10-27 09:00:00 | AAPL | Stock | 2.0293 | 2.0357 | 2.0271 | 2.0271 | 1109892.0 |
| 2005-10-27 09:30:00 | AAPL | Stock | 2.0354 | 2.0361 | 2.0075 | 2.0139 | 60132044.0 |
| 2005-10-27 10:00:00 | AAPL | Stock | 2.0139 | 2.0214 | 2.0 | 2.0036 | 41670132.0 |
| 2005-10-27 10:30:00 | AAPL | Stock | 2.0032 | 2.0089 | 1.9921 | 2.0054 | 43002848.0 |
| 2005-10-27 11:00:00 | AAPL | Stock | 2.0046 | 2.0139 | 2.0025 | 2.0125 | 28144984.0 |
| 2005-10-27 11:30:00 | AAPL | Stock | 2.0121 | 2.0136 | 1.9986 | 2.0021 | 24083248.0 |
| 2005-10-27 12:00:00 | AAPL | Stock | 2.0014 | 2.0107 | 2.0011 | 2.0089 | 15385496.0 |
| 2005-10-27 12:30:00 | AAPL | Stock | 2.0086 | 2.0114 | 2.0039 | 2.0075 | 11654636.0 |
| 2005-10-27 13:00:00 | AAPL | Stock | 2.0075 | 2.0089 | 1.9979 | 1.9982 | 19507348.0 |
| 2005-10-27 13:30:00 | AAPL | Stock | 1.9982 | 2.0107 | 1.9961 | 2.0089 | 19902960.0 |
| 2005-10-27 14:00:00 | AAPL | Stock | 2.0086 | 2.0089 | 2.0014 | 2.0032 | 15076040.0 |
| 2005-10-27 14:30:00 | AAPL | Stock | 2.0032 | 2.0061 | 1.9943 | 1.9968 | 23979312.0 |
| 2005-10-27 15:00:00 | AAPL | Stock | 1.9968 | 1.9996 | 1.9857 | 1.9911 | 43764700.0 |
| 2005-10-27 15:30:00 | AAPL | Stock | 1.9914 | 1.9957 | 1.9789 | 1.9789 | 58511712.0 |
| 2005-10-27 16:00:00 | AAPL | Stock | 1.9789 | 2.0143 | 1.9714 | 1.975 | 1608992.0 |
| 2005-10-27 16:30:00 | AAPL | Stock | 1.9732 | 1.9789 | 1.9725 | 1.9757 | 496972.0 |
| 2005-10-27 17:00:00 | AAPL | Stock | 1.9786 | 2.004 | 1.9786 | 1.9789 | 252560.0 |
| 2005-10-27 17:30:00 | AAPL | Stock | 1.9761 | 1.9814 | 1.975 | 1.9789 | 149184.0 |
| 2005-10-27 18:00:00 | AAPL | Stock | 1.9793 | 1.9793 | 1.9757 | 1.9793 | 85400.0 |
| 2005-10-27 07:00:00 | MSFT | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 300.0 |
| 2005-10-27 08:00:00 | MSFT | Stock | 25.1 | 25.2 | 25.1 | 25.15 | 10575.0 |
| 2005-10-27 08:30:00 | MSFT | Stock | 25.14 | 25.19 | 25.14 | 25.17 | 10371.0 |
| 2005-10-27 09:00:00 | MSFT | Stock | 25.17 | 25.22 | 25.1 | 25.22 | 51101.0 |
| 2005-10-27 09:30:00 | MSFT | Stock | 25.22 | 25.27 | 25.12 | 25.2 | 4539272.0 |
| 2005-10-27 10:00:00 | MSFT | Stock | 25.2 | 25.25 | 25.13 | 25.17 | 4716220.0 |
| 2005-10-27 10:30:00 | MSFT | Stock | 25.17 | 25.22 | 25.13 | 25.18 | 3080725.0 |
| 2005-10-27 11:00:00 | MSFT | Stock | 25.18 | 25.23 | 25.11 | 25.2 | 3630675.0 |
| 2005-10-27 11:30:00 | MSFT | Stock | 25.2 | 25.24 | 25.15 | 25.19 | 2888215.0 |
| 2005-10-27 12:00:00 | MSFT | Stock | 25.2 | 25.25 | 25.19 | 25.23 | 1614453.0 |
| 2005-10-27 12:30:00 | MSFT | Stock | 25.24 | 25.25 | 25.17 | 25.171 | 2310061.0 |
| 2005-10-27 13:00:00 | MSFT | Stock | 25.17 | 25.18 | 25.02 | 25.06 | 4071560.0 |
| 2005-10-27 13:30:00 | MSFT | Stock | 25.06 | 25.17 | 25.05 | 25.1 | 2802390.0 |
| 2005-10-27 14:00:00 | MSFT | Stock | 25.1 | 25.11 | 25.0 | 25.03 | 3244839.0 |
| 2005-10-27 14:30:00 | MSFT | Stock | 25.04 | 25.05 | 24.92 | 24.94 | 3174317.0 |
| 2005-10-27 15:00:00 | MSFT | Stock | 24.93 | 25.03 | 24.91 | 24.94 | 5800767.0 |
| 2005-10-27 15:30:00 | MSFT | Stock | 24.94 | 25.25 | 24.88 | 24.88 | 10154426.0 |
| 2005-10-27 16:00:00 | MSFT | Stock | 24.85 | 24.96 | 24.01 | 24.33 | 3892291.0 |
| 2005-10-27 16:30:00 | MSFT | Stock | 24.33 | 25.24 | 24.11 | 24.42 | 3273289.0 |
| 2005-10-27 17:00:00 | MSFT | Stock | 24.43 | 25.078 | 24.3 | 24.31 | 487563.0 |
| 2005-10-27 17:30:00 | MSFT | Stock | 24.31 | 24.85 | 24.3 | 24.51 | 550628.0 |
| 2005-10-27 18:00:00 | MSFT | Stock | 24.51 | 24.6 | 24.4 | 24.45 | 279199.0 |
| 2005-10-27 08:30:00 | NVDA | Stock | 0.2667 | 0.2667 | 0.2667 | 0.2667 | 120000.0 |
| 2005-10-27 09:00:00 | NVDA | Stock | 0.2678 | 0.2679 | 0.2667 | 0.2667 | 120000.0 |
| 2005-10-27 09:30:00 | NVDA | Stock | 0.2682 | 0.2689 | 0.266 | 0.2687 | 29156400.0 |
| 2005-10-27 10:00:00 | NVDA | Stock | 0.2688 | 0.269 | 0.2656 | 0.2658 | 16883400.0 |
| 2005-10-27 10:30:00 | NVDA | Stock | 0.2657 | 0.2671 | 0.2642 | 0.2654 | 27295200.0 |
| 2005-10-27 11:00:00 | NVDA | Stock | 0.2654 | 0.2665 | 0.2649 | 0.2656 | 13218360.0 |
| 2005-10-27 11:30:00 | NVDA | Stock | 0.2657 | 0.2658 | 0.2638 | 0.2647 | 10641720.0 |
> showing 50 of 46,162 rows — these rows as CSV