PREVIEW / stock_1hour / 2005-03-10
file: by_date/stock_1hour/2005/2005-03-10.parquet size: 544 KB rows: 25,780 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-10 08:00:00 | AAPL | Stock | 1.4014 | 1.4093 | 1.3932 | 1.4093 | 2093476.0 |
| 2005-03-10 09:00:00 | AAPL | Stock | 1.4089 | 1.4379 | 1.4082 | 1.4307 | 151943624.0 |
| 2005-03-10 10:00:00 | AAPL | Stock | 1.4307 | 1.4339 | 1.4046 | 1.4104 | 150769948.0 |
| 2005-03-10 11:00:00 | AAPL | Stock | 1.4104 | 1.4196 | 1.3964 | 1.4196 | 121497712.0 |
| 2005-03-10 12:00:00 | AAPL | Stock | 1.4193 | 1.4232 | 1.4086 | 1.4229 | 70400764.0 |
| 2005-03-10 13:00:00 | AAPL | Stock | 1.4229 | 1.4296 | 1.4182 | 1.4239 | 98286524.0 |
| 2005-03-10 14:00:00 | AAPL | Stock | 1.4239 | 1.4246 | 1.4146 | 1.4204 | 65454592.0 |
| 2005-03-10 15:00:00 | AAPL | Stock | 1.4207 | 1.4254 | 1.4107 | 1.4246 | 95835180.0 |
| 2005-03-10 16:00:00 | AAPL | Stock | 1.4229 | 1.4296 | 1.4193 | 1.4275 | 5686576.0 |
| 2005-03-10 17:00:00 | AAPL | Stock | 1.4279 | 1.4304 | 1.4175 | 1.4261 | 795284.0 |
| 2005-03-10 18:00:00 | AAPL | Stock | 1.425 | 1.4321 | 1.425 | 1.4307 | 355600.0 |
| 2005-03-10 08:00:00 | MSFT | Stock | 25.41 | 25.42 | 25.32 | 25.39 | 62650.0 |
| 2005-03-10 09:00:00 | MSFT | Stock | 25.38 | 25.73 | 25.31 | 25.36 | 7226944.0 |
| 2005-03-10 10:00:00 | MSFT | Stock | 25.35 | 25.39 | 25.31 | 25.35 | 7458160.0 |
| 2005-03-10 11:00:00 | MSFT | Stock | 25.35 | 25.35 | 25.25 | 25.31 | 5988920.0 |
| 2005-03-10 12:00:00 | MSFT | Stock | 25.31 | 25.37 | 25.27 | 25.29 | 5335799.0 |
| 2005-03-10 13:00:00 | MSFT | Stock | 25.292 | 25.38 | 25.28 | 25.34 | 9086729.0 |
| 2005-03-10 14:00:00 | MSFT | Stock | 25.34 | 25.34 | 25.28 | 25.32 | 8814513.0 |
| 2005-03-10 15:00:00 | MSFT | Stock | 25.33 | 25.44 | 25.3 | 25.44 | 7755581.0 |
| 2005-03-10 16:00:00 | MSFT | Stock | 25.43 | 25.53 | 25.41 | 25.5 | 5488616.0 |
| 2005-03-10 17:00:00 | MSFT | Stock | 25.5 | 25.53 | 25.336 | 25.46 | 201687.0 |
| 2005-03-10 18:00:00 | MSFT | Stock | 25.45 | 25.46 | 25.4 | 25.41 | 31700.0 |
| 2005-03-10 08:00:00 | NVDA | Stock | 0.215 | 0.2155 | 0.215 | 0.215 | 672000.0 |
| 2005-03-10 09:00:00 | NVDA | Stock | 0.2153 | 0.2172 | 0.2147 | 0.2161 | 74081040.0 |
| 2005-03-10 10:00:00 | NVDA | Stock | 0.216 | 0.2164 | 0.2129 | 0.2133 | 119193240.0 |
| 2005-03-10 11:00:00 | NVDA | Stock | 0.2134 | 0.2135 | 0.2119 | 0.2122 | 110019480.0 |
| 2005-03-10 12:00:00 | NVDA | Stock | 0.2123 | 0.2154 | 0.2111 | 0.2154 | 81442800.0 |
| 2005-03-10 13:00:00 | NVDA | Stock | 0.2154 | 0.2162 | 0.2145 | 0.2146 | 97745040.0 |
| 2005-03-10 14:00:00 | NVDA | Stock | 0.2146 | 0.2159 | 0.2132 | 0.2155 | 92109240.0 |
| 2005-03-10 15:00:00 | NVDA | Stock | 0.2155 | 0.2157 | 0.2142 | 0.2145 | 96879480.0 |
| 2005-03-10 16:00:00 | NVDA | Stock | 0.2145 | 0.2179 | 0.2137 | 0.2167 | 7892400.0 |
| 2005-03-10 17:00:00 | NVDA | Stock | 0.2173 | 0.2173 | 0.215 | 0.215 | 1008000.0 |
| 2005-03-10 18:00:00 | NVDA | Stock | 0.215 | 0.216 | 0.215 | 0.216 | 432000.0 |
| 2005-03-10 08:00:00 | AMZN | Stock | 1.77 | 1.7715 | 1.77 | 1.7715 | 26000.0 |
| 2005-03-10 09:00:00 | AMZN | Stock | 1.7715 | 1.8025 | 1.7605 | 1.763 | 11398480.0 |
| 2005-03-10 10:00:00 | AMZN | Stock | 1.763 | 1.764 | 1.744 | 1.745 | 19189680.0 |
| 2005-03-10 11:00:00 | AMZN | Stock | 1.7445 | 1.759 | 1.7285 | 1.749 | 31295040.0 |
| 2005-03-10 12:00:00 | AMZN | Stock | 1.75 | 1.752 | 1.7405 | 1.751 | 10771480.0 |
| 2005-03-10 13:00:00 | AMZN | Stock | 1.75 | 1.7585 | 1.746 | 1.7555 | 12216080.0 |
| 2005-03-10 14:00:00 | AMZN | Stock | 1.756 | 1.756 | 1.741 | 1.7424 | 7585180.0 |
| 2005-03-10 15:00:00 | AMZN | Stock | 1.7425 | 1.748 | 1.735 | 1.7475 | 15372480.0 |
| 2005-03-10 16:00:00 | AMZN | Stock | 1.7445 | 1.75 | 1.7425 | 1.75 | 624640.0 |
| 2005-03-10 17:00:00 | AMZN | Stock | 1.7455 | 1.7455 | 1.7455 | 1.7455 | 2278720.0 |
| 2005-03-10 18:00:00 | AMZN | Stock | 1.744 | 1.744 | 1.744 | 1.744 | 19620.0 |
| 2005-03-10 09:00:00 | CL | Stock | 25.84 | 25.905 | 25.83 | 25.895 | 550600.0 |
| 2005-03-10 10:00:00 | CL | Stock | 25.895 | 26.34 | 25.88 | 26.16 | 1114000.0 |
| 2005-03-10 11:00:00 | CL | Stock | 26.135 | 26.185 | 26.055 | 26.135 | 322400.0 |
| 2005-03-10 12:00:00 | CL | Stock | 26.135 | 26.205 | 26.075 | 26.205 | 223600.0 |
| 2005-03-10 13:00:00 | CL | Stock | 26.205 | 26.455 | 26.185 | 26.425 | 362800.0 |
| 2005-03-10 14:00:00 | CL | Stock | 26.425 | 26.43 | 26.32 | 26.405 | 426200.0 |
> showing 50 of 25,780 rows — these rows as CSV