PREVIEW / stock_1hour / 2002-01-11
file: by_date/stock_1hour/2002/2002-01-11.parquet size: 379 KB rows: 17,833 symbols: 1,353
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-01-11 08:00:00 | AAPL | Stock | 0.3823 | 0.3823 | 0.3793 | 0.3793 | 84000.0 |
| 2002-01-11 09:00:00 | AAPL | Stock | 0.3796 | 0.387 | 0.3795 | 0.3841 | 30111200.0 |
| 2002-01-11 10:00:00 | AAPL | Stock | 0.3841 | 0.39 | 0.3793 | 0.3804 | 46961600.0 |
| 2002-01-11 11:00:00 | AAPL | Stock | 0.3805 | 0.3821 | 0.3745 | 0.3786 | 54644800.0 |
| 2002-01-11 12:00:00 | AAPL | Stock | 0.3784 | 0.3786 | 0.3738 | 0.3759 | 22792000.0 |
| 2002-01-11 13:00:00 | AAPL | Stock | 0.3759 | 0.3761 | 0.3688 | 0.372 | 42968800.0 |
| 2002-01-11 14:00:00 | AAPL | Stock | 0.372 | 0.3814 | 0.3679 | 0.3741 | 89779200.0 |
| 2002-01-11 15:00:00 | AAPL | Stock | 0.3741 | 0.3766 | 0.3713 | 0.3761 | 45438400.0 |
| 2002-01-11 16:00:00 | AAPL | Stock | 0.3759 | 0.3839 | 0.3759 | 0.3786 | 4608800.0 |
| 2002-01-11 17:00:00 | AAPL | Stock | 0.3777 | 0.3777 | 0.3732 | 0.3768 | 369600.0 |
| 2002-01-11 18:00:00 | AAPL | Stock | 0.3734 | 0.3763 | 0.3732 | 0.3732 | 78400.0 |
| 2002-01-11 08:00:00 | MSFT | Stock | 34.675 | 34.6905 | 34.57 | 34.65 | 92800.0 |
| 2002-01-11 09:00:00 | MSFT | Stock | 34.725 | 34.98 | 34.64 | 34.965 | 6488600.0 |
| 2002-01-11 10:00:00 | MSFT | Stock | 34.965 | 35.16 | 34.9 | 34.985 | 10697800.0 |
| 2002-01-11 11:00:00 | MSFT | Stock | 34.985 | 35.005 | 34.875 | 34.945 | 4327200.0 |
| 2002-01-11 12:00:00 | MSFT | Stock | 34.945 | 34.965 | 34.625 | 34.78 | 5472200.0 |
| 2002-01-11 13:00:00 | MSFT | Stock | 34.775 | 34.83 | 34.45 | 34.6145 | 6464000.0 |
| 2002-01-11 14:00:00 | MSFT | Stock | 34.615 | 34.625 | 34.125 | 34.5315 | 17314800.0 |
| 2002-01-11 15:00:00 | MSFT | Stock | 34.531 | 34.6 | 34.24 | 34.31 | 9290000.0 |
| 2002-01-11 16:00:00 | MSFT | Stock | 34.305 | 34.78 | 34.225 | 34.305 | 5299400.0 |
| 2002-01-11 17:00:00 | MSFT | Stock | 34.375 | 34.375 | 34.34 | 34.345 | 6600.0 |
| 2002-01-11 18:00:00 | MSFT | Stock | 34.345 | 34.375 | 34.345 | 34.375 | 1000.0 |
| 2002-01-11 08:00:00 | NVDA | Stock | 0.5504 | 0.5583 | 0.5492 | 0.5509 | 744000.0 |
| 2002-01-11 09:00:00 | NVDA | Stock | 0.5518 | 0.5537 | 0.545 | 0.5478 | 123012000.0 |
| 2002-01-11 10:00:00 | NVDA | Stock | 0.5479 | 0.5516 | 0.5412 | 0.5428 | 200184000.0 |
| 2002-01-11 11:00:00 | NVDA | Stock | 0.5427 | 0.5437 | 0.5383 | 0.5414 | 152340000.0 |
| 2002-01-11 12:00:00 | NVDA | Stock | 0.5414 | 0.5421 | 0.5297 | 0.5319 | 125064000.0 |
| 2002-01-11 13:00:00 | NVDA | Stock | 0.5322 | 0.5337 | 0.5234 | 0.5287 | 244620000.0 |
| 2002-01-11 14:00:00 | NVDA | Stock | 0.5287 | 0.5312 | 0.5235 | 0.5279 | 193224000.0 |
| 2002-01-11 15:00:00 | NVDA | Stock | 0.5277 | 0.5354 | 0.525 | 0.5254 | 220704000.0 |
| 2002-01-11 16:00:00 | NVDA | Stock | 0.5255 | 0.5372 | 0.525 | 0.5256 | 80544000.0 |
| 2002-01-11 17:00:00 | NVDA | Stock | 0.5258 | 0.5289 | 0.5258 | 0.5289 | 180000.0 |
| 2002-01-11 18:00:00 | NVDA | Stock | 0.5263 | 0.5263 | 0.5263 | 0.5263 | 12000.0 |
| 2002-01-11 08:00:00 | AMZN | Stock | 0.5575 | 0.5575 | 0.5525 | 0.555 | 242000.0 |
| 2002-01-11 09:00:00 | AMZN | Stock | 0.555 | 0.5595 | 0.5465 | 0.5535 | 11646000.0 |
| 2002-01-11 10:00:00 | AMZN | Stock | 0.554 | 0.567 | 0.5535 | 0.562 | 19128000.0 |
| 2002-01-11 11:00:00 | AMZN | Stock | 0.562 | 0.5625 | 0.5535 | 0.556 | 7106000.0 |
| 2002-01-11 12:00:00 | AMZN | Stock | 0.5565 | 0.559 | 0.551 | 0.556 | 4974000.0 |
| 2002-01-11 13:00:00 | AMZN | Stock | 0.556 | 0.558 | 0.551 | 0.5525 | 8328000.0 |
| 2002-01-11 14:00:00 | AMZN | Stock | 0.553 | 0.5535 | 0.547 | 0.551 | 7922000.0 |
| 2002-01-11 15:00:00 | AMZN | Stock | 0.551 | 0.5616 | 0.5505 | 0.552 | 16148000.0 |
| 2002-01-11 16:00:00 | AMZN | Stock | 0.5515 | 0.5566 | 0.545 | 0.5515 | 6180000.0 |
| 2002-01-11 17:00:00 | AMZN | Stock | 0.5475 | 0.5475 | 0.546 | 0.546 | 68000.0 |
| 2002-01-11 18:00:00 | AMZN | Stock | 0.5465 | 0.5465 | 0.5465 | 0.5465 | 10000.0 |
| 2002-01-11 09:00:00 | CL | Stock | 27.7 | 27.8 | 27.625 | 27.775 | 205200.0 |
| 2002-01-11 10:00:00 | CL | Stock | 27.785 | 27.98 | 27.78 | 27.89 | 502800.0 |
| 2002-01-11 11:00:00 | CL | Stock | 27.89 | 27.915 | 27.75 | 27.815 | 183200.0 |
| 2002-01-11 12:00:00 | CL | Stock | 27.815 | 27.84 | 27.75 | 27.785 | 169200.0 |
| 2002-01-11 13:00:00 | CL | Stock | 27.81 | 27.825 | 27.75 | 27.775 | 322400.0 |
| 2002-01-11 14:00:00 | CL | Stock | 27.775 | 27.825 | 27.725 | 27.815 | 250800.0 |
> showing 50 of 17,833 rows — these rows as CSV