PREVIEW / stock_1hour / 2000-12-04
file: by_date/stock_1hour/2000/2000-12-04.parquet size: 314 KB rows: 16,275 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-04 08:00:00 | AAPL | Stock | 0.3036 | 0.3075 | 0.2946 | 0.3002 | 190400.0 |
| 2000-12-04 09:00:00 | AAPL | Stock | 0.3036 | 0.3069 | 0.3013 | 0.3047 | 30088800.0 |
| 2000-12-04 10:00:00 | AAPL | Stock | 0.3058 | 0.3069 | 0.2958 | 0.2974 | 57769600.0 |
| 2000-12-04 11:00:00 | AAPL | Stock | 0.2969 | 0.3013 | 0.2935 | 0.2952 | 84067200.0 |
| 2000-12-04 12:00:00 | AAPL | Stock | 0.2946 | 0.298 | 0.2946 | 0.2969 | 36551200.0 |
| 2000-12-04 13:00:00 | AAPL | Stock | 0.2969 | 0.2991 | 0.2958 | 0.298 | 33650400.0 |
| 2000-12-04 14:00:00 | AAPL | Stock | 0.298 | 0.298 | 0.2958 | 0.2969 | 60368000.0 |
| 2000-12-04 15:00:00 | AAPL | Stock | 0.2969 | 0.2997 | 0.2969 | 0.2997 | 46558400.0 |
| 2000-12-04 16:00:00 | AAPL | Stock | 0.2991 | 0.3013 | 0.2935 | 0.298 | 3337600.0 |
| 2000-12-04 17:00:00 | AAPL | Stock | 0.3013 | 0.3025 | 0.2946 | 0.3025 | 470400.0 |
| 2000-12-04 18:00:00 | AAPL | Stock | 0.3013 | 0.3025 | 0.2991 | 0.2991 | 16800.0 |
| 2000-12-04 08:00:00 | MSFT | Stock | 28.9375 | 29.0469 | 28.2969 | 28.75 | 103260.0 |
| 2000-12-04 09:00:00 | MSFT | Stock | 28.75 | 29.0 | 28.2812 | 28.3438 | 8666800.0 |
| 2000-12-04 10:00:00 | MSFT | Stock | 28.3438 | 28.5625 | 27.5938 | 28.0938 | 12759400.0 |
| 2000-12-04 11:00:00 | MSFT | Stock | 28.0625 | 29.0 | 27.9375 | 28.3125 | 16232800.0 |
| 2000-12-04 12:00:00 | MSFT | Stock | 28.375 | 28.4375 | 28.1562 | 28.375 | 5876600.0 |
| 2000-12-04 13:00:00 | MSFT | Stock | 28.3594 | 28.4688 | 28.1562 | 28.4688 | 5249800.0 |
| 2000-12-04 14:00:00 | MSFT | Stock | 28.4688 | 28.7188 | 28.3125 | 28.5 | 11143000.0 |
| 2000-12-04 15:00:00 | MSFT | Stock | 28.5 | 28.5938 | 28.1562 | 28.2188 | 11822600.0 |
| 2000-12-04 16:00:00 | MSFT | Stock | 28.2188 | 30.3125 | 28.125 | 29.6875 | 2197200.0 |
| 2000-12-04 17:00:00 | MSFT | Stock | 29.6875 | 30.9688 | 28.2188 | 29.7812 | 1104600.0 |
| 2000-12-04 18:00:00 | MSFT | Stock | 29.7812 | 30.125 | 29.7188 | 30.0 | 128400.0 |
| 2000-12-04 09:00:00 | NVDA | Stock | 0.1844 | 0.1911 | 0.1813 | 0.188 | 52392000.0 |
| 2000-12-04 10:00:00 | NVDA | Stock | 0.187 | 0.1878 | 0.1742 | 0.181 | 95280000.0 |
| 2000-12-04 11:00:00 | NVDA | Stock | 0.181 | 0.1872 | 0.1781 | 0.1823 | 79080000.0 |
| 2000-12-04 12:00:00 | NVDA | Stock | 0.1813 | 0.1831 | 0.1797 | 0.1818 | 42192000.0 |
| 2000-12-04 13:00:00 | NVDA | Stock | 0.1818 | 0.1891 | 0.1818 | 0.1883 | 24624000.0 |
| 2000-12-04 14:00:00 | NVDA | Stock | 0.1885 | 0.1927 | 0.1875 | 0.1901 | 35328000.0 |
| 2000-12-04 15:00:00 | NVDA | Stock | 0.1901 | 0.1917 | 0.1865 | 0.1883 | 94296000.0 |
| 2000-12-04 16:00:00 | NVDA | Stock | 0.1893 | 0.1917 | 0.1875 | 0.1911 | 9648000.0 |
| 2000-12-04 17:00:00 | NVDA | Stock | 0.1943 | 0.2042 | 0.1943 | 0.2042 | 96000.0 |
| 2000-12-04 08:00:00 | AMZN | Stock | 1.2438 | 1.2438 | 1.2438 | 1.2438 | 20000.0 |
| 2000-12-04 09:00:00 | AMZN | Stock | 1.2438 | 1.3063 | 1.2438 | 1.25 | 18916000.0 |
| 2000-12-04 10:00:00 | AMZN | Stock | 1.25 | 1.2625 | 1.1625 | 1.225 | 21734000.0 |
| 2000-12-04 11:00:00 | AMZN | Stock | 1.225 | 1.3 | 1.225 | 1.2531 | 18616000.0 |
| 2000-12-04 12:00:00 | AMZN | Stock | 1.2531 | 1.2844 | 1.25 | 1.2812 | 14106000.0 |
| 2000-12-04 13:00:00 | AMZN | Stock | 1.2844 | 1.3063 | 1.2438 | 1.3063 | 20410000.0 |
| 2000-12-04 14:00:00 | AMZN | Stock | 1.3063 | 1.35 | 1.2969 | 1.3281 | 27328000.0 |
| 2000-12-04 15:00:00 | AMZN | Stock | 1.3312 | 1.3594 | 1.3188 | 1.3312 | 31544000.0 |
| 2000-12-04 16:00:00 | AMZN | Stock | 1.3281 | 1.35 | 1.3125 | 1.3344 | 1686000.0 |
| 2000-12-04 17:00:00 | AMZN | Stock | 1.35 | 1.3969 | 1.35 | 1.3781 | 172000.0 |
| 2000-12-04 18:00:00 | AMZN | Stock | 1.3781 | 1.3844 | 1.3781 | 1.3844 | 6000.0 |
| 2000-12-04 09:00:00 | CL | Stock | 29.525 | 29.7 | 29.525 | 29.68 | 171200.0 |
| 2000-12-04 10:00:00 | CL | Stock | 29.725 | 30.2 | 29.725 | 30.11 | 537600.0 |
| 2000-12-04 11:00:00 | CL | Stock | 30.105 | 30.15 | 29.925 | 29.975 | 511400.0 |
| 2000-12-04 12:00:00 | CL | Stock | 29.975 | 30.075 | 29.855 | 30.0 | 268600.0 |
| 2000-12-04 13:00:00 | CL | Stock | 30.0 | 30.04 | 29.83 | 29.92 | 400400.0 |
| 2000-12-04 14:00:00 | CL | Stock | 29.925 | 29.95 | 29.765 | 29.95 | 412000.0 |
| 2000-12-04 15:00:00 | CL | Stock | 29.95 | 30.0 | 29.91 | 29.955 | 420400.0 |
| 2000-12-04 16:00:00 | CL | Stock | 29.96 | 29.97 | 29.96 | 29.97 | 45000.0 |
> showing 50 of 16,275 rows — these rows as CSV