PREVIEW / stock_30min / 2006-10-27
file: by_date/stock_30min/2006/2006-10-27.parquet size: 941 KB rows: 50,588 symbols: 2,395
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-10-27 08:00:00 | AAPL | Stock | 2.9286 | 2.9354 | 2.9196 | 2.9271 | 334880.0 |
| 2006-10-27 08:30:00 | AAPL | Stock | 2.9271 | 2.9282 | 2.9214 | 2.925 | 315672.0 |
| 2006-10-27 09:00:00 | AAPL | Stock | 2.925 | 2.9282 | 2.9193 | 2.9204 | 587188.0 |
| 2006-10-27 09:30:00 | AAPL | Stock | 2.9196 | 2.9429 | 2.9182 | 2.9339 | 60634840.0 |
| 2006-10-27 10:00:00 | AAPL | Stock | 2.9325 | 2.9395 | 2.9279 | 2.9357 | 36898624.0 |
| 2006-10-27 10:30:00 | AAPL | Stock | 2.9361 | 2.9446 | 2.9325 | 2.9411 | 28160356.0 |
| 2006-10-27 11:00:00 | AAPL | Stock | 2.9414 | 2.9439 | 2.9361 | 2.9411 | 29203048.0 |
| 2006-10-27 11:30:00 | AAPL | Stock | 2.9408 | 2.9418 | 2.9307 | 2.9343 | 22372616.0 |
| 2006-10-27 12:00:00 | AAPL | Stock | 2.9346 | 2.9368 | 2.93 | 2.9346 | 17318476.0 |
| 2006-10-27 12:30:00 | AAPL | Stock | 2.9343 | 2.9368 | 2.9179 | 2.9229 | 28603596.0 |
| 2006-10-27 13:00:00 | AAPL | Stock | 2.9225 | 2.9243 | 2.9125 | 2.9179 | 27539036.0 |
| 2006-10-27 13:30:00 | AAPL | Stock | 2.9179 | 2.9182 | 2.8829 | 2.8864 | 78839936.0 |
| 2006-10-27 14:00:00 | AAPL | Stock | 2.8868 | 2.8929 | 2.8654 | 2.8661 | 70383012.0 |
| 2006-10-27 14:30:00 | AAPL | Stock | 2.8661 | 2.8796 | 2.8575 | 2.8746 | 77094304.0 |
| 2006-10-27 15:00:00 | AAPL | Stock | 2.8743 | 2.9286 | 2.8689 | 2.8746 | 48552784.0 |
| 2006-10-27 15:30:00 | AAPL | Stock | 2.8746 | 2.8786 | 2.8657 | 2.8721 | 58784012.0 |
| 2006-10-27 16:00:00 | AAPL | Stock | 2.8732 | 2.8746 | 2.8682 | 2.8746 | 1039444.0 |
| 2006-10-27 16:30:00 | AAPL | Stock | 2.8746 | 2.8746 | 2.8707 | 2.8721 | 118832.0 |
| 2006-10-27 17:00:00 | AAPL | Stock | 2.8714 | 2.8729 | 2.8679 | 2.8714 | 464044.0 |
| 2006-10-27 17:30:00 | AAPL | Stock | 2.8714 | 2.8714 | 2.8696 | 2.8696 | 70364.0 |
| 2006-10-27 18:00:00 | AAPL | Stock | 2.8696 | 2.8732 | 2.8696 | 2.8732 | 40012.0 |
| 2006-10-27 18:30:00 | AAPL | Stock | 2.8725 | 2.8725 | 2.8725 | 2.8725 | 2800.0 |
| 2006-10-27 19:00:00 | AAPL | Stock | 2.8711 | 2.8729 | 2.8711 | 2.8714 | 51408.0 |
| 2006-10-27 19:30:00 | AAPL | Stock | 2.8679 | 2.8714 | 2.8675 | 2.8714 | 83720.0 |
| 2006-10-27 07:00:00 | MSFT | Stock | 28.38 | 28.38 | 28.38 | 28.38 | 500.0 |
| 2006-10-27 07:30:00 | MSFT | Stock | 28.25 | 28.25 | 28.24 | 28.24 | 3100.0 |
| 2006-10-27 08:00:00 | MSFT | Stock | 28.25 | 28.3 | 28.13 | 28.2 | 93771.0 |
| 2006-10-27 08:30:00 | MSFT | Stock | 28.2 | 28.4 | 28.19 | 28.37 | 291326.0 |
| 2006-10-27 09:00:00 | MSFT | Stock | 28.35 | 28.53 | 28.35 | 28.5 | 485788.0 |
| 2006-10-27 09:30:00 | MSFT | Stock | 28.49 | 28.76 | 28.43 | 28.67 | 17858533.0 |
| 2006-10-27 10:00:00 | MSFT | Stock | 28.67 | 28.79 | 28.66 | 28.73 | 10341783.0 |
| 2006-10-27 10:30:00 | MSFT | Stock | 28.73 | 28.73 | 28.53 | 28.58 | 7215059.0 |
| 2006-10-27 11:00:00 | MSFT | Stock | 28.578 | 28.64 | 28.48 | 28.55 | 5068538.0 |
| 2006-10-27 11:30:00 | MSFT | Stock | 28.55 | 28.67 | 28.55 | 28.662 | 3367786.0 |
| 2006-10-27 12:00:00 | MSFT | Stock | 28.66 | 28.7 | 28.61 | 28.68 | 3344470.0 |
| 2006-10-27 12:30:00 | MSFT | Stock | 28.68 | 28.72 | 28.66 | 28.68 | 3147429.0 |
| 2006-10-27 13:00:00 | MSFT | Stock | 28.69 | 28.7 | 28.61 | 28.63 | 2328710.0 |
| 2006-10-27 13:30:00 | MSFT | Stock | 28.63 | 28.64 | 28.41 | 28.45 | 8232252.0 |
| 2006-10-27 14:00:00 | MSFT | Stock | 28.45 | 28.46 | 28.27 | 28.283 | 5641206.0 |
| 2006-10-27 14:30:00 | MSFT | Stock | 28.29 | 28.37 | 28.25 | 28.3 | 6380118.0 |
| 2006-10-27 15:00:00 | MSFT | Stock | 28.291 | 28.33 | 28.25 | 28.31 | 4536042.0 |
| 2006-10-27 15:30:00 | MSFT | Stock | 28.31 | 28.36 | 28.27 | 28.36 | 7395967.0 |
| 2006-10-27 16:00:00 | MSFT | Stock | 28.36 | 28.4 | 28.29 | 28.35 | 131449.0 |
| 2006-10-27 16:30:00 | MSFT | Stock | 28.35 | 28.35 | 28.34 | 28.35 | 713465.0 |
| 2006-10-27 17:00:00 | MSFT | Stock | 28.36 | 28.36 | 28.31 | 28.33 | 8781.0 |
| 2006-10-27 17:30:00 | MSFT | Stock | 28.31 | 28.36 | 28.31 | 28.35 | 7310.0 |
| 2006-10-27 18:00:00 | MSFT | Stock | 28.35 | 28.35 | 28.35 | 28.35 | 200.0 |
| 2006-10-27 19:30:00 | MSFT | Stock | 28.34 | 28.34 | 28.34 | 28.34 | 500.0 |
| 2006-10-27 08:00:00 | NVDA | Stock | 0.5633 | 0.5663 | 0.5633 | 0.564 | 96000.0 |
| 2006-10-27 08:30:00 | NVDA | Stock | 0.5628 | 0.5628 | 0.5625 | 0.5625 | 642000.0 |
> showing 50 of 50,588 rows — these rows as CSV