PREVIEW / stock_1hour / 2001-02-20
file: by_date/stock_1hour/2001/2001-02-20.parquet size: 351 KB rows: 16,626 symbols: 1,271
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 |
|---|---|---|---|---|---|---|---|
| 2001-02-20 09:00:00 | AAPL | Stock | 0.3438 | 0.3482 | 0.3382 | 0.3415 | 32961600.0 |
| 2001-02-20 10:00:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3315 | 0.3315 | 38998400.0 |
| 2001-02-20 11:00:00 | AAPL | Stock | 0.3315 | 0.3326 | 0.3259 | 0.3304 | 57086400.0 |
| 2001-02-20 12:00:00 | AAPL | Stock | 0.3292 | 0.3337 | 0.3281 | 0.3304 | 43215200.0 |
| 2001-02-20 13:00:00 | AAPL | Stock | 0.3304 | 0.3337 | 0.3292 | 0.3337 | 28431200.0 |
| 2001-02-20 14:00:00 | AAPL | Stock | 0.3337 | 0.3359 | 0.3281 | 0.3315 | 18659200.0 |
| 2001-02-20 15:00:00 | AAPL | Stock | 0.3304 | 0.3326 | 0.3248 | 0.327 | 60362400.0 |
| 2001-02-20 16:00:00 | AAPL | Stock | 0.3248 | 0.3449 | 0.3248 | 0.327 | 13507200.0 |
| 2001-02-20 17:00:00 | AAPL | Stock | 0.327 | 0.3304 | 0.3259 | 0.3259 | 1013600.0 |
| 2001-02-20 08:00:00 | MSFT | Stock | 28.8438 | 29.0 | 28.6406 | 28.9375 | 37000.0 |
| 2001-02-20 09:00:00 | MSFT | Stock | 28.8438 | 29.125 | 28.5312 | 29.125 | 7965800.0 |
| 2001-02-20 10:00:00 | MSFT | Stock | 29.0938 | 29.125 | 28.5312 | 28.5312 | 8788000.0 |
| 2001-02-20 11:00:00 | MSFT | Stock | 28.5312 | 28.5781 | 28.125 | 28.375 | 10706400.0 |
| 2001-02-20 12:00:00 | MSFT | Stock | 28.375 | 28.4375 | 28.0938 | 28.125 | 5406800.0 |
| 2001-02-20 13:00:00 | MSFT | Stock | 28.125 | 28.1875 | 27.6875 | 28.125 | 6484200.0 |
| 2001-02-20 14:00:00 | MSFT | Stock | 28.125 | 28.3125 | 27.75 | 27.9375 | 6097200.0 |
| 2001-02-20 15:00:00 | MSFT | Stock | 27.9375 | 28.2188 | 27.8125 | 27.9375 | 8575400.0 |
| 2001-02-20 16:00:00 | MSFT | Stock | 27.9062 | 28.6875 | 27.875 | 28.0 | 3720200.0 |
| 2001-02-20 17:00:00 | MSFT | Stock | 27.9688 | 28.0 | 27.875 | 28.0 | 21800.0 |
| 2001-02-20 18:00:00 | MSFT | Stock | 28.0 | 28.0 | 27.875 | 27.9375 | 3000.0 |
| 2001-02-20 08:00:00 | NVDA | Stock | 0.2542 | 0.2542 | 0.2516 | 0.2526 | 432000.0 |
| 2001-02-20 09:00:00 | NVDA | Stock | 0.25 | 0.251 | 0.2375 | 0.2385 | 159744000.0 |
| 2001-02-20 10:00:00 | NVDA | Stock | 0.238 | 0.2401 | 0.2333 | 0.2336 | 167664000.0 |
| 2001-02-20 11:00:00 | NVDA | Stock | 0.2333 | 0.2411 | 0.2302 | 0.2398 | 108216000.0 |
| 2001-02-20 12:00:00 | NVDA | Stock | 0.2398 | 0.2417 | 0.2359 | 0.2414 | 49320000.0 |
| 2001-02-20 13:00:00 | NVDA | Stock | 0.2406 | 0.2424 | 0.2367 | 0.2375 | 53568000.0 |
| 2001-02-20 14:00:00 | NVDA | Stock | 0.2396 | 0.2417 | 0.232 | 0.2346 | 48408000.0 |
| 2001-02-20 15:00:00 | NVDA | Stock | 0.2346 | 0.2346 | 0.2229 | 0.2229 | 84984000.0 |
| 2001-02-20 16:00:00 | NVDA | Stock | 0.2232 | 0.2255 | 0.2229 | 0.225 | 2856000.0 |
| 2001-02-20 17:00:00 | NVDA | Stock | 0.225 | 0.225 | 0.225 | 0.225 | 24000.0 |
| 2001-02-20 18:00:00 | NVDA | Stock | 0.225 | 0.2266 | 0.225 | 0.2266 | 48000.0 |
| 2001-02-20 08:00:00 | AMZN | Stock | 0.7 | 0.7062 | 0.6781 | 0.7062 | 72000.0 |
| 2001-02-20 09:00:00 | AMZN | Stock | 0.7 | 0.7062 | 0.6594 | 0.6656 | 13242000.0 |
| 2001-02-20 10:00:00 | AMZN | Stock | 0.6625 | 0.6688 | 0.65 | 0.6562 | 19030000.0 |
| 2001-02-20 11:00:00 | AMZN | Stock | 0.6562 | 0.6688 | 0.6469 | 0.6688 | 20916000.0 |
| 2001-02-20 12:00:00 | AMZN | Stock | 0.6688 | 0.6688 | 0.6469 | 0.6469 | 10226000.0 |
| 2001-02-20 13:00:00 | AMZN | Stock | 0.6484 | 0.6531 | 0.6422 | 0.65 | 10876000.0 |
| 2001-02-20 14:00:00 | AMZN | Stock | 0.65 | 0.6531 | 0.6438 | 0.6438 | 16402000.0 |
| 2001-02-20 15:00:00 | AMZN | Stock | 0.6469 | 0.6469 | 0.6219 | 0.625 | 25442000.0 |
| 2001-02-20 16:00:00 | AMZN | Stock | 0.625 | 0.6562 | 0.6219 | 0.6516 | 8466000.0 |
| 2001-02-20 17:00:00 | AMZN | Stock | 0.6375 | 0.6375 | 0.6281 | 0.6313 | 162000.0 |
| 2001-02-20 18:00:00 | AMZN | Stock | 0.6375 | 0.6375 | 0.6313 | 0.6313 | 20000.0 |
| 2001-02-20 09:00:00 | CL | Stock | 29.75 | 29.995 | 29.675 | 29.94 | 395600.0 |
| 2001-02-20 10:00:00 | CL | Stock | 29.94 | 30.075 | 29.8 | 29.8 | 570000.0 |
| 2001-02-20 11:00:00 | CL | Stock | 29.855 | 29.945 | 29.75 | 29.79 | 276800.0 |
| 2001-02-20 12:00:00 | CL | Stock | 29.775 | 29.79 | 29.625 | 29.7 | 254400.0 |
| 2001-02-20 13:00:00 | CL | Stock | 29.705 | 29.85 | 29.625 | 29.845 | 190200.0 |
| 2001-02-20 14:00:00 | CL | Stock | 29.84 | 29.99 | 29.84 | 29.925 | 219200.0 |
| 2001-02-20 15:00:00 | CL | Stock | 29.9 | 30.125 | 29.86 | 30.025 | 577400.0 |
| 2001-02-20 16:00:00 | CL | Stock | 30.025 | 30.025 | 29.895 | 29.895 | 254600.0 |
> showing 50 of 16,626 rows — these rows as CSV