PREVIEW / stock_1hour / 2000-12-13
file: by_date/stock_1hour/2000/2000-12-13.parquet size: 314 KB rows: 16,244 symbols: 1,256
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-13 08:00:00 | AAPL | Stock | 0.279 | 0.2813 | 0.2746 | 0.2779 | 252000.0 |
| 2000-12-13 09:00:00 | AAPL | Stock | 0.2779 | 0.2801 | 0.2723 | 0.2723 | 37245600.0 |
| 2000-12-13 10:00:00 | AAPL | Stock | 0.2723 | 0.2746 | 0.269 | 0.269 | 35173600.0 |
| 2000-12-13 11:00:00 | AAPL | Stock | 0.269 | 0.2701 | 0.2667 | 0.269 | 63565600.0 |
| 2000-12-13 12:00:00 | AAPL | Stock | 0.269 | 0.269 | 0.2656 | 0.2667 | 39620000.0 |
| 2000-12-13 13:00:00 | AAPL | Stock | 0.2667 | 0.269 | 0.2656 | 0.2679 | 24791200.0 |
| 2000-12-13 14:00:00 | AAPL | Stock | 0.269 | 0.269 | 0.2656 | 0.2679 | 35056000.0 |
| 2000-12-13 15:00:00 | AAPL | Stock | 0.2679 | 0.269 | 0.2656 | 0.2667 | 63336000.0 |
| 2000-12-13 16:00:00 | AAPL | Stock | 0.2667 | 0.2746 | 0.2656 | 0.2746 | 21235200.0 |
| 2000-12-13 17:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2673 | 0.2679 | 375200.0 |
| 2000-12-13 18:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 22400.0 |
| 2000-12-13 08:00:00 | MSFT | Stock | 29.25 | 30.25 | 29.0625 | 30.125 | 1312800.0 |
| 2000-12-13 09:00:00 | MSFT | Stock | 30.1562 | 30.25 | 29.25 | 29.4688 | 20339400.0 |
| 2000-12-13 10:00:00 | MSFT | Stock | 29.4375 | 29.9375 | 28.9688 | 29.0 | 21143600.0 |
| 2000-12-13 11:00:00 | MSFT | Stock | 29.0 | 29.75 | 28.9375 | 29.7188 | 9710000.0 |
| 2000-12-13 12:00:00 | MSFT | Stock | 29.75 | 29.8125 | 29.125 | 29.125 | 6155800.0 |
| 2000-12-13 13:00:00 | MSFT | Stock | 29.125 | 29.5938 | 29.0938 | 29.4688 | 5053200.0 |
| 2000-12-13 14:00:00 | MSFT | Stock | 29.5 | 29.625 | 29.1562 | 29.4375 | 5685600.0 |
| 2000-12-13 15:00:00 | MSFT | Stock | 29.4375 | 29.5625 | 28.4062 | 28.625 | 18424000.0 |
| 2000-12-13 16:00:00 | MSFT | Stock | 28.5938 | 29.6875 | 28.4688 | 28.8125 | 2038000.0 |
| 2000-12-13 17:00:00 | MSFT | Stock | 28.8438 | 28.9375 | 28.625 | 28.875 | 68400.0 |
| 2000-12-13 18:00:00 | MSFT | Stock | 28.8125 | 28.9844 | 28.8125 | 28.9688 | 9400.0 |
| 2000-12-13 08:00:00 | NVDA | Stock | 0.2086 | 0.2094 | 0.2083 | 0.2083 | 480000.0 |
| 2000-12-13 09:00:00 | NVDA | Stock | 0.2083 | 0.2083 | 0.1885 | 0.1885 | 130416000.0 |
| 2000-12-13 10:00:00 | NVDA | Stock | 0.1885 | 0.1958 | 0.1844 | 0.187 | 138672000.0 |
| 2000-12-13 11:00:00 | NVDA | Stock | 0.1872 | 0.1901 | 0.1823 | 0.1891 | 64656000.0 |
| 2000-12-13 12:00:00 | NVDA | Stock | 0.1891 | 0.1932 | 0.1857 | 0.1875 | 48480000.0 |
| 2000-12-13 13:00:00 | NVDA | Stock | 0.1865 | 0.1904 | 0.1844 | 0.1878 | 62616000.0 |
| 2000-12-13 14:00:00 | NVDA | Stock | 0.188 | 0.1911 | 0.1833 | 0.1885 | 47880000.0 |
| 2000-12-13 15:00:00 | NVDA | Stock | 0.1885 | 0.1904 | 0.1823 | 0.1865 | 127152000.0 |
| 2000-12-13 16:00:00 | NVDA | Stock | 0.1857 | 0.1874 | 0.1833 | 0.1854 | 5256000.0 |
| 2000-12-13 08:00:00 | AMZN | Stock | 1.3125 | 1.3312 | 1.3125 | 1.3219 | 126000.0 |
| 2000-12-13 09:00:00 | AMZN | Stock | 1.325 | 1.35 | 1.2688 | 1.2688 | 15842000.0 |
| 2000-12-13 10:00:00 | AMZN | Stock | 1.2719 | 1.2938 | 1.2313 | 1.2406 | 22804000.0 |
| 2000-12-13 11:00:00 | AMZN | Stock | 1.2406 | 1.2562 | 1.2313 | 1.2438 | 15590000.0 |
| 2000-12-13 12:00:00 | AMZN | Stock | 1.2406 | 1.2531 | 1.2188 | 1.225 | 12232000.0 |
| 2000-12-13 13:00:00 | AMZN | Stock | 1.225 | 1.2438 | 1.2156 | 1.2219 | 12186000.0 |
| 2000-12-13 14:00:00 | AMZN | Stock | 1.225 | 1.2406 | 1.2062 | 1.2313 | 12466000.0 |
| 2000-12-13 15:00:00 | AMZN | Stock | 1.2313 | 1.2344 | 1.175 | 1.1906 | 22812000.0 |
| 2000-12-13 16:00:00 | AMZN | Stock | 1.1906 | 1.2375 | 1.1875 | 1.1875 | 1972000.0 |
| 2000-12-13 17:00:00 | AMZN | Stock | 1.1875 | 1.2062 | 1.1875 | 1.2 | 30000.0 |
| 2000-12-13 18:00:00 | AMZN | Stock | 1.2 | 1.2 | 1.2 | 1.2 | 8000.0 |
| 2000-12-13 09:00:00 | CL | Stock | 29.4 | 29.4 | 29.2 | 29.24 | 369600.0 |
| 2000-12-13 10:00:00 | CL | Stock | 29.205 | 29.205 | 28.9 | 29.075 | 617000.0 |
| 2000-12-13 11:00:00 | CL | Stock | 29.08 | 29.245 | 29.075 | 29.165 | 217600.0 |
| 2000-12-13 12:00:00 | CL | Stock | 29.165 | 29.25 | 29.155 | 29.2 | 165000.0 |
| 2000-12-13 13:00:00 | CL | Stock | 29.16 | 29.19 | 29.025 | 29.13 | 253000.0 |
| 2000-12-13 14:00:00 | CL | Stock | 29.135 | 29.15 | 29.0 | 29.15 | 765400.0 |
| 2000-12-13 15:00:00 | CL | Stock | 29.125 | 29.14 | 29.07 | 29.075 | 387000.0 |
| 2000-12-13 16:00:00 | CL | Stock | 29.08 | 29.33 | 29.075 | 29.125 | 134800.0 |
> showing 50 of 16,244 rows — these rows as CSV