PREVIEW / stock_30min / 2006-08-18
file: by_date/stock_30min/2006/2006-08-18.parquet size: 887 KB rows: 48,509 symbols: 2,325
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-18 08:00:00 | AAPL | Stock | 2.4136 | 2.4136 | 2.4071 | 2.4071 | 263340.0 |
| 2006-08-18 08:30:00 | AAPL | Stock | 2.4054 | 2.4089 | 2.4036 | 2.4089 | 473676.0 |
| 2006-08-18 09:00:00 | AAPL | Stock | 2.4089 | 2.4196 | 2.4043 | 2.4193 | 1453088.0 |
| 2006-08-18 09:30:00 | AAPL | Stock | 2.4182 | 2.4211 | 2.4021 | 2.4136 | 92015952.0 |
| 2006-08-18 10:00:00 | AAPL | Stock | 2.4143 | 2.4204 | 2.4093 | 2.4129 | 55610268.0 |
| 2006-08-18 10:30:00 | AAPL | Stock | 2.4125 | 2.4368 | 2.4125 | 2.4346 | 65694524.0 |
| 2006-08-18 11:00:00 | AAPL | Stock | 2.4347 | 2.4429 | 2.4329 | 2.4329 | 43679748.0 |
| 2006-08-18 11:30:00 | AAPL | Stock | 2.4329 | 2.4339 | 2.425 | 2.4311 | 30576476.0 |
| 2006-08-18 12:00:00 | AAPL | Stock | 2.4307 | 2.4329 | 2.4175 | 2.43 | 40022696.0 |
| 2006-08-18 12:30:00 | AAPL | Stock | 2.43 | 2.4354 | 2.425 | 2.4321 | 23461228.0 |
| 2006-08-18 13:00:00 | AAPL | Stock | 2.4325 | 2.4418 | 2.4304 | 2.4336 | 27598228.0 |
| 2006-08-18 13:30:00 | AAPL | Stock | 2.4336 | 2.436 | 2.4282 | 2.4286 | 20524084.0 |
| 2006-08-18 14:00:00 | AAPL | Stock | 2.4286 | 2.4325 | 2.4254 | 2.4293 | 26058088.0 |
| 2006-08-18 14:30:00 | AAPL | Stock | 2.4293 | 2.4354 | 2.4218 | 2.4232 | 26139904.0 |
| 2006-08-18 15:00:00 | AAPL | Stock | 2.4232 | 2.4279 | 2.4225 | 2.4268 | 23685956.0 |
| 2006-08-18 15:30:00 | AAPL | Stock | 2.4268 | 2.4293 | 2.4232 | 2.4264 | 47753888.0 |
| 2006-08-18 16:00:00 | AAPL | Stock | 2.4264 | 2.4286 | 2.4257 | 2.4279 | 1029700.0 |
| 2006-08-18 16:30:00 | AAPL | Stock | 2.4271 | 2.4286 | 2.4243 | 2.4243 | 877240.0 |
| 2006-08-18 17:00:00 | AAPL | Stock | 2.4286 | 2.4286 | 2.4286 | 2.4286 | 28000.0 |
| 2006-08-18 17:30:00 | AAPL | Stock | 2.4271 | 2.4286 | 2.4239 | 2.4239 | 63000.0 |
| 2006-08-18 08:00:00 | MSFT | Stock | 24.63 | 24.71 | 24.63 | 24.64 | 1700.0 |
| 2006-08-18 08:30:00 | MSFT | Stock | 24.67 | 24.68 | 24.66 | 24.68 | 3500.0 |
| 2006-08-18 09:00:00 | MSFT | Stock | 24.69 | 25.2 | 24.68 | 25.06 | 1766956.0 |
| 2006-08-18 09:30:00 | MSFT | Stock | 25.05 | 25.129 | 24.98 | 25.02 | 20953835.0 |
| 2006-08-18 10:00:00 | MSFT | Stock | 25.03 | 25.08 | 25.0 | 25.052 | 5447401.0 |
| 2006-08-18 10:30:00 | MSFT | Stock | 25.05 | 25.1 | 25.04 | 25.09 | 4191304.0 |
| 2006-08-18 11:00:00 | MSFT | Stock | 25.1 | 25.36 | 25.06 | 25.347 | 14305896.0 |
| 2006-08-18 11:30:00 | MSFT | Stock | 25.35 | 25.43 | 25.05 | 25.41 | 9965420.0 |
| 2006-08-18 12:00:00 | MSFT | Stock | 25.42 | 25.54 | 25.4 | 25.49 | 10115562.0 |
| 2006-08-18 12:30:00 | MSFT | Stock | 25.5 | 25.51 | 25.44 | 25.44 | 3670216.0 |
| 2006-08-18 13:00:00 | MSFT | Stock | 25.44 | 25.49 | 25.4 | 25.44 | 4252535.0 |
| 2006-08-18 13:30:00 | MSFT | Stock | 25.448 | 25.45 | 25.42 | 25.42 | 2831807.0 |
| 2006-08-18 14:00:00 | MSFT | Stock | 25.43 | 25.48 | 25.42 | 25.47 | 5393953.0 |
| 2006-08-18 14:30:00 | MSFT | Stock | 25.47 | 25.53 | 25.46 | 25.48 | 6362908.0 |
| 2006-08-18 15:00:00 | MSFT | Stock | 25.49 | 25.71 | 25.47 | 25.7 | 10495809.0 |
| 2006-08-18 15:30:00 | MSFT | Stock | 25.7 | 25.8 | 25.66 | 25.78 | 21538816.0 |
| 2006-08-18 16:00:00 | MSFT | Stock | 25.79 | 25.85 | 25.74 | 25.78 | 1071960.0 |
| 2006-08-18 16:30:00 | MSFT | Stock | 25.78 | 25.79 | 25.76 | 25.78 | 44049.0 |
| 2006-08-18 17:00:00 | MSFT | Stock | 25.79 | 25.79 | 25.7 | 25.76 | 2363498.0 |
| 2006-08-18 17:30:00 | MSFT | Stock | 25.78 | 25.8 | 25.76 | 25.8 | 3675.0 |
| 2006-08-18 18:00:00 | MSFT | Stock | 25.79 | 25.79 | 25.77 | 25.78 | 9800.0 |
| 2006-08-18 06:30:00 | NVDA | Stock | 0.4625 | 0.4625 | 0.4625 | 0.4625 | 6000.0 |
| 2006-08-18 07:00:00 | NVDA | Stock | 0.4535 | 0.4583 | 0.4535 | 0.4583 | 24060.0 |
| 2006-08-18 07:30:00 | NVDA | Stock | 0.4567 | 0.4567 | 0.455 | 0.455 | 408000.0 |
| 2006-08-18 08:00:00 | NVDA | Stock | 0.455 | 0.4567 | 0.45 | 0.45 | 4110000.0 |
| 2006-08-18 08:30:00 | NVDA | Stock | 0.45 | 0.45 | 0.4458 | 0.449 | 9403020.0 |
| 2006-08-18 09:00:00 | NVDA | Stock | 0.448 | 0.45 | 0.4467 | 0.4493 | 3282060.0 |
| 2006-08-18 09:30:00 | NVDA | Stock | 0.4492 | 0.4498 | 0.4338 | 0.4347 | 146428620.0 |
| 2006-08-18 10:00:00 | NVDA | Stock | 0.4347 | 0.4415 | 0.4335 | 0.4397 | 63800640.0 |
| 2006-08-18 10:30:00 | NVDA | Stock | 0.4395 | 0.4478 | 0.4395 | 0.4453 | 62228880.0 |
> showing 50 of 48,509 rows — these rows as CSV