PREVIEW / stock_1hour / 2000-05-24
file: by_date/stock_1hour/2000/2000-05-24.parquet size: 281 KB rows: 14,686 symbols: 1,168
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-05-24 09:00:00 | AAPL | Stock | 0.7695 | 0.7879 | 0.7656 | 0.7757 | 69440000.0 |
| 2000-05-24 10:00:00 | AAPL | Stock | 0.7757 | 0.8013 | 0.7623 | 0.7813 | 121049600.0 |
| 2000-05-24 11:00:00 | AAPL | Stock | 0.7813 | 0.7902 | 0.7679 | 0.7712 | 68353600.0 |
| 2000-05-24 12:00:00 | AAPL | Stock | 0.7712 | 0.7734 | 0.7411 | 0.7439 | 66248000.0 |
| 2000-05-24 13:00:00 | AAPL | Stock | 0.7427 | 0.7679 | 0.7427 | 0.7517 | 93116800.0 |
| 2000-05-24 14:00:00 | AAPL | Stock | 0.7517 | 0.7746 | 0.7444 | 0.7645 | 122897600.0 |
| 2000-05-24 15:00:00 | AAPL | Stock | 0.764 | 0.7857 | 0.7494 | 0.7829 | 106758400.0 |
| 2000-05-24 16:00:00 | AAPL | Stock | 0.7835 | 0.7846 | 0.7829 | 0.7829 | 3416000.0 |
| 2000-05-24 09:00:00 | MSFT | Stock | 31.5625 | 32.0625 | 31.5625 | 31.625 | 7606000.0 |
| 2000-05-24 10:00:00 | MSFT | Stock | 31.5938 | 32.5625 | 31.5 | 32.3125 | 15290200.0 |
| 2000-05-24 11:00:00 | MSFT | Stock | 32.3125 | 32.7812 | 31.75 | 32.0625 | 11137800.0 |
| 2000-05-24 12:00:00 | MSFT | Stock | 32.0625 | 32.4375 | 31.5625 | 31.7812 | 9328800.0 |
| 2000-05-24 13:00:00 | MSFT | Stock | 31.7812 | 32.5312 | 31.75 | 32.4062 | 7605600.0 |
| 2000-05-24 14:00:00 | MSFT | Stock | 32.4062 | 32.8438 | 32.2812 | 32.8125 | 12794600.0 |
| 2000-05-24 15:00:00 | MSFT | Stock | 32.8125 | 33.2812 | 32.6562 | 32.75 | 16989000.0 |
| 2000-05-24 16:00:00 | MSFT | Stock | 32.75 | 32.7812 | 32.6875 | 32.7812 | 510200.0 |
| 2000-05-24 09:00:00 | NVDA | Stock | 0.2245 | 0.2257 | 0.2195 | 0.2208 | 69936000.0 |
| 2000-05-24 10:00:00 | NVDA | Stock | 0.2204 | 0.2224 | 0.2128 | 0.2201 | 114528000.0 |
| 2000-05-24 11:00:00 | NVDA | Stock | 0.2201 | 0.2219 | 0.2167 | 0.2167 | 34560000.0 |
| 2000-05-24 12:00:00 | NVDA | Stock | 0.2167 | 0.2172 | 0.1922 | 0.1964 | 87264000.0 |
| 2000-05-24 13:00:00 | NVDA | Stock | 0.1965 | 0.2072 | 0.1935 | 0.2052 | 153024000.0 |
| 2000-05-24 14:00:00 | NVDA | Stock | 0.2062 | 0.2185 | 0.2042 | 0.2151 | 112944000.0 |
| 2000-05-24 15:00:00 | NVDA | Stock | 0.2156 | 0.2281 | 0.2129 | 0.2211 | 129264000.0 |
| 2000-05-24 16:00:00 | NVDA | Stock | 0.2211 | 0.2219 | 0.2211 | 0.2219 | 4896000.0 |
| 2000-05-24 09:00:00 | AMZN | Stock | 2.3219 | 2.3313 | 2.2344 | 2.2375 | 18216000.0 |
| 2000-05-24 10:00:00 | AMZN | Stock | 2.2406 | 2.2812 | 2.15 | 2.2188 | 46848000.0 |
| 2000-05-24 11:00:00 | AMZN | Stock | 2.2188 | 2.25 | 2.15 | 2.1969 | 15180000.0 |
| 2000-05-24 12:00:00 | AMZN | Stock | 2.1938 | 2.2125 | 2.0219 | 2.0875 | 37958000.0 |
| 2000-05-24 13:00:00 | AMZN | Stock | 2.0844 | 2.2281 | 2.075 | 2.2 | 37372000.0 |
| 2000-05-24 14:00:00 | AMZN | Stock | 2.2031 | 2.4438 | 2.1875 | 2.4375 | 38806000.0 |
| 2000-05-24 15:00:00 | AMZN | Stock | 2.4375 | 2.4844 | 2.3469 | 2.4281 | 28998000.0 |
| 2000-05-24 16:00:00 | AMZN | Stock | 2.4344 | 2.4344 | 2.4281 | 2.4281 | 476000.0 |
| 2000-05-24 09:00:00 | CL | Stock | 27.8438 | 28.3906 | 27.8438 | 28.375 | 463400.0 |
| 2000-05-24 10:00:00 | CL | Stock | 28.375 | 28.4688 | 28.125 | 28.25 | 1088800.0 |
| 2000-05-24 11:00:00 | CL | Stock | 28.25 | 28.4375 | 28.2188 | 28.4062 | 614600.0 |
| 2000-05-24 12:00:00 | CL | Stock | 28.4062 | 28.4062 | 28.125 | 28.1562 | 175000.0 |
| 2000-05-24 13:00:00 | CL | Stock | 28.125 | 28.5 | 28.125 | 28.4062 | 327400.0 |
| 2000-05-24 14:00:00 | CL | Stock | 28.4375 | 28.4688 | 28.1875 | 28.1875 | 399800.0 |
| 2000-05-24 15:00:00 | CL | Stock | 28.1875 | 28.3438 | 28.125 | 28.2188 | 400200.0 |
| 2000-05-24 16:00:00 | CL | Stock | 28.2188 | 28.3125 | 28.2188 | 28.3125 | 47800.0 |
> showing 40 of 14,686 rows — these rows as CSV