PREVIEW / stock_1hour / 2002-06-13
file: by_date/stock_1hour/2002/2002-06-13.parquet size: 407 KB rows: 18,940 symbols: 1,435
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 |
|---|---|---|---|---|---|---|---|
| 2002-06-13 08:00:00 | AAPL | Stock | 0.3589 | 0.3599 | 0.3571 | 0.3573 | 509600.0 |
| 2002-06-13 09:00:00 | AAPL | Stock | 0.3573 | 0.3588 | 0.3541 | 0.3563 | 58234400.0 |
| 2002-06-13 10:00:00 | AAPL | Stock | 0.3563 | 0.3564 | 0.3477 | 0.3504 | 58066400.0 |
| 2002-06-13 11:00:00 | AAPL | Stock | 0.3509 | 0.358 | 0.3507 | 0.3575 | 44811200.0 |
| 2002-06-13 12:00:00 | AAPL | Stock | 0.3575 | 0.3577 | 0.3532 | 0.3543 | 20815200.0 |
| 2002-06-13 13:00:00 | AAPL | Stock | 0.3545 | 0.3557 | 0.353 | 0.3545 | 25726400.0 |
| 2002-06-13 14:00:00 | AAPL | Stock | 0.3541 | 0.3548 | 0.3495 | 0.3539 | 29041600.0 |
| 2002-06-13 15:00:00 | AAPL | Stock | 0.3539 | 0.3554 | 0.3461 | 0.3488 | 92747200.0 |
| 2002-06-13 16:00:00 | AAPL | Stock | 0.3488 | 0.3549 | 0.3464 | 0.35 | 6703200.0 |
| 2002-06-13 17:00:00 | AAPL | Stock | 0.3489 | 0.3489 | 0.3489 | 0.3489 | 1041600.0 |
| 2002-06-13 18:00:00 | AAPL | Stock | 0.3482 | 0.3482 | 0.3482 | 0.3482 | 11200.0 |
| 2002-06-13 08:00:00 | MSFT | Stock | 27.925 | 28.0 | 27.455 | 27.53 | 337000.0 |
| 2002-06-13 09:00:00 | MSFT | Stock | 27.53 | 27.795 | 27.375 | 27.525 | 12886000.0 |
| 2002-06-13 10:00:00 | MSFT | Stock | 27.52 | 27.535 | 27.1 | 27.26 | 15860400.0 |
| 2002-06-13 11:00:00 | MSFT | Stock | 27.265 | 27.725 | 27.235 | 27.67 | 12124800.0 |
| 2002-06-13 12:00:00 | MSFT | Stock | 27.67 | 27.68 | 27.34 | 27.425 | 7364200.0 |
| 2002-06-13 13:00:00 | MSFT | Stock | 27.425 | 27.575 | 27.295 | 27.34 | 5770400.0 |
| 2002-06-13 14:00:00 | MSFT | Stock | 27.345 | 27.465 | 27.2 | 27.45 | 7194400.0 |
| 2002-06-13 15:00:00 | MSFT | Stock | 27.4495 | 27.5 | 27.11 | 27.12 | 12743400.0 |
| 2002-06-13 16:00:00 | MSFT | Stock | 27.11 | 27.435 | 27.1 | 27.16 | 2838000.0 |
| 2002-06-13 17:00:00 | MSFT | Stock | 27.19 | 27.225 | 27.1 | 27.225 | 158600.0 |
| 2002-06-13 18:00:00 | MSFT | Stock | 27.25 | 27.275 | 27.205 | 27.275 | 3000.0 |
| 2002-06-13 08:00:00 | NVDA | Stock | 0.2271 | 0.2492 | 0.2271 | 0.2317 | 3252000.0 |
| 2002-06-13 09:00:00 | NVDA | Stock | 0.2318 | 0.2362 | 0.2275 | 0.2297 | 180252000.0 |
| 2002-06-13 10:00:00 | NVDA | Stock | 0.2296 | 0.2296 | 0.2232 | 0.2267 | 252180000.0 |
| 2002-06-13 11:00:00 | NVDA | Stock | 0.2267 | 0.2353 | 0.2266 | 0.2339 | 204576000.0 |
| 2002-06-13 12:00:00 | NVDA | Stock | 0.2339 | 0.239 | 0.2314 | 0.2345 | 180432000.0 |
| 2002-06-13 13:00:00 | NVDA | Stock | 0.2347 | 0.2376 | 0.2333 | 0.2354 | 59340000.0 |
| 2002-06-13 14:00:00 | NVDA | Stock | 0.2354 | 0.2383 | 0.231 | 0.2354 | 147372000.0 |
| 2002-06-13 15:00:00 | NVDA | Stock | 0.2354 | 0.2354 | 0.2296 | 0.2307 | 170004000.0 |
| 2002-06-13 16:00:00 | NVDA | Stock | 0.2304 | 0.2321 | 0.2285 | 0.2292 | 19212000.0 |
| 2002-06-13 17:00:00 | NVDA | Stock | 0.2292 | 0.2305 | 0.2287 | 0.2304 | 1572000.0 |
| 2002-06-13 18:00:00 | NVDA | Stock | 0.2287 | 0.2304 | 0.2287 | 0.23 | 540000.0 |
| 2002-06-13 08:00:00 | AMZN | Stock | 0.855 | 0.8631 | 0.83 | 0.83 | 166000.0 |
| 2002-06-13 09:00:00 | AMZN | Stock | 0.8499 | 0.8574 | 0.837 | 0.8466 | 15186000.0 |
| 2002-06-13 10:00:00 | AMZN | Stock | 0.8465 | 0.857 | 0.8425 | 0.8525 | 15022000.0 |
| 2002-06-13 11:00:00 | AMZN | Stock | 0.8524 | 0.87 | 0.851 | 0.866 | 16808000.0 |
| 2002-06-13 12:00:00 | AMZN | Stock | 0.8665 | 0.869 | 0.861 | 0.866 | 10834000.0 |
| 2002-06-13 13:00:00 | AMZN | Stock | 0.868 | 0.873 | 0.862 | 0.866 | 8046000.0 |
| 2002-06-13 14:00:00 | AMZN | Stock | 0.8664 | 0.872 | 0.86 | 0.871 | 10396000.0 |
| 2002-06-13 15:00:00 | AMZN | Stock | 0.871 | 0.875 | 0.865 | 0.8706 | 14532000.0 |
| 2002-06-13 16:00:00 | AMZN | Stock | 0.8715 | 0.8725 | 0.8625 | 0.87 | 2566000.0 |
| 2002-06-13 17:00:00 | AMZN | Stock | 0.8695 | 0.8715 | 0.8695 | 0.8715 | 258000.0 |
| 2002-06-13 18:00:00 | AMZN | Stock | 0.87 | 0.87 | 0.8675 | 0.8675 | 66000.0 |
| 2002-06-13 09:00:00 | CL | Stock | 26.75 | 26.91 | 26.69 | 26.69 | 370000.0 |
| 2002-06-13 10:00:00 | CL | Stock | 26.69 | 26.695 | 26.575 | 26.66 | 437600.0 |
| 2002-06-13 11:00:00 | CL | Stock | 26.66 | 26.715 | 26.575 | 26.715 | 319200.0 |
| 2002-06-13 12:00:00 | CL | Stock | 26.71 | 26.715 | 26.53 | 26.555 | 404000.0 |
| 2002-06-13 13:00:00 | CL | Stock | 26.555 | 26.685 | 26.55 | 26.61 | 252800.0 |
| 2002-06-13 14:00:00 | CL | Stock | 26.61 | 26.615 | 26.5 | 26.52 | 274200.0 |
> showing 50 of 18,940 rows — these rows as CSV