PREVIEW / stock_1hour / 2001-12-03
file: by_date/stock_1hour/2001/2001-12-03.parquet size: 372 KB rows: 17,689 symbols: 1,346
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-03 08:00:00 | AAPL | Stock | 0.3805 | 0.3811 | 0.3784 | 0.3784 | 56000.0 |
| 2001-12-03 09:00:00 | AAPL | Stock | 0.3786 | 0.3807 | 0.3734 | 0.377 | 39597600.0 |
| 2001-12-03 10:00:00 | AAPL | Stock | 0.377 | 0.3773 | 0.3716 | 0.3759 | 37032800.0 |
| 2001-12-03 11:00:00 | AAPL | Stock | 0.3754 | 0.3755 | 0.3679 | 0.373 | 26829600.0 |
| 2001-12-03 12:00:00 | AAPL | Stock | 0.373 | 0.3748 | 0.3711 | 0.3737 | 10130400.0 |
| 2001-12-03 13:00:00 | AAPL | Stock | 0.3734 | 0.3768 | 0.3729 | 0.3738 | 12734400.0 |
| 2001-12-03 14:00:00 | AAPL | Stock | 0.3737 | 0.3784 | 0.3718 | 0.377 | 11435200.0 |
| 2001-12-03 15:00:00 | AAPL | Stock | 0.377 | 0.3796 | 0.3743 | 0.3761 | 33398400.0 |
| 2001-12-03 16:00:00 | AAPL | Stock | 0.3755 | 0.3798 | 0.3723 | 0.3759 | 9940000.0 |
| 2001-12-03 18:00:00 | AAPL | Stock | 0.3757 | 0.3777 | 0.3757 | 0.3777 | 151200.0 |
| 2001-12-03 08:00:00 | MSFT | Stock | 32.045 | 32.121 | 31.88 | 32.01 | 137800.0 |
| 2001-12-03 09:00:00 | MSFT | Stock | 32.05 | 32.5 | 31.9 | 32.375 | 6945400.0 |
| 2001-12-03 10:00:00 | MSFT | Stock | 32.375 | 32.53 | 32.045 | 32.345 | 10785400.0 |
| 2001-12-03 11:00:00 | MSFT | Stock | 32.34 | 32.425 | 32.125 | 32.35 | 4844600.0 |
| 2001-12-03 12:00:00 | MSFT | Stock | 32.3545 | 32.45 | 32.24 | 32.45 | 3564600.0 |
| 2001-12-03 13:00:00 | MSFT | Stock | 32.45 | 32.53 | 32.315 | 32.315 | 4709400.0 |
| 2001-12-03 14:00:00 | MSFT | Stock | 32.315 | 32.485 | 32.26 | 32.37 | 3431600.0 |
| 2001-12-03 15:00:00 | MSFT | Stock | 32.365 | 32.615 | 32.23 | 32.375 | 9584200.0 |
| 2001-12-03 16:00:00 | MSFT | Stock | 32.385 | 32.495 | 31.9149 | 32.385 | 2339600.0 |
| 2001-12-03 17:00:00 | MSFT | Stock | 32.375 | 32.42 | 32.375 | 32.42 | 400.0 |
| 2001-12-03 18:00:00 | MSFT | Stock | 32.385 | 32.415 | 32.385 | 32.395 | 1600.0 |
| 2001-12-03 08:00:00 | NVDA | Stock | 0.4417 | 0.4481 | 0.4386 | 0.445 | 5472000.0 |
| 2001-12-03 09:00:00 | NVDA | Stock | 0.4453 | 0.4555 | 0.4416 | 0.4442 | 150588000.0 |
| 2001-12-03 10:00:00 | NVDA | Stock | 0.4439 | 0.447 | 0.4422 | 0.4452 | 135228000.0 |
| 2001-12-03 11:00:00 | NVDA | Stock | 0.4448 | 0.4453 | 0.4404 | 0.4437 | 88284000.0 |
| 2001-12-03 12:00:00 | NVDA | Stock | 0.4436 | 0.4443 | 0.4417 | 0.4436 | 111768000.0 |
| 2001-12-03 13:00:00 | NVDA | Stock | 0.4442 | 0.4458 | 0.4417 | 0.4429 | 101772000.0 |
| 2001-12-03 14:00:00 | NVDA | Stock | 0.4429 | 0.4445 | 0.4422 | 0.4444 | 72636000.0 |
| 2001-12-03 15:00:00 | NVDA | Stock | 0.4445 | 0.4513 | 0.4432 | 0.4485 | 133680000.0 |
| 2001-12-03 16:00:00 | NVDA | Stock | 0.4484 | 0.4489 | 0.4476 | 0.4479 | 26328000.0 |
| 2001-12-03 17:00:00 | NVDA | Stock | 0.4484 | 0.4487 | 0.4477 | 0.4477 | 576000.0 |
| 2001-12-03 18:00:00 | NVDA | Stock | 0.4483 | 0.4487 | 0.4477 | 0.4487 | 120000.0 |
| 2001-12-03 08:00:00 | AMZN | Stock | 0.557 | 0.5663 | 0.55 | 0.5595 | 902000.0 |
| 2001-12-03 09:00:00 | AMZN | Stock | 0.5526 | 0.567 | 0.5395 | 0.5415 | 47826000.0 |
| 2001-12-03 10:00:00 | AMZN | Stock | 0.541 | 0.5515 | 0.5405 | 0.5445 | 30868000.0 |
| 2001-12-03 11:00:00 | AMZN | Stock | 0.544 | 0.547 | 0.5405 | 0.545 | 17312000.0 |
| 2001-12-03 12:00:00 | AMZN | Stock | 0.5436 | 0.5475 | 0.5385 | 0.5425 | 13874000.0 |
| 2001-12-03 13:00:00 | AMZN | Stock | 0.543 | 0.5465 | 0.5325 | 0.5365 | 21382000.0 |
| 2001-12-03 14:00:00 | AMZN | Stock | 0.5365 | 0.538 | 0.5275 | 0.5331 | 17730000.0 |
| 2001-12-03 15:00:00 | AMZN | Stock | 0.5335 | 0.5375 | 0.524 | 0.525 | 31794000.0 |
| 2001-12-03 16:00:00 | AMZN | Stock | 0.5245 | 0.5415 | 0.522 | 0.5245 | 5126000.0 |
| 2001-12-03 17:00:00 | AMZN | Stock | 0.5325 | 0.5345 | 0.53 | 0.5325 | 130000.0 |
| 2001-12-03 09:00:00 | CL | Stock | 29.025 | 29.06 | 28.9 | 28.915 | 335400.0 |
| 2001-12-03 10:00:00 | CL | Stock | 28.91 | 29.0 | 28.7 | 28.93 | 337200.0 |
| 2001-12-03 11:00:00 | CL | Stock | 28.93 | 29.025 | 28.855 | 28.955 | 253400.0 |
| 2001-12-03 12:00:00 | CL | Stock | 28.98 | 29.035 | 28.9 | 29.025 | 520200.0 |
| 2001-12-03 13:00:00 | CL | Stock | 29.04 | 29.175 | 29.015 | 29.035 | 705400.0 |
| 2001-12-03 14:00:00 | CL | Stock | 29.03 | 29.04 | 28.925 | 28.975 | 433800.0 |
| 2001-12-03 15:00:00 | CL | Stock | 28.975 | 29.075 | 28.925 | 29.04 | 657600.0 |
| 2001-12-03 16:00:00 | CL | Stock | 29.055 | 29.055 | 29.035 | 29.05 | 97600.0 |
> showing 50 of 17,689 rows — these rows as CSV