PREVIEW / stock_1hour / 2004-02-09
file: by_date/stock_1hour/2004/2004-02-09.parquet size: 498 KB rows: 22,854 symbols: 1,715
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 |
|---|---|---|---|---|---|---|---|
| 2004-02-09 08:00:00 | AAPL | Stock | 0.4027 | 0.4027 | 0.4027 | 0.4027 | 16800.0 |
| 2004-02-09 09:00:00 | AAPL | Stock | 0.4055 | 0.407 | 0.4018 | 0.4031 | 19793536.0 |
| 2004-02-09 10:00:00 | AAPL | Stock | 0.4032 | 0.4082 | 0.4025 | 0.4059 | 30718408.0 |
| 2004-02-09 11:00:00 | AAPL | Stock | 0.4063 | 0.4063 | 0.4034 | 0.4039 | 24416392.0 |
| 2004-02-09 12:00:00 | AAPL | Stock | 0.4038 | 0.4054 | 0.4036 | 0.4045 | 11838904.0 |
| 2004-02-09 13:00:00 | AAPL | Stock | 0.4046 | 0.4061 | 0.4045 | 0.4054 | 8668016.0 |
| 2004-02-09 14:00:00 | AAPL | Stock | 0.4053 | 0.4055 | 0.4036 | 0.4038 | 30714600.0 |
| 2004-02-09 15:00:00 | AAPL | Stock | 0.4038 | 0.4063 | 0.4032 | 0.4048 | 55029968.0 |
| 2004-02-09 16:00:00 | AAPL | Stock | 0.4048 | 0.4052 | 0.4032 | 0.405 | 4362008.0 |
| 2004-02-09 17:00:00 | AAPL | Stock | 0.4034 | 0.4048 | 0.4032 | 0.4048 | 188216.0 |
| 2004-02-09 08:00:00 | MSFT | Stock | 27.08 | 27.28 | 27.08 | 27.19 | 55407.0 |
| 2004-02-09 09:00:00 | MSFT | Stock | 27.2 | 27.25 | 27.01 | 27.06 | 6432284.0 |
| 2004-02-09 10:00:00 | MSFT | Stock | 27.06 | 27.11 | 26.96 | 27.04 | 7582517.0 |
| 2004-02-09 11:00:00 | MSFT | Stock | 27.03 | 27.08 | 26.9799 | 27.05 | 5021793.0 |
| 2004-02-09 12:00:00 | MSFT | Stock | 27.06 | 27.07 | 27.0 | 27.04 | 3615332.0 |
| 2004-02-09 13:00:00 | MSFT | Stock | 27.02 | 27.04 | 26.96 | 26.97 | 3676079.0 |
| 2004-02-09 14:00:00 | MSFT | Stock | 26.97 | 27.01 | 26.85 | 26.86 | 7155082.0 |
| 2004-02-09 15:00:00 | MSFT | Stock | 26.86 | 27.04 | 26.86 | 26.9 | 12257898.0 |
| 2004-02-09 16:00:00 | MSFT | Stock | 26.89 | 27.0 | 26.84 | 26.87 | 721485.0 |
| 2004-02-09 17:00:00 | MSFT | Stock | 26.86 | 26.9 | 26.86 | 26.88 | 14675.0 |
| 2004-02-09 18:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.88 | 26.88 | 1000.0 |
| 2004-02-09 08:00:00 | NVDA | Stock | 0.19 | 0.1912 | 0.19 | 0.1909 | 2280000.0 |
| 2004-02-09 09:00:00 | NVDA | Stock | 0.1909 | 0.1912 | 0.1882 | 0.1893 | 70317600.0 |
| 2004-02-09 10:00:00 | NVDA | Stock | 0.1892 | 0.1942 | 0.1886 | 0.1927 | 90459960.0 |
| 2004-02-09 11:00:00 | NVDA | Stock | 0.1929 | 0.1933 | 0.1921 | 0.1922 | 29001120.0 |
| 2004-02-09 12:00:00 | NVDA | Stock | 0.1921 | 0.1924 | 0.1912 | 0.1918 | 23471160.0 |
| 2004-02-09 13:00:00 | NVDA | Stock | 0.1918 | 0.1926 | 0.1911 | 0.1911 | 30867600.0 |
| 2004-02-09 14:00:00 | NVDA | Stock | 0.1909 | 0.1912 | 0.1893 | 0.1893 | 42755160.0 |
| 2004-02-09 15:00:00 | NVDA | Stock | 0.1893 | 0.1903 | 0.1883 | 0.1887 | 64460640.0 |
| 2004-02-09 16:00:00 | NVDA | Stock | 0.1887 | 0.1887 | 0.1882 | 0.1883 | 2768640.0 |
| 2004-02-09 18:00:00 | NVDA | Stock | 0.1902 | 0.1902 | 0.1902 | 0.1902 | 24000.0 |
| 2004-02-09 08:00:00 | AMZN | Stock | 2.323 | 2.3325 | 2.32 | 2.3266 | 133500.0 |
| 2004-02-09 09:00:00 | AMZN | Stock | 2.3275 | 2.34 | 2.3 | 2.3088 | 15456880.0 |
| 2004-02-09 10:00:00 | AMZN | Stock | 2.309 | 2.3275 | 2.2875 | 2.2925 | 25718580.0 |
| 2004-02-09 11:00:00 | AMZN | Stock | 2.292 | 2.3125 | 2.285 | 2.307 | 17699040.0 |
| 2004-02-09 12:00:00 | AMZN | Stock | 2.307 | 2.323 | 2.3035 | 2.3115 | 11248700.0 |
| 2004-02-09 13:00:00 | AMZN | Stock | 2.3115 | 2.325 | 2.311 | 2.3195 | 7563280.0 |
| 2004-02-09 14:00:00 | AMZN | Stock | 2.3195 | 2.322 | 2.314 | 2.315 | 8589820.0 |
| 2004-02-09 15:00:00 | AMZN | Stock | 2.315 | 2.315 | 2.285 | 2.2915 | 28432620.0 |
| 2004-02-09 16:00:00 | AMZN | Stock | 2.291 | 2.2962 | 2.2885 | 2.293 | 1291080.0 |
| 2004-02-09 17:00:00 | AMZN | Stock | 2.2935 | 2.297 | 2.2905 | 2.291 | 1769040.0 |
| 2004-02-09 18:00:00 | AMZN | Stock | 2.2925 | 2.2925 | 2.2905 | 2.2905 | 21520.0 |
| 2004-02-09 09:00:00 | CL | Stock | 27.48 | 27.48 | 27.375 | 27.4 | 469000.0 |
| 2004-02-09 10:00:00 | CL | Stock | 27.4 | 27.405 | 27.3 | 27.305 | 759600.0 |
| 2004-02-09 11:00:00 | CL | Stock | 27.305 | 27.45 | 27.15 | 27.185 | 737800.0 |
| 2004-02-09 12:00:00 | CL | Stock | 27.19 | 27.36 | 27.155 | 27.35 | 495000.0 |
| 2004-02-09 13:00:00 | CL | Stock | 27.35 | 27.42 | 27.275 | 27.395 | 302600.0 |
| 2004-02-09 14:00:00 | CL | Stock | 27.4 | 27.495 | 27.385 | 27.445 | 738600.0 |
| 2004-02-09 15:00:00 | CL | Stock | 27.425 | 27.5 | 27.395 | 27.46 | 867600.0 |
> showing 49 of 22,854 rows — these rows as CSV