PREVIEW / stock_1hour / 2002-02-28
file: by_date/stock_1hour/2002/2002-02-28.parquet size: 383 KB rows: 18,444 symbols: 1,392
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-02-28 08:00:00 | AAPL | Stock | 0.3924 | 0.3929 | 0.3916 | 0.3916 | 2654400.0 |
| 2002-02-28 09:00:00 | AAPL | Stock | 0.392 | 0.4014 | 0.3914 | 0.4002 | 95250400.0 |
| 2002-02-28 10:00:00 | AAPL | Stock | 0.4 | 0.4034 | 0.3955 | 0.3963 | 83182400.0 |
| 2002-02-28 11:00:00 | AAPL | Stock | 0.3963 | 0.3964 | 0.3848 | 0.3866 | 81933600.0 |
| 2002-02-28 12:00:00 | AAPL | Stock | 0.3866 | 0.3959 | 0.3859 | 0.3916 | 41260800.0 |
| 2002-02-28 13:00:00 | AAPL | Stock | 0.3916 | 0.3929 | 0.3813 | 0.3839 | 27697600.0 |
| 2002-02-28 14:00:00 | AAPL | Stock | 0.3836 | 0.3889 | 0.3813 | 0.3871 | 50069600.0 |
| 2002-02-28 15:00:00 | AAPL | Stock | 0.3873 | 0.3918 | 0.3845 | 0.3875 | 37542400.0 |
| 2002-02-28 16:00:00 | AAPL | Stock | 0.3875 | 0.3897 | 0.3864 | 0.387 | 11664800.0 |
| 2002-02-28 08:00:00 | MSFT | Stock | 29.175 | 29.41 | 29.175 | 29.4 | 53200.0 |
| 2002-02-28 09:00:00 | MSFT | Stock | 29.4 | 29.544 | 29.07 | 29.465 | 7722400.0 |
| 2002-02-28 10:00:00 | MSFT | Stock | 29.455 | 29.85 | 29.385 | 29.44 | 12908600.0 |
| 2002-02-28 11:00:00 | MSFT | Stock | 29.45 | 29.7 | 29.275 | 29.641 | 7885400.0 |
| 2002-02-28 12:00:00 | MSFT | Stock | 29.64 | 29.725 | 29.5305 | 29.675 | 5409000.0 |
| 2002-02-28 13:00:00 | MSFT | Stock | 29.675 | 29.765 | 29.355 | 29.565 | 9069000.0 |
| 2002-02-28 14:00:00 | MSFT | Stock | 29.565 | 29.645 | 29.165 | 29.325 | 9184400.0 |
| 2002-02-28 15:00:00 | MSFT | Stock | 29.3399 | 29.6 | 29.1585 | 29.17 | 9187200.0 |
| 2002-02-28 16:00:00 | MSFT | Stock | 29.17 | 29.4975 | 29.15 | 29.3 | 4238600.0 |
| 2002-02-28 17:00:00 | MSFT | Stock | 29.23 | 29.3 | 29.23 | 29.275 | 5600.0 |
| 2002-02-28 18:00:00 | MSFT | Stock | 29.3 | 29.3 | 29.25 | 29.25 | 600.0 |
| 2002-02-28 08:00:00 | NVDA | Stock | 0.4417 | 0.4426 | 0.4387 | 0.4421 | 1116000.0 |
| 2002-02-28 09:00:00 | NVDA | Stock | 0.4425 | 0.4479 | 0.4318 | 0.4439 | 251580000.0 |
| 2002-02-28 10:00:00 | NVDA | Stock | 0.4445 | 0.4475 | 0.4342 | 0.435 | 314268000.0 |
| 2002-02-28 11:00:00 | NVDA | Stock | 0.4347 | 0.4379 | 0.4297 | 0.4364 | 208380000.0 |
| 2002-02-28 12:00:00 | NVDA | Stock | 0.4362 | 0.4375 | 0.4335 | 0.4342 | 125928000.0 |
| 2002-02-28 13:00:00 | NVDA | Stock | 0.4342 | 0.4355 | 0.4279 | 0.4291 | 157572000.0 |
| 2002-02-28 14:00:00 | NVDA | Stock | 0.4289 | 0.4292 | 0.4213 | 0.4247 | 206988000.0 |
| 2002-02-28 15:00:00 | NVDA | Stock | 0.4248 | 0.4333 | 0.4238 | 0.4251 | 251976000.0 |
| 2002-02-28 16:00:00 | NVDA | Stock | 0.4252 | 0.4275 | 0.4229 | 0.4232 | 15228000.0 |
| 2002-02-28 17:00:00 | NVDA | Stock | 0.4231 | 0.4247 | 0.423 | 0.4237 | 384000.0 |
| 2002-02-28 18:00:00 | NVDA | Stock | 0.4237 | 0.4248 | 0.4237 | 0.4248 | 192000.0 |
| 2002-02-28 08:00:00 | AMZN | Stock | 0.7135 | 0.715 | 0.7125 | 0.715 | 216000.0 |
| 2002-02-28 09:00:00 | AMZN | Stock | 0.715 | 0.73 | 0.712 | 0.7285 | 13470000.0 |
| 2002-02-28 10:00:00 | AMZN | Stock | 0.7285 | 0.7375 | 0.718 | 0.7205 | 24350000.0 |
| 2002-02-28 11:00:00 | AMZN | Stock | 0.72 | 0.721 | 0.7 | 0.709 | 19784000.0 |
| 2002-02-28 12:00:00 | AMZN | Stock | 0.7095 | 0.712 | 0.7005 | 0.7065 | 13016000.0 |
| 2002-02-28 13:00:00 | AMZN | Stock | 0.7065 | 0.709 | 0.6975 | 0.7015 | 13742000.0 |
| 2002-02-28 14:00:00 | AMZN | Stock | 0.7005 | 0.7115 | 0.6965 | 0.7015 | 12510000.0 |
| 2002-02-28 15:00:00 | AMZN | Stock | 0.703 | 0.715 | 0.7 | 0.7035 | 16936000.0 |
| 2002-02-28 16:00:00 | AMZN | Stock | 0.7035 | 0.7132 | 0.7025 | 0.705 | 5052000.0 |
| 2002-02-28 17:00:00 | AMZN | Stock | 0.703 | 0.705 | 0.7025 | 0.705 | 258000.0 |
| 2002-02-28 18:00:00 | AMZN | Stock | 0.703 | 0.703 | 0.7025 | 0.7025 | 208000.0 |
| 2002-02-28 09:00:00 | CL | Stock | 28.05 | 28.35 | 28.0 | 28.345 | 360200.0 |
| 2002-02-28 10:00:00 | CL | Stock | 28.35 | 28.375 | 28.15 | 28.255 | 674000.0 |
| 2002-02-28 11:00:00 | CL | Stock | 28.25 | 28.255 | 28.075 | 28.15 | 531400.0 |
| 2002-02-28 12:00:00 | CL | Stock | 28.15 | 28.275 | 28.145 | 28.215 | 561200.0 |
| 2002-02-28 13:00:00 | CL | Stock | 28.24 | 28.29 | 28.025 | 28.045 | 815600.0 |
| 2002-02-28 14:00:00 | CL | Stock | 28.045 | 28.1 | 27.875 | 27.99 | 522800.0 |
| 2002-02-28 15:00:00 | CL | Stock | 27.985 | 28.095 | 27.825 | 28.0 | 736000.0 |
| 2002-02-28 16:00:00 | CL | Stock | 28.0 | 28.12 | 27.99 | 27.99 | 165200.0 |
> showing 50 of 18,444 rows — these rows as CSV