PREVIEW / stock_1hour / 2000-12-27
file: by_date/stock_1hour/2000/2000-12-27.parquet size: 328 KB rows: 17,135 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-27 08:00:00 | AAPL | Stock | 0.2617 | 0.2634 | 0.2612 | 0.2612 | 778400.0 |
| 2000-12-27 09:00:00 | AAPL | Stock | 0.2612 | 0.2612 | 0.2533 | 0.2567 | 34608000.0 |
| 2000-12-27 10:00:00 | AAPL | Stock | 0.2556 | 0.2589 | 0.2545 | 0.2567 | 28072800.0 |
| 2000-12-27 11:00:00 | AAPL | Stock | 0.2578 | 0.2578 | 0.2545 | 0.2567 | 34742400.0 |
| 2000-12-27 12:00:00 | AAPL | Stock | 0.2567 | 0.2623 | 0.2567 | 0.2567 | 40560800.0 |
| 2000-12-27 13:00:00 | AAPL | Stock | 0.2567 | 0.2589 | 0.2545 | 0.2567 | 20809600.0 |
| 2000-12-27 14:00:00 | AAPL | Stock | 0.2567 | 0.2623 | 0.2545 | 0.2623 | 56134400.0 |
| 2000-12-27 15:00:00 | AAPL | Stock | 0.2623 | 0.2645 | 0.2567 | 0.2645 | 96303200.0 |
| 2000-12-27 16:00:00 | AAPL | Stock | 0.2634 | 0.2667 | 0.2623 | 0.2645 | 6574400.0 |
| 2000-12-27 17:00:00 | AAPL | Stock | 0.2645 | 0.2645 | 0.2617 | 0.2617 | 128800.0 |
| 2000-12-27 08:00:00 | MSFT | Stock | 23.4375 | 23.625 | 23.375 | 23.4375 | 148400.0 |
| 2000-12-27 09:00:00 | MSFT | Stock | 23.4688 | 23.5 | 22.8125 | 22.8438 | 9696200.0 |
| 2000-12-27 10:00:00 | MSFT | Stock | 22.8438 | 23.4062 | 22.5625 | 22.9062 | 13198200.0 |
| 2000-12-27 11:00:00 | MSFT | Stock | 22.875 | 23.2188 | 22.875 | 23.125 | 8061600.0 |
| 2000-12-27 12:00:00 | MSFT | Stock | 23.0938 | 23.125 | 22.7188 | 22.7812 | 7732200.0 |
| 2000-12-27 13:00:00 | MSFT | Stock | 23.0 | 23.0 | 22.7188 | 22.9062 | 6461200.0 |
| 2000-12-27 14:00:00 | MSFT | Stock | 22.9062 | 23.0625 | 22.6562 | 22.8438 | 7220400.0 |
| 2000-12-27 15:00:00 | MSFT | Stock | 22.8438 | 23.25 | 22.6875 | 23.1875 | 12703400.0 |
| 2000-12-27 16:00:00 | MSFT | Stock | 23.1562 | 23.2188 | 22.9062 | 23.0 | 2743200.0 |
| 2000-12-27 17:00:00 | MSFT | Stock | 23.1562 | 23.2188 | 23.0 | 23.0312 | 40800.0 |
| 2000-12-27 18:00:00 | MSFT | Stock | 23.0312 | 23.0938 | 23.0 | 23.0312 | 10600.0 |
| 2000-12-27 09:00:00 | NVDA | Stock | 0.1385 | 0.1391 | 0.1328 | 0.1375 | 28824000.0 |
| 2000-12-27 10:00:00 | NVDA | Stock | 0.1385 | 0.1505 | 0.1359 | 0.15 | 74304000.0 |
| 2000-12-27 11:00:00 | NVDA | Stock | 0.1501 | 0.1542 | 0.1443 | 0.1495 | 42816000.0 |
| 2000-12-27 12:00:00 | NVDA | Stock | 0.1487 | 0.1523 | 0.1474 | 0.15 | 27216000.0 |
| 2000-12-27 13:00:00 | NVDA | Stock | 0.15 | 0.1521 | 0.1479 | 0.1505 | 22392000.0 |
| 2000-12-27 14:00:00 | NVDA | Stock | 0.1516 | 0.1542 | 0.149 | 0.1521 | 45456000.0 |
| 2000-12-27 15:00:00 | NVDA | Stock | 0.1521 | 0.1552 | 0.1487 | 0.1495 | 83256000.0 |
| 2000-12-27 16:00:00 | NVDA | Stock | 0.1493 | 0.1508 | 0.1492 | 0.1508 | 5064000.0 |
| 2000-12-27 08:00:00 | AMZN | Stock | 0.8625 | 0.8625 | 0.8406 | 0.85 | 108000.0 |
| 2000-12-27 09:00:00 | AMZN | Stock | 0.8406 | 0.85 | 0.7875 | 0.8031 | 30522000.0 |
| 2000-12-27 10:00:00 | AMZN | Stock | 0.8062 | 0.8562 | 0.7781 | 0.8438 | 25804000.0 |
| 2000-12-27 11:00:00 | AMZN | Stock | 0.8469 | 0.8719 | 0.8344 | 0.8531 | 28578000.0 |
| 2000-12-27 12:00:00 | AMZN | Stock | 0.8562 | 0.8656 | 0.8406 | 0.8406 | 10180000.0 |
| 2000-12-27 13:00:00 | AMZN | Stock | 0.8438 | 0.85 | 0.8281 | 0.8344 | 8264000.0 |
| 2000-12-27 14:00:00 | AMZN | Stock | 0.8344 | 0.8469 | 0.8312 | 0.8438 | 8708000.0 |
| 2000-12-27 15:00:00 | AMZN | Stock | 0.8469 | 0.8531 | 0.8281 | 0.8406 | 15588000.0 |
| 2000-12-27 16:00:00 | AMZN | Stock | 0.8406 | 0.8594 | 0.8281 | 0.8406 | 2616000.0 |
| 2000-12-27 17:00:00 | AMZN | Stock | 0.8406 | 0.8469 | 0.8375 | 0.8453 | 68000.0 |
| 2000-12-27 18:00:00 | AMZN | Stock | 0.85 | 0.85 | 0.85 | 0.85 | 16000.0 |
| 2000-12-27 09:00:00 | CL | Stock | 31.75 | 32.125 | 31.72 | 31.785 | 594600.0 |
| 2000-12-27 10:00:00 | CL | Stock | 31.795 | 32.35 | 31.795 | 32.025 | 573000.0 |
| 2000-12-27 11:00:00 | CL | Stock | 32.025 | 32.3 | 31.86 | 32.25 | 426800.0 |
| 2000-12-27 12:00:00 | CL | Stock | 32.245 | 32.485 | 32.125 | 32.365 | 486000.0 |
| 2000-12-27 13:00:00 | CL | Stock | 32.37 | 32.375 | 32.25 | 32.25 | 454200.0 |
| 2000-12-27 14:00:00 | CL | Stock | 32.25 | 32.35 | 32.25 | 32.29 | 311800.0 |
| 2000-12-27 15:00:00 | CL | Stock | 32.265 | 32.42 | 32.265 | 32.285 | 618000.0 |
| 2000-12-27 16:00:00 | CL | Stock | 32.285 | 32.285 | 32.28 | 32.28 | 107000.0 |
> showing 48 of 17,135 rows — these rows as CSV