PREVIEW / stock_1hour / 2000-03-09
file: by_date/stock_1hour/2000/2000-03-09.parquet size: 285 KB rows: 14,616 symbols: 1,143
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-03-09 09:00:00 | AAPL | Stock | 1.0792 | 1.0871 | 1.058 | 1.058 | 25390400.0 |
| 2000-03-09 10:00:00 | AAPL | Stock | 1.058 | 1.0804 | 1.0558 | 1.0804 | 32088000.0 |
| 2000-03-09 11:00:00 | AAPL | Stock | 1.0804 | 1.1161 | 1.0804 | 1.0988 | 65598400.0 |
| 2000-03-09 12:00:00 | AAPL | Stock | 1.0982 | 1.0993 | 1.0826 | 1.0826 | 34932800.0 |
| 2000-03-09 13:00:00 | AAPL | Stock | 1.0837 | 1.0837 | 1.0714 | 1.0815 | 21156800.0 |
| 2000-03-09 14:00:00 | AAPL | Stock | 1.0815 | 1.0848 | 1.0737 | 1.0826 | 31472000.0 |
| 2000-03-09 15:00:00 | AAPL | Stock | 1.0823 | 1.096 | 1.0804 | 1.0915 | 46905600.0 |
| 2000-03-09 16:00:00 | AAPL | Stock | 1.0915 | 1.0915 | 1.091 | 1.0915 | 324800.0 |
| 2000-03-09 09:00:00 | MSFT | Stock | 47.6562 | 48.5 | 47.5 | 47.5 | 12732000.0 |
| 2000-03-09 10:00:00 | MSFT | Stock | 47.5 | 48.1875 | 47.5 | 47.9062 | 10054600.0 |
| 2000-03-09 11:00:00 | MSFT | Stock | 47.9375 | 48.125 | 47.6875 | 47.8438 | 7085000.0 |
| 2000-03-09 12:00:00 | MSFT | Stock | 47.8438 | 48.8125 | 47.8438 | 48.5938 | 12795000.0 |
| 2000-03-09 13:00:00 | MSFT | Stock | 48.5938 | 49.0625 | 48.5625 | 48.9688 | 8966000.0 |
| 2000-03-09 14:00:00 | MSFT | Stock | 49.0 | 49.1875 | 48.6875 | 49.1562 | 7316400.0 |
| 2000-03-09 15:00:00 | MSFT | Stock | 49.125 | 50.0 | 49.0625 | 50.0 | 21023000.0 |
| 2000-03-09 16:00:00 | MSFT | Stock | 50.0 | 50.0 | 49.9375 | 50.0 | 220200.0 |
| 2000-03-09 09:00:00 | NVDA | Stock | 0.1771 | 0.1974 | 0.1766 | 0.1954 | 112752000.0 |
| 2000-03-09 10:00:00 | NVDA | Stock | 0.1941 | 0.2125 | 0.1904 | 0.2085 | 259824000.0 |
| 2000-03-09 11:00:00 | NVDA | Stock | 0.2091 | 0.221 | 0.2036 | 0.2062 | 131376000.0 |
| 2000-03-09 12:00:00 | NVDA | Stock | 0.2062 | 0.2099 | 0.2021 | 0.2052 | 44688000.0 |
| 2000-03-09 13:00:00 | NVDA | Stock | 0.2072 | 0.2164 | 0.2047 | 0.2144 | 74064000.0 |
| 2000-03-09 14:00:00 | NVDA | Stock | 0.2151 | 0.2155 | 0.2091 | 0.2124 | 46848000.0 |
| 2000-03-09 15:00:00 | NVDA | Stock | 0.2109 | 0.225 | 0.2062 | 0.209 | 202992000.0 |
| 2000-03-09 16:00:00 | NVDA | Stock | 0.209 | 0.209 | 0.2089 | 0.2089 | 240000.0 |
| 2000-03-09 09:00:00 | AMZN | Stock | 3.15 | 3.1938 | 3.1094 | 3.1156 | 7686000.0 |
| 2000-03-09 10:00:00 | AMZN | Stock | 3.1156 | 3.275 | 3.1094 | 3.2531 | 21736000.0 |
| 2000-03-09 11:00:00 | AMZN | Stock | 3.2531 | 3.275 | 3.225 | 3.275 | 17140000.0 |
| 2000-03-09 12:00:00 | AMZN | Stock | 3.2719 | 3.4031 | 3.2688 | 3.375 | 45768000.0 |
| 2000-03-09 13:00:00 | AMZN | Stock | 3.375 | 3.3875 | 3.3188 | 3.3594 | 16390000.0 |
| 2000-03-09 14:00:00 | AMZN | Stock | 3.3594 | 3.3969 | 3.325 | 3.3875 | 12960000.0 |
| 2000-03-09 15:00:00 | AMZN | Stock | 3.3875 | 3.45 | 3.3812 | 3.4438 | 36812000.0 |
| 2000-03-09 16:00:00 | AMZN | Stock | 3.4344 | 3.4438 | 3.4312 | 3.4406 | 248000.0 |
| 2000-03-09 09:00:00 | CL | Stock | 21.875 | 21.9375 | 21.6562 | 21.6875 | 498400.0 |
| 2000-03-09 10:00:00 | CL | Stock | 21.6562 | 22.1562 | 21.5 | 22.0938 | 1210600.0 |
| 2000-03-09 11:00:00 | CL | Stock | 22.125 | 22.125 | 21.8438 | 21.8438 | 484200.0 |
| 2000-03-09 12:00:00 | CL | Stock | 21.8438 | 22.1875 | 21.8438 | 22.0312 | 871600.0 |
| 2000-03-09 13:00:00 | CL | Stock | 22.0312 | 22.0938 | 21.9375 | 22.0 | 434200.0 |
| 2000-03-09 14:00:00 | CL | Stock | 22.0 | 22.125 | 21.9375 | 21.9688 | 777800.0 |
| 2000-03-09 15:00:00 | CL | Stock | 21.9375 | 22.0 | 21.875 | 22.0 | 842600.0 |
| 2000-03-09 16:00:00 | CL | Stock | 21.9688 | 22.0 | 21.9688 | 22.0 | 116400.0 |
> showing 40 of 14,616 rows — these rows as CSV