PREVIEW / stock_30min / 2006-08-31
file: by_date/stock_30min/2006/2006-08-31.parquet size: 915 KB rows: 50,748 symbols: 2,341
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-31 07:00:00 | AAPL | Stock | 2.39 | 2.3961 | 2.39 | 2.3961 | 70000.0 |
| 2006-08-31 08:00:00 | AAPL | Stock | 2.3929 | 2.3982 | 2.3921 | 2.3961 | 343756.0 |
| 2006-08-31 08:30:00 | AAPL | Stock | 2.3979 | 2.4025 | 2.3964 | 2.4011 | 455644.0 |
| 2006-08-31 09:00:00 | AAPL | Stock | 2.4011 | 2.4054 | 2.3989 | 2.405 | 705796.0 |
| 2006-08-31 09:30:00 | AAPL | Stock | 2.4029 | 2.4071 | 2.3936 | 2.3993 | 62455512.0 |
| 2006-08-31 10:00:00 | AAPL | Stock | 2.3993 | 2.4054 | 2.3971 | 2.4 | 38565604.0 |
| 2006-08-31 10:30:00 | AAPL | Stock | 2.4004 | 2.4036 | 2.3807 | 2.395 | 59418324.0 |
| 2006-08-31 11:00:00 | AAPL | Stock | 2.3946 | 2.3993 | 2.3907 | 2.3971 | 30205616.0 |
| 2006-08-31 11:30:00 | AAPL | Stock | 2.3975 | 2.4136 | 2.3975 | 2.4093 | 47418196.0 |
| 2006-08-31 12:00:00 | AAPL | Stock | 2.4096 | 2.42 | 2.4096 | 2.4136 | 36720544.0 |
| 2006-08-31 12:30:00 | AAPL | Stock | 2.4132 | 2.4229 | 2.4121 | 2.4179 | 37257276.0 |
| 2006-08-31 13:00:00 | AAPL | Stock | 2.4175 | 2.4186 | 2.4057 | 2.4125 | 24136252.0 |
| 2006-08-31 13:30:00 | AAPL | Stock | 2.4121 | 2.4143 | 2.4039 | 2.4086 | 18844056.0 |
| 2006-08-31 14:00:00 | AAPL | Stock | 2.4082 | 2.4154 | 2.4057 | 2.4129 | 19080124.0 |
| 2006-08-31 14:30:00 | AAPL | Stock | 2.4129 | 2.4254 | 2.4082 | 2.4243 | 38367616.0 |
| 2006-08-31 15:00:00 | AAPL | Stock | 2.4243 | 2.4368 | 2.4221 | 2.4353 | 65019892.0 |
| 2006-08-31 15:30:00 | AAPL | Stock | 2.4352 | 2.4393 | 2.4221 | 2.4232 | 82984300.0 |
| 2006-08-31 16:00:00 | AAPL | Stock | 2.4246 | 2.4257 | 2.4196 | 2.4232 | 1490496.0 |
| 2006-08-31 16:30:00 | AAPL | Stock | 2.4232 | 2.4232 | 2.4214 | 2.4221 | 200200.0 |
| 2006-08-31 17:00:00 | AAPL | Stock | 2.4221 | 2.4239 | 2.4204 | 2.4239 | 88200.0 |
| 2006-08-31 17:30:00 | AAPL | Stock | 2.4229 | 2.4246 | 2.4229 | 2.4246 | 80416.0 |
| 2006-08-31 18:00:00 | AAPL | Stock | 2.4229 | 2.4232 | 2.4207 | 2.4214 | 101724.0 |
| 2006-08-31 08:00:00 | MSFT | Stock | 25.78 | 25.78 | 25.78 | 25.78 | 100.0 |
| 2006-08-31 08:30:00 | MSFT | Stock | 25.86 | 25.86 | 25.86 | 25.86 | 1000.0 |
| 2006-08-31 09:00:00 | MSFT | Stock | 25.84 | 25.89 | 25.8 | 25.87 | 50997.0 |
| 2006-08-31 09:30:00 | MSFT | Stock | 25.87 | 25.98 | 25.81 | 25.92 | 3590946.0 |
| 2006-08-31 10:00:00 | MSFT | Stock | 25.92 | 25.96 | 25.82 | 25.83 | 3461176.0 |
| 2006-08-31 10:30:00 | MSFT | Stock | 25.83 | 25.88 | 25.8 | 25.88 | 1717712.0 |
| 2006-08-31 11:00:00 | MSFT | Stock | 25.88 | 25.89 | 25.84 | 25.84 | 1139199.0 |
| 2006-08-31 11:30:00 | MSFT | Stock | 25.85 | 25.85 | 25.76 | 25.78 | 1041608.0 |
| 2006-08-31 12:00:00 | MSFT | Stock | 25.78 | 25.83 | 25.76 | 25.78 | 1121493.0 |
| 2006-08-31 12:30:00 | MSFT | Stock | 25.78 | 25.83 | 25.77 | 25.77 | 992361.0 |
| 2006-08-31 13:00:00 | MSFT | Stock | 25.77 | 25.8 | 25.75 | 25.77 | 964368.0 |
| 2006-08-31 13:30:00 | MSFT | Stock | 25.77 | 25.79 | 25.77 | 25.78 | 695479.0 |
| 2006-08-31 14:00:00 | MSFT | Stock | 25.78 | 25.79 | 25.77 | 25.78 | 1060530.0 |
| 2006-08-31 14:30:00 | MSFT | Stock | 25.79 | 25.82 | 25.75 | 25.76 | 1782421.0 |
| 2006-08-31 15:00:00 | MSFT | Stock | 25.76 | 25.81 | 25.75 | 25.79 | 1662778.0 |
| 2006-08-31 15:30:00 | MSFT | Stock | 25.78 | 25.816 | 25.68 | 25.68 | 4164160.0 |
| 2006-08-31 16:00:00 | MSFT | Stock | 25.67 | 25.73 | 25.67 | 25.69 | 121857.0 |
| 2006-08-31 16:30:00 | MSFT | Stock | 25.7 | 25.7 | 25.69 | 25.7 | 4656.0 |
| 2006-08-31 18:00:00 | MSFT | Stock | 25.69 | 25.71 | 25.69 | 25.71 | 40732.0 |
| 2006-08-31 08:00:00 | NVDA | Stock | 0.485 | 0.4865 | 0.485 | 0.485 | 168000.0 |
| 2006-08-31 08:30:00 | NVDA | Stock | 0.4865 | 0.4872 | 0.4858 | 0.4858 | 226500.0 |
| 2006-08-31 09:00:00 | NVDA | Stock | 0.4858 | 0.4858 | 0.485 | 0.485 | 184500.0 |
| 2006-08-31 09:30:00 | NVDA | Stock | 0.4858 | 0.4858 | 0.4802 | 0.4833 | 46804680.0 |
| 2006-08-31 10:00:00 | NVDA | Stock | 0.4833 | 0.4865 | 0.4812 | 0.482 | 42489480.0 |
| 2006-08-31 10:30:00 | NVDA | Stock | 0.482 | 0.4823 | 0.4778 | 0.4792 | 64421940.0 |
| 2006-08-31 11:00:00 | NVDA | Stock | 0.4792 | 0.4793 | 0.4747 | 0.4752 | 36318720.0 |
| 2006-08-31 11:30:00 | NVDA | Stock | 0.4752 | 0.4792 | 0.4752 | 0.4788 | 29754180.0 |
| 2006-08-31 12:00:00 | NVDA | Stock | 0.4787 | 0.4792 | 0.4763 | 0.4777 | 19658100.0 |
> showing 50 of 50,748 rows — these rows as CSV