PREVIEW / stock_30min / 2006-08-22
file: by_date/stock_30min/2006/2006-08-22.parquet size: 875 KB rows: 48,391 symbols: 2,339
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-22 08:00:00 | AAPL | Stock | 2.3732 | 2.3732 | 2.3661 | 2.3732 | 283500.0 |
| 2006-08-22 08:30:00 | AAPL | Stock | 2.3732 | 2.3843 | 2.3732 | 2.3829 | 395108.0 |
| 2006-08-22 09:00:00 | AAPL | Stock | 2.3839 | 2.3854 | 2.375 | 2.3804 | 518336.0 |
| 2006-08-22 09:30:00 | AAPL | Stock | 2.3814 | 2.4061 | 2.375 | 2.3996 | 73768016.0 |
| 2006-08-22 10:00:00 | AAPL | Stock | 2.3996 | 2.4229 | 2.3971 | 2.4193 | 64282036.0 |
| 2006-08-22 10:30:00 | AAPL | Stock | 2.4193 | 2.4254 | 2.4164 | 2.4207 | 56660912.0 |
| 2006-08-22 11:00:00 | AAPL | Stock | 2.4207 | 2.435 | 2.4143 | 2.4332 | 41333880.0 |
| 2006-08-22 11:30:00 | AAPL | Stock | 2.4332 | 2.44 | 2.4321 | 2.4361 | 40717656.0 |
| 2006-08-22 12:00:00 | AAPL | Stock | 2.4361 | 2.4368 | 2.4225 | 2.4286 | 34141464.0 |
| 2006-08-22 12:30:00 | AAPL | Stock | 2.4286 | 2.4336 | 2.4236 | 2.4329 | 19930064.0 |
| 2006-08-22 13:00:00 | AAPL | Stock | 2.4332 | 2.4339 | 2.4132 | 2.4175 | 41742540.0 |
| 2006-08-22 13:30:00 | AAPL | Stock | 2.4171 | 2.42 | 2.4046 | 2.4082 | 44650452.0 |
| 2006-08-22 14:00:00 | AAPL | Stock | 2.4089 | 2.4143 | 2.4014 | 2.4086 | 35103208.0 |
| 2006-08-22 14:30:00 | AAPL | Stock | 2.4089 | 2.4175 | 2.4086 | 2.4168 | 25743816.0 |
| 2006-08-22 15:00:00 | AAPL | Stock | 2.4168 | 2.4229 | 2.4129 | 2.4136 | 29270472.0 |
| 2006-08-22 15:30:00 | AAPL | Stock | 2.4143 | 2.4204 | 2.4114 | 2.4146 | 43362648.0 |
| 2006-08-22 16:00:00 | AAPL | Stock | 2.4136 | 2.4171 | 2.4114 | 2.4125 | 1413916.0 |
| 2006-08-22 16:30:00 | AAPL | Stock | 2.4125 | 2.415 | 2.41 | 2.4136 | 13325228.0 |
| 2006-08-22 17:00:00 | AAPL | Stock | 2.4132 | 2.4143 | 2.4132 | 2.4143 | 70560.0 |
| 2006-08-22 17:30:00 | AAPL | Stock | 2.4143 | 2.4143 | 2.4143 | 2.4143 | 19600.0 |
| 2006-08-22 18:00:00 | AAPL | Stock | 2.4146 | 2.4161 | 2.4146 | 2.4161 | 244580.0 |
| 2006-08-22 07:30:00 | MSFT | Stock | 26.08 | 26.1 | 26.04 | 26.04 | 1150.0 |
| 2006-08-22 08:00:00 | MSFT | Stock | 26.03 | 26.09 | 26.0 | 26.02 | 89188.0 |
| 2006-08-22 08:30:00 | MSFT | Stock | 26.03 | 26.04 | 26.01 | 26.01 | 19850.0 |
| 2006-08-22 09:00:00 | MSFT | Stock | 26.03 | 26.08 | 25.99 | 26.01 | 242837.0 |
| 2006-08-22 09:30:00 | MSFT | Stock | 26.01 | 26.25 | 25.99 | 26.21 | 9805333.0 |
| 2006-08-22 10:00:00 | MSFT | Stock | 26.21 | 26.25 | 26.19 | 26.23 | 4398951.0 |
| 2006-08-22 10:30:00 | MSFT | Stock | 26.23 | 26.24 | 26.15 | 26.19 | 5566944.0 |
| 2006-08-22 11:00:00 | MSFT | Stock | 26.18 | 26.2 | 26.12 | 26.15 | 5840300.0 |
| 2006-08-22 11:30:00 | MSFT | Stock | 26.15 | 26.19 | 26.01 | 26.03 | 5609587.0 |
| 2006-08-22 12:00:00 | MSFT | Stock | 26.03 | 26.03 | 25.87 | 25.878 | 6587142.0 |
| 2006-08-22 12:30:00 | MSFT | Stock | 25.87 | 25.93 | 25.84 | 25.929 | 3104003.0 |
| 2006-08-22 13:00:00 | MSFT | Stock | 25.93 | 25.94 | 25.8 | 25.8 | 4992393.0 |
| 2006-08-22 13:30:00 | MSFT | Stock | 25.81 | 25.82 | 25.71 | 25.77 | 6048773.0 |
| 2006-08-22 14:00:00 | MSFT | Stock | 25.76 | 25.78 | 25.66 | 25.71 | 4348010.0 |
| 2006-08-22 14:30:00 | MSFT | Stock | 25.712 | 25.78 | 25.69 | 25.76 | 3369571.0 |
| 2006-08-22 15:00:00 | MSFT | Stock | 25.77 | 25.82 | 25.69 | 25.75 | 7880342.0 |
| 2006-08-22 15:30:00 | MSFT | Stock | 25.75 | 25.971 | 25.62 | 25.66 | 11434489.0 |
| 2006-08-22 16:00:00 | MSFT | Stock | 25.66 | 25.66 | 25.57 | 25.58 | 1360973.0 |
| 2006-08-22 16:30:00 | MSFT | Stock | 25.57 | 26.016 | 25.5 | 25.5 | 110418.0 |
| 2006-08-22 17:00:00 | MSFT | Stock | 25.5 | 25.62 | 25.5 | 25.54 | 34800.0 |
| 2006-08-22 17:30:00 | MSFT | Stock | 25.54 | 25.57 | 25.54 | 25.57 | 4400.0 |
| 2006-08-22 18:00:00 | MSFT | Stock | 25.56 | 25.57 | 25.52 | 25.57 | 17523.0 |
| 2006-08-22 08:30:00 | NVDA | Stock | 0.4383 | 0.4383 | 0.4383 | 0.4383 | 18000.0 |
| 2006-08-22 09:00:00 | NVDA | Stock | 0.4392 | 0.4402 | 0.4365 | 0.4402 | 411960.0 |
| 2006-08-22 09:30:00 | NVDA | Stock | 0.4378 | 0.4488 | 0.4378 | 0.4463 | 77593140.0 |
| 2006-08-22 10:00:00 | NVDA | Stock | 0.4465 | 0.4488 | 0.4438 | 0.4482 | 40023960.0 |
| 2006-08-22 10:30:00 | NVDA | Stock | 0.4483 | 0.4487 | 0.4453 | 0.446 | 18099420.0 |
| 2006-08-22 11:00:00 | NVDA | Stock | 0.4458 | 0.45 | 0.4433 | 0.4497 | 31003680.0 |
| 2006-08-22 11:30:00 | NVDA | Stock | 0.4498 | 0.4507 | 0.447 | 0.4476 | 34031640.0 |
> showing 50 of 48,391 rows — these rows as CSV