PREVIEW / stock_1hour / 2000-12-22
file: by_date/stock_1hour/2000/2000-12-22.parquet size: 315 KB rows: 16,672 symbols: 1,271
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-22 08:00:00 | AAPL | Stock | 0.2522 | 0.2545 | 0.2517 | 0.2545 | 1500800.0 |
| 2000-12-22 09:00:00 | AAPL | Stock | 0.2545 | 0.2589 | 0.2522 | 0.2589 | 34249600.0 |
| 2000-12-22 10:00:00 | AAPL | Stock | 0.2578 | 0.2634 | 0.2578 | 0.2634 | 65441600.0 |
| 2000-12-22 11:00:00 | AAPL | Stock | 0.2634 | 0.2645 | 0.2589 | 0.2589 | 42050400.0 |
| 2000-12-22 12:00:00 | AAPL | Stock | 0.2589 | 0.2612 | 0.2533 | 0.26 | 29439200.0 |
| 2000-12-22 13:00:00 | AAPL | Stock | 0.26 | 0.2612 | 0.2567 | 0.26 | 33544000.0 |
| 2000-12-22 14:00:00 | AAPL | Stock | 0.2589 | 0.2612 | 0.2567 | 0.2589 | 27731200.0 |
| 2000-12-22 15:00:00 | AAPL | Stock | 0.26 | 0.2679 | 0.2589 | 0.2679 | 48669600.0 |
| 2000-12-22 16:00:00 | AAPL | Stock | 0.2679 | 0.2701 | 0.26 | 0.2679 | 17942400.0 |
| 2000-12-22 17:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 11200.0 |
| 2000-12-22 08:00:00 | MSFT | Stock | 22.0 | 22.25 | 21.7188 | 22.125 | 785400.0 |
| 2000-12-22 09:00:00 | MSFT | Stock | 22.125 | 23.1875 | 22.0 | 23.1406 | 17488000.0 |
| 2000-12-22 10:00:00 | MSFT | Stock | 23.1562 | 23.4375 | 23.0312 | 23.2812 | 21196600.0 |
| 2000-12-22 11:00:00 | MSFT | Stock | 23.3125 | 23.4688 | 23.0625 | 23.0625 | 17897600.0 |
| 2000-12-22 12:00:00 | MSFT | Stock | 23.0625 | 23.4375 | 23.0312 | 23.1875 | 10494200.0 |
| 2000-12-22 13:00:00 | MSFT | Stock | 23.1875 | 23.2812 | 22.875 | 22.9844 | 9962400.0 |
| 2000-12-22 14:00:00 | MSFT | Stock | 22.9688 | 23.1875 | 22.8438 | 23.0625 | 8022600.0 |
| 2000-12-22 15:00:00 | MSFT | Stock | 23.0312 | 23.5625 | 22.9375 | 23.1875 | 14846400.0 |
| 2000-12-22 16:00:00 | MSFT | Stock | 23.1875 | 23.375 | 23.0312 | 23.0938 | 1918000.0 |
| 2000-12-22 17:00:00 | MSFT | Stock | 23.0625 | 23.5625 | 23.0312 | 23.25 | 9000.0 |
| 2000-12-22 18:00:00 | MSFT | Stock | 23.2188 | 23.3125 | 23.2188 | 23.2344 | 1200.0 |
| 2000-12-22 09:00:00 | NVDA | Stock | 0.1229 | 0.1341 | 0.1219 | 0.1297 | 70944000.0 |
| 2000-12-22 10:00:00 | NVDA | Stock | 0.1297 | 0.1401 | 0.1276 | 0.1383 | 98232000.0 |
| 2000-12-22 11:00:00 | NVDA | Stock | 0.138 | 0.1531 | 0.138 | 0.1464 | 246288000.0 |
| 2000-12-22 12:00:00 | NVDA | Stock | 0.1469 | 0.1563 | 0.1466 | 0.1555 | 92808000.0 |
| 2000-12-22 13:00:00 | NVDA | Stock | 0.1557 | 0.1594 | 0.1385 | 0.1417 | 126696000.0 |
| 2000-12-22 14:00:00 | NVDA | Stock | 0.1413 | 0.1526 | 0.1333 | 0.15 | 168816000.0 |
| 2000-12-22 15:00:00 | NVDA | Stock | 0.1503 | 0.1542 | 0.1458 | 0.1461 | 86760000.0 |
| 2000-12-22 16:00:00 | NVDA | Stock | 0.1461 | 0.1479 | 0.1461 | 0.1479 | 6096000.0 |
| 2000-12-22 18:00:00 | NVDA | Stock | 0.1479 | 0.1482 | 0.1479 | 0.1482 | 48000.0 |
| 2000-12-22 08:00:00 | AMZN | Stock | 0.7688 | 0.775 | 0.7469 | 0.7625 | 166000.0 |
| 2000-12-22 09:00:00 | AMZN | Stock | 0.7563 | 0.8125 | 0.75 | 0.7969 | 20188000.0 |
| 2000-12-22 10:00:00 | AMZN | Stock | 0.7969 | 0.8266 | 0.7844 | 0.8 | 28482000.0 |
| 2000-12-22 11:00:00 | AMZN | Stock | 0.8 | 0.8094 | 0.7906 | 0.7938 | 17074000.0 |
| 2000-12-22 12:00:00 | AMZN | Stock | 0.7938 | 0.8062 | 0.7938 | 0.7984 | 19954000.0 |
| 2000-12-22 13:00:00 | AMZN | Stock | 0.8 | 0.8062 | 0.7938 | 0.8 | 30358000.0 |
| 2000-12-22 14:00:00 | AMZN | Stock | 0.8031 | 0.8031 | 0.7938 | 0.7938 | 30944000.0 |
| 2000-12-22 15:00:00 | AMZN | Stock | 0.7969 | 0.8 | 0.7688 | 0.7781 | 29438000.0 |
| 2000-12-22 16:00:00 | AMZN | Stock | 0.7781 | 0.7953 | 0.775 | 0.7781 | 3220000.0 |
| 2000-12-22 17:00:00 | AMZN | Stock | 0.7875 | 0.7906 | 0.7812 | 0.7906 | 60000.0 |
| 2000-12-22 18:00:00 | AMZN | Stock | 0.7875 | 0.7906 | 0.775 | 0.7875 | 26000.0 |
| 2000-12-22 09:00:00 | CL | Stock | 29.94 | 30.075 | 29.94 | 29.975 | 477800.0 |
| 2000-12-22 10:00:00 | CL | Stock | 29.95 | 30.22 | 29.78 | 29.8 | 319400.0 |
| 2000-12-22 11:00:00 | CL | Stock | 29.8 | 29.8 | 29.42 | 29.505 | 458400.0 |
| 2000-12-22 12:00:00 | CL | Stock | 29.5 | 29.65 | 29.5 | 29.58 | 144800.0 |
| 2000-12-22 13:00:00 | CL | Stock | 29.6 | 29.6 | 29.38 | 29.5 | 385600.0 |
| 2000-12-22 14:00:00 | CL | Stock | 29.5 | 29.995 | 29.4 | 29.98 | 175000.0 |
| 2000-12-22 15:00:00 | CL | Stock | 29.98 | 29.98 | 29.805 | 29.875 | 435200.0 |
| 2000-12-22 16:00:00 | CL | Stock | 29.88 | 29.88 | 29.875 | 29.88 | 59000.0 |
> showing 49 of 16,672 rows — these rows as CSV