PREVIEW / stock_1hour / 2000-12-28
file: by_date/stock_1hour/2000/2000-12-28.parquet size: 333 KB rows: 17,365 symbols: 1,275
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-28 08:00:00 | AAPL | Stock | 0.2595 | 0.2612 | 0.2578 | 0.2589 | 1780800.0 |
| 2000-12-28 09:00:00 | AAPL | Stock | 0.2612 | 0.2645 | 0.2556 | 0.2612 | 36954400.0 |
| 2000-12-28 10:00:00 | AAPL | Stock | 0.2612 | 0.2634 | 0.2589 | 0.2612 | 64439200.0 |
| 2000-12-28 11:00:00 | AAPL | Stock | 0.2623 | 0.2667 | 0.26 | 0.2645 | 52936800.0 |
| 2000-12-28 12:00:00 | AAPL | Stock | 0.2645 | 0.2656 | 0.2623 | 0.2645 | 33364800.0 |
| 2000-12-28 13:00:00 | AAPL | Stock | 0.2634 | 0.2645 | 0.2623 | 0.2634 | 30867200.0 |
| 2000-12-28 14:00:00 | AAPL | Stock | 0.2634 | 0.2645 | 0.2623 | 0.2634 | 22405600.0 |
| 2000-12-28 15:00:00 | AAPL | Stock | 0.2645 | 0.2656 | 0.2623 | 0.2634 | 55529600.0 |
| 2000-12-28 16:00:00 | AAPL | Stock | 0.2634 | 0.2662 | 0.2634 | 0.2634 | 3472000.0 |
| 2000-12-28 17:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 56000.0 |
| 2000-12-28 18:00:00 | AAPL | Stock | 0.2634 | 0.2645 | 0.2634 | 0.2645 | 117600.0 |
| 2000-12-28 08:00:00 | MSFT | Stock | 22.75 | 22.875 | 22.625 | 22.8125 | 78600.0 |
| 2000-12-28 09:00:00 | MSFT | Stock | 22.8125 | 23.125 | 22.5 | 22.75 | 9133000.0 |
| 2000-12-28 10:00:00 | MSFT | Stock | 22.75 | 22.8906 | 22.5625 | 22.5625 | 9739000.0 |
| 2000-12-28 11:00:00 | MSFT | Stock | 22.5625 | 22.5938 | 22.0312 | 22.25 | 14449200.0 |
| 2000-12-28 12:00:00 | MSFT | Stock | 22.2188 | 22.375 | 22.0938 | 22.1875 | 9769000.0 |
| 2000-12-28 13:00:00 | MSFT | Stock | 22.1562 | 22.3125 | 21.9375 | 22.0312 | 7699600.0 |
| 2000-12-28 14:00:00 | MSFT | Stock | 22.0 | 22.2812 | 21.9688 | 22.25 | 9788200.0 |
| 2000-12-28 15:00:00 | MSFT | Stock | 22.25 | 22.3438 | 22.0938 | 22.3125 | 12476000.0 |
| 2000-12-28 16:00:00 | MSFT | Stock | 22.2812 | 22.3125 | 22.0 | 22.25 | 2184000.0 |
| 2000-12-28 17:00:00 | MSFT | Stock | 22.3125 | 22.375 | 22.1875 | 22.2812 | 11600.0 |
| 2000-12-28 18:00:00 | MSFT | Stock | 22.2812 | 22.3438 | 22.25 | 22.25 | 15400.0 |
| 2000-12-28 08:00:00 | NVDA | Stock | 0.1493 | 0.1493 | 0.1493 | 0.1493 | 3816000.0 |
| 2000-12-28 09:00:00 | NVDA | Stock | 0.1474 | 0.1542 | 0.1414 | 0.1518 | 72504000.0 |
| 2000-12-28 10:00:00 | NVDA | Stock | 0.1516 | 0.1531 | 0.149 | 0.1517 | 77304000.0 |
| 2000-12-28 11:00:00 | NVDA | Stock | 0.1516 | 0.1523 | 0.1497 | 0.1503 | 55008000.0 |
| 2000-12-28 12:00:00 | NVDA | Stock | 0.1503 | 0.1516 | 0.15 | 0.1508 | 44040000.0 |
| 2000-12-28 13:00:00 | NVDA | Stock | 0.1508 | 0.151 | 0.1464 | 0.1464 | 48072000.0 |
| 2000-12-28 14:00:00 | NVDA | Stock | 0.1464 | 0.1505 | 0.1458 | 0.1477 | 50232000.0 |
| 2000-12-28 15:00:00 | NVDA | Stock | 0.1471 | 0.1503 | 0.1458 | 0.1503 | 53376000.0 |
| 2000-12-28 16:00:00 | NVDA | Stock | 0.15 | 0.1503 | 0.1495 | 0.1495 | 2448000.0 |
| 2000-12-28 08:00:00 | AMZN | Stock | 0.875 | 0.875 | 0.8062 | 0.8438 | 188000.0 |
| 2000-12-28 09:00:00 | AMZN | Stock | 0.8375 | 0.9125 | 0.825 | 0.8969 | 45430000.0 |
| 2000-12-28 10:00:00 | AMZN | Stock | 0.9 | 0.9062 | 0.8688 | 0.8688 | 30304000.0 |
| 2000-12-28 11:00:00 | AMZN | Stock | 0.8688 | 0.8812 | 0.8594 | 0.8656 | 15004000.0 |
| 2000-12-28 12:00:00 | AMZN | Stock | 0.8688 | 0.8719 | 0.8375 | 0.8531 | 16410000.0 |
| 2000-12-28 13:00:00 | AMZN | Stock | 0.8531 | 0.8562 | 0.8438 | 0.8469 | 15044000.0 |
| 2000-12-28 14:00:00 | AMZN | Stock | 0.8469 | 0.8781 | 0.8469 | 0.8781 | 19728000.0 |
| 2000-12-28 15:00:00 | AMZN | Stock | 0.8781 | 0.8875 | 0.8594 | 0.8656 | 21966000.0 |
| 2000-12-28 16:00:00 | AMZN | Stock | 0.8656 | 0.8688 | 0.85 | 0.8656 | 1150000.0 |
| 2000-12-28 17:00:00 | AMZN | Stock | 0.8609 | 0.8656 | 0.8516 | 0.8562 | 48000.0 |
| 2000-12-28 18:00:00 | AMZN | Stock | 0.8562 | 0.8656 | 0.8562 | 0.8656 | 14000.0 |
| 2000-12-28 09:00:00 | CL | Stock | 32.225 | 32.25 | 31.88 | 31.925 | 253800.0 |
| 2000-12-28 10:00:00 | CL | Stock | 31.925 | 32.05 | 31.445 | 31.955 | 527200.0 |
| 2000-12-28 11:00:00 | CL | Stock | 31.955 | 32.11 | 31.73 | 31.8 | 455600.0 |
| 2000-12-28 12:00:00 | CL | Stock | 31.8 | 32.075 | 31.76 | 32.03 | 238800.0 |
| 2000-12-28 13:00:00 | CL | Stock | 32.04 | 32.475 | 32.02 | 32.42 | 206200.0 |
| 2000-12-28 14:00:00 | CL | Stock | 32.425 | 32.505 | 32.275 | 32.315 | 521200.0 |
| 2000-12-28 15:00:00 | CL | Stock | 32.315 | 32.525 | 32.21 | 32.235 | 501000.0 |
| 2000-12-28 16:00:00 | CL | Stock | 32.23 | 32.25 | 32.2 | 32.2 | 163000.0 |
> showing 50 of 17,365 rows — these rows as CSV