PREVIEW / stock_1hour / 2001-12-07
file: by_date/stock_1hour/2001/2001-12-07.parquet size: 388 KB rows: 18,546 symbols: 1,360
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-07 08:00:00 | AAPL | Stock | 0.4152 | 0.4154 | 0.4059 | 0.4059 | 1103200.0 |
| 2001-12-07 09:00:00 | AAPL | Stock | 0.4061 | 0.4061 | 0.3982 | 0.3991 | 39524800.0 |
| 2001-12-07 10:00:00 | AAPL | Stock | 0.3998 | 0.4014 | 0.3952 | 0.3982 | 37374400.0 |
| 2001-12-07 11:00:00 | AAPL | Stock | 0.3979 | 0.3989 | 0.3945 | 0.3955 | 25435200.0 |
| 2001-12-07 12:00:00 | AAPL | Stock | 0.3955 | 0.3968 | 0.3939 | 0.3961 | 17158400.0 |
| 2001-12-07 13:00:00 | AAPL | Stock | 0.3961 | 0.3989 | 0.3948 | 0.397 | 11855200.0 |
| 2001-12-07 14:00:00 | AAPL | Stock | 0.3957 | 0.3973 | 0.3929 | 0.3971 | 16951200.0 |
| 2001-12-07 15:00:00 | AAPL | Stock | 0.397 | 0.4055 | 0.3952 | 0.4025 | 26460000.0 |
| 2001-12-07 16:00:00 | AAPL | Stock | 0.4023 | 0.4052 | 0.4016 | 0.405 | 19303200.0 |
| 2001-12-07 17:00:00 | AAPL | Stock | 0.4025 | 0.4025 | 0.4025 | 0.4025 | 56000.0 |
| 2001-12-07 08:00:00 | MSFT | Stock | 34.385 | 34.425 | 34.2 | 34.25 | 54000.0 |
| 2001-12-07 09:00:00 | MSFT | Stock | 34.275 | 34.325 | 34.065 | 34.275 | 6823600.0 |
| 2001-12-07 10:00:00 | MSFT | Stock | 34.295 | 34.4 | 34.19 | 34.285 | 7209000.0 |
| 2001-12-07 11:00:00 | MSFT | Stock | 34.2945 | 34.355 | 33.915 | 33.94 | 5914200.0 |
| 2001-12-07 12:00:00 | MSFT | Stock | 33.945 | 34.075 | 33.77 | 33.98 | 3570800.0 |
| 2001-12-07 13:00:00 | MSFT | Stock | 33.9705 | 34.0 | 33.71 | 33.725 | 2385000.0 |
| 2001-12-07 14:00:00 | MSFT | Stock | 33.725 | 33.865 | 33.3 | 33.73 | 8133600.0 |
| 2001-12-07 15:00:00 | MSFT | Stock | 33.73 | 34.015 | 33.585 | 33.92 | 5725600.0 |
| 2001-12-07 16:00:00 | MSFT | Stock | 33.915 | 34.265 | 33.82 | 33.91 | 2092200.0 |
| 2001-12-07 17:00:00 | MSFT | Stock | 33.91 | 33.915 | 33.9 | 33.91 | 30000.0 |
| 2001-12-07 08:00:00 | NVDA | Stock | 0.5175 | 0.5205 | 0.5115 | 0.5125 | 888000.0 |
| 2001-12-07 09:00:00 | NVDA | Stock | 0.5125 | 0.5153 | 0.503 | 0.508 | 93360000.0 |
| 2001-12-07 10:00:00 | NVDA | Stock | 0.508 | 0.5157 | 0.5066 | 0.512 | 101916000.0 |
| 2001-12-07 11:00:00 | NVDA | Stock | 0.5123 | 0.5162 | 0.5003 | 0.5021 | 107172000.0 |
| 2001-12-07 12:00:00 | NVDA | Stock | 0.5018 | 0.5026 | 0.4961 | 0.5008 | 106764000.0 |
| 2001-12-07 13:00:00 | NVDA | Stock | 0.5004 | 0.5017 | 0.4958 | 0.4962 | 59676000.0 |
| 2001-12-07 14:00:00 | NVDA | Stock | 0.4961 | 0.4978 | 0.4907 | 0.496 | 146436000.0 |
| 2001-12-07 15:00:00 | NVDA | Stock | 0.4962 | 0.5039 | 0.4943 | 0.4997 | 125256000.0 |
| 2001-12-07 16:00:00 | NVDA | Stock | 0.4984 | 0.5072 | 0.4984 | 0.5 | 56472000.0 |
| 2001-12-07 17:00:00 | NVDA | Stock | 0.4997 | 0.5004 | 0.4987 | 0.4987 | 108000.0 |
| 2001-12-07 18:00:00 | NVDA | Stock | 0.5002 | 0.5002 | 0.5002 | 0.5002 | 120000.0 |
| 2001-12-07 08:00:00 | AMZN | Stock | 0.6135 | 0.6135 | 0.605 | 0.605 | 532000.0 |
| 2001-12-07 09:00:00 | AMZN | Stock | 0.605 | 0.615 | 0.575 | 0.5875 | 33322000.0 |
| 2001-12-07 10:00:00 | AMZN | Stock | 0.5875 | 0.5975 | 0.581 | 0.593 | 27234000.0 |
| 2001-12-07 11:00:00 | AMZN | Stock | 0.593 | 0.5975 | 0.584 | 0.5876 | 15298000.0 |
| 2001-12-07 12:00:00 | AMZN | Stock | 0.5875 | 0.5935 | 0.5875 | 0.5915 | 12696000.0 |
| 2001-12-07 13:00:00 | AMZN | Stock | 0.592 | 0.5995 | 0.5895 | 0.596 | 14424000.0 |
| 2001-12-07 14:00:00 | AMZN | Stock | 0.596 | 0.597 | 0.5855 | 0.5915 | 15736000.0 |
| 2001-12-07 15:00:00 | AMZN | Stock | 0.5915 | 0.5975 | 0.583 | 0.587 | 17020000.0 |
| 2001-12-07 16:00:00 | AMZN | Stock | 0.586 | 0.5883 | 0.5835 | 0.586 | 3534000.0 |
| 2001-12-07 17:00:00 | AMZN | Stock | 0.587 | 0.587 | 0.5855 | 0.5865 | 70000.0 |
| 2001-12-07 18:00:00 | AMZN | Stock | 0.5865 | 0.5865 | 0.5865 | 0.5865 | 4000.0 |
| 2001-12-07 09:00:00 | CL | Stock | 28.425 | 28.425 | 28.11 | 28.22 | 313800.0 |
| 2001-12-07 10:00:00 | CL | Stock | 28.22 | 28.28 | 28.17 | 28.185 | 298000.0 |
| 2001-12-07 11:00:00 | CL | Stock | 28.185 | 28.225 | 28.08 | 28.08 | 413400.0 |
| 2001-12-07 12:00:00 | CL | Stock | 28.08 | 28.15 | 28.08 | 28.095 | 259600.0 |
| 2001-12-07 13:00:00 | CL | Stock | 28.095 | 28.24 | 28.09 | 28.095 | 222200.0 |
| 2001-12-07 14:00:00 | CL | Stock | 28.095 | 28.425 | 28.075 | 28.425 | 397800.0 |
| 2001-12-07 15:00:00 | CL | Stock | 28.425 | 28.515 | 28.295 | 28.33 | 732600.0 |
| 2001-12-07 16:00:00 | CL | Stock | 28.325 | 28.33 | 28.25 | 28.33 | 98800.0 |
> showing 50 of 18,546 rows — these rows as CSV