PREVIEW / stock_1hour / 2000-01-31
file: by_date/stock_1hour/2000/2000-01-31.parquet size: 285 KB rows: 14,478 symbols: 1,129
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 |
|---|---|---|---|---|---|---|---|
| 2000-01-31 09:00:00 | AAPL | Stock | 0.9018 | 0.9018 | 0.8789 | 0.8789 | 57288000.0 |
| 2000-01-31 10:00:00 | AAPL | Stock | 0.8795 | 0.8968 | 0.8571 | 0.8661 | 125036800.0 |
| 2000-01-31 11:00:00 | AAPL | Stock | 0.8666 | 0.8705 | 0.8527 | 0.8527 | 101864000.0 |
| 2000-01-31 12:00:00 | AAPL | Stock | 0.8532 | 0.8694 | 0.8438 | 0.8661 | 130961600.0 |
| 2000-01-31 13:00:00 | AAPL | Stock | 0.8661 | 0.88 | 0.8661 | 0.8672 | 56481600.0 |
| 2000-01-31 14:00:00 | AAPL | Stock | 0.8672 | 0.8906 | 0.8549 | 0.8892 | 66091200.0 |
| 2000-01-31 15:00:00 | AAPL | Stock | 0.8895 | 0.9263 | 0.8778 | 0.9263 | 112728000.0 |
| 2000-01-31 16:00:00 | AAPL | Stock | 0.9258 | 0.9275 | 0.9258 | 0.9263 | 851200.0 |
| 2000-01-31 09:00:00 | MSFT | Stock | 48.8125 | 48.9062 | 47.8438 | 48.125 | 9985000.0 |
| 2000-01-31 10:00:00 | MSFT | Stock | 48.1562 | 48.625 | 47.5 | 47.6562 | 13317400.0 |
| 2000-01-31 11:00:00 | MSFT | Stock | 47.6562 | 47.9375 | 47.4375 | 47.5938 | 8704800.0 |
| 2000-01-31 12:00:00 | MSFT | Stock | 47.625 | 48.3125 | 47.5 | 48.2188 | 8356400.0 |
| 2000-01-31 13:00:00 | MSFT | Stock | 48.1875 | 48.3125 | 47.7188 | 47.8125 | 7187000.0 |
| 2000-01-31 14:00:00 | MSFT | Stock | 47.7812 | 48.5625 | 47.5938 | 48.5 | 7375400.0 |
| 2000-01-31 15:00:00 | MSFT | Stock | 48.5 | 49.0938 | 48.3125 | 48.9375 | 12508000.0 |
| 2000-01-31 16:00:00 | MSFT | Stock | 48.9375 | 48.9375 | 48.9062 | 48.9375 | 190800.0 |
| 2000-01-31 09:00:00 | NVDA | Stock | 0.0783 | 0.0799 | 0.0775 | 0.0779 | 16416000.0 |
| 2000-01-31 10:00:00 | NVDA | Stock | 0.0779 | 0.0784 | 0.0745 | 0.075 | 50784000.0 |
| 2000-01-31 11:00:00 | NVDA | Stock | 0.0753 | 0.0755 | 0.0729 | 0.0734 | 33360000.0 |
| 2000-01-31 12:00:00 | NVDA | Stock | 0.0742 | 0.0758 | 0.0737 | 0.0742 | 26880000.0 |
| 2000-01-31 13:00:00 | NVDA | Stock | 0.0746 | 0.0758 | 0.0745 | 0.0753 | 13488000.0 |
| 2000-01-31 14:00:00 | NVDA | Stock | 0.0753 | 0.0759 | 0.0737 | 0.0759 | 21696000.0 |
| 2000-01-31 15:00:00 | NVDA | Stock | 0.0759 | 0.0776 | 0.0754 | 0.0772 | 7344000.0 |
| 2000-01-31 16:00:00 | NVDA | Stock | 0.0768 | 0.0772 | 0.0768 | 0.0772 | 3504000.0 |
| 2000-01-31 09:00:00 | AMZN | Stock | 3.0188 | 3.0531 | 2.9938 | 3.0156 | 30318000.0 |
| 2000-01-31 10:00:00 | AMZN | Stock | 3.0125 | 3.1281 | 2.95 | 3.0188 | 61184000.0 |
| 2000-01-31 11:00:00 | AMZN | Stock | 3.0188 | 3.0438 | 2.9688 | 2.9812 | 27512000.0 |
| 2000-01-31 12:00:00 | AMZN | Stock | 2.9844 | 3.075 | 2.9781 | 3.0406 | 18298000.0 |
| 2000-01-31 13:00:00 | AMZN | Stock | 3.0469 | 3.075 | 3.0312 | 3.0406 | 11870000.0 |
| 2000-01-31 14:00:00 | AMZN | Stock | 3.0406 | 3.125 | 3.0125 | 3.1125 | 21252000.0 |
| 2000-01-31 15:00:00 | AMZN | Stock | 3.1125 | 3.2375 | 3.1094 | 3.2281 | 32832000.0 |
| 2000-01-31 16:00:00 | AMZN | Stock | 3.2312 | 3.2312 | 3.2281 | 3.2281 | 194000.0 |
| 2000-01-31 09:00:00 | CL | Stock | 29.375 | 29.8438 | 29.25 | 29.8438 | 229400.0 |
| 2000-01-31 10:00:00 | CL | Stock | 29.75 | 29.8125 | 29.4375 | 29.4688 | 205800.0 |
| 2000-01-31 11:00:00 | CL | Stock | 29.4375 | 29.6562 | 29.375 | 29.4688 | 302200.0 |
| 2000-01-31 12:00:00 | CL | Stock | 29.4688 | 29.5625 | 29.3125 | 29.4375 | 609200.0 |
| 2000-01-31 13:00:00 | CL | Stock | 29.4375 | 29.6875 | 29.375 | 29.4688 | 567200.0 |
| 2000-01-31 14:00:00 | CL | Stock | 29.4688 | 29.6562 | 29.4375 | 29.6562 | 412600.0 |
| 2000-01-31 15:00:00 | CL | Stock | 29.6562 | 29.8125 | 29.5625 | 29.75 | 561600.0 |
| 2000-01-31 16:00:00 | CL | Stock | 29.75 | 29.75 | 29.625 | 29.625 | 382200.0 |
> showing 40 of 14,478 rows — these rows as CSV