PREVIEW / stock_30min / 2010-12-15
file: by_date/stock_30min/2010/2010-12-15.parquet size: 1.4 MB rows: 75,267 symbols: 3,541
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-15 04:00:00 | AAPL | Stock | 11.3946 | 11.3946 | 11.3946 | 11.3946 | 2800.0 |
| 2010-12-15 04:30:00 | AAPL | Stock | 11.4107 | 11.4107 | 11.4107 | 11.4107 | 2800.0 |
| 2010-12-15 05:30:00 | AAPL | Stock | 11.4107 | 11.4107 | 11.3982 | 11.3982 | 18340.0 |
| 2010-12-15 06:00:00 | AAPL | Stock | 11.4107 | 11.4107 | 11.4107 | 11.4107 | 14000.0 |
| 2010-12-15 06:30:00 | AAPL | Stock | 11.4518 | 11.4518 | 11.4514 | 11.4514 | 5600.0 |
| 2010-12-15 07:00:00 | AAPL | Stock | 11.4314 | 11.4446 | 11.4314 | 11.4368 | 41916.0 |
| 2010-12-15 07:30:00 | AAPL | Stock | 11.4446 | 11.4629 | 11.4443 | 11.4443 | 160300.0 |
| 2010-12-15 08:00:00 | AAPL | Stock | 11.4379 | 11.4518 | 11.42 | 11.4232 | 1369368.0 |
| 2010-12-15 08:30:00 | AAPL | Stock | 11.4268 | 11.4286 | 11.3971 | 11.4086 | 1431360.0 |
| 2010-12-15 09:00:00 | AAPL | Stock | 11.4089 | 11.4354 | 11.4089 | 11.4257 | 620956.0 |
| 2010-12-15 09:30:00 | AAPL | Stock | 11.4257 | 11.4732 | 11.415 | 11.4429 | 48680296.0 |
| 2010-12-15 10:00:00 | AAPL | Stock | 11.4432 | 11.4929 | 11.4214 | 11.4807 | 44701636.0 |
| 2010-12-15 10:30:00 | AAPL | Stock | 11.4811 | 11.5357 | 11.4796 | 11.5132 | 41626228.0 |
| 2010-12-15 11:00:00 | AAPL | Stock | 11.5114 | 11.5154 | 11.4732 | 11.4853 | 20873216.0 |
| 2010-12-15 11:30:00 | AAPL | Stock | 11.4836 | 11.4893 | 11.4579 | 11.4775 | 18218844.0 |
| 2010-12-15 12:00:00 | AAPL | Stock | 11.4768 | 11.4821 | 11.4654 | 11.4729 | 9101736.0 |
| 2010-12-15 12:30:00 | AAPL | Stock | 11.4739 | 11.4754 | 11.425 | 11.4329 | 21202272.0 |
| 2010-12-15 13:00:00 | AAPL | Stock | 11.4339 | 11.4464 | 11.4175 | 11.4359 | 18349268.0 |
| 2010-12-15 13:30:00 | AAPL | Stock | 11.4357 | 11.4569 | 11.4196 | 11.4532 | 14916104.0 |
| 2010-12-15 14:00:00 | AAPL | Stock | 11.4543 | 11.4614 | 11.4187 | 11.42 | 13910260.0 |
| 2010-12-15 14:30:00 | AAPL | Stock | 11.4193 | 11.4343 | 11.3996 | 11.4146 | 32855872.0 |
| 2010-12-15 15:00:00 | AAPL | Stock | 11.4125 | 11.45 | 11.4093 | 11.4404 | 22062992.0 |
| 2010-12-15 15:30:00 | AAPL | Stock | 11.4396 | 11.4589 | 11.4236 | 11.4429 | 38460772.0 |
| 2010-12-15 16:00:00 | AAPL | Stock | 11.4429 | 11.4821 | 11.4371 | 11.4507 | 57462188.0 |
| 2010-12-15 16:30:00 | AAPL | Stock | 11.4518 | 11.4614 | 11.4472 | 11.4604 | 764652.0 |
| 2010-12-15 17:00:00 | AAPL | Stock | 11.4604 | 11.4621 | 11.4557 | 11.4571 | 212240.0 |
| 2010-12-15 17:30:00 | AAPL | Stock | 11.4582 | 11.46 | 11.4564 | 11.4571 | 81536.0 |
| 2010-12-15 18:00:00 | AAPL | Stock | 11.4582 | 11.4589 | 11.4414 | 11.4464 | 376656.0 |
| 2010-12-15 18:30:00 | AAPL | Stock | 11.4457 | 11.45 | 11.4446 | 11.4464 | 447888.0 |
| 2010-12-15 19:00:00 | AAPL | Stock | 11.4468 | 11.4482 | 11.4446 | 11.4482 | 144928.0 |
| 2010-12-15 19:30:00 | AAPL | Stock | 11.4446 | 11.4446 | 11.4018 | 11.4164 | 808528.0 |
| 2010-12-15 06:00:00 | MSFT | Stock | 27.43 | 27.57 | 27.43 | 27.57 | 600.0 |
| 2010-12-15 07:30:00 | MSFT | Stock | 27.61 | 27.65 | 27.61 | 27.64 | 1000.0 |
| 2010-12-15 08:00:00 | MSFT | Stock | 27.62 | 27.73 | 27.62 | 27.7 | 14010.0 |
| 2010-12-15 08:30:00 | MSFT | Stock | 27.72 | 27.73 | 27.65 | 27.7 | 30943.0 |
| 2010-12-15 09:00:00 | MSFT | Stock | 27.7 | 27.73 | 27.54 | 27.54 | 189040.0 |
| 2010-12-15 09:30:00 | MSFT | Stock | 27.53 | 27.67 | 27.53 | 27.67 | 7616677.0 |
| 2010-12-15 10:00:00 | MSFT | Stock | 27.665 | 27.77 | 27.6 | 27.77 | 4645478.0 |
| 2010-12-15 10:30:00 | MSFT | Stock | 27.77 | 27.93 | 27.73 | 27.89 | 4431301.0 |
| 2010-12-15 11:00:00 | MSFT | Stock | 27.884 | 27.94 | 27.84 | 27.9 | 3084725.0 |
| 2010-12-15 11:30:00 | MSFT | Stock | 27.9 | 27.97 | 27.89 | 27.965 | 3296526.0 |
| 2010-12-15 12:00:00 | MSFT | Stock | 27.96 | 27.99 | 27.85 | 27.91 | 3407147.0 |
| 2010-12-15 12:30:00 | MSFT | Stock | 27.91 | 27.92 | 27.761 | 27.82 | 3060092.0 |
| 2010-12-15 13:00:00 | MSFT | Stock | 27.825 | 27.835 | 27.73 | 27.78 | 2529418.0 |
| 2010-12-15 13:30:00 | MSFT | Stock | 27.78 | 27.8 | 27.71 | 27.79 | 2437470.0 |
| 2010-12-15 14:00:00 | MSFT | Stock | 27.8 | 27.84 | 27.74 | 27.74 | 2206826.0 |
| 2010-12-15 14:30:00 | MSFT | Stock | 27.75 | 27.8 | 27.68 | 27.77 | 3556592.0 |
| 2010-12-15 15:00:00 | MSFT | Stock | 27.77 | 27.94 | 27.76 | 27.925 | 3805946.0 |
| 2010-12-15 15:30:00 | MSFT | Stock | 27.925 | 27.98 | 27.85 | 27.86 | 10212389.0 |
| 2010-12-15 16:00:00 | MSFT | Stock | 27.85 | 27.912 | 27.63 | 27.86 | 13347887.0 |
> showing 50 of 75,267 rows — these rows as CSV