PREVIEW / stock_30min / 2006-09-01
file: by_date/stock_30min/2006/2006-09-01.parquet size: 906 KB rows: 50,340 symbols: 2,349
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-01 07:30:00 | AAPL | Stock | 2.4339 | 2.4339 | 2.4339 | 2.4339 | 2800.0 |
| 2006-09-01 08:00:00 | AAPL | Stock | 2.4304 | 2.4393 | 2.4232 | 2.4386 | 1380176.0 |
| 2006-09-01 08:30:00 | AAPL | Stock | 2.4386 | 2.4457 | 2.4232 | 2.4346 | 3051524.0 |
| 2006-09-01 09:00:00 | AAPL | Stock | 2.4357 | 2.4482 | 2.4357 | 2.445 | 3444728.0 |
| 2006-09-01 09:30:00 | AAPL | Stock | 2.4457 | 2.4518 | 2.4371 | 2.4493 | 72778916.0 |
| 2006-09-01 10:00:00 | AAPL | Stock | 2.4493 | 2.4496 | 2.4268 | 2.4368 | 55294176.0 |
| 2006-09-01 10:30:00 | AAPL | Stock | 2.4368 | 2.4396 | 2.4275 | 2.4296 | 33802076.0 |
| 2006-09-01 11:00:00 | AAPL | Stock | 2.43 | 2.4332 | 2.4221 | 2.4307 | 41952036.0 |
| 2006-09-01 11:30:00 | AAPL | Stock | 2.4307 | 2.4368 | 2.425 | 2.4354 | 29903468.0 |
| 2006-09-01 12:00:00 | AAPL | Stock | 2.4354 | 2.4357 | 2.4304 | 2.4346 | 17519908.0 |
| 2006-09-01 12:30:00 | AAPL | Stock | 2.4346 | 2.4379 | 2.4314 | 2.4372 | 17332476.0 |
| 2006-09-01 13:00:00 | AAPL | Stock | 2.4375 | 2.4389 | 2.4314 | 2.4346 | 16251676.0 |
| 2006-09-01 13:30:00 | AAPL | Stock | 2.4346 | 2.4357 | 2.4289 | 2.4339 | 12249580.0 |
| 2006-09-01 14:00:00 | AAPL | Stock | 2.4339 | 2.4368 | 2.4304 | 2.4357 | 15635172.0 |
| 2006-09-01 14:30:00 | AAPL | Stock | 2.4361 | 2.4361 | 2.4304 | 2.4357 | 17580360.0 |
| 2006-09-01 15:00:00 | AAPL | Stock | 2.4357 | 2.4375 | 2.4336 | 2.4354 | 16115008.0 |
| 2006-09-01 15:30:00 | AAPL | Stock | 2.4357 | 2.4425 | 2.4336 | 2.4411 | 43603000.0 |
| 2006-09-01 16:00:00 | AAPL | Stock | 2.4421 | 2.4425 | 2.4382 | 2.4404 | 1579116.0 |
| 2006-09-01 16:30:00 | AAPL | Stock | 2.4414 | 2.4421 | 2.4396 | 2.4396 | 232960.0 |
| 2006-09-01 17:00:00 | AAPL | Stock | 2.4396 | 2.4418 | 2.4396 | 2.4418 | 30800.0 |
| 2006-09-01 17:30:00 | AAPL | Stock | 2.4418 | 2.4421 | 2.4418 | 2.4421 | 21896.0 |
| 2006-09-01 18:00:00 | AAPL | Stock | 2.4421 | 2.4429 | 2.4421 | 2.4425 | 127960.0 |
| 2006-09-01 05:30:00 | MSFT | Stock | 25.71 | 25.71 | 25.71 | 25.71 | 100.0 |
| 2006-09-01 08:00:00 | MSFT | Stock | 25.65 | 25.7 | 25.65 | 25.7 | 136900.0 |
| 2006-09-01 08:30:00 | MSFT | Stock | 25.72 | 25.75 | 25.67 | 25.75 | 42476.0 |
| 2006-09-01 09:00:00 | MSFT | Stock | 25.73 | 25.91 | 25.73 | 25.89 | 200914.0 |
| 2006-09-01 09:30:00 | MSFT | Stock | 25.89 | 25.97 | 25.8 | 25.85 | 5706324.0 |
| 2006-09-01 10:00:00 | MSFT | Stock | 25.85 | 25.85 | 25.67 | 25.71 | 3924922.0 |
| 2006-09-01 10:30:00 | MSFT | Stock | 25.73 | 25.9 | 25.64 | 25.7 | 2597169.0 |
| 2006-09-01 11:00:00 | MSFT | Stock | 25.69 | 25.73 | 25.65 | 25.66 | 1602917.0 |
| 2006-09-01 11:30:00 | MSFT | Stock | 25.65 | 25.74 | 25.64 | 25.73 | 1868510.0 |
| 2006-09-01 12:00:00 | MSFT | Stock | 25.73 | 25.83 | 25.67 | 25.68 | 1220716.0 |
| 2006-09-01 12:30:00 | MSFT | Stock | 25.68 | 25.74 | 25.67 | 25.71 | 1369022.0 |
| 2006-09-01 13:00:00 | MSFT | Stock | 25.71 | 25.73 | 25.68 | 25.69 | 829097.0 |
| 2006-09-01 13:30:00 | MSFT | Stock | 25.7 | 25.7 | 25.66 | 25.67 | 856245.0 |
| 2006-09-01 14:00:00 | MSFT | Stock | 25.668 | 25.7 | 25.64 | 25.69 | 2048520.0 |
| 2006-09-01 14:30:00 | MSFT | Stock | 25.68 | 25.69 | 25.64 | 25.68 | 1174894.0 |
| 2006-09-01 15:00:00 | MSFT | Stock | 25.68 | 25.77 | 25.68 | 25.732 | 2047182.0 |
| 2006-09-01 15:30:00 | MSFT | Stock | 25.73 | 25.9 | 25.71 | 25.83 | 4344861.0 |
| 2006-09-01 16:00:00 | MSFT | Stock | 25.84 | 25.85 | 25.705 | 25.81 | 80318.0 |
| 2006-09-01 16:30:00 | MSFT | Stock | 25.8 | 25.83 | 25.8 | 25.83 | 2100.0 |
| 2006-09-01 17:00:00 | MSFT | Stock | 25.81 | 25.81 | 25.8 | 25.8 | 1841.0 |
| 2006-09-01 17:30:00 | MSFT | Stock | 25.8 | 25.8 | 25.8 | 25.8 | 1810.0 |
| 2006-09-01 18:00:00 | MSFT | Stock | 25.81 | 25.81 | 25.8 | 25.8 | 990.0 |
| 2006-09-01 08:00:00 | NVDA | Stock | 0.4852 | 0.4852 | 0.4852 | 0.4852 | 804000.0 |
| 2006-09-01 08:30:00 | NVDA | Stock | 0.4867 | 0.49 | 0.4852 | 0.4852 | 495480.0 |
| 2006-09-01 09:00:00 | NVDA | Stock | 0.4878 | 0.4895 | 0.4728 | 0.4783 | 4669860.0 |
| 2006-09-01 09:30:00 | NVDA | Stock | 0.478 | 0.4818 | 0.4738 | 0.477 | 113448360.0 |
| 2006-09-01 10:00:00 | NVDA | Stock | 0.477 | 0.477 | 0.4637 | 0.4685 | 97443900.0 |
| 2006-09-01 10:30:00 | NVDA | Stock | 0.4688 | 0.47 | 0.4663 | 0.4685 | 50792940.0 |
> showing 50 of 50,340 rows — these rows as CSV