PREVIEW / stock_1hour / 2002-03-13
file: by_date/stock_1hour/2002/2002-03-13.parquet size: 388 KB rows: 18,261 symbols: 1,398
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-03-13 08:00:00 | AAPL | Stock | 0.4418 | 0.4423 | 0.4411 | 0.442 | 1864800.0 |
| 2002-03-13 09:00:00 | AAPL | Stock | 0.4375 | 0.44 | 0.4313 | 0.4379 | 26476800.0 |
| 2002-03-13 10:00:00 | AAPL | Stock | 0.438 | 0.4438 | 0.4375 | 0.4404 | 48255200.0 |
| 2002-03-13 11:00:00 | AAPL | Stock | 0.4402 | 0.4423 | 0.4364 | 0.4379 | 24315200.0 |
| 2002-03-13 12:00:00 | AAPL | Stock | 0.4384 | 0.4405 | 0.4366 | 0.4382 | 11508000.0 |
| 2002-03-13 13:00:00 | AAPL | Stock | 0.438 | 0.442 | 0.4366 | 0.4382 | 25233600.0 |
| 2002-03-13 14:00:00 | AAPL | Stock | 0.4382 | 0.4402 | 0.4366 | 0.4377 | 26308800.0 |
| 2002-03-13 15:00:00 | AAPL | Stock | 0.4377 | 0.4402 | 0.4364 | 0.4375 | 21823200.0 |
| 2002-03-13 16:00:00 | AAPL | Stock | 0.4373 | 0.4389 | 0.4373 | 0.4373 | 8444800.0 |
| 2002-03-13 08:00:00 | MSFT | Stock | 31.3 | 31.36 | 31.0245 | 31.04 | 183600.0 |
| 2002-03-13 09:00:00 | MSFT | Stock | 31.04 | 31.4 | 30.975 | 31.08 | 8321600.0 |
| 2002-03-13 10:00:00 | MSFT | Stock | 31.085 | 31.51 | 31.02 | 31.32 | 7784800.0 |
| 2002-03-13 11:00:00 | MSFT | Stock | 31.325 | 31.375 | 31.125 | 31.15 | 4343800.0 |
| 2002-03-13 12:00:00 | MSFT | Stock | 31.1505 | 31.215 | 31.005 | 31.1467 | 4354400.0 |
| 2002-03-13 13:00:00 | MSFT | Stock | 31.145 | 31.3 | 31.035 | 31.06 | 4859200.0 |
| 2002-03-13 14:00:00 | MSFT | Stock | 31.065 | 31.23 | 30.99 | 31.045 | 4686000.0 |
| 2002-03-13 15:00:00 | MSFT | Stock | 31.05 | 31.2 | 31.02 | 31.045 | 5800400.0 |
| 2002-03-13 16:00:00 | MSFT | Stock | 31.045 | 31.1936 | 31.01 | 31.05 | 2357400.0 |
| 2002-03-13 17:00:00 | MSFT | Stock | 31.05 | 31.075 | 31.0 | 31.05 | 33200.0 |
| 2002-03-13 18:00:00 | MSFT | Stock | 31.075 | 31.075 | 31.075 | 31.075 | 600.0 |
| 2002-03-13 08:00:00 | NVDA | Stock | 0.4562 | 0.4575 | 0.4479 | 0.4492 | 4992000.0 |
| 2002-03-13 09:00:00 | NVDA | Stock | 0.4492 | 0.4529 | 0.445 | 0.4487 | 161580000.0 |
| 2002-03-13 10:00:00 | NVDA | Stock | 0.4487 | 0.4529 | 0.4474 | 0.4483 | 137976000.0 |
| 2002-03-13 11:00:00 | NVDA | Stock | 0.4484 | 0.4517 | 0.4483 | 0.4491 | 73728000.0 |
| 2002-03-13 12:00:00 | NVDA | Stock | 0.4493 | 0.4518 | 0.4492 | 0.4503 | 67536000.0 |
| 2002-03-13 13:00:00 | NVDA | Stock | 0.4504 | 0.4525 | 0.4492 | 0.4501 | 106572000.0 |
| 2002-03-13 14:00:00 | NVDA | Stock | 0.4502 | 0.4539 | 0.4496 | 0.4503 | 122868000.0 |
| 2002-03-13 15:00:00 | NVDA | Stock | 0.4506 | 0.4525 | 0.4458 | 0.4467 | 209748000.0 |
| 2002-03-13 16:00:00 | NVDA | Stock | 0.4467 | 0.4501 | 0.4342 | 0.4399 | 78444000.0 |
| 2002-03-13 17:00:00 | NVDA | Stock | 0.4392 | 0.4403 | 0.4386 | 0.4399 | 1488000.0 |
| 2002-03-13 18:00:00 | NVDA | Stock | 0.4404 | 0.4452 | 0.4404 | 0.4449 | 1200000.0 |
| 2002-03-13 08:00:00 | AMZN | Stock | 0.81 | 0.82 | 0.8 | 0.81 | 130000.0 |
| 2002-03-13 09:00:00 | AMZN | Stock | 0.8045 | 0.8125 | 0.794 | 0.8065 | 17694000.0 |
| 2002-03-13 10:00:00 | AMZN | Stock | 0.805 | 0.817 | 0.8015 | 0.8075 | 12422000.0 |
| 2002-03-13 11:00:00 | AMZN | Stock | 0.8075 | 0.811 | 0.802 | 0.8035 | 7768000.0 |
| 2002-03-13 12:00:00 | AMZN | Stock | 0.804 | 0.811 | 0.8025 | 0.807 | 6334000.0 |
| 2002-03-13 13:00:00 | AMZN | Stock | 0.807 | 0.809 | 0.8 | 0.8015 | 8492000.0 |
| 2002-03-13 14:00:00 | AMZN | Stock | 0.802 | 0.804 | 0.782 | 0.787 | 17874000.0 |
| 2002-03-13 15:00:00 | AMZN | Stock | 0.787 | 0.795 | 0.785 | 0.7875 | 19922000.0 |
| 2002-03-13 16:00:00 | AMZN | Stock | 0.787 | 0.7996 | 0.7845 | 0.7875 | 16648000.0 |
| 2002-03-13 17:00:00 | AMZN | Stock | 0.787 | 0.7885 | 0.785 | 0.7885 | 118000.0 |
| 2002-03-13 18:00:00 | AMZN | Stock | 0.8081 | 0.8081 | 0.7876 | 0.7876 | 18000.0 |
| 2002-03-13 09:00:00 | CL | Stock | 27.635 | 27.67 | 27.45 | 27.525 | 420000.0 |
| 2002-03-13 10:00:00 | CL | Stock | 27.495 | 27.565 | 27.325 | 27.355 | 404600.0 |
| 2002-03-13 11:00:00 | CL | Stock | 27.365 | 27.425 | 27.335 | 27.35 | 206000.0 |
| 2002-03-13 12:00:00 | CL | Stock | 27.355 | 27.4 | 27.325 | 27.325 | 240400.0 |
| 2002-03-13 13:00:00 | CL | Stock | 27.35 | 27.475 | 27.2 | 27.2 | 429600.0 |
| 2002-03-13 14:00:00 | CL | Stock | 27.205 | 27.305 | 27.185 | 27.225 | 311800.0 |
| 2002-03-13 15:00:00 | CL | Stock | 27.215 | 27.38 | 27.215 | 27.34 | 929800.0 |
| 2002-03-13 16:00:00 | CL | Stock | 27.35 | 27.375 | 27.35 | 27.375 | 98400.0 |
> showing 50 of 18,261 rows — these rows as CSV