PREVIEW / stock_30min / 2002-01-07
file: by_date/stock_30min/2002/2002-01-07.parquet size: 597 KB rows: 30,933 symbols: 1,357
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-07 08:00:00 | AAPL | Stock | 0.4236 | 0.4254 | 0.4198 | 0.4225 | 403200.0 |
| 2002-01-07 08:30:00 | AAPL | Stock | 0.4225 | 0.4234 | 0.4225 | 0.4232 | 834400.0 |
| 2002-01-07 09:00:00 | AAPL | Stock | 0.4232 | 0.4241 | 0.4214 | 0.4236 | 5734400.0 |
| 2002-01-07 09:30:00 | AAPL | Stock | 0.4236 | 0.4286 | 0.417 | 0.4177 | 64422400.0 |
| 2002-01-07 10:00:00 | AAPL | Stock | 0.4175 | 0.4241 | 0.4157 | 0.4218 | 52253600.0 |
| 2002-01-07 10:30:00 | AAPL | Stock | 0.4213 | 0.4218 | 0.4171 | 0.4188 | 24382400.0 |
| 2002-01-07 11:00:00 | AAPL | Stock | 0.4188 | 0.4193 | 0.4145 | 0.4154 | 25099200.0 |
| 2002-01-07 11:30:00 | AAPL | Stock | 0.4152 | 0.4161 | 0.41 | 0.4111 | 43400000.0 |
| 2002-01-07 12:00:00 | AAPL | Stock | 0.4111 | 0.4116 | 0.4063 | 0.4111 | 25334400.0 |
| 2002-01-07 12:30:00 | AAPL | Stock | 0.4113 | 0.415 | 0.4109 | 0.4139 | 11233600.0 |
| 2002-01-07 13:00:00 | AAPL | Stock | 0.4138 | 0.4157 | 0.4116 | 0.4155 | 10970400.0 |
| 2002-01-07 13:30:00 | AAPL | Stock | 0.4152 | 0.4164 | 0.4116 | 0.4134 | 17040800.0 |
| 2002-01-07 14:00:00 | AAPL | Stock | 0.4127 | 0.4161 | 0.4111 | 0.4155 | 30794400.0 |
| 2002-01-07 14:30:00 | AAPL | Stock | 0.4159 | 0.4189 | 0.4143 | 0.4163 | 33980800.0 |
| 2002-01-07 15:00:00 | AAPL | Stock | 0.4157 | 0.417 | 0.4107 | 0.4116 | 26734400.0 |
| 2002-01-07 15:30:00 | AAPL | Stock | 0.4116 | 0.4127 | 0.4077 | 0.4091 | 53116000.0 |
| 2002-01-07 16:00:00 | AAPL | Stock | 0.4095 | 0.4147 | 0.408 | 0.4093 | 6546400.0 |
| 2002-01-07 16:30:00 | AAPL | Stock | 0.4091 | 0.4098 | 0.4089 | 0.4089 | 196000.0 |
| 2002-01-07 17:00:00 | AAPL | Stock | 0.4116 | 0.4116 | 0.4098 | 0.4098 | 50400.0 |
| 2002-01-07 17:30:00 | AAPL | Stock | 0.4089 | 0.4107 | 0.4089 | 0.4107 | 33600.0 |
| 2002-01-07 18:00:00 | AAPL | Stock | 0.4107 | 0.4123 | 0.4089 | 0.4107 | 72800.0 |
| 2002-01-07 08:00:00 | MSFT | Stock | 35.0 | 35.15 | 34.4525 | 35.0 | 270400.0 |
| 2002-01-07 08:30:00 | MSFT | Stock | 35.0 | 35.05 | 34.995 | 35.025 | 164600.0 |
| 2002-01-07 09:00:00 | MSFT | Stock | 35.025 | 35.045 | 34.55 | 34.875 | 685400.0 |
| 2002-01-07 09:30:00 | MSFT | Stock | 34.875 | 35.01 | 34.85 | 34.93 | 10908800.0 |
| 2002-01-07 10:00:00 | MSFT | Stock | 34.93 | 34.975 | 34.7345 | 34.92 | 7791800.0 |
| 2002-01-07 10:30:00 | MSFT | Stock | 34.92 | 34.97 | 34.8 | 34.835 | 3071200.0 |
| 2002-01-07 11:00:00 | MSFT | Stock | 34.835 | 34.95 | 34.785 | 34.845 | 3494800.0 |
| 2002-01-07 11:30:00 | MSFT | Stock | 34.86 | 34.915 | 34.55 | 34.6 | 3783200.0 |
| 2002-01-07 12:00:00 | MSFT | Stock | 34.61 | 34.775 | 34.595 | 34.6451 | 3578000.0 |
| 2002-01-07 12:30:00 | MSFT | Stock | 34.65 | 34.785 | 34.6 | 34.61 | 1525200.0 |
| 2002-01-07 13:00:00 | MSFT | Stock | 34.61 | 34.81 | 34.54 | 34.755 | 2581200.0 |
| 2002-01-07 13:30:00 | MSFT | Stock | 34.75 | 34.795 | 34.575 | 34.685 | 2073800.0 |
| 2002-01-07 14:00:00 | MSFT | Stock | 34.685 | 34.81 | 34.555 | 34.675 | 2028400.0 |
| 2002-01-07 14:30:00 | MSFT | Stock | 34.67 | 34.8105 | 34.36 | 34.515 | 4542400.0 |
| 2002-01-07 15:00:00 | MSFT | Stock | 34.5 | 34.575 | 34.175 | 34.26 | 4080400.0 |
| 2002-01-07 15:30:00 | MSFT | Stock | 34.26 | 34.38 | 34.21 | 34.28 | 4488000.0 |
| 2002-01-07 16:00:00 | MSFT | Stock | 34.275 | 34.905 | 34.26 | 34.26 | 1462000.0 |
| 2002-01-07 16:30:00 | MSFT | Stock | 34.4606 | 34.7296 | 34.225 | 34.28 | 400000.0 |
| 2002-01-07 17:00:00 | MSFT | Stock | 34.32 | 34.345 | 34.28 | 34.28 | 57600.0 |
| 2002-01-07 17:30:00 | MSFT | Stock | 34.345 | 34.375 | 34.325 | 34.35 | 12600.0 |
| 2002-01-07 18:00:00 | MSFT | Stock | 34.37 | 34.37 | 34.26 | 34.3 | 9600.0 |
| 2002-01-07 08:00:00 | NVDA | Stock | 0.5792 | 0.5837 | 0.5792 | 0.5837 | 84000.0 |
| 2002-01-07 08:30:00 | NVDA | Stock | 0.5858 | 0.5858 | 0.5837 | 0.5858 | 408000.0 |
| 2002-01-07 09:00:00 | NVDA | Stock | 0.5837 | 0.5876 | 0.5817 | 0.5825 | 4224000.0 |
| 2002-01-07 09:30:00 | NVDA | Stock | 0.5825 | 0.5833 | 0.5647 | 0.5654 | 166236000.0 |
| 2002-01-07 10:00:00 | NVDA | Stock | 0.5656 | 0.5718 | 0.5613 | 0.5712 | 127884000.0 |
| 2002-01-07 10:30:00 | NVDA | Stock | 0.5712 | 0.5737 | 0.5614 | 0.5632 | 90684000.0 |
| 2002-01-07 11:00:00 | NVDA | Stock | 0.5632 | 0.5645 | 0.5567 | 0.5587 | 117444000.0 |
| 2002-01-07 11:30:00 | NVDA | Stock | 0.5591 | 0.5621 | 0.5583 | 0.5593 | 53412000.0 |
> showing 50 of 30,933 rows — these rows as CSV