PREVIEW / stock_1hour / 2002-02-12
file: by_date/stock_1hour/2002/2002-02-12.parquet size: 379 KB rows: 18,135 symbols: 1,390
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-12 08:00:00 | AAPL | Stock | 0.4462 | 0.45 | 0.4321 | 0.4402 | 22551200.0 |
| 2002-02-12 09:00:00 | AAPL | Stock | 0.4411 | 0.4434 | 0.4366 | 0.4384 | 22428000.0 |
| 2002-02-12 10:00:00 | AAPL | Stock | 0.4388 | 0.442 | 0.4382 | 0.44 | 33510400.0 |
| 2002-02-12 11:00:00 | AAPL | Stock | 0.4398 | 0.4411 | 0.4379 | 0.4396 | 22142400.0 |
| 2002-02-12 12:00:00 | AAPL | Stock | 0.4397 | 0.4438 | 0.4396 | 0.442 | 20132000.0 |
| 2002-02-12 13:00:00 | AAPL | Stock | 0.4421 | 0.4452 | 0.4416 | 0.442 | 17214400.0 |
| 2002-02-12 14:00:00 | AAPL | Stock | 0.4425 | 0.4471 | 0.4423 | 0.4459 | 23441600.0 |
| 2002-02-12 15:00:00 | AAPL | Stock | 0.4457 | 0.4459 | 0.4411 | 0.4414 | 47812800.0 |
| 2002-02-12 16:00:00 | AAPL | Stock | 0.4413 | 0.4436 | 0.4393 | 0.4393 | 7879200.0 |
| 2002-02-12 17:00:00 | AAPL | Stock | 0.4413 | 0.4413 | 0.44 | 0.44 | 257600.0 |
| 2002-02-12 18:00:00 | AAPL | Stock | 0.44 | 0.44 | 0.44 | 0.44 | 56000.0 |
| 2002-02-12 08:00:00 | MSFT | Stock | 30.295 | 30.35 | 30.205 | 30.32 | 99200.0 |
| 2002-02-12 09:00:00 | MSFT | Stock | 30.3 | 30.535 | 30.02 | 30.0775 | 6524000.0 |
| 2002-02-12 10:00:00 | MSFT | Stock | 30.075 | 30.25 | 30.01 | 30.235 | 9164400.0 |
| 2002-02-12 11:00:00 | MSFT | Stock | 30.21 | 30.2505 | 30.045 | 30.06 | 4415000.0 |
| 2002-02-12 12:00:00 | MSFT | Stock | 30.065 | 30.17 | 30.04 | 30.1295 | 4757000.0 |
| 2002-02-12 13:00:00 | MSFT | Stock | 30.12 | 30.295 | 30.12 | 30.2 | 5999200.0 |
| 2002-02-12 14:00:00 | MSFT | Stock | 30.205 | 30.425 | 30.155 | 30.335 | 4681400.0 |
| 2002-02-12 15:00:00 | MSFT | Stock | 30.335 | 30.3495 | 30.025 | 30.07 | 6979600.0 |
| 2002-02-12 16:00:00 | MSFT | Stock | 30.06 | 30.225 | 29.9 | 30.0 | 1829000.0 |
| 2002-02-12 17:00:00 | MSFT | Stock | 30.0 | 30.135 | 30.0 | 30.125 | 31000.0 |
| 2002-02-12 08:00:00 | NVDA | Stock | 0.5042 | 0.5075 | 0.4975 | 0.4993 | 4452000.0 |
| 2002-02-12 09:00:00 | NVDA | Stock | 0.4987 | 0.5057 | 0.4967 | 0.4991 | 124980000.0 |
| 2002-02-12 10:00:00 | NVDA | Stock | 0.4987 | 0.5057 | 0.4942 | 0.5051 | 255852000.0 |
| 2002-02-12 11:00:00 | NVDA | Stock | 0.5055 | 0.5127 | 0.5026 | 0.5051 | 147384000.0 |
| 2002-02-12 12:00:00 | NVDA | Stock | 0.5047 | 0.5205 | 0.5047 | 0.5168 | 137724000.0 |
| 2002-02-12 13:00:00 | NVDA | Stock | 0.5168 | 0.5226 | 0.5158 | 0.5192 | 166884000.0 |
| 2002-02-12 14:00:00 | NVDA | Stock | 0.5192 | 0.5279 | 0.5187 | 0.5243 | 146760000.0 |
| 2002-02-12 15:00:00 | NVDA | Stock | 0.5242 | 0.5242 | 0.5152 | 0.5183 | 202836000.0 |
| 2002-02-12 16:00:00 | NVDA | Stock | 0.5183 | 0.5186 | 0.5 | 0.5183 | 10020000.0 |
| 2002-02-12 17:00:00 | NVDA | Stock | 0.5207 | 0.5249 | 0.5183 | 0.5217 | 1356000.0 |
| 2002-02-12 18:00:00 | NVDA | Stock | 0.5217 | 0.5233 | 0.5217 | 0.5232 | 132000.0 |
| 2002-02-12 08:00:00 | AMZN | Stock | 0.655 | 0.655 | 0.6475 | 0.65 | 190000.0 |
| 2002-02-12 09:00:00 | AMZN | Stock | 0.65 | 0.66 | 0.627 | 0.638 | 30492000.0 |
| 2002-02-12 10:00:00 | AMZN | Stock | 0.638 | 0.653 | 0.6335 | 0.651 | 23498000.0 |
| 2002-02-12 11:00:00 | AMZN | Stock | 0.651 | 0.662 | 0.645 | 0.6485 | 19074000.0 |
| 2002-02-12 12:00:00 | AMZN | Stock | 0.6485 | 0.6535 | 0.6475 | 0.652 | 11272000.0 |
| 2002-02-12 13:00:00 | AMZN | Stock | 0.652 | 0.66 | 0.6455 | 0.65 | 17306000.0 |
| 2002-02-12 14:00:00 | AMZN | Stock | 0.65 | 0.66 | 0.649 | 0.6565 | 16130000.0 |
| 2002-02-12 15:00:00 | AMZN | Stock | 0.656 | 0.6585 | 0.6444 | 0.646 | 25062000.0 |
| 2002-02-12 16:00:00 | AMZN | Stock | 0.645 | 0.6475 | 0.64 | 0.645 | 1908000.0 |
| 2002-02-12 17:00:00 | AMZN | Stock | 0.6475 | 0.6525 | 0.645 | 0.6525 | 108000.0 |
| 2002-02-12 18:00:00 | AMZN | Stock | 0.65 | 0.6525 | 0.65 | 0.6525 | 14000.0 |
| 2002-02-12 09:00:00 | CL | Stock | 27.125 | 27.305 | 27.055 | 27.3 | 559000.0 |
| 2002-02-12 10:00:00 | CL | Stock | 27.295 | 27.35 | 27.205 | 27.25 | 538400.0 |
| 2002-02-12 11:00:00 | CL | Stock | 27.25 | 27.325 | 27.24 | 27.325 | 396400.0 |
| 2002-02-12 12:00:00 | CL | Stock | 27.325 | 27.325 | 27.26 | 27.305 | 677000.0 |
| 2002-02-12 13:00:00 | CL | Stock | 27.315 | 27.36 | 27.25 | 27.265 | 550600.0 |
| 2002-02-12 14:00:00 | CL | Stock | 27.275 | 27.325 | 27.25 | 27.3 | 589800.0 |
| 2002-02-12 15:00:00 | CL | Stock | 27.3 | 27.32 | 27.225 | 27.295 | 819600.0 |
> showing 50 of 18,135 rows — these rows as CSV