PREVIEW / stock_1hour / 2005-03-11
file: by_date/stock_1hour/2005/2005-03-11.parquet size: 546 KB rows: 25,740 symbols: 1,943
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-11 08:00:00 | AAPL | Stock | 1.4339 | 1.4464 | 1.4339 | 1.4375 | 3694908.0 |
| 2005-03-11 09:00:00 | AAPL | Stock | 1.4382 | 1.4496 | 1.4214 | 1.4475 | 137209464.0 |
| 2005-03-11 10:00:00 | AAPL | Stock | 1.4475 | 1.4482 | 1.4289 | 1.4304 | 128135588.0 |
| 2005-03-11 11:00:00 | AAPL | Stock | 1.4304 | 1.4364 | 1.4282 | 1.4336 | 79176328.0 |
| 2005-03-11 12:00:00 | AAPL | Stock | 1.4339 | 1.4389 | 1.4304 | 1.4365 | 37332232.0 |
| 2005-03-11 13:00:00 | AAPL | Stock | 1.4364 | 1.4375 | 1.4271 | 1.4293 | 50903748.0 |
| 2005-03-11 14:00:00 | AAPL | Stock | 1.4296 | 1.4368 | 1.4282 | 1.4318 | 64821484.0 |
| 2005-03-11 15:00:00 | AAPL | Stock | 1.4321 | 1.4425 | 1.4275 | 1.4389 | 110038012.0 |
| 2005-03-11 16:00:00 | AAPL | Stock | 1.4393 | 1.4436 | 1.4339 | 1.4429 | 4453988.0 |
| 2005-03-11 17:00:00 | AAPL | Stock | 1.4382 | 1.4429 | 1.4382 | 1.4411 | 678720.0 |
| 2005-03-11 18:00:00 | AAPL | Stock | 1.4411 | 1.4429 | 1.4407 | 1.4421 | 12600.0 |
| 2005-03-11 08:00:00 | MSFT | Stock | 25.5 | 25.53 | 25.42 | 25.43 | 82840.0 |
| 2005-03-11 09:00:00 | MSFT | Stock | 25.43 | 25.48 | 25.36 | 25.42 | 7477700.0 |
| 2005-03-11 10:00:00 | MSFT | Stock | 25.42 | 25.45 | 25.31 | 25.33 | 7765385.0 |
| 2005-03-11 11:00:00 | MSFT | Stock | 25.33 | 25.36 | 25.27 | 25.31 | 6561438.0 |
| 2005-03-11 12:00:00 | MSFT | Stock | 25.32 | 25.44 | 25.28 | 25.31 | 3693810.0 |
| 2005-03-11 13:00:00 | MSFT | Stock | 25.31 | 25.33 | 25.25 | 25.29 | 6384597.0 |
| 2005-03-11 14:00:00 | MSFT | Stock | 25.3 | 25.31 | 25.2 | 25.23 | 6613488.0 |
| 2005-03-11 15:00:00 | MSFT | Stock | 25.22 | 25.23 | 25.06 | 25.07 | 19731297.0 |
| 2005-03-11 16:00:00 | MSFT | Stock | 25.09 | 25.23 | 25.03 | 25.06 | 703378.0 |
| 2005-03-11 17:00:00 | MSFT | Stock | 25.06 | 25.175 | 25.06 | 25.07 | 63815.0 |
| 2005-03-11 18:00:00 | MSFT | Stock | 25.07 | 25.07 | 25.05 | 25.05 | 52382.0 |
| 2005-03-11 08:00:00 | NVDA | Stock | 0.2167 | 0.2173 | 0.2167 | 0.2167 | 1335240.0 |
| 2005-03-11 09:00:00 | NVDA | Stock | 0.2162 | 0.2167 | 0.2128 | 0.2129 | 134939160.0 |
| 2005-03-11 10:00:00 | NVDA | Stock | 0.2129 | 0.2138 | 0.2096 | 0.2102 | 177770280.0 |
| 2005-03-11 11:00:00 | NVDA | Stock | 0.2102 | 0.2128 | 0.2102 | 0.2119 | 105956640.0 |
| 2005-03-11 12:00:00 | NVDA | Stock | 0.2119 | 0.2137 | 0.2117 | 0.2127 | 30383640.0 |
| 2005-03-11 13:00:00 | NVDA | Stock | 0.2127 | 0.2135 | 0.2117 | 0.2124 | 26744280.0 |
| 2005-03-11 14:00:00 | NVDA | Stock | 0.2125 | 0.2132 | 0.2097 | 0.2102 | 64956120.0 |
| 2005-03-11 15:00:00 | NVDA | Stock | 0.2102 | 0.2103 | 0.2077 | 0.2092 | 156138720.0 |
| 2005-03-11 16:00:00 | NVDA | Stock | 0.2092 | 0.2097 | 0.2085 | 0.2097 | 26730120.0 |
| 2005-03-11 17:00:00 | NVDA | Stock | 0.2091 | 0.2097 | 0.2091 | 0.2097 | 159600.0 |
| 2005-03-11 08:00:00 | AMZN | Stock | 1.75 | 1.75 | 1.735 | 1.7375 | 208900.0 |
| 2005-03-11 09:00:00 | AMZN | Stock | 1.7425 | 1.745 | 1.724 | 1.725 | 17290560.0 |
| 2005-03-11 10:00:00 | AMZN | Stock | 1.725 | 1.7335 | 1.715 | 1.7195 | 27454180.0 |
| 2005-03-11 11:00:00 | AMZN | Stock | 1.7195 | 1.721 | 1.7075 | 1.7125 | 19015060.0 |
| 2005-03-11 12:00:00 | AMZN | Stock | 1.7125 | 1.7185 | 1.7055 | 1.7175 | 12540120.0 |
| 2005-03-11 13:00:00 | AMZN | Stock | 1.7175 | 1.7245 | 1.7025 | 1.7095 | 18282120.0 |
| 2005-03-11 14:00:00 | AMZN | Stock | 1.71 | 1.7415 | 1.709 | 1.7358 | 25217420.0 |
| 2005-03-11 15:00:00 | AMZN | Stock | 1.736 | 1.741 | 1.7115 | 1.7355 | 35721860.0 |
| 2005-03-11 16:00:00 | AMZN | Stock | 1.7345 | 1.7375 | 1.7255 | 1.7255 | 846380.0 |
| 2005-03-11 17:00:00 | AMZN | Stock | 1.7375 | 1.7375 | 1.735 | 1.7375 | 136440.0 |
| 2005-03-11 09:00:00 | CL | Stock | 26.275 | 26.495 | 26.255 | 26.475 | 438600.0 |
| 2005-03-11 10:00:00 | CL | Stock | 26.495 | 26.625 | 26.465 | 26.485 | 902000.0 |
| 2005-03-11 11:00:00 | CL | Stock | 26.48 | 26.48 | 26.25 | 26.25 | 369800.0 |
| 2005-03-11 12:00:00 | CL | Stock | 26.25 | 26.355 | 26.205 | 26.28 | 294800.0 |
| 2005-03-11 13:00:00 | CL | Stock | 26.285 | 26.305 | 26.225 | 26.245 | 247000.0 |
| 2005-03-11 14:00:00 | CL | Stock | 26.25 | 26.4 | 26.155 | 26.21 | 369800.0 |
| 2005-03-11 15:00:00 | CL | Stock | 26.21 | 26.21 | 26.125 | 26.175 | 460600.0 |
| 2005-03-11 16:00:00 | CL | Stock | 26.17 | 26.17 | 26.17 | 26.17 | 200.0 |
> showing 50 of 25,740 rows — these rows as CSV