PREVIEW / stock_30min / 2006-01-24
file: by_date/stock_30min/2006/2006-01-24.parquet size: 890 KB rows: 48,220 symbols: 2,183
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-01-24 06:00:00 | AAPL | Stock | 2.7768 | 2.7768 | 2.7768 | 2.7768 | 5600.0 |
| 2006-01-24 06:30:00 | AAPL | Stock | 2.7786 | 2.7786 | 2.7786 | 2.7786 | 5600.0 |
| 2006-01-24 07:00:00 | AAPL | Stock | 2.7946 | 2.8071 | 2.7946 | 2.8071 | 70000.0 |
| 2006-01-24 07:30:00 | AAPL | Stock | 2.8071 | 2.8071 | 2.8054 | 2.8054 | 43708.0 |
| 2006-01-24 08:00:00 | AAPL | Stock | 2.8054 | 2.8254 | 2.8054 | 2.8175 | 2153816.0 |
| 2006-01-24 08:30:00 | AAPL | Stock | 2.8196 | 2.8204 | 2.8068 | 2.8071 | 1551508.0 |
| 2006-01-24 09:00:00 | AAPL | Stock | 2.8061 | 2.8161 | 2.8061 | 2.8154 | 4943736.0 |
| 2006-01-24 09:30:00 | AAPL | Stock | 2.8129 | 2.8364 | 2.8057 | 2.8289 | 132099912.0 |
| 2006-01-24 10:00:00 | AAPL | Stock | 2.8286 | 2.8325 | 2.8096 | 2.8175 | 78865556.0 |
| 2006-01-24 10:30:00 | AAPL | Stock | 2.8178 | 2.8196 | 2.7793 | 2.7868 | 86558500.0 |
| 2006-01-24 11:00:00 | AAPL | Stock | 2.7868 | 2.7882 | 2.7714 | 2.7854 | 79315096.0 |
| 2006-01-24 11:30:00 | AAPL | Stock | 2.7853 | 2.7882 | 2.775 | 2.7786 | 41288548.0 |
| 2006-01-24 12:00:00 | AAPL | Stock | 2.7786 | 2.7825 | 2.7625 | 2.7671 | 43606108.0 |
| 2006-01-24 12:30:00 | AAPL | Stock | 2.7671 | 2.7714 | 2.7354 | 2.7389 | 107063320.0 |
| 2006-01-24 13:00:00 | AAPL | Stock | 2.7389 | 2.7404 | 2.7061 | 2.7307 | 136755612.0 |
| 2006-01-24 13:30:00 | AAPL | Stock | 2.7304 | 2.7804 | 2.7279 | 2.7436 | 71442420.0 |
| 2006-01-24 14:00:00 | AAPL | Stock | 2.7436 | 2.7632 | 2.7432 | 2.75 | 91390796.0 |
| 2006-01-24 14:30:00 | AAPL | Stock | 2.75 | 2.75 | 2.7232 | 2.7261 | 65805376.0 |
| 2006-01-24 15:00:00 | AAPL | Stock | 2.7261 | 2.7361 | 2.7232 | 2.7282 | 52456292.0 |
| 2006-01-24 15:30:00 | AAPL | Stock | 2.7275 | 2.7421 | 2.7111 | 2.7118 | 114495164.0 |
| 2006-01-24 16:00:00 | AAPL | Stock | 2.7132 | 2.7279 | 2.7093 | 2.7218 | 6797812.0 |
| 2006-01-24 16:30:00 | AAPL | Stock | 2.7221 | 2.7336 | 2.7157 | 2.7304 | 1628200.0 |
| 2006-01-24 17:00:00 | AAPL | Stock | 2.7318 | 2.7411 | 2.7157 | 2.7393 | 2383892.0 |
| 2006-01-24 17:30:00 | AAPL | Stock | 2.7393 | 2.7554 | 2.7393 | 2.7514 | 2510592.0 |
| 2006-01-24 18:00:00 | AAPL | Stock | 2.7514 | 2.7514 | 2.7429 | 2.7471 | 391804.0 |
| 2006-01-24 06:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 200.0 |
| 2006-01-24 06:30:00 | MSFT | Stock | 26.35 | 26.35 | 26.35 | 26.35 | 300.0 |
| 2006-01-24 08:00:00 | MSFT | Stock | 26.45 | 26.45 | 26.4 | 26.44 | 2560.0 |
| 2006-01-24 08:30:00 | MSFT | Stock | 26.4 | 26.4 | 26.37 | 26.37 | 3984.0 |
| 2006-01-24 09:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.33 | 26.33 | 36302.0 |
| 2006-01-24 09:30:00 | MSFT | Stock | 26.34 | 26.44 | 26.32 | 26.41 | 6432271.0 |
| 2006-01-24 10:00:00 | MSFT | Stock | 26.4 | 26.45 | 26.365 | 26.4 | 5479265.0 |
| 2006-01-24 10:30:00 | MSFT | Stock | 26.4 | 26.43 | 26.38 | 26.39 | 3561600.0 |
| 2006-01-24 11:00:00 | MSFT | Stock | 26.4 | 26.4 | 26.32 | 26.4 | 4996438.0 |
| 2006-01-24 11:30:00 | MSFT | Stock | 26.4 | 26.41 | 26.36 | 26.4 | 3046578.0 |
| 2006-01-24 12:00:00 | MSFT | Stock | 26.4 | 26.43 | 26.36 | 26.39 | 3792434.0 |
| 2006-01-24 12:30:00 | MSFT | Stock | 26.388 | 26.41 | 26.33 | 26.38 | 3493834.0 |
| 2006-01-24 13:00:00 | MSFT | Stock | 26.37 | 26.38 | 26.31 | 26.37 | 3550393.0 |
| 2006-01-24 13:30:00 | MSFT | Stock | 26.37 | 26.38 | 26.31 | 26.342 | 5036226.0 |
| 2006-01-24 14:00:00 | MSFT | Stock | 26.35 | 26.42 | 26.33 | 26.38 | 4645293.0 |
| 2006-01-24 14:30:00 | MSFT | Stock | 26.382 | 26.4 | 26.27 | 26.31 | 3932973.0 |
| 2006-01-24 15:00:00 | MSFT | Stock | 26.31 | 26.36 | 26.22 | 26.26 | 5292079.0 |
| 2006-01-24 15:30:00 | MSFT | Stock | 26.26 | 26.33 | 26.25 | 26.28 | 6085857.0 |
| 2006-01-24 16:00:00 | MSFT | Stock | 26.25 | 26.38 | 26.235 | 26.27 | 1269814.0 |
| 2006-01-24 16:30:00 | MSFT | Stock | 26.28 | 26.3 | 26.27 | 26.27 | 235056.0 |
| 2006-01-24 17:00:00 | MSFT | Stock | 26.28 | 26.28 | 26.25 | 26.28 | 318987.0 |
| 2006-01-24 17:30:00 | MSFT | Stock | 26.28 | 26.28 | 26.28 | 26.28 | 7000.0 |
| 2006-01-24 18:00:00 | MSFT | Stock | 26.27 | 26.3 | 26.27 | 26.3 | 20986.0 |
| 2006-01-24 09:30:00 | NVDA | Stock | 0.368 | 0.3767 | 0.367 | 0.3746 | 64993320.0 |
| 2006-01-24 10:00:00 | NVDA | Stock | 0.3747 | 0.3759 | 0.3732 | 0.3738 | 45583440.0 |
> showing 50 of 48,220 rows — these rows as CSV