PREVIEW / stock_1hour / 2000-12-26
file: by_date/stock_1hour/2000/2000-12-26.parquet size: 312 KB rows: 16,633 symbols: 1,267
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-26 08:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 16800.0 |
| 2000-12-26 09:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2612 | 0.2645 | 26784800.0 |
| 2000-12-26 10:00:00 | AAPL | Stock | 0.2645 | 0.2667 | 0.2623 | 0.2623 | 30156000.0 |
| 2000-12-26 11:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2578 | 0.2578 | 21240800.0 |
| 2000-12-26 12:00:00 | AAPL | Stock | 0.2589 | 0.2612 | 0.2545 | 0.26 | 40230400.0 |
| 2000-12-26 13:00:00 | AAPL | Stock | 0.26 | 0.26 | 0.2567 | 0.2578 | 13490400.0 |
| 2000-12-26 14:00:00 | AAPL | Stock | 0.2567 | 0.2612 | 0.2545 | 0.2578 | 40471200.0 |
| 2000-12-26 15:00:00 | AAPL | Stock | 0.2567 | 0.2623 | 0.2545 | 0.2623 | 33980800.0 |
| 2000-12-26 16:00:00 | AAPL | Stock | 0.2623 | 0.2634 | 0.2589 | 0.2623 | 5331200.0 |
| 2000-12-26 17:00:00 | AAPL | Stock | 0.26 | 0.2623 | 0.26 | 0.2623 | 319200.0 |
| 2000-12-26 18:00:00 | AAPL | Stock | 0.2589 | 0.2589 | 0.2589 | 0.2589 | 5600.0 |
| 2000-12-26 08:00:00 | MSFT | Stock | 23.2188 | 24.0 | 23.2031 | 23.375 | 68800.0 |
| 2000-12-26 09:00:00 | MSFT | Stock | 23.5 | 23.9375 | 23.3125 | 23.9062 | 9912200.0 |
| 2000-12-26 10:00:00 | MSFT | Stock | 23.875 | 24.2812 | 23.75 | 24.0625 | 14932200.0 |
| 2000-12-26 11:00:00 | MSFT | Stock | 24.0625 | 24.125 | 23.375 | 23.4531 | 8097800.0 |
| 2000-12-26 12:00:00 | MSFT | Stock | 23.4375 | 23.5 | 23.2188 | 23.3438 | 6534600.0 |
| 2000-12-26 13:00:00 | MSFT | Stock | 23.3438 | 23.5 | 23.0 | 23.0312 | 6924200.0 |
| 2000-12-26 14:00:00 | MSFT | Stock | 23.0625 | 23.3125 | 22.9375 | 23.0312 | 7335800.0 |
| 2000-12-26 15:00:00 | MSFT | Stock | 23.0312 | 23.5 | 23.0 | 23.4375 | 9618600.0 |
| 2000-12-26 16:00:00 | MSFT | Stock | 23.4375 | 23.625 | 23.2812 | 23.5 | 1438200.0 |
| 2000-12-26 17:00:00 | MSFT | Stock | 23.5 | 23.625 | 23.4375 | 23.5 | 197600.0 |
| 2000-12-26 18:00:00 | MSFT | Stock | 23.5469 | 23.5625 | 23.5 | 23.5312 | 2600.0 |
| 2000-12-26 08:00:00 | NVDA | Stock | 0.1542 | 0.1542 | 0.1521 | 0.1521 | 672000.0 |
| 2000-12-26 09:00:00 | NVDA | Stock | 0.1521 | 0.1521 | 0.1456 | 0.1464 | 55920000.0 |
| 2000-12-26 10:00:00 | NVDA | Stock | 0.1464 | 0.1469 | 0.1365 | 0.1396 | 45840000.0 |
| 2000-12-26 11:00:00 | NVDA | Stock | 0.1396 | 0.1438 | 0.1375 | 0.1383 | 30336000.0 |
| 2000-12-26 12:00:00 | NVDA | Stock | 0.1383 | 0.1391 | 0.1349 | 0.1357 | 34416000.0 |
| 2000-12-26 13:00:00 | NVDA | Stock | 0.1365 | 0.138 | 0.1307 | 0.1323 | 39048000.0 |
| 2000-12-26 14:00:00 | NVDA | Stock | 0.1331 | 0.1354 | 0.1313 | 0.1344 | 64488000.0 |
| 2000-12-26 15:00:00 | NVDA | Stock | 0.1344 | 0.1422 | 0.1333 | 0.1401 | 62232000.0 |
| 2000-12-26 16:00:00 | NVDA | Stock | 0.1406 | 0.1406 | 0.1401 | 0.1401 | 1968000.0 |
| 2000-12-26 08:00:00 | AMZN | Stock | 0.7906 | 0.8125 | 0.7781 | 0.8062 | 294000.0 |
| 2000-12-26 09:00:00 | AMZN | Stock | 0.8125 | 0.925 | 0.7875 | 0.9 | 51006000.0 |
| 2000-12-26 10:00:00 | AMZN | Stock | 0.9 | 0.9062 | 0.8469 | 0.8812 | 38452000.0 |
| 2000-12-26 11:00:00 | AMZN | Stock | 0.8844 | 0.8875 | 0.8406 | 0.85 | 18004000.0 |
| 2000-12-26 12:00:00 | AMZN | Stock | 0.85 | 0.8656 | 0.8375 | 0.8531 | 14484000.0 |
| 2000-12-26 13:00:00 | AMZN | Stock | 0.8531 | 0.8547 | 0.825 | 0.8406 | 14410000.0 |
| 2000-12-26 14:00:00 | AMZN | Stock | 0.8406 | 0.8531 | 0.8219 | 0.8406 | 20786000.0 |
| 2000-12-26 15:00:00 | AMZN | Stock | 0.8422 | 0.8547 | 0.8375 | 0.8469 | 17652000.0 |
| 2000-12-26 16:00:00 | AMZN | Stock | 0.8438 | 0.8625 | 0.8438 | 0.8469 | 2348000.0 |
| 2000-12-26 17:00:00 | AMZN | Stock | 0.8469 | 0.85 | 0.8375 | 0.85 | 134000.0 |
| 2000-12-26 18:00:00 | AMZN | Stock | 0.8531 | 0.8562 | 0.8531 | 0.8562 | 8000.0 |
| 2000-12-26 09:00:00 | CL | Stock | 30.0 | 30.35 | 30.0 | 30.325 | 374000.0 |
| 2000-12-26 10:00:00 | CL | Stock | 30.31 | 30.675 | 30.305 | 30.6 | 601000.0 |
| 2000-12-26 11:00:00 | CL | Stock | 30.625 | 30.75 | 30.555 | 30.74 | 306000.0 |
| 2000-12-26 12:00:00 | CL | Stock | 30.75 | 31.05 | 30.725 | 31.02 | 451000.0 |
| 2000-12-26 13:00:00 | CL | Stock | 31.02 | 31.04 | 30.825 | 31.02 | 155000.0 |
| 2000-12-26 14:00:00 | CL | Stock | 31.025 | 31.25 | 31.005 | 31.185 | 232400.0 |
| 2000-12-26 15:00:00 | CL | Stock | 31.185 | 31.33 | 31.085 | 31.18 | 407000.0 |
| 2000-12-26 16:00:00 | CL | Stock | 31.215 | 31.215 | 31.145 | 31.145 | 38800.0 |
> showing 50 of 16,633 rows — these rows as CSV