PREVIEW / stock_1hour / 2000-01-13
file: by_date/stock_1hour/2000/2000-01-13.parquet size: 271 KB rows: 14,202 symbols: 1,122
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-13 09:00:00 | AAPL | Stock | 0.8435 | 0.861 | 0.8259 | 0.8262 | 233665600.0 |
| 2000-01-13 10:00:00 | AAPL | Stock | 0.8265 | 0.8527 | 0.8259 | 0.8404 | 196537600.0 |
| 2000-01-13 11:00:00 | AAPL | Stock | 0.8398 | 0.8477 | 0.8371 | 0.841 | 64321600.0 |
| 2000-01-13 12:00:00 | AAPL | Stock | 0.8404 | 0.8516 | 0.8404 | 0.8449 | 69843200.0 |
| 2000-01-13 13:00:00 | AAPL | Stock | 0.8449 | 0.8705 | 0.8449 | 0.8694 | 97227200.0 |
| 2000-01-13 14:00:00 | AAPL | Stock | 0.8705 | 0.8817 | 0.8532 | 0.8638 | 145275200.0 |
| 2000-01-13 15:00:00 | AAPL | Stock | 0.8661 | 0.8722 | 0.8493 | 0.8638 | 132596800.0 |
| 2000-01-13 16:00:00 | AAPL | Stock | 0.8644 | 0.8644 | 0.8627 | 0.8638 | 1064000.0 |
| 2000-01-13 09:00:00 | MSFT | Stock | 52.1875 | 52.7188 | 51.5625 | 51.625 | 8605800.0 |
| 2000-01-13 10:00:00 | MSFT | Stock | 51.6562 | 51.8125 | 50.75 | 51.3125 | 13974400.0 |
| 2000-01-13 11:00:00 | MSFT | Stock | 51.3438 | 51.75 | 51.0 | 51.2188 | 5913600.0 |
| 2000-01-13 12:00:00 | MSFT | Stock | 51.1875 | 51.3125 | 50.9375 | 51.0312 | 4049800.0 |
| 2000-01-13 13:00:00 | MSFT | Stock | 51.0312 | 51.25 | 50.9062 | 51.0938 | 5559400.0 |
| 2000-01-13 14:00:00 | MSFT | Stock | 51.0 | 52.0312 | 50.9688 | 51.8438 | 8256400.0 |
| 2000-01-13 15:00:00 | MSFT | Stock | 51.8125 | 54.3125 | 51.75 | 53.9219 | 31519600.0 |
| 2000-01-13 16:00:00 | MSFT | Stock | 53.875 | 54.125 | 53.6875 | 53.8125 | 208000.0 |
| 2000-01-13 09:00:00 | NVDA | Stock | 0.0841 | 0.0854 | 0.0833 | 0.0846 | 4704000.0 |
| 2000-01-13 10:00:00 | NVDA | Stock | 0.0858 | 0.0862 | 0.0841 | 0.0854 | 5376000.0 |
| 2000-01-13 11:00:00 | NVDA | Stock | 0.0854 | 0.0854 | 0.0831 | 0.0837 | 17088000.0 |
| 2000-01-13 12:00:00 | NVDA | Stock | 0.0837 | 0.0849 | 0.0833 | 0.0841 | 3120000.0 |
| 2000-01-13 13:00:00 | NVDA | Stock | 0.0836 | 0.0854 | 0.0833 | 0.0854 | 10224000.0 |
| 2000-01-13 14:00:00 | NVDA | Stock | 0.0854 | 0.0885 | 0.0844 | 0.0885 | 19104000.0 |
| 2000-01-13 15:00:00 | NVDA | Stock | 0.0885 | 0.0885 | 0.0867 | 0.0878 | 65520000.0 |
| 2000-01-13 16:00:00 | NVDA | Stock | 0.0876 | 0.0878 | 0.0876 | 0.0878 | 4656000.0 |
| 2000-01-13 09:00:00 | AMZN | Stock | 3.2469 | 3.2469 | 3.1813 | 3.1875 | 27126000.0 |
| 2000-01-13 10:00:00 | AMZN | Stock | 3.1906 | 3.2375 | 3.1562 | 3.1969 | 38656000.0 |
| 2000-01-13 11:00:00 | AMZN | Stock | 3.1938 | 3.2063 | 3.1625 | 3.175 | 25842000.0 |
| 2000-01-13 12:00:00 | AMZN | Stock | 3.1719 | 3.3594 | 3.1719 | 3.3156 | 47090000.0 |
| 2000-01-13 13:00:00 | AMZN | Stock | 3.3062 | 3.3156 | 3.2531 | 3.2719 | 16956000.0 |
| 2000-01-13 14:00:00 | AMZN | Stock | 3.2688 | 3.3125 | 3.2625 | 3.2688 | 17854000.0 |
| 2000-01-13 15:00:00 | AMZN | Stock | 3.2719 | 3.3094 | 3.25 | 3.3 | 28022000.0 |
| 2000-01-13 16:00:00 | AMZN | Stock | 3.2906 | 3.3 | 3.2906 | 3.2969 | 442000.0 |
| 2000-01-13 09:00:00 | CL | Stock | 32.0625 | 32.1875 | 32.0 | 32.125 | 274600.0 |
| 2000-01-13 10:00:00 | CL | Stock | 32.125 | 32.1562 | 31.9062 | 32.125 | 383400.0 |
| 2000-01-13 11:00:00 | CL | Stock | 32.1562 | 32.4688 | 32.0938 | 32.2812 | 234600.0 |
| 2000-01-13 12:00:00 | CL | Stock | 32.3125 | 32.3438 | 32.125 | 32.3125 | 208600.0 |
| 2000-01-13 13:00:00 | CL | Stock | 32.3125 | 32.8438 | 32.2812 | 32.7812 | 673200.0 |
| 2000-01-13 14:00:00 | CL | Stock | 32.8125 | 32.8438 | 32.6875 | 32.6875 | 294600.0 |
| 2000-01-13 15:00:00 | CL | Stock | 32.6875 | 32.75 | 32.2812 | 32.4062 | 438600.0 |
| 2000-01-13 16:00:00 | CL | Stock | 32.4062 | 32.4062 | 32.4062 | 32.4062 | 92600.0 |
> showing 40 of 14,202 rows — these rows as CSV