PREVIEW / stock_1hour / 2001-12-06
file: by_date/stock_1hour/2001/2001-12-06.parquet size: 390 KB rows: 18,445 symbols: 1,363
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-06 08:00:00 | AAPL | Stock | 0.4238 | 0.4238 | 0.4214 | 0.4214 | 128800.0 |
| 2001-12-06 09:00:00 | AAPL | Stock | 0.4214 | 0.4214 | 0.4114 | 0.4161 | 36719200.0 |
| 2001-12-06 10:00:00 | AAPL | Stock | 0.4168 | 0.4191 | 0.408 | 0.4091 | 39614400.0 |
| 2001-12-06 11:00:00 | AAPL | Stock | 0.4091 | 0.4121 | 0.4075 | 0.4109 | 43920800.0 |
| 2001-12-06 12:00:00 | AAPL | Stock | 0.4109 | 0.4121 | 0.4066 | 0.4095 | 44290400.0 |
| 2001-12-06 13:00:00 | AAPL | Stock | 0.4095 | 0.41 | 0.4054 | 0.4077 | 21677600.0 |
| 2001-12-06 14:00:00 | AAPL | Stock | 0.4082 | 0.4082 | 0.3973 | 0.4009 | 48591200.0 |
| 2001-12-06 15:00:00 | AAPL | Stock | 0.4009 | 0.4073 | 0.3954 | 0.407 | 89185600.0 |
| 2001-12-06 16:00:00 | AAPL | Stock | 0.407 | 0.4123 | 0.4036 | 0.4068 | 13860000.0 |
| 2001-12-06 17:00:00 | AAPL | Stock | 0.4114 | 0.4114 | 0.4107 | 0.4107 | 28000.0 |
| 2001-12-06 08:00:00 | MSFT | Stock | 34.04 | 34.175 | 34.0055 | 34.075 | 30000.0 |
| 2001-12-06 09:00:00 | MSFT | Stock | 34.065 | 34.12 | 33.775 | 34.055 | 8294200.0 |
| 2001-12-06 10:00:00 | MSFT | Stock | 34.055 | 34.4 | 34.025 | 34.085 | 12216600.0 |
| 2001-12-06 11:00:00 | MSFT | Stock | 34.0675 | 34.37 | 33.975 | 34.325 | 5698600.0 |
| 2001-12-06 12:00:00 | MSFT | Stock | 34.32 | 34.5 | 34.27 | 34.47 | 4934400.0 |
| 2001-12-06 13:00:00 | MSFT | Stock | 34.4695 | 34.475 | 34.135 | 34.21 | 4652800.0 |
| 2001-12-06 14:00:00 | MSFT | Stock | 34.215 | 34.255 | 34.025 | 34.19 | 5937000.0 |
| 2001-12-06 15:00:00 | MSFT | Stock | 34.19 | 34.39 | 34.0945 | 34.31 | 8817000.0 |
| 2001-12-06 16:00:00 | MSFT | Stock | 34.31 | 34.6 | 34.13 | 34.555 | 2783200.0 |
| 2001-12-06 17:00:00 | MSFT | Stock | 34.56 | 34.57 | 34.385 | 34.51 | 21000.0 |
| 2001-12-06 18:00:00 | MSFT | Stock | 34.52 | 34.55 | 34.52 | 34.52 | 5600.0 |
| 2001-12-06 08:00:00 | NVDA | Stock | 0.5235 | 0.5236 | 0.5217 | 0.5217 | 744000.0 |
| 2001-12-06 09:00:00 | NVDA | Stock | 0.5212 | 0.5228 | 0.5083 | 0.5167 | 178728000.0 |
| 2001-12-06 10:00:00 | NVDA | Stock | 0.517 | 0.5207 | 0.5057 | 0.5069 | 248964000.0 |
| 2001-12-06 11:00:00 | NVDA | Stock | 0.507 | 0.5115 | 0.5022 | 0.511 | 176472000.0 |
| 2001-12-06 12:00:00 | NVDA | Stock | 0.511 | 0.5177 | 0.5104 | 0.5177 | 111984000.0 |
| 2001-12-06 13:00:00 | NVDA | Stock | 0.5165 | 0.5207 | 0.5072 | 0.5091 | 102516000.0 |
| 2001-12-06 14:00:00 | NVDA | Stock | 0.5091 | 0.5102 | 0.5047 | 0.508 | 118044000.0 |
| 2001-12-06 15:00:00 | NVDA | Stock | 0.508 | 0.5157 | 0.5063 | 0.5157 | 135432000.0 |
| 2001-12-06 16:00:00 | NVDA | Stock | 0.5153 | 0.5209 | 0.5118 | 0.5183 | 23496000.0 |
| 2001-12-06 17:00:00 | NVDA | Stock | 0.5181 | 0.5192 | 0.5163 | 0.5175 | 348000.0 |
| 2001-12-06 18:00:00 | NVDA | Stock | 0.5175 | 0.5207 | 0.5175 | 0.5207 | 228000.0 |
| 2001-12-06 08:00:00 | AMZN | Stock | 0.59 | 0.6035 | 0.5883 | 0.599 | 1314000.0 |
| 2001-12-06 09:00:00 | AMZN | Stock | 0.599 | 0.62 | 0.5925 | 0.6125 | 48744000.0 |
| 2001-12-06 10:00:00 | AMZN | Stock | 0.6125 | 0.6155 | 0.606 | 0.61 | 51448000.0 |
| 2001-12-06 11:00:00 | AMZN | Stock | 0.609 | 0.6195 | 0.6065 | 0.612 | 35572000.0 |
| 2001-12-06 12:00:00 | AMZN | Stock | 0.612 | 0.6165 | 0.611 | 0.6135 | 34730000.0 |
| 2001-12-06 13:00:00 | AMZN | Stock | 0.614 | 0.615 | 0.6045 | 0.605 | 25576000.0 |
| 2001-12-06 14:00:00 | AMZN | Stock | 0.605 | 0.6055 | 0.5955 | 0.605 | 15390000.0 |
| 2001-12-06 15:00:00 | AMZN | Stock | 0.605 | 0.6135 | 0.5995 | 0.605 | 21070000.0 |
| 2001-12-06 16:00:00 | AMZN | Stock | 0.6045 | 0.61 | 0.601 | 0.61 | 5030000.0 |
| 2001-12-06 17:00:00 | AMZN | Stock | 0.61 | 0.6105 | 0.6055 | 0.6055 | 208000.0 |
| 2001-12-06 18:00:00 | AMZN | Stock | 0.605 | 0.6065 | 0.605 | 0.606 | 30000.0 |
| 2001-12-06 09:00:00 | CL | Stock | 28.675 | 28.795 | 28.665 | 28.665 | 379800.0 |
| 2001-12-06 10:00:00 | CL | Stock | 28.675 | 28.69 | 28.5 | 28.515 | 506800.0 |
| 2001-12-06 11:00:00 | CL | Stock | 28.525 | 28.6 | 28.5 | 28.585 | 345800.0 |
| 2001-12-06 12:00:00 | CL | Stock | 28.59 | 28.675 | 28.585 | 28.655 | 188200.0 |
| 2001-12-06 13:00:00 | CL | Stock | 28.665 | 28.67 | 28.525 | 28.54 | 312000.0 |
| 2001-12-06 14:00:00 | CL | Stock | 28.54 | 28.55 | 28.475 | 28.475 | 411800.0 |
| 2001-12-06 15:00:00 | CL | Stock | 28.475 | 28.525 | 28.425 | 28.445 | 1522000.0 |
> showing 50 of 18,445 rows — these rows as CSV