PREVIEW / stock_30min / 2006-09-05
file: by_date/stock_30min/2006/2006-09-05.parquet size: 906 KB rows: 49,843 symbols: 2,359
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-05 06:00:00 | AAPL | Stock | 2.4357 | 2.4357 | 2.4357 | 2.4357 | 2800.0 |
| 2006-09-05 06:30:00 | AAPL | Stock | 2.4421 | 2.4421 | 2.4357 | 2.4357 | 9800.0 |
| 2006-09-05 08:00:00 | AAPL | Stock | 2.4429 | 2.4554 | 2.4394 | 2.4525 | 1800372.0 |
| 2006-09-05 08:30:00 | AAPL | Stock | 2.4543 | 2.4643 | 2.4518 | 2.4625 | 1390116.0 |
| 2006-09-05 09:00:00 | AAPL | Stock | 2.4618 | 2.4654 | 2.4564 | 2.4643 | 2137100.0 |
| 2006-09-05 09:30:00 | AAPL | Stock | 2.4632 | 2.4775 | 2.4511 | 2.46 | 108431344.0 |
| 2006-09-05 10:00:00 | AAPL | Stock | 2.46 | 2.4796 | 2.4571 | 2.4604 | 74479692.0 |
| 2006-09-05 10:30:00 | AAPL | Stock | 2.4604 | 2.4686 | 2.4482 | 2.4496 | 56132412.0 |
| 2006-09-05 11:00:00 | AAPL | Stock | 2.4498 | 2.4743 | 2.4496 | 2.4743 | 47489960.0 |
| 2006-09-05 11:30:00 | AAPL | Stock | 2.4743 | 2.4961 | 2.4661 | 2.4939 | 114681140.0 |
| 2006-09-05 12:00:00 | AAPL | Stock | 2.4936 | 2.4971 | 2.4871 | 2.4946 | 52924956.0 |
| 2006-09-05 12:30:00 | AAPL | Stock | 2.4946 | 2.4982 | 2.4893 | 2.4911 | 35360808.0 |
| 2006-09-05 13:00:00 | AAPL | Stock | 2.4907 | 2.5132 | 2.4839 | 2.5089 | 94462676.0 |
| 2006-09-05 13:30:00 | AAPL | Stock | 2.5089 | 2.5136 | 2.4979 | 2.5093 | 61122320.0 |
| 2006-09-05 14:00:00 | AAPL | Stock | 2.5089 | 2.5207 | 2.5046 | 2.52 | 66066308.0 |
| 2006-09-05 14:30:00 | AAPL | Stock | 2.52 | 2.5336 | 2.5139 | 2.5332 | 64299844.0 |
| 2006-09-05 15:00:00 | AAPL | Stock | 2.5332 | 2.5479 | 2.5279 | 2.5393 | 109267564.0 |
| 2006-09-05 15:30:00 | AAPL | Stock | 2.5393 | 2.5536 | 2.5389 | 2.5529 | 102601548.0 |
| 2006-09-05 16:00:00 | AAPL | Stock | 2.5525 | 2.5632 | 2.5493 | 2.5625 | 3935176.0 |
| 2006-09-05 16:30:00 | AAPL | Stock | 2.5625 | 2.5629 | 2.56 | 2.5611 | 1071812.0 |
| 2006-09-05 17:00:00 | AAPL | Stock | 2.5611 | 2.5654 | 2.5607 | 2.5643 | 700112.0 |
| 2006-09-05 17:30:00 | AAPL | Stock | 2.5643 | 2.5668 | 2.5636 | 2.5668 | 768992.0 |
| 2006-09-05 18:00:00 | AAPL | Stock | 2.5668 | 2.5707 | 2.5646 | 2.5654 | 591528.0 |
| 2006-09-05 04:00:00 | MSFT | Stock | 25.84 | 25.84 | 25.84 | 25.84 | 100.0 |
| 2006-09-05 06:30:00 | MSFT | Stock | 25.83 | 25.83 | 25.83 | 25.83 | 1000.0 |
| 2006-09-05 07:30:00 | MSFT | Stock | 25.85 | 25.85 | 25.85 | 25.85 | 1000.0 |
| 2006-09-05 08:00:00 | MSFT | Stock | 25.84 | 25.85 | 25.83 | 25.83 | 7470.0 |
| 2006-09-05 08:30:00 | MSFT | Stock | 25.85 | 25.85 | 25.8 | 25.8 | 6775.0 |
| 2006-09-05 09:00:00 | MSFT | Stock | 25.8 | 25.83 | 25.66 | 25.69 | 156974.0 |
| 2006-09-05 09:30:00 | MSFT | Stock | 25.69 | 25.77 | 25.56 | 25.761 | 8482557.0 |
| 2006-09-05 10:00:00 | MSFT | Stock | 25.76 | 25.96 | 25.73 | 25.9 | 6691655.0 |
| 2006-09-05 10:30:00 | MSFT | Stock | 25.9 | 25.9 | 25.73 | 25.77 | 4507675.0 |
| 2006-09-05 11:00:00 | MSFT | Stock | 25.76 | 25.81 | 25.75 | 25.795 | 2150941.0 |
| 2006-09-05 11:30:00 | MSFT | Stock | 25.793 | 25.85 | 25.761 | 25.841 | 2714357.0 |
| 2006-09-05 12:00:00 | MSFT | Stock | 25.85 | 25.85 | 25.73 | 25.75 | 3060228.0 |
| 2006-09-05 12:30:00 | MSFT | Stock | 25.75 | 25.77 | 25.73 | 25.74 | 1271472.0 |
| 2006-09-05 13:00:00 | MSFT | Stock | 25.74 | 25.75 | 25.69 | 25.72 | 848991.0 |
| 2006-09-05 13:30:00 | MSFT | Stock | 25.72 | 25.73 | 25.61 | 25.66 | 2160943.0 |
| 2006-09-05 14:00:00 | MSFT | Stock | 25.67 | 25.77 | 25.66 | 25.74 | 1980081.0 |
| 2006-09-05 14:30:00 | MSFT | Stock | 25.74 | 25.77 | 25.72 | 25.72 | 1946205.0 |
| 2006-09-05 15:00:00 | MSFT | Stock | 25.72 | 25.73 | 25.64 | 25.67 | 2524288.0 |
| 2006-09-05 15:30:00 | MSFT | Stock | 25.66 | 25.7 | 25.6 | 25.62 | 3999323.0 |
| 2006-09-05 16:00:00 | MSFT | Stock | 25.61 | 25.9 | 25.6 | 25.62 | 259200.0 |
| 2006-09-05 16:30:00 | MSFT | Stock | 25.61 | 25.62 | 25.61 | 25.61 | 1850.0 |
| 2006-09-05 17:00:00 | MSFT | Stock | 25.61 | 25.63 | 25.61 | 25.63 | 3600.0 |
| 2006-09-05 17:30:00 | MSFT | Stock | 25.65 | 25.68 | 25.63 | 25.63 | 17242.0 |
| 2006-09-05 18:00:00 | MSFT | Stock | 25.62 | 25.63 | 25.61 | 25.61 | 5070.0 |
| 2006-09-05 08:00:00 | NVDA | Stock | 0.4633 | 0.4633 | 0.4633 | 0.4633 | 6000.0 |
| 2006-09-05 08:30:00 | NVDA | Stock | 0.4665 | 0.4665 | 0.4642 | 0.4648 | 296940.0 |
| 2006-09-05 09:00:00 | NVDA | Stock | 0.4647 | 0.4692 | 0.4645 | 0.4665 | 1809840.0 |
> showing 50 of 49,843 rows — these rows as CSV