PREVIEW / stock_1hour / 2000-12-06
file: by_date/stock_1hour/2000/2000-12-06.parquet size: 318 KB rows: 16,259 symbols: 1,253
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-06 08:00:00 | AAPL | Stock | 0.2522 | 0.269 | 0.25 | 0.2656 | 24892000.0 |
| 2000-12-06 09:00:00 | AAPL | Stock | 0.2656 | 0.2712 | 0.25 | 0.2634 | 333978400.0 |
| 2000-12-06 10:00:00 | AAPL | Stock | 0.2623 | 0.2645 | 0.2578 | 0.26 | 269802400.0 |
| 2000-12-06 11:00:00 | AAPL | Stock | 0.2612 | 0.2623 | 0.2533 | 0.2545 | 162898400.0 |
| 2000-12-06 12:00:00 | AAPL | Stock | 0.2545 | 0.2578 | 0.25 | 0.2567 | 134724800.0 |
| 2000-12-06 13:00:00 | AAPL | Stock | 0.2556 | 0.2578 | 0.2511 | 0.2545 | 80427200.0 |
| 2000-12-06 14:00:00 | AAPL | Stock | 0.2545 | 0.2567 | 0.2533 | 0.2545 | 104501600.0 |
| 2000-12-06 15:00:00 | AAPL | Stock | 0.2545 | 0.26 | 0.2511 | 0.2545 | 128800000.0 |
| 2000-12-06 16:00:00 | AAPL | Stock | 0.2545 | 0.26 | 0.2545 | 0.2567 | 8596000.0 |
| 2000-12-06 17:00:00 | AAPL | Stock | 0.2556 | 0.2567 | 0.2545 | 0.2556 | 1226400.0 |
| 2000-12-06 18:00:00 | AAPL | Stock | 0.2561 | 0.2561 | 0.2545 | 0.2545 | 28000.0 |
| 2000-12-06 08:00:00 | MSFT | Stock | 29.625 | 30.0 | 29.625 | 29.8125 | 121200.0 |
| 2000-12-06 09:00:00 | MSFT | Stock | 29.875 | 30.0312 | 29.5 | 29.5 | 7281000.0 |
| 2000-12-06 10:00:00 | MSFT | Stock | 29.5312 | 29.5312 | 28.875 | 29.2188 | 13527000.0 |
| 2000-12-06 11:00:00 | MSFT | Stock | 29.25 | 29.25 | 28.6875 | 28.7188 | 10209800.0 |
| 2000-12-06 12:00:00 | MSFT | Stock | 28.7188 | 28.875 | 28.5 | 28.7188 | 8044800.0 |
| 2000-12-06 13:00:00 | MSFT | Stock | 28.75 | 28.9688 | 28.375 | 28.5312 | 8337400.0 |
| 2000-12-06 14:00:00 | MSFT | Stock | 28.5312 | 28.5625 | 28.1875 | 28.3125 | 12881800.0 |
| 2000-12-06 15:00:00 | MSFT | Stock | 28.3125 | 28.5625 | 28.0312 | 28.375 | 17575400.0 |
| 2000-12-06 16:00:00 | MSFT | Stock | 28.4062 | 30.0156 | 28.125 | 28.375 | 3669200.0 |
| 2000-12-06 17:00:00 | MSFT | Stock | 28.2812 | 28.4062 | 28.25 | 28.375 | 218200.0 |
| 2000-12-06 18:00:00 | MSFT | Stock | 28.3906 | 28.5 | 28.375 | 28.375 | 5200.0 |
| 2000-12-06 08:00:00 | NVDA | Stock | 0.1938 | 0.1958 | 0.1938 | 0.1958 | 360000.0 |
| 2000-12-06 09:00:00 | NVDA | Stock | 0.1979 | 0.2021 | 0.1938 | 0.1944 | 75336000.0 |
| 2000-12-06 10:00:00 | NVDA | Stock | 0.1945 | 0.1982 | 0.1917 | 0.1977 | 120096000.0 |
| 2000-12-06 11:00:00 | NVDA | Stock | 0.1979 | 0.2 | 0.1943 | 0.1958 | 111120000.0 |
| 2000-12-06 12:00:00 | NVDA | Stock | 0.1945 | 0.1958 | 0.193 | 0.1932 | 98160000.0 |
| 2000-12-06 13:00:00 | NVDA | Stock | 0.1932 | 0.1945 | 0.1909 | 0.1922 | 126048000.0 |
| 2000-12-06 14:00:00 | NVDA | Stock | 0.1922 | 0.1927 | 0.1859 | 0.1875 | 171888000.0 |
| 2000-12-06 15:00:00 | NVDA | Stock | 0.187 | 0.1875 | 0.1708 | 0.1727 | 113808000.0 |
| 2000-12-06 16:00:00 | NVDA | Stock | 0.1708 | 0.1721 | 0.1604 | 0.1667 | 7440000.0 |
| 2000-12-06 17:00:00 | NVDA | Stock | 0.1667 | 0.1685 | 0.1667 | 0.1685 | 96000.0 |
| 2000-12-06 08:00:00 | AMZN | Stock | 1.275 | 1.3031 | 1.175 | 1.2031 | 1190000.0 |
| 2000-12-06 09:00:00 | AMZN | Stock | 1.2062 | 1.3 | 1.2 | 1.25 | 26220000.0 |
| 2000-12-06 10:00:00 | AMZN | Stock | 1.2469 | 1.2594 | 1.2125 | 1.2156 | 27984000.0 |
| 2000-12-06 11:00:00 | AMZN | Stock | 1.2156 | 1.25 | 1.2125 | 1.2156 | 24988000.0 |
| 2000-12-06 12:00:00 | AMZN | Stock | 1.2156 | 1.2438 | 1.2125 | 1.2281 | 14956000.0 |
| 2000-12-06 13:00:00 | AMZN | Stock | 1.2297 | 1.2344 | 1.2 | 1.2125 | 9522000.0 |
| 2000-12-06 14:00:00 | AMZN | Stock | 1.2094 | 1.225 | 1.2031 | 1.225 | 14152000.0 |
| 2000-12-06 15:00:00 | AMZN | Stock | 1.2219 | 1.2313 | 1.1813 | 1.1813 | 22716000.0 |
| 2000-12-06 16:00:00 | AMZN | Stock | 1.1844 | 1.2125 | 1.15 | 1.1625 | 5476000.0 |
| 2000-12-06 17:00:00 | AMZN | Stock | 1.1688 | 1.1813 | 1.1688 | 1.1719 | 38000.0 |
| 2000-12-06 09:00:00 | CL | Stock | 29.125 | 29.285 | 29.075 | 29.075 | 366600.0 |
| 2000-12-06 10:00:00 | CL | Stock | 29.0 | 29.0 | 28.495 | 28.61 | 1237200.0 |
| 2000-12-06 11:00:00 | CL | Stock | 28.61 | 28.645 | 28.325 | 28.35 | 978600.0 |
| 2000-12-06 12:00:00 | CL | Stock | 28.35 | 28.355 | 28.245 | 28.29 | 1031600.0 |
| 2000-12-06 13:00:00 | CL | Stock | 28.295 | 28.31 | 27.72 | 27.725 | 1075800.0 |
| 2000-12-06 14:00:00 | CL | Stock | 27.725 | 28.05 | 27.725 | 27.99 | 620800.0 |
| 2000-12-06 15:00:00 | CL | Stock | 28.025 | 28.415 | 27.91 | 28.215 | 976600.0 |
| 2000-12-06 16:00:00 | CL | Stock | 28.215 | 28.24 | 28.21 | 28.24 | 69400.0 |
> showing 50 of 16,259 rows — these rows as CSV