PREVIEW / stock_1hour / 2001-04-04
file: by_date/stock_1hour/2001/2001-04-04.parquet size: 356 KB rows: 16,649 symbols: 1,285
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-04-04 08:00:00 | AAPL | Stock | 0.3607 | 0.3623 | 0.3571 | 0.3598 | 1400000.0 |
| 2001-04-04 09:00:00 | AAPL | Stock | 0.3593 | 0.3616 | 0.3461 | 0.3463 | 68880000.0 |
| 2001-04-04 10:00:00 | AAPL | Stock | 0.3461 | 0.3488 | 0.3355 | 0.3452 | 151244800.0 |
| 2001-04-04 11:00:00 | AAPL | Stock | 0.3448 | 0.3616 | 0.3446 | 0.3536 | 114032800.0 |
| 2001-04-04 12:00:00 | AAPL | Stock | 0.3534 | 0.355 | 0.3402 | 0.3432 | 65884000.0 |
| 2001-04-04 13:00:00 | AAPL | Stock | 0.3434 | 0.3509 | 0.343 | 0.3459 | 45360000.0 |
| 2001-04-04 14:00:00 | AAPL | Stock | 0.3459 | 0.3516 | 0.3438 | 0.3457 | 59522400.0 |
| 2001-04-04 15:00:00 | AAPL | Stock | 0.3455 | 0.3511 | 0.3377 | 0.3482 | 125921600.0 |
| 2001-04-04 16:00:00 | AAPL | Stock | 0.3518 | 0.3518 | 0.3461 | 0.3495 | 29691200.0 |
| 2001-04-04 17:00:00 | AAPL | Stock | 0.3518 | 0.3571 | 0.3482 | 0.3571 | 2861600.0 |
| 2001-04-04 18:00:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 145600.0 |
| 2001-04-04 08:00:00 | MSFT | Stock | 26.75 | 26.9062 | 26.5312 | 26.6875 | 274200.0 |
| 2001-04-04 09:00:00 | MSFT | Stock | 26.6875 | 27.0 | 26.4062 | 26.625 | 12165000.0 |
| 2001-04-04 10:00:00 | MSFT | Stock | 26.6406 | 27.0938 | 26.2188 | 26.8438 | 20428600.0 |
| 2001-04-04 11:00:00 | MSFT | Stock | 26.875 | 27.5 | 26.8125 | 27.25 | 10424600.0 |
| 2001-04-04 12:00:00 | MSFT | Stock | 27.2656 | 27.5 | 27.125 | 27.1562 | 5406000.0 |
| 2001-04-04 13:00:00 | MSFT | Stock | 27.125 | 27.1875 | 26.2188 | 26.2344 | 10435200.0 |
| 2001-04-04 14:00:00 | MSFT | Stock | 26.2344 | 26.5938 | 25.7812 | 25.9375 | 16428600.0 |
| 2001-04-04 15:00:00 | MSFT | Stock | 25.9375 | 26.0 | 25.5312 | 25.9375 | 22640800.0 |
| 2001-04-04 16:00:00 | MSFT | Stock | 25.9688 | 26.5938 | 25.5 | 25.9062 | 3867400.0 |
| 2001-04-04 17:00:00 | MSFT | Stock | 25.9688 | 26.7656 | 25.7812 | 26.375 | 402400.0 |
| 2001-04-04 18:00:00 | MSFT | Stock | 26.4375 | 26.5 | 26.2812 | 26.4688 | 41200.0 |
| 2001-04-04 08:00:00 | NVDA | Stock | 0.2635 | 0.2646 | 0.2563 | 0.2583 | 23568000.0 |
| 2001-04-04 09:00:00 | NVDA | Stock | 0.2589 | 0.2589 | 0.2448 | 0.2456 | 492888000.0 |
| 2001-04-04 10:00:00 | NVDA | Stock | 0.2453 | 0.2458 | 0.225 | 0.2357 | 981624000.0 |
| 2001-04-04 11:00:00 | NVDA | Stock | 0.2357 | 0.2435 | 0.2341 | 0.2383 | 328392000.0 |
| 2001-04-04 12:00:00 | NVDA | Stock | 0.2383 | 0.2391 | 0.2333 | 0.2333 | 154632000.0 |
| 2001-04-04 13:00:00 | NVDA | Stock | 0.2333 | 0.237 | 0.2315 | 0.232 | 178128000.0 |
| 2001-04-04 14:00:00 | NVDA | Stock | 0.2315 | 0.2346 | 0.2279 | 0.2279 | 211536000.0 |
| 2001-04-04 15:00:00 | NVDA | Stock | 0.2281 | 0.2474 | 0.2242 | 0.2404 | 846384000.0 |
| 2001-04-04 16:00:00 | NVDA | Stock | 0.2404 | 0.2438 | 0.2313 | 0.2422 | 43584000.0 |
| 2001-04-04 17:00:00 | NVDA | Stock | 0.2422 | 0.251 | 0.2292 | 0.2479 | 19416000.0 |
| 2001-04-04 18:00:00 | NVDA | Stock | 0.247 | 0.25 | 0.2469 | 0.25 | 576000.0 |
| 2001-04-04 08:00:00 | AMZN | Stock | 0.4315 | 0.4315 | 0.425 | 0.425 | 320000.0 |
| 2001-04-04 09:00:00 | AMZN | Stock | 0.425 | 0.445 | 0.424 | 0.431 | 14624000.0 |
| 2001-04-04 10:00:00 | AMZN | Stock | 0.431 | 0.434 | 0.4125 | 0.4285 | 20530000.0 |
| 2001-04-04 11:00:00 | AMZN | Stock | 0.428 | 0.438 | 0.426 | 0.437 | 13640000.0 |
| 2001-04-04 12:00:00 | AMZN | Stock | 0.4375 | 0.45 | 0.436 | 0.437 | 11532000.0 |
| 2001-04-04 13:00:00 | AMZN | Stock | 0.437 | 0.4375 | 0.4275 | 0.4275 | 10092000.0 |
| 2001-04-04 14:00:00 | AMZN | Stock | 0.4285 | 0.4325 | 0.425 | 0.4255 | 10816000.0 |
| 2001-04-04 15:00:00 | AMZN | Stock | 0.425 | 0.4275 | 0.412 | 0.42 | 19276000.0 |
| 2001-04-04 16:00:00 | AMZN | Stock | 0.418 | 0.4375 | 0.4135 | 0.42 | 5076000.0 |
| 2001-04-04 17:00:00 | AMZN | Stock | 0.4125 | 0.4375 | 0.4125 | 0.4125 | 42000.0 |
| 2001-04-04 18:00:00 | AMZN | Stock | 0.425 | 0.425 | 0.425 | 0.425 | 2000.0 |
| 2001-04-04 09:00:00 | CL | Stock | 26.575 | 26.85 | 26.45 | 26.45 | 319600.0 |
| 2001-04-04 10:00:00 | CL | Stock | 26.455 | 26.455 | 26.145 | 26.35 | 435000.0 |
| 2001-04-04 11:00:00 | CL | Stock | 26.375 | 27.4 | 26.375 | 27.05 | 814400.0 |
| 2001-04-04 12:00:00 | CL | Stock | 27.05 | 27.165 | 26.94 | 27.055 | 360600.0 |
| 2001-04-04 13:00:00 | CL | Stock | 27.055 | 27.12 | 26.825 | 26.85 | 204600.0 |
| 2001-04-04 14:00:00 | CL | Stock | 26.815 | 26.885 | 26.725 | 26.835 | 341800.0 |
> showing 50 of 16,649 rows — these rows as CSV