PREVIEW / stock_1hour / 2002-03-12
file: by_date/stock_1hour/2002/2002-03-12.parquet size: 394 KB rows: 18,723 symbols: 1,399
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-12 08:00:00 | AAPL | Stock | 0.4395 | 0.4411 | 0.4395 | 0.4411 | 112000.0 |
| 2002-03-12 09:00:00 | AAPL | Stock | 0.4384 | 0.4402 | 0.4323 | 0.4332 | 31567200.0 |
| 2002-03-12 10:00:00 | AAPL | Stock | 0.4332 | 0.4361 | 0.4309 | 0.4314 | 42291200.0 |
| 2002-03-12 11:00:00 | AAPL | Stock | 0.4316 | 0.435 | 0.4304 | 0.4345 | 19247200.0 |
| 2002-03-12 12:00:00 | AAPL | Stock | 0.4345 | 0.4377 | 0.4332 | 0.4375 | 26168800.0 |
| 2002-03-12 13:00:00 | AAPL | Stock | 0.4375 | 0.4404 | 0.4368 | 0.4379 | 33404000.0 |
| 2002-03-12 14:00:00 | AAPL | Stock | 0.4379 | 0.44 | 0.4366 | 0.4375 | 25110400.0 |
| 2002-03-12 15:00:00 | AAPL | Stock | 0.4377 | 0.4418 | 0.4352 | 0.4418 | 41574400.0 |
| 2002-03-12 16:00:00 | AAPL | Stock | 0.4414 | 0.4429 | 0.4332 | 0.4357 | 14996800.0 |
| 2002-03-12 17:00:00 | AAPL | Stock | 0.4375 | 0.442 | 0.4375 | 0.4409 | 1545600.0 |
| 2002-03-12 08:00:00 | MSFT | Stock | 31.78 | 31.78 | 31.0 | 31.3 | 254400.0 |
| 2002-03-12 09:00:00 | MSFT | Stock | 31.3 | 32.17 | 31.025 | 31.21 | 9610400.0 |
| 2002-03-12 10:00:00 | MSFT | Stock | 31.21 | 31.33 | 31.0 | 31.145 | 10299800.0 |
| 2002-03-12 11:00:00 | MSFT | Stock | 31.15 | 31.375 | 31.06 | 31.23 | 7258200.0 |
| 2002-03-12 12:00:00 | MSFT | Stock | 31.225 | 31.25 | 30.975 | 31.02 | 7805800.0 |
| 2002-03-12 13:00:00 | MSFT | Stock | 31.0155 | 31.19 | 30.835 | 31.115 | 7297600.0 |
| 2002-03-12 14:00:00 | MSFT | Stock | 31.1145 | 31.185 | 30.9 | 30.945 | 7902800.0 |
| 2002-03-12 15:00:00 | MSFT | Stock | 30.94 | 31.275 | 30.9 | 31.27 | 10108200.0 |
| 2002-03-12 16:00:00 | MSFT | Stock | 31.275 | 31.375 | 30.95 | 31.35 | 2846600.0 |
| 2002-03-12 17:00:00 | MSFT | Stock | 31.2 | 31.31 | 31.2 | 31.276 | 198000.0 |
| 2002-03-12 18:00:00 | MSFT | Stock | 31.3 | 31.305 | 31.29 | 31.305 | 6600.0 |
| 2002-03-12 08:00:00 | NVDA | Stock | 0.4651 | 0.4685 | 0.4638 | 0.4667 | 636000.0 |
| 2002-03-12 09:00:00 | NVDA | Stock | 0.467 | 0.4798 | 0.4593 | 0.4622 | 180924000.0 |
| 2002-03-12 10:00:00 | NVDA | Stock | 0.4621 | 0.4662 | 0.4614 | 0.4614 | 138060000.0 |
| 2002-03-12 11:00:00 | NVDA | Stock | 0.4614 | 0.4655 | 0.4612 | 0.4649 | 79080000.0 |
| 2002-03-12 12:00:00 | NVDA | Stock | 0.4649 | 0.4652 | 0.4604 | 0.4609 | 86436000.0 |
| 2002-03-12 13:00:00 | NVDA | Stock | 0.461 | 0.4641 | 0.4572 | 0.4625 | 136608000.0 |
| 2002-03-12 14:00:00 | NVDA | Stock | 0.4609 | 0.4627 | 0.4542 | 0.455 | 158676000.0 |
| 2002-03-12 15:00:00 | NVDA | Stock | 0.455 | 0.4582 | 0.4517 | 0.4548 | 288036000.0 |
| 2002-03-12 16:00:00 | NVDA | Stock | 0.4548 | 0.4675 | 0.4517 | 0.4657 | 58380000.0 |
| 2002-03-12 17:00:00 | NVDA | Stock | 0.4637 | 0.4637 | 0.4549 | 0.4558 | 1140000.0 |
| 2002-03-12 18:00:00 | NVDA | Stock | 0.4558 | 0.4584 | 0.4558 | 0.4584 | 180000.0 |
| 2002-03-12 08:00:00 | AMZN | Stock | 0.82 | 0.82 | 0.805 | 0.805 | 216000.0 |
| 2002-03-12 09:00:00 | AMZN | Stock | 0.8175 | 0.8285 | 0.805 | 0.8185 | 23028000.0 |
| 2002-03-12 10:00:00 | AMZN | Stock | 0.8185 | 0.8295 | 0.8175 | 0.8225 | 17442000.0 |
| 2002-03-12 11:00:00 | AMZN | Stock | 0.8225 | 0.826 | 0.82 | 0.82 | 10462000.0 |
| 2002-03-12 12:00:00 | AMZN | Stock | 0.82 | 0.8225 | 0.816 | 0.8175 | 8562000.0 |
| 2002-03-12 13:00:00 | AMZN | Stock | 0.8178 | 0.8185 | 0.809 | 0.814 | 12148000.0 |
| 2002-03-12 14:00:00 | AMZN | Stock | 0.8135 | 0.818 | 0.802 | 0.8055 | 11256000.0 |
| 2002-03-12 15:00:00 | AMZN | Stock | 0.8055 | 0.8185 | 0.8045 | 0.8185 | 19162000.0 |
| 2002-03-12 16:00:00 | AMZN | Stock | 0.8185 | 0.8225 | 0.8125 | 0.8225 | 2414000.0 |
| 2002-03-12 17:00:00 | AMZN | Stock | 0.8155 | 0.8155 | 0.8155 | 0.8155 | 240000.0 |
| 2002-03-12 18:00:00 | AMZN | Stock | 0.8155 | 0.8155 | 0.8155 | 0.8155 | 2000.0 |
| 2002-03-12 09:00:00 | CL | Stock | 26.925 | 27.325 | 26.87 | 27.245 | 573200.0 |
| 2002-03-12 10:00:00 | CL | Stock | 27.25 | 27.26 | 27.065 | 27.1 | 507200.0 |
| 2002-03-12 11:00:00 | CL | Stock | 27.09 | 27.1 | 27.0 | 27.04 | 713400.0 |
| 2002-03-12 12:00:00 | CL | Stock | 27.05 | 27.3 | 27.045 | 27.3 | 668600.0 |
| 2002-03-12 13:00:00 | CL | Stock | 27.315 | 27.47 | 27.29 | 27.44 | 440600.0 |
| 2002-03-12 14:00:00 | CL | Stock | 27.44 | 27.5 | 27.4 | 27.47 | 318400.0 |
| 2002-03-12 15:00:00 | CL | Stock | 27.46 | 27.625 | 27.425 | 27.575 | 738800.0 |
> showing 50 of 18,723 rows — these rows as CSV