PREVIEW / stock_1hour / 2000-11-13
file: by_date/stock_1hour/2000/2000-11-13.parquet size: 311 KB rows: 15,894 symbols: 1,245
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-13 08:00:00 | AAPL | Stock | 0.3415 | 0.3415 | 0.3237 | 0.3304 | 2665600.0 |
| 2000-11-13 09:00:00 | AAPL | Stock | 0.3304 | 0.3404 | 0.3248 | 0.3315 | 51016000.0 |
| 2000-11-13 10:00:00 | AAPL | Stock | 0.3326 | 0.3393 | 0.3292 | 0.3304 | 59729600.0 |
| 2000-11-13 11:00:00 | AAPL | Stock | 0.3292 | 0.3326 | 0.327 | 0.327 | 52494400.0 |
| 2000-11-13 12:00:00 | AAPL | Stock | 0.327 | 0.3337 | 0.3259 | 0.3304 | 44940000.0 |
| 2000-11-13 13:00:00 | AAPL | Stock | 0.3315 | 0.3527 | 0.3292 | 0.3504 | 72508800.0 |
| 2000-11-13 14:00:00 | AAPL | Stock | 0.3504 | 0.3571 | 0.3482 | 0.3493 | 54465600.0 |
| 2000-11-13 15:00:00 | AAPL | Stock | 0.3493 | 0.356 | 0.3438 | 0.3449 | 53043200.0 |
| 2000-11-13 16:00:00 | AAPL | Stock | 0.346 | 0.3571 | 0.3415 | 0.346 | 5717600.0 |
| 2000-11-13 17:00:00 | AAPL | Stock | 0.346 | 0.346 | 0.3426 | 0.3432 | 800800.0 |
| 2000-11-13 18:00:00 | AAPL | Stock | 0.3415 | 0.3426 | 0.3415 | 0.3426 | 11200.0 |
| 2000-11-13 08:00:00 | MSFT | Stock | 33.0 | 33.375 | 32.9062 | 33.3125 | 275200.0 |
| 2000-11-13 09:00:00 | MSFT | Stock | 33.3438 | 33.75 | 32.8125 | 32.8438 | 10629600.0 |
| 2000-11-13 10:00:00 | MSFT | Stock | 32.8438 | 33.375 | 32.625 | 32.875 | 11158200.0 |
| 2000-11-13 11:00:00 | MSFT | Stock | 32.875 | 32.9688 | 32.5 | 32.5469 | 7875800.0 |
| 2000-11-13 12:00:00 | MSFT | Stock | 32.5625 | 32.7188 | 32.2031 | 32.3125 | 7740800.0 |
| 2000-11-13 13:00:00 | MSFT | Stock | 32.3438 | 33.0312 | 32.25 | 33.0156 | 11982800.0 |
| 2000-11-13 14:00:00 | MSFT | Stock | 33.0312 | 33.5781 | 33.0 | 33.375 | 10842600.0 |
| 2000-11-13 15:00:00 | MSFT | Stock | 33.4062 | 34.0625 | 33.1562 | 33.2344 | 12191600.0 |
| 2000-11-13 16:00:00 | MSFT | Stock | 33.2188 | 33.5 | 33.0469 | 33.25 | 1940200.0 |
| 2000-11-13 17:00:00 | MSFT | Stock | 33.0156 | 33.4375 | 33.0156 | 33.25 | 27400.0 |
| 2000-11-13 18:00:00 | MSFT | Stock | 33.25 | 33.3125 | 33.1562 | 33.2188 | 16000.0 |
| 2000-11-13 08:00:00 | NVDA | Stock | 0.2417 | 0.2417 | 0.2375 | 0.2375 | 168000.0 |
| 2000-11-13 09:00:00 | NVDA | Stock | 0.2354 | 0.2375 | 0.225 | 0.2318 | 59832000.0 |
| 2000-11-13 10:00:00 | NVDA | Stock | 0.2302 | 0.25 | 0.2297 | 0.2427 | 102744000.0 |
| 2000-11-13 11:00:00 | NVDA | Stock | 0.2427 | 0.2443 | 0.2385 | 0.2385 | 34848000.0 |
| 2000-11-13 12:00:00 | NVDA | Stock | 0.2385 | 0.2464 | 0.2375 | 0.2417 | 35064000.0 |
| 2000-11-13 13:00:00 | NVDA | Stock | 0.2438 | 0.2563 | 0.2427 | 0.2542 | 41640000.0 |
| 2000-11-13 14:00:00 | NVDA | Stock | 0.2542 | 0.2667 | 0.2531 | 0.2615 | 63864000.0 |
| 2000-11-13 15:00:00 | NVDA | Stock | 0.2622 | 0.2729 | 0.2451 | 0.2466 | 101328000.0 |
| 2000-11-13 16:00:00 | NVDA | Stock | 0.2466 | 0.2521 | 0.2461 | 0.2513 | 4152000.0 |
| 2000-11-13 17:00:00 | NVDA | Stock | 0.249 | 0.249 | 0.2479 | 0.2479 | 264000.0 |
| 2000-11-13 08:00:00 | AMZN | Stock | 1.5 | 1.5 | 1.45 | 1.45 | 234000.0 |
| 2000-11-13 09:00:00 | AMZN | Stock | 1.4531 | 1.4719 | 1.4156 | 1.4406 | 12130000.0 |
| 2000-11-13 10:00:00 | AMZN | Stock | 1.4406 | 1.4531 | 1.4281 | 1.4375 | 18502000.0 |
| 2000-11-13 11:00:00 | AMZN | Stock | 1.4375 | 1.4531 | 1.425 | 1.4313 | 18688000.0 |
| 2000-11-13 12:00:00 | AMZN | Stock | 1.4344 | 1.4406 | 1.4 | 1.4094 | 22918000.0 |
| 2000-11-13 13:00:00 | AMZN | Stock | 1.4062 | 1.4375 | 1.3719 | 1.425 | 24500000.0 |
| 2000-11-13 14:00:00 | AMZN | Stock | 1.4313 | 1.4844 | 1.4188 | 1.4375 | 22126000.0 |
| 2000-11-13 15:00:00 | AMZN | Stock | 1.4391 | 1.5047 | 1.3719 | 1.3875 | 35258000.0 |
| 2000-11-13 16:00:00 | AMZN | Stock | 1.3922 | 1.4125 | 1.3781 | 1.3906 | 2020000.0 |
| 2000-11-13 17:00:00 | AMZN | Stock | 1.3906 | 1.4 | 1.3906 | 1.4 | 148000.0 |
| 2000-11-13 09:00:00 | CL | Stock | 29.95 | 30.0 | 29.875 | 29.95 | 393800.0 |
| 2000-11-13 10:00:00 | CL | Stock | 29.95 | 30.05 | 29.66 | 29.705 | 545800.0 |
| 2000-11-13 11:00:00 | CL | Stock | 29.69 | 29.775 | 29.4 | 29.575 | 980800.0 |
| 2000-11-13 12:00:00 | CL | Stock | 29.575 | 29.75 | 29.4 | 29.575 | 679200.0 |
| 2000-11-13 13:00:00 | CL | Stock | 29.575 | 29.68 | 29.3 | 29.35 | 490600.0 |
| 2000-11-13 14:00:00 | CL | Stock | 29.35 | 29.465 | 29.225 | 29.245 | 446600.0 |
| 2000-11-13 15:00:00 | CL | Stock | 29.245 | 29.58 | 29.245 | 29.575 | 778600.0 |
| 2000-11-13 16:00:00 | CL | Stock | 29.58 | 29.58 | 29.58 | 29.58 | 69400.0 |
> showing 50 of 15,894 rows — these rows as CSV