PREVIEW / stock_30min / 2006-08-24
file: by_date/stock_30min/2006/2006-08-24.parquet size: 886 KB rows: 48,878 symbols: 2,321
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-24 04:00:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4036 | 2.4036 | 6440.0 |
| 2006-08-24 08:00:00 | AAPL | Stock | 2.4143 | 2.4193 | 2.4089 | 2.4143 | 865620.0 |
| 2006-08-24 08:30:00 | AAPL | Stock | 2.4143 | 2.4196 | 2.4111 | 2.4179 | 427280.0 |
| 2006-08-24 09:00:00 | AAPL | Stock | 2.4179 | 2.4264 | 2.4179 | 2.4257 | 1004752.0 |
| 2006-08-24 09:30:00 | AAPL | Stock | 2.4246 | 2.4304 | 2.4114 | 2.4207 | 49147280.0 |
| 2006-08-24 10:00:00 | AAPL | Stock | 2.4204 | 2.4354 | 2.4129 | 2.4271 | 64685880.0 |
| 2006-08-24 10:30:00 | AAPL | Stock | 2.4271 | 2.4275 | 2.4129 | 2.4211 | 40018160.0 |
| 2006-08-24 11:00:00 | AAPL | Stock | 2.4211 | 2.4243 | 2.415 | 2.415 | 21446656.0 |
| 2006-08-24 11:30:00 | AAPL | Stock | 2.4146 | 2.4175 | 2.4018 | 2.4036 | 30982196.0 |
| 2006-08-24 12:00:00 | AAPL | Stock | 2.4036 | 2.4054 | 2.3957 | 2.4036 | 26641468.0 |
| 2006-08-24 12:30:00 | AAPL | Stock | 2.4036 | 2.4104 | 2.3971 | 2.4075 | 24393712.0 |
| 2006-08-24 13:00:00 | AAPL | Stock | 2.4071 | 2.4079 | 2.3668 | 2.3957 | 159636008.0 |
| 2006-08-24 13:30:00 | AAPL | Stock | 2.3957 | 2.4093 | 2.3907 | 2.405 | 37913988.0 |
| 2006-08-24 14:00:00 | AAPL | Stock | 2.405 | 2.4243 | 2.4018 | 2.4157 | 65594564.0 |
| 2006-08-24 14:30:00 | AAPL | Stock | 2.4157 | 2.4268 | 2.4121 | 2.4254 | 35003080.0 |
| 2006-08-24 15:00:00 | AAPL | Stock | 2.4254 | 2.4261 | 2.4121 | 2.4186 | 33567380.0 |
| 2006-08-24 15:30:00 | AAPL | Stock | 2.4186 | 2.4246 | 2.4164 | 2.4218 | 52324188.0 |
| 2006-08-24 16:00:00 | AAPL | Stock | 2.4218 | 2.4268 | 2.4204 | 2.425 | 2031820.0 |
| 2006-08-24 16:30:00 | AAPL | Stock | 2.4257 | 2.4261 | 2.4243 | 2.4243 | 42000.0 |
| 2006-08-24 17:00:00 | AAPL | Stock | 2.4261 | 2.4261 | 2.4243 | 2.4243 | 107800.0 |
| 2006-08-24 17:30:00 | AAPL | Stock | 2.4243 | 2.4261 | 2.4232 | 2.425 | 334740.0 |
| 2006-08-24 18:00:00 | AAPL | Stock | 2.4246 | 2.4261 | 2.4246 | 2.4257 | 46060.0 |
| 2006-08-24 06:30:00 | MSFT | Stock | 25.75 | 28.0 | 25.75 | 28.0 | 1400.0 |
| 2006-08-24 08:00:00 | MSFT | Stock | 25.7 | 25.7 | 25.7 | 25.7 | 400.0 |
| 2006-08-24 08:30:00 | MSFT | Stock | 25.75 | 25.8 | 25.75 | 25.79 | 38900.0 |
| 2006-08-24 09:00:00 | MSFT | Stock | 25.8 | 25.82 | 25.75 | 25.82 | 42767.0 |
| 2006-08-24 09:30:00 | MSFT | Stock | 25.82 | 25.86 | 25.73 | 25.74 | 3287111.0 |
| 2006-08-24 10:00:00 | MSFT | Stock | 25.75 | 25.85 | 25.68 | 25.82 | 3220846.0 |
| 2006-08-24 10:30:00 | MSFT | Stock | 25.82 | 25.835 | 25.7 | 25.71 | 2415239.0 |
| 2006-08-24 11:00:00 | MSFT | Stock | 25.72 | 25.8 | 25.69 | 25.69 | 2337463.0 |
| 2006-08-24 11:30:00 | MSFT | Stock | 25.69 | 25.72 | 25.56 | 25.61 | 2377608.0 |
| 2006-08-24 12:00:00 | MSFT | Stock | 25.6 | 25.64 | 25.5 | 25.52 | 2440743.0 |
| 2006-08-24 12:30:00 | MSFT | Stock | 25.52 | 25.62 | 25.5 | 25.59 | 3937160.0 |
| 2006-08-24 13:00:00 | MSFT | Stock | 25.6 | 25.7 | 25.58 | 25.67 | 1586294.0 |
| 2006-08-24 13:30:00 | MSFT | Stock | 25.68 | 25.69 | 25.62 | 25.67 | 1030115.0 |
| 2006-08-24 14:00:00 | MSFT | Stock | 25.66 | 25.77 | 25.65 | 25.712 | 2136040.0 |
| 2006-08-24 14:30:00 | MSFT | Stock | 25.71 | 25.77 | 25.69 | 25.76 | 1773793.0 |
| 2006-08-24 15:00:00 | MSFT | Stock | 25.76 | 25.79 | 25.65 | 25.71 | 2467670.0 |
| 2006-08-24 15:30:00 | MSFT | Stock | 25.71 | 25.77 | 25.69 | 25.74 | 4147799.0 |
| 2006-08-24 16:00:00 | MSFT | Stock | 25.75 | 25.85 | 25.73 | 25.78 | 38952.0 |
| 2006-08-24 16:30:00 | MSFT | Stock | 25.75 | 25.75 | 25.74 | 25.74 | 884.0 |
| 2006-08-24 17:30:00 | MSFT | Stock | 25.74 | 25.79 | 25.74 | 25.79 | 4870.0 |
| 2006-08-24 09:00:00 | NVDA | Stock | 0.4388 | 0.44 | 0.4382 | 0.4393 | 192000.0 |
| 2006-08-24 09:30:00 | NVDA | Stock | 0.4393 | 0.4425 | 0.4355 | 0.4363 | 27789000.0 |
| 2006-08-24 10:00:00 | NVDA | Stock | 0.4362 | 0.4403 | 0.4333 | 0.4383 | 34834680.0 |
| 2006-08-24 10:30:00 | NVDA | Stock | 0.4383 | 0.4383 | 0.4342 | 0.4358 | 25878660.0 |
| 2006-08-24 11:00:00 | NVDA | Stock | 0.4358 | 0.4375 | 0.4345 | 0.4362 | 13786860.0 |
| 2006-08-24 11:30:00 | NVDA | Stock | 0.436 | 0.436 | 0.4333 | 0.4342 | 13772580.0 |
| 2006-08-24 12:00:00 | NVDA | Stock | 0.434 | 0.4345 | 0.4323 | 0.4338 | 15965820.0 |
| 2006-08-24 12:30:00 | NVDA | Stock | 0.4341 | 0.4358 | 0.4325 | 0.4345 | 11029020.0 |
> showing 50 of 48,878 rows — these rows as CSV