PREVIEW / stock_30min / 2006-08-28
file: by_date/stock_30min/2006/2006-08-28.parquet size: 904 KB rows: 49,600 symbols: 2,331
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-08-28 05:30:00 | AAPL | Stock | 2.4482 | 2.4482 | 2.4482 | 2.4482 | 28000.0 |
| 2006-08-28 08:00:00 | AAPL | Stock | 2.4546 | 2.4561 | 2.4496 | 2.4554 | 528948.0 |
| 2006-08-28 08:30:00 | AAPL | Stock | 2.4554 | 2.4593 | 2.4554 | 2.4554 | 431172.0 |
| 2006-08-28 09:00:00 | AAPL | Stock | 2.4543 | 2.455 | 2.4443 | 2.4443 | 645624.0 |
| 2006-08-28 09:30:00 | AAPL | Stock | 2.4464 | 2.4504 | 2.4254 | 2.4418 | 117064528.0 |
| 2006-08-28 10:00:00 | AAPL | Stock | 2.4418 | 2.4439 | 2.4207 | 2.4357 | 89780012.0 |
| 2006-08-28 10:30:00 | AAPL | Stock | 2.4357 | 2.4389 | 2.4214 | 2.4304 | 54695536.0 |
| 2006-08-28 11:00:00 | AAPL | Stock | 2.4304 | 2.4364 | 2.4236 | 2.425 | 29238188.0 |
| 2006-08-28 11:30:00 | AAPL | Stock | 2.425 | 2.4282 | 2.4168 | 2.4268 | 41606544.0 |
| 2006-08-28 12:00:00 | AAPL | Stock | 2.4264 | 2.4271 | 2.4139 | 2.4154 | 40581464.0 |
| 2006-08-28 12:30:00 | AAPL | Stock | 2.4154 | 2.4171 | 2.4039 | 2.4089 | 42194684.0 |
| 2006-08-28 13:00:00 | AAPL | Stock | 2.4086 | 2.4154 | 2.4057 | 2.4075 | 27974576.0 |
| 2006-08-28 13:30:00 | AAPL | Stock | 2.4075 | 2.4075 | 2.3814 | 2.3993 | 114850344.0 |
| 2006-08-28 14:00:00 | AAPL | Stock | 2.3989 | 2.4011 | 2.3893 | 2.3929 | 40550356.0 |
| 2006-08-28 14:30:00 | AAPL | Stock | 2.3929 | 2.3996 | 2.3875 | 2.3979 | 32772040.0 |
| 2006-08-28 15:00:00 | AAPL | Stock | 2.3975 | 2.3996 | 2.3896 | 2.3939 | 28355488.0 |
| 2006-08-28 15:30:00 | AAPL | Stock | 2.3943 | 2.3943 | 2.3861 | 2.3929 | 59889144.0 |
| 2006-08-28 16:00:00 | AAPL | Stock | 2.3946 | 2.3954 | 2.39 | 2.3921 | 1282904.0 |
| 2006-08-28 16:30:00 | AAPL | Stock | 2.3918 | 2.3936 | 2.3918 | 2.3929 | 71540.0 |
| 2006-08-28 17:00:00 | AAPL | Stock | 2.3929 | 2.3964 | 2.3929 | 2.3964 | 285712.0 |
| 2006-08-28 17:30:00 | AAPL | Stock | 2.3982 | 2.3982 | 2.3936 | 2.3964 | 61600.0 |
| 2006-08-28 18:00:00 | AAPL | Stock | 2.3979 | 2.3979 | 2.3936 | 2.3943 | 67200.0 |
| 2006-08-28 07:00:00 | MSFT | Stock | 25.83 | 25.83 | 25.83 | 25.83 | 500.0 |
| 2006-08-28 08:00:00 | MSFT | Stock | 25.83 | 25.85 | 25.83 | 25.85 | 450.0 |
| 2006-08-28 08:30:00 | MSFT | Stock | 25.9 | 25.9 | 25.85 | 25.85 | 1100.0 |
| 2006-08-28 09:00:00 | MSFT | Stock | 25.86 | 25.86 | 25.77 | 25.85 | 57234.0 |
| 2006-08-28 09:30:00 | MSFT | Stock | 25.84 | 25.85 | 25.69 | 25.73 | 4017054.0 |
| 2006-08-28 10:00:00 | MSFT | Stock | 25.73 | 25.8 | 25.7 | 25.79 | 2457210.0 |
| 2006-08-28 10:30:00 | MSFT | Stock | 25.79 | 25.92 | 25.79 | 25.86 | 2007186.0 |
| 2006-08-28 11:00:00 | MSFT | Stock | 25.87 | 25.9 | 25.86 | 25.87 | 1442833.0 |
| 2006-08-28 11:30:00 | MSFT | Stock | 25.87 | 25.92 | 25.81 | 25.9 | 2775817.0 |
| 2006-08-28 12:00:00 | MSFT | Stock | 25.9 | 26.0 | 25.88 | 25.93 | 3335531.0 |
| 2006-08-28 12:30:00 | MSFT | Stock | 25.94 | 25.94 | 25.87 | 25.89 | 2071684.0 |
| 2006-08-28 13:00:00 | MSFT | Stock | 25.89 | 25.89 | 25.77 | 25.83 | 1735494.0 |
| 2006-08-28 13:30:00 | MSFT | Stock | 25.83 | 25.91 | 25.83 | 25.88 | 1393599.0 |
| 2006-08-28 14:00:00 | MSFT | Stock | 25.89 | 25.93 | 25.84 | 25.85 | 2662298.0 |
| 2006-08-28 14:30:00 | MSFT | Stock | 25.85 | 25.87 | 25.82 | 25.86 | 1458111.0 |
| 2006-08-28 15:00:00 | MSFT | Stock | 25.86 | 25.99 | 25.85 | 25.89 | 2097752.0 |
| 2006-08-28 15:30:00 | MSFT | Stock | 25.89 | 25.95 | 25.86 | 25.95 | 4261554.0 |
| 2006-08-28 16:00:00 | MSFT | Stock | 25.95 | 26.01 | 25.833 | 25.93 | 118850.0 |
| 2006-08-28 16:30:00 | MSFT | Stock | 25.93 | 25.99 | 25.93 | 25.99 | 5466.0 |
| 2006-08-28 17:00:00 | MSFT | Stock | 25.95 | 25.95 | 25.94 | 25.94 | 1500.0 |
| 2006-08-28 17:30:00 | MSFT | Stock | 25.855 | 25.855 | 25.855 | 25.855 | 300.0 |
| 2006-08-28 18:00:00 | MSFT | Stock | 25.89 | 25.98 | 25.89 | 25.94 | 1100.0 |
| 2006-08-28 07:30:00 | NVDA | Stock | 0.45 | 0.45 | 0.45 | 0.45 | 389880.0 |
| 2006-08-28 08:00:00 | NVDA | Stock | 0.45 | 0.45 | 0.4467 | 0.4475 | 1284000.0 |
| 2006-08-28 08:30:00 | NVDA | Stock | 0.4473 | 0.4473 | 0.4472 | 0.4473 | 240000.0 |
| 2006-08-28 09:00:00 | NVDA | Stock | 0.447 | 0.4487 | 0.4467 | 0.4478 | 699780.0 |
| 2006-08-28 09:30:00 | NVDA | Stock | 0.4487 | 0.4597 | 0.4478 | 0.4591 | 118305660.0 |
| 2006-08-28 10:00:00 | NVDA | Stock | 0.4592 | 0.4695 | 0.459 | 0.4687 | 131897100.0 |
> showing 50 of 49,600 rows — these rows as CSV