PREVIEW / stock_1hour / 2000-11-22
file: by_date/stock_1hour/2000/2000-11-22.parquet size: 305 KB rows: 15,838 symbols: 1,254
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-11-22 08:00:00 | AAPL | Stock | 0.3359 | 0.3371 | 0.3348 | 0.3371 | 520800.0 |
| 2000-11-22 09:00:00 | AAPL | Stock | 0.3371 | 0.3415 | 0.3348 | 0.3393 | 29988000.0 |
| 2000-11-22 10:00:00 | AAPL | Stock | 0.3371 | 0.3415 | 0.3292 | 0.3304 | 45701600.0 |
| 2000-11-22 11:00:00 | AAPL | Stock | 0.3315 | 0.3326 | 0.3287 | 0.3326 | 55434400.0 |
| 2000-11-22 12:00:00 | AAPL | Stock | 0.3326 | 0.3359 | 0.3292 | 0.3348 | 33812800.0 |
| 2000-11-22 13:00:00 | AAPL | Stock | 0.3326 | 0.3404 | 0.3326 | 0.3371 | 45354400.0 |
| 2000-11-22 14:00:00 | AAPL | Stock | 0.3371 | 0.3393 | 0.3315 | 0.3326 | 20059200.0 |
| 2000-11-22 15:00:00 | AAPL | Stock | 0.3326 | 0.3359 | 0.3281 | 0.3304 | 30122400.0 |
| 2000-11-22 16:00:00 | AAPL | Stock | 0.3315 | 0.332 | 0.3281 | 0.3304 | 5818400.0 |
| 2000-11-22 17:00:00 | AAPL | Stock | 0.3304 | 0.3304 | 0.3292 | 0.3292 | 190400.0 |
| 2000-11-22 18:00:00 | AAPL | Stock | 0.3281 | 0.3281 | 0.3281 | 0.3281 | 28000.0 |
| 2000-11-22 08:00:00 | MSFT | Stock | 33.7188 | 33.875 | 31.0 | 33.375 | 208400.0 |
| 2000-11-22 09:00:00 | MSFT | Stock | 33.4375 | 34.0 | 32.9688 | 33.7188 | 8190200.0 |
| 2000-11-22 10:00:00 | MSFT | Stock | 33.6875 | 33.7812 | 33.0938 | 33.3125 | 10124800.0 |
| 2000-11-22 11:00:00 | MSFT | Stock | 33.2812 | 33.625 | 33.2812 | 33.5 | 8079600.0 |
| 2000-11-22 12:00:00 | MSFT | Stock | 33.5 | 33.5625 | 33.2188 | 33.375 | 4845800.0 |
| 2000-11-22 13:00:00 | MSFT | Stock | 33.4375 | 34.5625 | 33.3125 | 34.5312 | 14118200.0 |
| 2000-11-22 14:00:00 | MSFT | Stock | 34.5 | 34.75 | 34.4062 | 34.625 | 9989400.0 |
| 2000-11-22 15:00:00 | MSFT | Stock | 34.6562 | 34.75 | 34.0625 | 34.125 | 13017400.0 |
| 2000-11-22 16:00:00 | MSFT | Stock | 34.0938 | 34.5 | 33.4688 | 33.6562 | 3121200.0 |
| 2000-11-22 17:00:00 | MSFT | Stock | 33.6562 | 34.125 | 33.6562 | 33.8125 | 103400.0 |
| 2000-11-22 18:00:00 | MSFT | Stock | 33.7812 | 33.875 | 33.7812 | 33.875 | 4200.0 |
| 2000-11-22 08:00:00 | NVDA | Stock | 0.2389 | 0.2389 | 0.2292 | 0.2292 | 2472000.0 |
| 2000-11-22 09:00:00 | NVDA | Stock | 0.2292 | 0.2365 | 0.224 | 0.2349 | 86520000.0 |
| 2000-11-22 10:00:00 | NVDA | Stock | 0.2335 | 0.234 | 0.2182 | 0.2203 | 64704000.0 |
| 2000-11-22 11:00:00 | NVDA | Stock | 0.2208 | 0.2237 | 0.2182 | 0.2232 | 60864000.0 |
| 2000-11-22 12:00:00 | NVDA | Stock | 0.2229 | 0.2237 | 0.218 | 0.218 | 40344000.0 |
| 2000-11-22 13:00:00 | NVDA | Stock | 0.2188 | 0.2323 | 0.2167 | 0.2249 | 50952000.0 |
| 2000-11-22 14:00:00 | NVDA | Stock | 0.2249 | 0.2249 | 0.2208 | 0.2229 | 19104000.0 |
| 2000-11-22 15:00:00 | NVDA | Stock | 0.2237 | 0.2271 | 0.2198 | 0.2266 | 59856000.0 |
| 2000-11-22 16:00:00 | NVDA | Stock | 0.2263 | 0.2266 | 0.225 | 0.225 | 3768000.0 |
| 2000-11-22 08:00:00 | AMZN | Stock | 1.2 | 1.2 | 1.15 | 1.175 | 388000.0 |
| 2000-11-22 09:00:00 | AMZN | Stock | 1.1719 | 1.275 | 1.1375 | 1.1375 | 20340000.0 |
| 2000-11-22 10:00:00 | AMZN | Stock | 1.1375 | 1.1625 | 1.1062 | 1.1375 | 27544000.0 |
| 2000-11-22 11:00:00 | AMZN | Stock | 1.1312 | 1.15 | 1.1062 | 1.1484 | 17936000.0 |
| 2000-11-22 12:00:00 | AMZN | Stock | 1.1469 | 1.1688 | 1.1375 | 1.1656 | 16248000.0 |
| 2000-11-22 13:00:00 | AMZN | Stock | 1.1688 | 1.375 | 1.1562 | 1.2938 | 74292000.0 |
| 2000-11-22 14:00:00 | AMZN | Stock | 1.2969 | 1.3 | 1.2406 | 1.25 | 31074000.0 |
| 2000-11-22 15:00:00 | AMZN | Stock | 1.2469 | 1.2938 | 1.2375 | 1.2625 | 33008000.0 |
| 2000-11-22 16:00:00 | AMZN | Stock | 1.2594 | 1.2688 | 1.2391 | 1.2391 | 4062000.0 |
| 2000-11-22 17:00:00 | AMZN | Stock | 1.25 | 1.25 | 1.25 | 1.25 | 14000.0 |
| 2000-11-22 09:00:00 | CL | Stock | 29.755 | 29.985 | 29.75 | 29.975 | 259200.0 |
| 2000-11-22 10:00:00 | CL | Stock | 29.97 | 29.975 | 29.5 | 29.725 | 352800.0 |
| 2000-11-22 11:00:00 | CL | Stock | 29.765 | 29.765 | 29.53 | 29.53 | 438600.0 |
| 2000-11-22 12:00:00 | CL | Stock | 29.56 | 29.56 | 29.33 | 29.475 | 299000.0 |
| 2000-11-22 13:00:00 | CL | Stock | 29.5 | 29.74 | 29.47 | 29.735 | 436400.0 |
| 2000-11-22 14:00:00 | CL | Stock | 29.73 | 29.73 | 29.475 | 29.56 | 380400.0 |
| 2000-11-22 15:00:00 | CL | Stock | 29.555 | 29.65 | 29.45 | 29.59 | 470400.0 |
| 2000-11-22 16:00:00 | CL | Stock | 29.59 | 29.6 | 29.59 | 29.6 | 97600.0 |
> showing 49 of 15,838 rows — these rows as CSV