PREVIEW / stock_1hour / 2000-12-01
file: by_date/stock_1hour/2000/2000-12-01.parquet size: 309 KB rows: 16,063 symbols: 1,252
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-01 08:00:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.2946 | 0.2991 | 2581600.0 |
| 2000-12-01 09:00:00 | AAPL | Stock | 0.2991 | 0.3092 | 0.2991 | 0.3036 | 60547200.0 |
| 2000-12-01 10:00:00 | AAPL | Stock | 0.3036 | 0.3114 | 0.3025 | 0.3092 | 72256800.0 |
| 2000-12-01 11:00:00 | AAPL | Stock | 0.3092 | 0.3125 | 0.3047 | 0.3047 | 60967200.0 |
| 2000-12-01 12:00:00 | AAPL | Stock | 0.3058 | 0.3114 | 0.3047 | 0.3103 | 18776800.0 |
| 2000-12-01 13:00:00 | AAPL | Stock | 0.3103 | 0.3125 | 0.3069 | 0.3103 | 24584000.0 |
| 2000-12-01 14:00:00 | AAPL | Stock | 0.3103 | 0.3114 | 0.3058 | 0.3058 | 58833600.0 |
| 2000-12-01 15:00:00 | AAPL | Stock | 0.3069 | 0.3069 | 0.3002 | 0.3047 | 47068000.0 |
| 2000-12-01 16:00:00 | AAPL | Stock | 0.3047 | 0.308 | 0.3019 | 0.3069 | 3416000.0 |
| 2000-12-01 17:00:00 | AAPL | Stock | 0.308 | 0.3125 | 0.308 | 0.3125 | 660800.0 |
| 2000-12-01 18:00:00 | AAPL | Stock | 0.3125 | 0.3125 | 0.3125 | 0.3125 | 11200.0 |
| 2000-12-01 08:00:00 | MSFT | Stock | 29.375 | 29.75 | 28.6875 | 29.0625 | 626800.0 |
| 2000-12-01 09:00:00 | MSFT | Stock | 29.125 | 29.2812 | 28.5 | 28.5312 | 16400600.0 |
| 2000-12-01 10:00:00 | MSFT | Stock | 28.5625 | 30.0938 | 28.0312 | 29.375 | 27689800.0 |
| 2000-12-01 11:00:00 | MSFT | Stock | 29.3125 | 29.5625 | 28.9375 | 29.0 | 11293200.0 |
| 2000-12-01 12:00:00 | MSFT | Stock | 28.9688 | 29.4375 | 28.9375 | 29.375 | 6268400.0 |
| 2000-12-01 13:00:00 | MSFT | Stock | 29.4062 | 29.625 | 29.2188 | 29.375 | 7418400.0 |
| 2000-12-01 14:00:00 | MSFT | Stock | 29.375 | 29.6719 | 28.9062 | 28.9375 | 10377000.0 |
| 2000-12-01 15:00:00 | MSFT | Stock | 28.9375 | 28.9375 | 28.0938 | 28.3125 | 16977800.0 |
| 2000-12-01 16:00:00 | MSFT | Stock | 28.3125 | 29.125 | 28.25 | 28.3125 | 1948000.0 |
| 2000-12-01 17:00:00 | MSFT | Stock | 28.625 | 29.0 | 28.625 | 29.0 | 34200.0 |
| 2000-12-01 18:00:00 | MSFT | Stock | 29.0 | 29.0 | 28.75 | 29.0 | 8800.0 |
| 2000-12-01 08:00:00 | NVDA | Stock | 0.175 | 0.175 | 0.175 | 0.175 | 48000.0 |
| 2000-12-01 09:00:00 | NVDA | Stock | 0.1771 | 0.1917 | 0.1727 | 0.1867 | 72888000.0 |
| 2000-12-01 10:00:00 | NVDA | Stock | 0.1862 | 0.1953 | 0.1839 | 0.1849 | 88080000.0 |
| 2000-12-01 11:00:00 | NVDA | Stock | 0.1865 | 0.1919 | 0.1849 | 0.1849 | 84720000.0 |
| 2000-12-01 12:00:00 | NVDA | Stock | 0.1862 | 0.1948 | 0.1854 | 0.1935 | 54984000.0 |
| 2000-12-01 13:00:00 | NVDA | Stock | 0.1945 | 0.2005 | 0.1938 | 0.1984 | 114528000.0 |
| 2000-12-01 14:00:00 | NVDA | Stock | 0.1979 | 0.2031 | 0.1896 | 0.1952 | 108672000.0 |
| 2000-12-01 15:00:00 | NVDA | Stock | 0.1953 | 0.1961 | 0.1781 | 0.1853 | 167832000.0 |
| 2000-12-01 16:00:00 | NVDA | Stock | 0.1849 | 0.1895 | 0.1776 | 0.1818 | 15072000.0 |
| 2000-12-01 17:00:00 | NVDA | Stock | 0.1854 | 0.1854 | 0.1844 | 0.1844 | 96000.0 |
| 2000-12-01 08:00:00 | AMZN | Stock | 1.2625 | 1.275 | 1.2625 | 1.2719 | 36000.0 |
| 2000-12-01 09:00:00 | AMZN | Stock | 1.2656 | 1.275 | 1.2313 | 1.275 | 12282000.0 |
| 2000-12-01 10:00:00 | AMZN | Stock | 1.275 | 1.3375 | 1.2375 | 1.3312 | 31284000.0 |
| 2000-12-01 11:00:00 | AMZN | Stock | 1.3281 | 1.3375 | 1.25 | 1.2812 | 26582000.0 |
| 2000-12-01 12:00:00 | AMZN | Stock | 1.2844 | 1.3063 | 1.275 | 1.2906 | 10306000.0 |
| 2000-12-01 13:00:00 | AMZN | Stock | 1.2906 | 1.2938 | 1.2625 | 1.2719 | 9290000.0 |
| 2000-12-01 14:00:00 | AMZN | Stock | 1.275 | 1.2812 | 1.2281 | 1.2313 | 12978000.0 |
| 2000-12-01 15:00:00 | AMZN | Stock | 1.2344 | 1.2469 | 1.15 | 1.2438 | 32980000.0 |
| 2000-12-01 16:00:00 | AMZN | Stock | 1.2281 | 1.2438 | 1.225 | 1.2313 | 1882000.0 |
| 2000-12-01 17:00:00 | AMZN | Stock | 1.2375 | 1.2375 | 1.2375 | 1.2375 | 6000.0 |
| 2000-12-01 18:00:00 | AMZN | Stock | 1.2375 | 1.2375 | 1.2375 | 1.2375 | 20000.0 |
| 2000-12-01 09:00:00 | CL | Stock | 29.875 | 29.875 | 29.625 | 29.705 | 552800.0 |
| 2000-12-01 10:00:00 | CL | Stock | 29.68 | 29.75 | 29.645 | 29.705 | 465800.0 |
| 2000-12-01 11:00:00 | CL | Stock | 29.68 | 29.745 | 29.45 | 29.71 | 333800.0 |
| 2000-12-01 12:00:00 | CL | Stock | 29.725 | 29.875 | 29.675 | 29.675 | 250800.0 |
| 2000-12-01 13:00:00 | CL | Stock | 29.675 | 29.725 | 29.63 | 29.68 | 123800.0 |
| 2000-12-01 14:00:00 | CL | Stock | 29.68 | 29.88 | 29.68 | 29.87 | 283000.0 |
| 2000-12-01 15:00:00 | CL | Stock | 29.86 | 29.99 | 29.775 | 29.85 | 582800.0 |
> showing 50 of 16,063 rows — these rows as CSV