PREVIEW / stock_1hour / 2000-12-12
file: by_date/stock_1hour/2000/2000-12-12.parquet size: 316 KB rows: 16,284 symbols: 1,259
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-12-12 08:00:00 | AAPL | Stock | 0.2706 | 0.2734 | 0.2706 | 0.2712 | 599200.0 |
| 2000-12-12 09:00:00 | AAPL | Stock | 0.2712 | 0.279 | 0.2679 | 0.2768 | 47146400.0 |
| 2000-12-12 10:00:00 | AAPL | Stock | 0.2768 | 0.2824 | 0.2746 | 0.2757 | 72632000.0 |
| 2000-12-12 11:00:00 | AAPL | Stock | 0.2757 | 0.2824 | 0.2734 | 0.2813 | 42744800.0 |
| 2000-12-12 12:00:00 | AAPL | Stock | 0.2813 | 0.2846 | 0.2801 | 0.2813 | 29265600.0 |
| 2000-12-12 13:00:00 | AAPL | Stock | 0.2824 | 0.2846 | 0.279 | 0.2813 | 32670400.0 |
| 2000-12-12 14:00:00 | AAPL | Stock | 0.2813 | 0.2857 | 0.279 | 0.279 | 45864000.0 |
| 2000-12-12 15:00:00 | AAPL | Stock | 0.279 | 0.2846 | 0.2723 | 0.2757 | 76143200.0 |
| 2000-12-12 16:00:00 | AAPL | Stock | 0.2751 | 0.2813 | 0.2679 | 0.279 | 24651200.0 |
| 2000-12-12 17:00:00 | AAPL | Stock | 0.2746 | 0.2768 | 0.2701 | 0.2746 | 190400.0 |
| 2000-12-12 18:00:00 | AAPL | Stock | 0.2734 | 0.2734 | 0.2723 | 0.2734 | 128800.0 |
| 2000-12-12 08:00:00 | MSFT | Stock | 29.0938 | 29.25 | 28.75 | 28.875 | 23800.0 |
| 2000-12-12 09:00:00 | MSFT | Stock | 28.8438 | 29.0781 | 28.375 | 28.6719 | 6766200.0 |
| 2000-12-12 10:00:00 | MSFT | Stock | 28.6875 | 29.3125 | 28.625 | 29.0312 | 7230000.0 |
| 2000-12-12 11:00:00 | MSFT | Stock | 29.0312 | 29.25 | 28.9375 | 29.1875 | 6994400.0 |
| 2000-12-12 12:00:00 | MSFT | Stock | 29.1875 | 29.6875 | 29.0625 | 29.625 | 7127600.0 |
| 2000-12-12 13:00:00 | MSFT | Stock | 29.625 | 29.875 | 29.4688 | 29.5938 | 8262000.0 |
| 2000-12-12 14:00:00 | MSFT | Stock | 29.5625 | 29.7812 | 29.25 | 29.3438 | 6815600.0 |
| 2000-12-12 15:00:00 | MSFT | Stock | 29.375 | 30.0 | 29.0625 | 29.1562 | 13839600.0 |
| 2000-12-12 16:00:00 | MSFT | Stock | 29.1562 | 30.0 | 28.75 | 28.9375 | 2330600.0 |
| 2000-12-12 17:00:00 | MSFT | Stock | 29.1875 | 29.3125 | 28.875 | 29.3125 | 150200.0 |
| 2000-12-12 18:00:00 | MSFT | Stock | 29.3125 | 29.3125 | 29.2188 | 29.2188 | 12200.0 |
| 2000-12-12 09:00:00 | NVDA | Stock | 0.201 | 0.2021 | 0.1951 | 0.1971 | 50184000.0 |
| 2000-12-12 10:00:00 | NVDA | Stock | 0.1974 | 0.2057 | 0.1969 | 0.2036 | 129456000.0 |
| 2000-12-12 11:00:00 | NVDA | Stock | 0.2029 | 0.2042 | 0.201 | 0.2026 | 53616000.0 |
| 2000-12-12 12:00:00 | NVDA | Stock | 0.2029 | 0.2031 | 0.1979 | 0.2003 | 36696000.0 |
| 2000-12-12 13:00:00 | NVDA | Stock | 0.2 | 0.2036 | 0.1997 | 0.2 | 22248000.0 |
| 2000-12-12 14:00:00 | NVDA | Stock | 0.2003 | 0.2031 | 0.1984 | 0.2031 | 30384000.0 |
| 2000-12-12 15:00:00 | NVDA | Stock | 0.2031 | 0.2052 | 0.2 | 0.2016 | 60432000.0 |
| 2000-12-12 16:00:00 | NVDA | Stock | 0.201 | 0.2021 | 0.1958 | 0.1958 | 8688000.0 |
| 2000-12-12 18:00:00 | NVDA | Stock | 0.1938 | 0.1938 | 0.1917 | 0.1917 | 264000.0 |
| 2000-12-12 08:00:00 | AMZN | Stock | 1.25 | 1.25 | 1.2375 | 1.25 | 112000.0 |
| 2000-12-12 09:00:00 | AMZN | Stock | 1.2469 | 1.3188 | 1.2156 | 1.3125 | 24574000.0 |
| 2000-12-12 10:00:00 | AMZN | Stock | 1.3094 | 1.375 | 1.2938 | 1.3094 | 50052000.0 |
| 2000-12-12 11:00:00 | AMZN | Stock | 1.3094 | 1.3484 | 1.3063 | 1.3312 | 18504000.0 |
| 2000-12-12 12:00:00 | AMZN | Stock | 1.3281 | 1.3344 | 1.2938 | 1.3094 | 10374000.0 |
| 2000-12-12 13:00:00 | AMZN | Stock | 1.3094 | 1.325 | 1.3031 | 1.3094 | 9468000.0 |
| 2000-12-12 14:00:00 | AMZN | Stock | 1.3031 | 1.3063 | 1.2906 | 1.2938 | 7284000.0 |
| 2000-12-12 15:00:00 | AMZN | Stock | 1.2938 | 1.3375 | 1.2906 | 1.2969 | 18028000.0 |
| 2000-12-12 16:00:00 | AMZN | Stock | 1.2906 | 1.2969 | 1.2812 | 1.2844 | 1336000.0 |
| 2000-12-12 18:00:00 | AMZN | Stock | 1.3 | 1.3 | 1.3 | 1.3 | 4000.0 |
| 2000-12-12 09:00:00 | CL | Stock | 29.25 | 29.95 | 29.175 | 29.575 | 862200.0 |
| 2000-12-12 10:00:00 | CL | Stock | 29.59 | 29.75 | 29.46 | 29.625 | 668400.0 |
| 2000-12-12 11:00:00 | CL | Stock | 29.625 | 29.625 | 29.5 | 29.58 | 410400.0 |
| 2000-12-12 12:00:00 | CL | Stock | 29.575 | 29.6 | 29.45 | 29.495 | 378200.0 |
| 2000-12-12 13:00:00 | CL | Stock | 29.49 | 29.625 | 29.485 | 29.6 | 261400.0 |
| 2000-12-12 14:00:00 | CL | Stock | 29.605 | 29.62 | 29.45 | 29.48 | 472000.0 |
| 2000-12-12 15:00:00 | CL | Stock | 29.5 | 29.55 | 29.42 | 29.46 | 640000.0 |
| 2000-12-12 16:00:00 | CL | Stock | 29.46 | 29.5 | 29.46 | 29.5 | 177600.0 |
> showing 49 of 16,284 rows — these rows as CSV