PREVIEW / stock_1hour / 2000-06-08
file: by_date/stock_1hour/2000/2000-06-08.parquet size: 284 KB rows: 15,055 symbols: 1,176
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-06-08 08:00:00 | AAPL | Stock | 0.8619 | 0.8761 | 0.8619 | 0.875 | 4457600.0 |
| 2000-06-08 09:00:00 | AAPL | Stock | 0.875 | 0.8795 | 0.8638 | 0.8683 | 38953600.0 |
| 2000-06-08 10:00:00 | AAPL | Stock | 0.8683 | 0.8733 | 0.8622 | 0.8717 | 29377600.0 |
| 2000-06-08 11:00:00 | AAPL | Stock | 0.8717 | 0.875 | 0.8599 | 0.8638 | 21761600.0 |
| 2000-06-08 12:00:00 | AAPL | Stock | 0.8633 | 0.865 | 0.8482 | 0.8488 | 24852800.0 |
| 2000-06-08 13:00:00 | AAPL | Stock | 0.8493 | 0.8571 | 0.8465 | 0.8549 | 20462400.0 |
| 2000-06-08 14:00:00 | AAPL | Stock | 0.8555 | 0.8555 | 0.8371 | 0.8429 | 24248000.0 |
| 2000-06-08 15:00:00 | AAPL | Stock | 0.8443 | 0.8527 | 0.8315 | 0.8465 | 64164800.0 |
| 2000-06-08 16:00:00 | AAPL | Stock | 0.8465 | 0.853 | 0.8449 | 0.8477 | 6764800.0 |
| 2000-06-08 17:00:00 | AAPL | Stock | 0.8457 | 0.8488 | 0.8457 | 0.8463 | 1836800.0 |
| 2000-06-08 08:00:00 | MSFT | Stock | 35.8125 | 37.0 | 35.375 | 35.875 | 1956800.0 |
| 2000-06-08 09:00:00 | MSFT | Stock | 35.875 | 36.0625 | 35.5 | 35.75 | 22741800.0 |
| 2000-06-08 10:00:00 | MSFT | Stock | 35.7188 | 35.7812 | 35.0156 | 35.25 | 20721800.0 |
| 2000-06-08 11:00:00 | MSFT | Stock | 35.2188 | 35.4375 | 34.9375 | 35.0312 | 9221800.0 |
| 2000-06-08 12:00:00 | MSFT | Stock | 34.9688 | 35.0938 | 34.7188 | 34.8125 | 7435400.0 |
| 2000-06-08 13:00:00 | MSFT | Stock | 34.8125 | 35.0 | 34.75 | 34.9688 | 4195600.0 |
| 2000-06-08 14:00:00 | MSFT | Stock | 34.9375 | 35.0938 | 34.2812 | 34.375 | 11032200.0 |
| 2000-06-08 15:00:00 | MSFT | Stock | 34.375 | 34.6562 | 34.125 | 34.4062 | 12978000.0 |
| 2000-06-08 16:00:00 | MSFT | Stock | 34.4062 | 35.875 | 34.3438 | 34.5625 | 2157400.0 |
| 2000-06-08 17:00:00 | MSFT | Stock | 34.5312 | 34.625 | 34.4062 | 34.5312 | 230400.0 |
| 2000-06-08 18:00:00 | MSFT | Stock | 34.4062 | 34.625 | 34.4062 | 34.625 | 380400.0 |
| 2000-06-08 09:00:00 | NVDA | Stock | 0.2609 | 0.2609 | 0.2552 | 0.2555 | 46464000.0 |
| 2000-06-08 10:00:00 | NVDA | Stock | 0.2555 | 0.2562 | 0.2521 | 0.254 | 49536000.0 |
| 2000-06-08 11:00:00 | NVDA | Stock | 0.2522 | 0.2552 | 0.2517 | 0.2526 | 64560000.0 |
| 2000-06-08 12:00:00 | NVDA | Stock | 0.2526 | 0.2565 | 0.2521 | 0.2521 | 20304000.0 |
| 2000-06-08 13:00:00 | NVDA | Stock | 0.2529 | 0.2552 | 0.2527 | 0.2547 | 59280000.0 |
| 2000-06-08 14:00:00 | NVDA | Stock | 0.2547 | 0.2577 | 0.2488 | 0.25 | 138048000.0 |
| 2000-06-08 15:00:00 | NVDA | Stock | 0.2496 | 0.2561 | 0.2458 | 0.2561 | 71568000.0 |
| 2000-06-08 16:00:00 | NVDA | Stock | 0.2561 | 0.2565 | 0.2552 | 0.2562 | 6480000.0 |
| 2000-06-08 08:00:00 | AMZN | Stock | 2.5891 | 2.6125 | 2.5891 | 2.6094 | 156000.0 |
| 2000-06-08 09:00:00 | AMZN | Stock | 2.625 | 2.6469 | 2.5813 | 2.5875 | 6402000.0 |
| 2000-06-08 10:00:00 | AMZN | Stock | 2.5938 | 2.6719 | 2.5875 | 2.6688 | 11162000.0 |
| 2000-06-08 11:00:00 | AMZN | Stock | 2.6688 | 2.6719 | 2.6125 | 2.6312 | 9188000.0 |
| 2000-06-08 12:00:00 | AMZN | Stock | 2.6312 | 2.6375 | 2.5813 | 2.6094 | 4730000.0 |
| 2000-06-08 13:00:00 | AMZN | Stock | 2.6062 | 2.6438 | 2.6 | 2.6375 | 4100000.0 |
| 2000-06-08 14:00:00 | AMZN | Stock | 2.6375 | 2.65 | 2.5938 | 2.6125 | 6512000.0 |
| 2000-06-08 15:00:00 | AMZN | Stock | 2.6156 | 2.6594 | 2.5813 | 2.5906 | 15534000.0 |
| 2000-06-08 16:00:00 | AMZN | Stock | 2.5875 | 2.6156 | 2.5875 | 2.5938 | 2086000.0 |
| 2000-06-08 17:00:00 | AMZN | Stock | 2.6 | 2.6 | 2.6 | 2.6 | 10000.0 |
| 2000-06-08 09:00:00 | CL | Stock | 27.875 | 27.9062 | 27.25 | 27.9062 | 944000.0 |
| 2000-06-08 10:00:00 | CL | Stock | 27.9688 | 28.25 | 27.8125 | 28.0938 | 770200.0 |
| 2000-06-08 11:00:00 | CL | Stock | 28.0938 | 28.25 | 28.0 | 28.25 | 420200.0 |
| 2000-06-08 12:00:00 | CL | Stock | 28.25 | 28.2812 | 28.0938 | 28.1562 | 257800.0 |
| 2000-06-08 13:00:00 | CL | Stock | 28.125 | 28.2812 | 28.125 | 28.2812 | 246200.0 |
| 2000-06-08 14:00:00 | CL | Stock | 28.25 | 28.4062 | 28.1562 | 28.2812 | 493200.0 |
| 2000-06-08 15:00:00 | CL | Stock | 28.3125 | 28.3438 | 28.2188 | 28.25 | 458800.0 |
| 2000-06-08 16:00:00 | CL | Stock | 28.2812 | 28.2812 | 28.0938 | 28.25 | 110400.0 |
| 2000-06-08 17:00:00 | CL | Stock | 28.25 | 28.25 | 28.25 | 28.25 | 98000.0 |
> showing 48 of 15,055 rows — these rows as CSV