PREVIEW / stock_1hour / 2002-03-26
file: by_date/stock_1hour/2002/2002-03-26.parquet size: 390 KB rows: 18,445 symbols: 1,401
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-03-26 08:00:00 | AAPL | Stock | 0.4175 | 0.4175 | 0.4175 | 0.4175 | 5600.0 |
| 2002-03-26 09:00:00 | AAPL | Stock | 0.4174 | 0.4179 | 0.4127 | 0.4164 | 33650400.0 |
| 2002-03-26 10:00:00 | AAPL | Stock | 0.4164 | 0.4221 | 0.4159 | 0.4171 | 74166400.0 |
| 2002-03-26 11:00:00 | AAPL | Stock | 0.417 | 0.4171 | 0.4125 | 0.4146 | 25121600.0 |
| 2002-03-26 12:00:00 | AAPL | Stock | 0.4145 | 0.4173 | 0.4144 | 0.4164 | 16889600.0 |
| 2002-03-26 13:00:00 | AAPL | Stock | 0.4161 | 0.4179 | 0.4161 | 0.4173 | 19913600.0 |
| 2002-03-26 14:00:00 | AAPL | Stock | 0.4173 | 0.4195 | 0.4121 | 0.4129 | 27787200.0 |
| 2002-03-26 15:00:00 | AAPL | Stock | 0.4129 | 0.4204 | 0.4107 | 0.4188 | 37895200.0 |
| 2002-03-26 16:00:00 | AAPL | Stock | 0.4189 | 0.4212 | 0.4156 | 0.4212 | 6921600.0 |
| 2002-03-26 18:00:00 | AAPL | Stock | 0.4189 | 0.4189 | 0.4189 | 0.4189 | 28000.0 |
| 2002-03-26 08:00:00 | MSFT | Stock | 29.81 | 29.825 | 29.5015 | 29.61 | 74800.0 |
| 2002-03-26 09:00:00 | MSFT | Stock | 29.615 | 29.82 | 29.415 | 29.8188 | 11249000.0 |
| 2002-03-26 10:00:00 | MSFT | Stock | 29.82 | 30.46 | 29.82 | 29.965 | 15748400.0 |
| 2002-03-26 11:00:00 | MSFT | Stock | 29.96 | 30.085 | 29.79 | 29.895 | 6638200.0 |
| 2002-03-26 12:00:00 | MSFT | Stock | 29.895 | 30.025 | 29.83 | 29.94 | 4186400.0 |
| 2002-03-26 13:00:00 | MSFT | Stock | 29.9444 | 30.015 | 29.76 | 29.78 | 4217000.0 |
| 2002-03-26 14:00:00 | MSFT | Stock | 29.78 | 29.78 | 29.35 | 29.395 | 8640600.0 |
| 2002-03-26 15:00:00 | MSFT | Stock | 29.395 | 29.575 | 29.155 | 29.535 | 11802400.0 |
| 2002-03-26 16:00:00 | MSFT | Stock | 29.535 | 30.0803 | 29.34 | 29.55 | 2194200.0 |
| 2002-03-26 17:00:00 | MSFT | Stock | 29.55 | 29.55 | 29.525 | 29.54 | 35800.0 |
| 2002-03-26 18:00:00 | MSFT | Stock | 29.505 | 29.89 | 29.345 | 29.535 | 48600.0 |
| 2002-03-26 08:00:00 | NVDA | Stock | 0.3846 | 0.3958 | 0.3834 | 0.3839 | 1176000.0 |
| 2002-03-26 09:00:00 | NVDA | Stock | 0.3843 | 0.3914 | 0.3777 | 0.3898 | 175212000.0 |
| 2002-03-26 10:00:00 | NVDA | Stock | 0.3897 | 0.4015 | 0.3895 | 0.3946 | 313764000.0 |
| 2002-03-26 11:00:00 | NVDA | Stock | 0.3946 | 0.397 | 0.3937 | 0.3966 | 75324000.0 |
| 2002-03-26 12:00:00 | NVDA | Stock | 0.3965 | 0.3983 | 0.3958 | 0.3972 | 69792000.0 |
| 2002-03-26 13:00:00 | NVDA | Stock | 0.3973 | 0.3992 | 0.3925 | 0.3925 | 100644000.0 |
| 2002-03-26 14:00:00 | NVDA | Stock | 0.3925 | 0.3925 | 0.3817 | 0.3832 | 143160000.0 |
| 2002-03-26 15:00:00 | NVDA | Stock | 0.3829 | 0.3933 | 0.381 | 0.3912 | 201264000.0 |
| 2002-03-26 16:00:00 | NVDA | Stock | 0.3917 | 0.3937 | 0.3884 | 0.3932 | 9012000.0 |
| 2002-03-26 17:00:00 | NVDA | Stock | 0.3923 | 0.3926 | 0.391 | 0.391 | 288000.0 |
| 2002-03-26 18:00:00 | NVDA | Stock | 0.3917 | 0.3981 | 0.3917 | 0.3981 | 168000.0 |
| 2002-03-26 08:00:00 | AMZN | Stock | 0.735 | 0.735 | 0.735 | 0.735 | 14000.0 |
| 2002-03-26 09:00:00 | AMZN | Stock | 0.736 | 0.757 | 0.7275 | 0.7525 | 16058000.0 |
| 2002-03-26 10:00:00 | AMZN | Stock | 0.7525 | 0.7725 | 0.7515 | 0.7595 | 25752000.0 |
| 2002-03-26 11:00:00 | AMZN | Stock | 0.7595 | 0.7637 | 0.7545 | 0.76 | 8950000.0 |
| 2002-03-26 12:00:00 | AMZN | Stock | 0.76 | 0.7685 | 0.759 | 0.7645 | 7198000.0 |
| 2002-03-26 13:00:00 | AMZN | Stock | 0.763 | 0.767 | 0.7574 | 0.7575 | 6796000.0 |
| 2002-03-26 14:00:00 | AMZN | Stock | 0.757 | 0.757 | 0.7335 | 0.734 | 13712000.0 |
| 2002-03-26 15:00:00 | AMZN | Stock | 0.734 | 0.749 | 0.7325 | 0.7415 | 15112000.0 |
| 2002-03-26 16:00:00 | AMZN | Stock | 0.7415 | 0.7684 | 0.74 | 0.7445 | 2230000.0 |
| 2002-03-26 17:00:00 | AMZN | Stock | 0.7415 | 0.7475 | 0.7415 | 0.7445 | 60000.0 |
| 2002-03-26 18:00:00 | AMZN | Stock | 0.7435 | 0.7435 | 0.7435 | 0.7435 | 2000.0 |
| 2002-03-26 09:00:00 | CL | Stock | 28.15 | 28.185 | 28.035 | 28.17 | 182400.0 |
| 2002-03-26 10:00:00 | CL | Stock | 28.17 | 28.425 | 28.165 | 28.355 | 716800.0 |
| 2002-03-26 11:00:00 | CL | Stock | 28.33 | 28.41 | 28.32 | 28.4 | 533400.0 |
| 2002-03-26 12:00:00 | CL | Stock | 28.4 | 28.525 | 28.4 | 28.47 | 415200.0 |
| 2002-03-26 13:00:00 | CL | Stock | 28.47 | 28.51 | 28.41 | 28.435 | 208800.0 |
| 2002-03-26 14:00:00 | CL | Stock | 28.435 | 28.435 | 28.29 | 28.3 | 259400.0 |
| 2002-03-26 15:00:00 | CL | Stock | 28.285 | 28.45 | 28.275 | 28.345 | 844200.0 |
> showing 50 of 18,445 rows — these rows as CSV