PREVIEW / stock_1hour / 2003-06-02
file: by_date/stock_1hour/2003/2003-06-02.parquet size: 457 KB rows: 21,288 symbols: 1,584
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-02 08:00:00 | AAPL | Stock | 0.3216 | 0.3216 | 0.3214 | 0.3216 | 1405600.0 |
| 2003-06-02 09:00:00 | AAPL | Stock | 0.3236 | 0.3266 | 0.3189 | 0.3191 | 36140776.0 |
| 2003-06-02 10:00:00 | AAPL | Stock | 0.3191 | 0.3239 | 0.3188 | 0.3223 | 71730960.0 |
| 2003-06-02 11:00:00 | AAPL | Stock | 0.3223 | 0.3241 | 0.3213 | 0.3236 | 22277080.0 |
| 2003-06-02 12:00:00 | AAPL | Stock | 0.3235 | 0.3245 | 0.3218 | 0.323 | 26707520.0 |
| 2003-06-02 13:00:00 | AAPL | Stock | 0.3229 | 0.3238 | 0.3223 | 0.3223 | 28558152.0 |
| 2003-06-02 14:00:00 | AAPL | Stock | 0.3223 | 0.3232 | 0.3145 | 0.3148 | 66709944.0 |
| 2003-06-02 15:00:00 | AAPL | Stock | 0.3152 | 0.3152 | 0.3084 | 0.3111 | 102311104.0 |
| 2003-06-02 16:00:00 | AAPL | Stock | 0.3118 | 0.312 | 0.308 | 0.3116 | 15726424.0 |
| 2003-06-02 17:00:00 | AAPL | Stock | 0.3098 | 0.3098 | 0.3098 | 0.3098 | 22400.0 |
| 2003-06-02 08:00:00 | MSFT | Stock | 24.78 | 24.96 | 24.78 | 24.939 | 271117.0 |
| 2003-06-02 09:00:00 | MSFT | Stock | 24.92 | 25.02 | 24.76 | 24.85 | 9611468.0 |
| 2003-06-02 10:00:00 | MSFT | Stock | 24.846 | 24.99 | 24.74 | 24.92 | 9611922.0 |
| 2003-06-02 11:00:00 | MSFT | Stock | 24.92 | 25.02 | 24.877 | 24.97 | 7147143.0 |
| 2003-06-02 12:00:00 | MSFT | Stock | 24.96 | 25.03 | 24.82 | 24.85 | 5114396.0 |
| 2003-06-02 13:00:00 | MSFT | Stock | 24.85 | 24.99 | 24.83 | 24.92 | 4378321.0 |
| 2003-06-02 14:00:00 | MSFT | Stock | 24.92 | 24.95 | 24.72 | 24.74 | 8507089.0 |
| 2003-06-02 15:00:00 | MSFT | Stock | 24.74 | 24.82 | 24.57 | 24.63 | 13157749.0 |
| 2003-06-02 16:00:00 | MSFT | Stock | 24.63 | 25.0 | 24.5 | 24.59 | 506493.0 |
| 2003-06-02 17:00:00 | MSFT | Stock | 24.62 | 24.62 | 24.5 | 24.59 | 55083.0 |
| 2003-06-02 18:00:00 | MSFT | Stock | 24.6 | 24.6 | 24.541 | 24.59 | 8404.0 |
| 2003-06-02 08:00:00 | NVDA | Stock | 0.2188 | 0.2233 | 0.2181 | 0.2225 | 6057840.0 |
| 2003-06-02 09:00:00 | NVDA | Stock | 0.2229 | 0.224 | 0.2174 | 0.2184 | 223732680.0 |
| 2003-06-02 10:00:00 | NVDA | Stock | 0.218 | 0.2217 | 0.2177 | 0.2203 | 207378240.0 |
| 2003-06-02 11:00:00 | NVDA | Stock | 0.2202 | 0.2209 | 0.2189 | 0.2193 | 101169120.0 |
| 2003-06-02 12:00:00 | NVDA | Stock | 0.2192 | 0.2196 | 0.2158 | 0.2168 | 116751360.0 |
| 2003-06-02 13:00:00 | NVDA | Stock | 0.2167 | 0.2183 | 0.2162 | 0.217 | 98488560.0 |
| 2003-06-02 14:00:00 | NVDA | Stock | 0.2169 | 0.2169 | 0.2099 | 0.2104 | 247433520.0 |
| 2003-06-02 15:00:00 | NVDA | Stock | 0.2104 | 0.2104 | 0.2047 | 0.2058 | 370680600.0 |
| 2003-06-02 16:00:00 | NVDA | Stock | 0.2058 | 0.2069 | 0.2017 | 0.2027 | 26288880.0 |
| 2003-06-02 17:00:00 | NVDA | Stock | 0.2021 | 0.2031 | 0.2008 | 0.2017 | 3980280.0 |
| 2003-06-02 18:00:00 | NVDA | Stock | 0.2021 | 0.2032 | 0.2013 | 0.2025 | 1021320.0 |
| 2003-06-02 08:00:00 | AMZN | Stock | 1.797 | 1.8125 | 1.797 | 1.8075 | 572000.0 |
| 2003-06-02 09:00:00 | AMZN | Stock | 1.81 | 1.825 | 1.796 | 1.805 | 28493180.0 |
| 2003-06-02 10:00:00 | AMZN | Stock | 1.8055 | 1.832 | 1.79 | 1.826 | 30484020.0 |
| 2003-06-02 11:00:00 | AMZN | Stock | 1.826 | 1.8275 | 1.8195 | 1.8265 | 19536080.0 |
| 2003-06-02 12:00:00 | AMZN | Stock | 1.8265 | 1.8339 | 1.811 | 1.8125 | 17710100.0 |
| 2003-06-02 13:00:00 | AMZN | Stock | 1.8125 | 1.825 | 1.8124 | 1.821 | 10029360.0 |
| 2003-06-02 14:00:00 | AMZN | Stock | 1.8215 | 1.8215 | 1.79 | 1.7905 | 26262680.0 |
| 2003-06-02 15:00:00 | AMZN | Stock | 1.7905 | 1.8 | 1.7675 | 1.769 | 40594280.0 |
| 2003-06-02 16:00:00 | AMZN | Stock | 1.769 | 1.7745 | 1.7635 | 1.7645 | 1815160.0 |
| 2003-06-02 17:00:00 | AMZN | Stock | 1.7645 | 1.7685 | 1.7625 | 1.7625 | 172900.0 |
| 2003-06-02 18:00:00 | AMZN | Stock | 1.77 | 1.77 | 1.77 | 1.77 | 4000.0 |
| 2003-06-02 09:00:00 | CL | Stock | 29.925 | 29.985 | 29.9 | 29.93 | 314800.0 |
| 2003-06-02 10:00:00 | CL | Stock | 29.935 | 30.0 | 29.895 | 29.93 | 531000.0 |
| 2003-06-02 11:00:00 | CL | Stock | 29.925 | 30.0 | 29.885 | 29.94 | 416600.0 |
| 2003-06-02 12:00:00 | CL | Stock | 29.94 | 29.995 | 29.93 | 29.95 | 318000.0 |
| 2003-06-02 13:00:00 | CL | Stock | 29.95 | 30.07 | 29.945 | 30.025 | 247200.0 |
| 2003-06-02 14:00:00 | CL | Stock | 30.02 | 30.025 | 29.85 | 29.855 | 429000.0 |
| 2003-06-02 15:00:00 | CL | Stock | 29.85 | 29.855 | 29.71 | 29.745 | 622800.0 |
> showing 50 of 21,288 rows — these rows as CSV