PREVIEW / stock_30min / 2006-08-23
file: by_date/stock_30min/2006/2006-08-23.parquet size: 893 KB rows: 49,553 symbols: 2,319
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-23 07:00:00 | AAPL | Stock | 2.4179 | 2.4429 | 2.3768 | 2.4382 | 61600.0 |
| 2006-08-23 07:30:00 | AAPL | Stock | 2.4354 | 2.4354 | 2.425 | 2.425 | 44800.0 |
| 2006-08-23 08:00:00 | AAPL | Stock | 2.4232 | 2.4321 | 2.4221 | 2.4286 | 860160.0 |
| 2006-08-23 08:30:00 | AAPL | Stock | 2.4286 | 2.4314 | 2.425 | 2.4286 | 487368.0 |
| 2006-08-23 09:00:00 | AAPL | Stock | 2.4275 | 2.4311 | 2.4109 | 2.4293 | 936348.0 |
| 2006-08-23 09:30:00 | AAPL | Stock | 2.4286 | 2.4518 | 2.4286 | 2.445 | 86932160.0 |
| 2006-08-23 10:00:00 | AAPL | Stock | 2.4443 | 2.4482 | 2.4307 | 2.4404 | 54108656.0 |
| 2006-08-23 10:30:00 | AAPL | Stock | 2.4411 | 2.445 | 2.4182 | 2.4229 | 66680152.0 |
| 2006-08-23 11:00:00 | AAPL | Stock | 2.4229 | 2.4304 | 2.3907 | 2.4029 | 84909664.0 |
| 2006-08-23 11:30:00 | AAPL | Stock | 2.4025 | 2.4104 | 2.3921 | 2.4054 | 39325944.0 |
| 2006-08-23 12:00:00 | AAPL | Stock | 2.405 | 2.4129 | 2.3975 | 2.4025 | 25219124.0 |
| 2006-08-23 12:30:00 | AAPL | Stock | 2.4021 | 2.41 | 2.3968 | 2.4068 | 17545080.0 |
| 2006-08-23 13:00:00 | AAPL | Stock | 2.4071 | 2.4089 | 2.3996 | 2.4071 | 17040828.0 |
| 2006-08-23 13:30:00 | AAPL | Stock | 2.4068 | 2.4068 | 2.3929 | 2.3982 | 26641580.0 |
| 2006-08-23 14:00:00 | AAPL | Stock | 2.3975 | 2.4029 | 2.3946 | 2.3957 | 19732496.0 |
| 2006-08-23 14:30:00 | AAPL | Stock | 2.3954 | 2.4018 | 2.3932 | 2.3977 | 22364188.0 |
| 2006-08-23 15:00:00 | AAPL | Stock | 2.3975 | 2.4036 | 2.3961 | 2.4018 | 23299528.0 |
| 2006-08-23 15:30:00 | AAPL | Stock | 2.4014 | 2.4082 | 2.3968 | 2.4043 | 38450552.0 |
| 2006-08-23 16:00:00 | AAPL | Stock | 2.4032 | 2.4079 | 2.4018 | 2.4018 | 1383396.0 |
| 2006-08-23 16:30:00 | AAPL | Stock | 2.4036 | 2.4054 | 2.3964 | 2.4054 | 520800.0 |
| 2006-08-23 17:00:00 | AAPL | Stock | 2.4 | 2.4043 | 2.3971 | 2.3971 | 129920.0 |
| 2006-08-23 17:30:00 | AAPL | Stock | 2.3971 | 2.4046 | 2.3964 | 2.3968 | 192220.0 |
| 2006-08-23 18:00:00 | AAPL | Stock | 2.3968 | 2.4039 | 2.3964 | 2.3982 | 213360.0 |
| 2006-08-23 07:30:00 | MSFT | Stock | 25.61 | 25.61 | 25.61 | 25.61 | 3000.0 |
| 2006-08-23 08:00:00 | MSFT | Stock | 25.61 | 25.61 | 25.59 | 25.6 | 5292.0 |
| 2006-08-23 08:30:00 | MSFT | Stock | 25.59 | 25.64 | 25.59 | 25.63 | 28219.0 |
| 2006-08-23 09:00:00 | MSFT | Stock | 25.63 | 25.735 | 25.6 | 25.65 | 132406.0 |
| 2006-08-23 09:30:00 | MSFT | Stock | 25.64 | 25.85 | 25.52 | 25.833 | 7260184.0 |
| 2006-08-23 10:00:00 | MSFT | Stock | 25.83 | 25.95 | 25.7 | 25.78 | 7371819.0 |
| 2006-08-23 10:30:00 | MSFT | Stock | 25.78 | 25.82 | 25.68 | 25.731 | 3263910.0 |
| 2006-08-23 11:00:00 | MSFT | Stock | 25.732 | 25.76 | 25.61 | 25.698 | 4116870.0 |
| 2006-08-23 11:30:00 | MSFT | Stock | 25.69 | 25.74 | 25.69 | 25.698 | 1382531.0 |
| 2006-08-23 12:00:00 | MSFT | Stock | 25.7 | 25.73 | 25.643 | 25.643 | 1114621.0 |
| 2006-08-23 12:30:00 | MSFT | Stock | 25.65 | 25.66 | 25.57 | 25.65 | 2316029.0 |
| 2006-08-23 13:00:00 | MSFT | Stock | 25.65 | 25.69 | 25.64 | 25.68 | 1429673.0 |
| 2006-08-23 13:30:00 | MSFT | Stock | 25.68 | 25.69 | 25.55 | 25.59 | 1851372.0 |
| 2006-08-23 14:00:00 | MSFT | Stock | 25.6 | 25.66 | 25.58 | 25.59 | 2037647.0 |
| 2006-08-23 14:30:00 | MSFT | Stock | 25.59 | 25.62 | 25.56 | 25.57 | 2030978.0 |
| 2006-08-23 15:00:00 | MSFT | Stock | 25.57 | 25.63 | 25.56 | 25.589 | 2147789.0 |
| 2006-08-23 15:30:00 | MSFT | Stock | 25.59 | 25.74 | 25.56 | 25.7 | 5175060.0 |
| 2006-08-23 16:00:00 | MSFT | Stock | 25.71 | 25.74 | 25.61 | 25.67 | 96499.0 |
| 2006-08-23 16:30:00 | MSFT | Stock | 25.67 | 25.67 | 25.67 | 25.67 | 186400.0 |
| 2006-08-23 17:00:00 | MSFT | Stock | 25.67 | 25.67 | 25.67 | 25.67 | 1825.0 |
| 2006-08-23 17:30:00 | MSFT | Stock | 25.7 | 25.7 | 25.7 | 25.7 | 500.0 |
| 2006-08-23 18:00:00 | MSFT | Stock | 25.69 | 25.69 | 25.69 | 25.69 | 16020.0 |
| 2006-08-23 08:00:00 | NVDA | Stock | 0.4383 | 0.439 | 0.4383 | 0.439 | 74460.0 |
| 2006-08-23 08:30:00 | NVDA | Stock | 0.4402 | 0.4402 | 0.4402 | 0.4402 | 15540.0 |
| 2006-08-23 09:00:00 | NVDA | Stock | 0.4408 | 0.4418 | 0.4383 | 0.4418 | 746700.0 |
| 2006-08-23 09:30:00 | NVDA | Stock | 0.4418 | 0.4463 | 0.434 | 0.4362 | 62557860.0 |
| 2006-08-23 10:00:00 | NVDA | Stock | 0.4362 | 0.4372 | 0.4297 | 0.4335 | 59729100.0 |
> showing 50 of 49,553 rows — these rows as CSV