PREVIEW / stock_1hour / 2000-10-25
file: by_date/stock_1hour/2000/2000-10-25.parquet size: 302 KB rows: 15,699 symbols: 1,243
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-10-25 08:00:00 | AAPL | Stock | 0.3354 | 0.3393 | 0.3304 | 0.3348 | 364000.0 |
| 2000-10-25 09:00:00 | AAPL | Stock | 0.3354 | 0.3426 | 0.3348 | 0.3404 | 85691200.0 |
| 2000-10-25 10:00:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3326 | 0.3393 | 119072800.0 |
| 2000-10-25 11:00:00 | AAPL | Stock | 0.3393 | 0.3404 | 0.3371 | 0.3382 | 79581600.0 |
| 2000-10-25 12:00:00 | AAPL | Stock | 0.3393 | 0.3393 | 0.3348 | 0.3371 | 52438400.0 |
| 2000-10-25 13:00:00 | AAPL | Stock | 0.3371 | 0.3382 | 0.3337 | 0.3359 | 49604800.0 |
| 2000-10-25 14:00:00 | AAPL | Stock | 0.3359 | 0.3382 | 0.3348 | 0.3348 | 101012800.0 |
| 2000-10-25 15:00:00 | AAPL | Stock | 0.3348 | 0.3371 | 0.3292 | 0.3304 | 90792800.0 |
| 2000-10-25 16:00:00 | AAPL | Stock | 0.3292 | 0.3359 | 0.3259 | 0.3304 | 10948000.0 |
| 2000-10-25 17:00:00 | AAPL | Stock | 0.3292 | 0.3304 | 0.3281 | 0.3304 | 3584000.0 |
| 2000-10-25 18:00:00 | AAPL | Stock | 0.3304 | 0.3304 | 0.3292 | 0.3304 | 72800.0 |
| 2000-10-25 08:00:00 | MSFT | Stock | 30.25 | 30.7656 | 30.25 | 30.5625 | 90400.0 |
| 2000-10-25 09:00:00 | MSFT | Stock | 30.625 | 31.1562 | 30.4688 | 30.7188 | 12744000.0 |
| 2000-10-25 10:00:00 | MSFT | Stock | 30.7188 | 31.1875 | 30.2188 | 31.1562 | 26043800.0 |
| 2000-10-25 11:00:00 | MSFT | Stock | 31.1562 | 31.7188 | 31.125 | 31.375 | 18829600.0 |
| 2000-10-25 12:00:00 | MSFT | Stock | 31.3906 | 31.5938 | 30.7812 | 30.8906 | 24010200.0 |
| 2000-10-25 13:00:00 | MSFT | Stock | 30.875 | 31.0312 | 30.5 | 30.5 | 13839000.0 |
| 2000-10-25 14:00:00 | MSFT | Stock | 30.5 | 31.0 | 30.375 | 30.4688 | 33755800.0 |
| 2000-10-25 15:00:00 | MSFT | Stock | 30.4688 | 30.6875 | 30.25 | 30.625 | 26555000.0 |
| 2000-10-25 16:00:00 | MSFT | Stock | 30.5938 | 31.0 | 30.3438 | 30.6875 | 1985000.0 |
| 2000-10-25 17:00:00 | MSFT | Stock | 30.6562 | 30.6562 | 30.5312 | 30.5312 | 91200.0 |
| 2000-10-25 18:00:00 | MSFT | Stock | 30.5312 | 30.5312 | 30.5 | 30.5 | 800.0 |
| 2000-10-25 08:00:00 | NVDA | Stock | 0.2708 | 0.2708 | 0.2708 | 0.2708 | 24000.0 |
| 2000-10-25 09:00:00 | NVDA | Stock | 0.2688 | 0.2708 | 0.263 | 0.2641 | 27408000.0 |
| 2000-10-25 10:00:00 | NVDA | Stock | 0.2648 | 0.2648 | 0.2542 | 0.2602 | 49224000.0 |
| 2000-10-25 11:00:00 | NVDA | Stock | 0.2589 | 0.2698 | 0.257 | 0.2609 | 39024000.0 |
| 2000-10-25 12:00:00 | NVDA | Stock | 0.2604 | 0.2635 | 0.257 | 0.2625 | 44112000.0 |
| 2000-10-25 13:00:00 | NVDA | Stock | 0.2625 | 0.2625 | 0.2563 | 0.257 | 42384000.0 |
| 2000-10-25 14:00:00 | NVDA | Stock | 0.257 | 0.2641 | 0.2563 | 0.2624 | 56352000.0 |
| 2000-10-25 15:00:00 | NVDA | Stock | 0.2625 | 0.265 | 0.2487 | 0.2505 | 80112000.0 |
| 2000-10-25 16:00:00 | NVDA | Stock | 0.2505 | 0.2633 | 0.2497 | 0.2633 | 3648000.0 |
| 2000-10-25 08:00:00 | AMZN | Stock | 1.65 | 1.6875 | 1.575 | 1.6125 | 3268000.0 |
| 2000-10-25 09:00:00 | AMZN | Stock | 1.6125 | 1.7359 | 1.6094 | 1.7094 | 91804000.0 |
| 2000-10-25 10:00:00 | AMZN | Stock | 1.7094 | 1.7375 | 1.6812 | 1.7188 | 83612000.0 |
| 2000-10-25 11:00:00 | AMZN | Stock | 1.7156 | 1.8156 | 1.7094 | 1.7656 | 109210000.0 |
| 2000-10-25 12:00:00 | AMZN | Stock | 1.7641 | 1.7781 | 1.7188 | 1.7438 | 42250000.0 |
| 2000-10-25 13:00:00 | AMZN | Stock | 1.7469 | 1.7625 | 1.7125 | 1.725 | 34224000.0 |
| 2000-10-25 14:00:00 | AMZN | Stock | 1.7219 | 1.7625 | 1.6562 | 1.6719 | 56560000.0 |
| 2000-10-25 15:00:00 | AMZN | Stock | 1.6719 | 1.6719 | 1.5875 | 1.5969 | 87602000.0 |
| 2000-10-25 16:00:00 | AMZN | Stock | 1.5938 | 1.7922 | 1.5875 | 1.5938 | 11150000.0 |
| 2000-10-25 17:00:00 | AMZN | Stock | 1.6156 | 1.6219 | 1.5938 | 1.6063 | 762000.0 |
| 2000-10-25 18:00:00 | AMZN | Stock | 1.6125 | 1.625 | 1.6094 | 1.6125 | 198000.0 |
| 2000-10-25 09:00:00 | CL | Stock | 27.375 | 27.415 | 27.225 | 27.365 | 650600.0 |
| 2000-10-25 10:00:00 | CL | Stock | 27.36 | 27.47 | 27.285 | 27.47 | 508400.0 |
| 2000-10-25 11:00:00 | CL | Stock | 27.465 | 27.465 | 27.125 | 27.28 | 588200.0 |
| 2000-10-25 12:00:00 | CL | Stock | 27.29 | 27.37 | 27.125 | 27.225 | 368800.0 |
| 2000-10-25 13:00:00 | CL | Stock | 27.225 | 27.325 | 27.125 | 27.125 | 241400.0 |
| 2000-10-25 14:00:00 | CL | Stock | 27.125 | 27.94 | 27.125 | 27.825 | 1090600.0 |
| 2000-10-25 15:00:00 | CL | Stock | 27.825 | 27.85 | 27.5 | 27.675 | 918200.0 |
| 2000-10-25 16:00:00 | CL | Stock | 27.7 | 27.775 | 27.445 | 27.445 | 123800.0 |
> showing 50 of 15,699 rows — these rows as CSV