PREVIEW / stock_1hour / 2000-12-29
file: by_date/stock_1hour/2000/2000-12-29.parquet size: 349 KB rows: 18,235 symbols: 1,278
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-12-29 08:00:00 | AAPL | Stock | 0.2595 | 0.2645 | 0.2589 | 0.2634 | 168000.0 |
| 2000-12-29 09:00:00 | AAPL | Stock | 0.2634 | 0.2667 | 0.2612 | 0.2656 | 60536000.0 |
| 2000-12-29 10:00:00 | AAPL | Stock | 0.2645 | 0.2667 | 0.2589 | 0.26 | 64360800.0 |
| 2000-12-29 11:00:00 | AAPL | Stock | 0.2589 | 0.2634 | 0.2589 | 0.26 | 75532800.0 |
| 2000-12-29 12:00:00 | AAPL | Stock | 0.26 | 0.2679 | 0.26 | 0.2667 | 81284000.0 |
| 2000-12-29 13:00:00 | AAPL | Stock | 0.2667 | 0.2679 | 0.26 | 0.2612 | 112123200.0 |
| 2000-12-29 14:00:00 | AAPL | Stock | 0.2612 | 0.2656 | 0.26 | 0.2634 | 69501600.0 |
| 2000-12-29 15:00:00 | AAPL | Stock | 0.2634 | 0.2667 | 0.2634 | 0.2645 | 69664000.0 |
| 2000-12-29 16:00:00 | AAPL | Stock | 0.2645 | 0.2673 | 0.26 | 0.2656 | 81536000.0 |
| 2000-12-29 17:00:00 | AAPL | Stock | 0.2656 | 0.2656 | 0.2623 | 0.2623 | 616000.0 |
| 2000-12-29 18:00:00 | AAPL | Stock | 0.2634 | 0.2656 | 0.2634 | 0.2656 | 806400.0 |
| 2000-12-29 08:00:00 | MSFT | Stock | 22.2188 | 22.4375 | 22.0 | 22.2812 | 54600.0 |
| 2000-12-29 09:00:00 | MSFT | Stock | 22.25 | 22.9062 | 21.9375 | 22.375 | 11570000.0 |
| 2000-12-29 10:00:00 | MSFT | Stock | 22.375 | 22.4688 | 21.7188 | 21.8125 | 16669600.0 |
| 2000-12-29 11:00:00 | MSFT | Stock | 21.8125 | 22.0 | 21.5 | 21.9688 | 11938200.0 |
| 2000-12-29 12:00:00 | MSFT | Stock | 21.9688 | 22.2188 | 21.6875 | 21.7812 | 8357400.0 |
| 2000-12-29 13:00:00 | MSFT | Stock | 21.7812 | 21.8125 | 21.5312 | 21.75 | 8425000.0 |
| 2000-12-29 14:00:00 | MSFT | Stock | 21.75 | 21.7656 | 21.5 | 21.5625 | 10295600.0 |
| 2000-12-29 15:00:00 | MSFT | Stock | 21.5625 | 21.875 | 21.3125 | 21.6875 | 22206000.0 |
| 2000-12-29 16:00:00 | MSFT | Stock | 21.75 | 21.9375 | 21.5 | 21.6875 | 6809200.0 |
| 2000-12-29 17:00:00 | MSFT | Stock | 21.7969 | 21.875 | 21.6875 | 21.75 | 484400.0 |
| 2000-12-29 18:00:00 | MSFT | Stock | 21.7188 | 21.75 | 21.625 | 21.75 | 100800.0 |
| 2000-12-29 09:00:00 | NVDA | Stock | 0.1503 | 0.1549 | 0.1471 | 0.1484 | 37896000.0 |
| 2000-12-29 10:00:00 | NVDA | Stock | 0.15 | 0.15 | 0.1411 | 0.1418 | 51744000.0 |
| 2000-12-29 11:00:00 | NVDA | Stock | 0.1418 | 0.1466 | 0.141 | 0.1458 | 56064000.0 |
| 2000-12-29 12:00:00 | NVDA | Stock | 0.1458 | 0.1479 | 0.1413 | 0.1422 | 50952000.0 |
| 2000-12-29 13:00:00 | NVDA | Stock | 0.1422 | 0.1422 | 0.1354 | 0.1396 | 91488000.0 |
| 2000-12-29 14:00:00 | NVDA | Stock | 0.1404 | 0.1419 | 0.1354 | 0.1375 | 44712000.0 |
| 2000-12-29 15:00:00 | NVDA | Stock | 0.1375 | 0.1396 | 0.1333 | 0.1365 | 126696000.0 |
| 2000-12-29 16:00:00 | NVDA | Stock | 0.1365 | 0.1396 | 0.1365 | 0.1391 | 15408000.0 |
| 2000-12-29 17:00:00 | NVDA | Stock | 0.1406 | 0.1406 | 0.1365 | 0.1365 | 672000.0 |
| 2000-12-29 18:00:00 | NVDA | Stock | 0.1385 | 0.1385 | 0.1365 | 0.1365 | 1992000.0 |
| 2000-12-29 08:00:00 | AMZN | Stock | 0.8672 | 0.875 | 0.8656 | 0.8656 | 426000.0 |
| 2000-12-29 09:00:00 | AMZN | Stock | 0.8594 | 0.8656 | 0.8344 | 0.8469 | 14866000.0 |
| 2000-12-29 10:00:00 | AMZN | Stock | 0.8469 | 0.8562 | 0.825 | 0.8281 | 19222000.0 |
| 2000-12-29 11:00:00 | AMZN | Stock | 0.8281 | 0.8344 | 0.7938 | 0.8188 | 21738000.0 |
| 2000-12-29 12:00:00 | AMZN | Stock | 0.8188 | 0.825 | 0.8062 | 0.8062 | 10552000.0 |
| 2000-12-29 13:00:00 | AMZN | Stock | 0.8094 | 0.8094 | 0.75 | 0.7875 | 29678000.0 |
| 2000-12-29 14:00:00 | AMZN | Stock | 0.7844 | 0.8094 | 0.775 | 0.7969 | 33968000.0 |
| 2000-12-29 15:00:00 | AMZN | Stock | 0.7938 | 0.8 | 0.7594 | 0.7781 | 52712000.0 |
| 2000-12-29 16:00:00 | AMZN | Stock | 0.775 | 0.7844 | 0.7719 | 0.7781 | 5342000.0 |
| 2000-12-29 17:00:00 | AMZN | Stock | 0.775 | 0.7891 | 0.775 | 0.775 | 222000.0 |
| 2000-12-29 18:00:00 | AMZN | Stock | 0.7812 | 0.7812 | 0.775 | 0.775 | 406000.0 |
| 2000-12-29 09:00:00 | CL | Stock | 32.625 | 32.845 | 32.625 | 32.755 | 286800.0 |
| 2000-12-29 10:00:00 | CL | Stock | 32.755 | 32.755 | 32.485 | 32.5 | 380600.0 |
| 2000-12-29 11:00:00 | CL | Stock | 32.495 | 32.615 | 32.405 | 32.615 | 300200.0 |
| 2000-12-29 12:00:00 | CL | Stock | 32.605 | 32.65 | 32.505 | 32.63 | 232000.0 |
| 2000-12-29 13:00:00 | CL | Stock | 32.63 | 32.65 | 32.4 | 32.485 | 234800.0 |
| 2000-12-29 14:00:00 | CL | Stock | 32.45 | 32.64 | 32.45 | 32.625 | 311000.0 |
| 2000-12-29 15:00:00 | CL | Stock | 32.62 | 32.64 | 32.225 | 32.275 | 533400.0 |
> showing 50 of 18,235 rows — these rows as CSV