PREVIEW / stock_1hour / 2004-04-02
file: by_date/stock_1hour/2004/2004-04-02.parquet size: 523 KB rows: 24,885 symbols: 1,761
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-04-02 08:00:00 | AAPL | Stock | 0.4841 | 0.4946 | 0.4841 | 0.493 | 940800.0 |
| 2004-04-02 09:00:00 | AAPL | Stock | 0.4938 | 0.4988 | 0.4879 | 0.4923 | 70766472.0 |
| 2004-04-02 10:00:00 | AAPL | Stock | 0.492 | 0.4945 | 0.4863 | 0.4898 | 52437952.0 |
| 2004-04-02 11:00:00 | AAPL | Stock | 0.4898 | 0.4911 | 0.4879 | 0.4909 | 20272224.0 |
| 2004-04-02 12:00:00 | AAPL | Stock | 0.4909 | 0.4936 | 0.49 | 0.4914 | 16158912.0 |
| 2004-04-02 13:00:00 | AAPL | Stock | 0.4913 | 0.4943 | 0.4888 | 0.4909 | 19276376.0 |
| 2004-04-02 14:00:00 | AAPL | Stock | 0.4911 | 0.4921 | 0.487 | 0.4909 | 32658136.0 |
| 2004-04-02 15:00:00 | AAPL | Stock | 0.4911 | 0.4936 | 0.4902 | 0.4913 | 43218280.0 |
| 2004-04-02 16:00:00 | AAPL | Stock | 0.4913 | 0.4932 | 0.4911 | 0.4929 | 6013112.0 |
| 2004-04-02 17:00:00 | AAPL | Stock | 0.4929 | 0.4929 | 0.4929 | 0.4929 | 29120.0 |
| 2004-04-02 18:00:00 | AAPL | Stock | 0.4929 | 0.4929 | 0.4929 | 0.4929 | 7000.0 |
| 2004-04-02 08:00:00 | MSFT | Stock | 25.075 | 25.51 | 25.075 | 25.44 | 1176173.0 |
| 2004-04-02 09:00:00 | MSFT | Stock | 25.45 | 25.72 | 25.07 | 25.64 | 15396896.0 |
| 2004-04-02 10:00:00 | MSFT | Stock | 25.64 | 25.72 | 25.58 | 25.65 | 17950326.0 |
| 2004-04-02 11:00:00 | MSFT | Stock | 25.65 | 25.8 | 25.55 | 25.78 | 11130009.0 |
| 2004-04-02 12:00:00 | MSFT | Stock | 25.78 | 25.9 | 25.72 | 25.86 | 8981389.0 |
| 2004-04-02 13:00:00 | MSFT | Stock | 25.86 | 25.87 | 25.73 | 25.76 | 8640892.0 |
| 2004-04-02 14:00:00 | MSFT | Stock | 25.76 | 25.78 | 25.64 | 25.74 | 8785788.0 |
| 2004-04-02 15:00:00 | MSFT | Stock | 25.74 | 25.81 | 25.69 | 25.81 | 11624828.0 |
| 2004-04-02 16:00:00 | MSFT | Stock | 25.81 | 25.9 | 25.7545 | 25.87 | 10305840.0 |
| 2004-04-02 17:00:00 | MSFT | Stock | 25.85 | 25.89 | 25.81 | 25.82 | 15518.0 |
| 2004-04-02 18:00:00 | MSFT | Stock | 25.83 | 25.85 | 25.82 | 25.82 | 3700.0 |
| 2004-04-02 08:00:00 | NVDA | Stock | 0.2187 | 0.2217 | 0.2167 | 0.221 | 2808240.0 |
| 2004-04-02 09:00:00 | NVDA | Stock | 0.2212 | 0.2222 | 0.2166 | 0.2198 | 137606880.0 |
| 2004-04-02 10:00:00 | NVDA | Stock | 0.2197 | 0.2199 | 0.2142 | 0.2172 | 149051280.0 |
| 2004-04-02 11:00:00 | NVDA | Stock | 0.2171 | 0.2177 | 0.2162 | 0.2168 | 55819320.0 |
| 2004-04-02 12:00:00 | NVDA | Stock | 0.2168 | 0.2187 | 0.2167 | 0.2186 | 44954400.0 |
| 2004-04-02 13:00:00 | NVDA | Stock | 0.2187 | 0.2204 | 0.2182 | 0.2203 | 57561000.0 |
| 2004-04-02 14:00:00 | NVDA | Stock | 0.2203 | 0.2204 | 0.2182 | 0.2187 | 54604680.0 |
| 2004-04-02 15:00:00 | NVDA | Stock | 0.2188 | 0.2195 | 0.2175 | 0.2194 | 109422480.0 |
| 2004-04-02 16:00:00 | NVDA | Stock | 0.2194 | 0.2194 | 0.2187 | 0.2192 | 6003240.0 |
| 2004-04-02 17:00:00 | NVDA | Stock | 0.2191 | 0.2193 | 0.2188 | 0.2188 | 158160.0 |
| 2004-04-02 08:00:00 | AMZN | Stock | 2.24 | 2.3065 | 2.2395 | 2.3 | 1535920.0 |
| 2004-04-02 09:00:00 | AMZN | Stock | 2.3 | 2.3125 | 2.2405 | 2.2935 | 29446620.0 |
| 2004-04-02 10:00:00 | AMZN | Stock | 2.2935 | 2.295 | 2.2625 | 2.281 | 24520300.0 |
| 2004-04-02 11:00:00 | AMZN | Stock | 2.2805 | 2.298 | 2.278 | 2.2965 | 18439240.0 |
| 2004-04-02 12:00:00 | AMZN | Stock | 2.2955 | 2.304 | 2.291 | 2.2995 | 14208000.0 |
| 2004-04-02 13:00:00 | AMZN | Stock | 2.2995 | 2.3125 | 2.2975 | 2.3095 | 18147040.0 |
| 2004-04-02 14:00:00 | AMZN | Stock | 2.31 | 2.312 | 2.293 | 2.2945 | 19591280.0 |
| 2004-04-02 15:00:00 | AMZN | Stock | 2.2945 | 2.3055 | 2.2905 | 2.3025 | 22840540.0 |
| 2004-04-02 16:00:00 | AMZN | Stock | 2.3035 | 2.3075 | 2.294 | 2.3 | 2745100.0 |
| 2004-04-02 17:00:00 | AMZN | Stock | 2.3035 | 2.307 | 2.2922 | 2.304 | 671920.0 |
| 2004-04-02 18:00:00 | AMZN | Stock | 2.3 | 2.3075 | 2.3 | 2.3075 | 10000.0 |
| 2004-04-02 09:00:00 | CL | Stock | 27.49 | 27.725 | 27.49 | 27.715 | 398000.0 |
| 2004-04-02 10:00:00 | CL | Stock | 27.715 | 27.925 | 27.635 | 27.92 | 508200.0 |
| 2004-04-02 11:00:00 | CL | Stock | 27.93 | 27.93 | 27.695 | 27.74 | 562600.0 |
| 2004-04-02 12:00:00 | CL | Stock | 27.735 | 27.75 | 27.64 | 27.725 | 359000.0 |
| 2004-04-02 13:00:00 | CL | Stock | 27.73 | 27.74 | 27.61 | 27.715 | 164000.0 |
| 2004-04-02 14:00:00 | CL | Stock | 27.72 | 27.735 | 27.605 | 27.66 | 282200.0 |
| 2004-04-02 15:00:00 | CL | Stock | 27.66 | 27.81 | 27.61 | 27.805 | 526400.0 |
> showing 50 of 24,885 rows — these rows as CSV