PREVIEW / stock_1hour / 2000-12-07
file: by_date/stock_1hour/2000/2000-12-07.parquet size: 307 KB rows: 16,055 symbols: 1,258
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-07 08:00:00 | AAPL | Stock | 0.255 | 0.2589 | 0.2522 | 0.2533 | 7750400.0 |
| 2000-12-07 09:00:00 | AAPL | Stock | 0.2517 | 0.2589 | 0.2506 | 0.2545 | 59360000.0 |
| 2000-12-07 10:00:00 | AAPL | Stock | 0.2533 | 0.2578 | 0.25 | 0.2567 | 85405600.0 |
| 2000-12-07 11:00:00 | AAPL | Stock | 0.2567 | 0.2612 | 0.2567 | 0.26 | 50836800.0 |
| 2000-12-07 12:00:00 | AAPL | Stock | 0.26 | 0.2656 | 0.2589 | 0.2623 | 53726400.0 |
| 2000-12-07 13:00:00 | AAPL | Stock | 0.2612 | 0.2623 | 0.2589 | 0.26 | 29663200.0 |
| 2000-12-07 14:00:00 | AAPL | Stock | 0.2589 | 0.2612 | 0.2545 | 0.2556 | 45539200.0 |
| 2000-12-07 15:00:00 | AAPL | Stock | 0.2545 | 0.2612 | 0.2533 | 0.2556 | 41400800.0 |
| 2000-12-07 16:00:00 | AAPL | Stock | 0.2556 | 0.2617 | 0.25 | 0.2528 | 5980800.0 |
| 2000-12-07 17:00:00 | AAPL | Stock | 0.2528 | 0.2567 | 0.2522 | 0.2545 | 896000.0 |
| 2000-12-07 18:00:00 | AAPL | Stock | 0.2545 | 0.2567 | 0.2545 | 0.2567 | 4900000.0 |
| 2000-12-07 08:00:00 | MSFT | Stock | 26.5 | 28.375 | 26.0 | 27.1562 | 1705800.0 |
| 2000-12-07 09:00:00 | MSFT | Stock | 27.1875 | 27.2031 | 26.125 | 26.3438 | 27780800.0 |
| 2000-12-07 10:00:00 | MSFT | Stock | 26.3438 | 26.6875 | 26.25 | 26.5156 | 24353600.0 |
| 2000-12-07 11:00:00 | MSFT | Stock | 26.5156 | 26.625 | 26.4688 | 26.5938 | 12254600.0 |
| 2000-12-07 12:00:00 | MSFT | Stock | 26.5625 | 26.5938 | 26.2188 | 26.2188 | 13344200.0 |
| 2000-12-07 13:00:00 | MSFT | Stock | 26.2188 | 26.4375 | 26.125 | 26.2188 | 15347000.0 |
| 2000-12-07 14:00:00 | MSFT | Stock | 26.1875 | 26.5312 | 26.1562 | 26.3438 | 15049800.0 |
| 2000-12-07 15:00:00 | MSFT | Stock | 26.375 | 26.6562 | 26.2812 | 26.5625 | 20620400.0 |
| 2000-12-07 16:00:00 | MSFT | Stock | 26.5625 | 26.625 | 25.7188 | 26.375 | 3189600.0 |
| 2000-12-07 17:00:00 | MSFT | Stock | 26.4062 | 26.8438 | 26.4062 | 26.7812 | 535200.0 |
| 2000-12-07 18:00:00 | MSFT | Stock | 26.7812 | 26.875 | 26.5625 | 26.75 | 28600.0 |
| 2000-12-07 08:00:00 | NVDA | Stock | 0.1665 | 0.1667 | 0.1665 | 0.1667 | 216000.0 |
| 2000-12-07 09:00:00 | NVDA | Stock | 0.1688 | 0.1698 | 0.1547 | 0.1591 | 124440000.0 |
| 2000-12-07 10:00:00 | NVDA | Stock | 0.1589 | 0.1708 | 0.1552 | 0.1659 | 217728000.0 |
| 2000-12-07 11:00:00 | NVDA | Stock | 0.1669 | 0.1779 | 0.1646 | 0.1708 | 80760000.0 |
| 2000-12-07 12:00:00 | NVDA | Stock | 0.1708 | 0.175 | 0.1672 | 0.1708 | 77400000.0 |
| 2000-12-07 13:00:00 | NVDA | Stock | 0.1708 | 0.1719 | 0.1667 | 0.1677 | 51000000.0 |
| 2000-12-07 14:00:00 | NVDA | Stock | 0.1677 | 0.1743 | 0.1677 | 0.1715 | 60072000.0 |
| 2000-12-07 15:00:00 | NVDA | Stock | 0.1714 | 0.1732 | 0.1648 | 0.1688 | 106008000.0 |
| 2000-12-07 16:00:00 | NVDA | Stock | 0.1688 | 0.1693 | 0.1563 | 0.1604 | 11160000.0 |
| 2000-12-07 17:00:00 | NVDA | Stock | 0.1625 | 0.1646 | 0.1625 | 0.1646 | 1632000.0 |
| 2000-12-07 18:00:00 | NVDA | Stock | 0.1688 | 0.1688 | 0.1667 | 0.1667 | 8928000.0 |
| 2000-12-07 08:00:00 | AMZN | Stock | 1.1828 | 1.1828 | 1.05 | 1.1531 | 296000.0 |
| 2000-12-07 09:00:00 | AMZN | Stock | 1.1562 | 1.1813 | 1.1125 | 1.1219 | 19840000.0 |
| 2000-12-07 10:00:00 | AMZN | Stock | 1.1219 | 1.1719 | 1.1219 | 1.1312 | 24574000.0 |
| 2000-12-07 11:00:00 | AMZN | Stock | 1.1312 | 1.1625 | 1.1312 | 1.15 | 10466000.0 |
| 2000-12-07 12:00:00 | AMZN | Stock | 1.15 | 1.1562 | 1.125 | 1.125 | 10840000.0 |
| 2000-12-07 13:00:00 | AMZN | Stock | 1.125 | 1.1312 | 1.0281 | 1.0438 | 32836000.0 |
| 2000-12-07 14:00:00 | AMZN | Stock | 1.0469 | 1.0625 | 1.0062 | 1.0219 | 53038000.0 |
| 2000-12-07 15:00:00 | AMZN | Stock | 1.0219 | 1.0875 | 1.0125 | 1.0719 | 41706000.0 |
| 2000-12-07 16:00:00 | AMZN | Stock | 1.0719 | 1.0938 | 1.025 | 1.05 | 3294000.0 |
| 2000-12-07 17:00:00 | AMZN | Stock | 1.0688 | 1.1 | 1.0422 | 1.075 | 360000.0 |
| 2000-12-07 18:00:00 | AMZN | Stock | 1.0719 | 1.0719 | 1.0719 | 1.0719 | 4000.0 |
| 2000-12-07 09:00:00 | CL | Stock | 27.775 | 28.75 | 27.775 | 28.56 | 577200.0 |
| 2000-12-07 10:00:00 | CL | Stock | 28.575 | 28.905 | 28.575 | 28.79 | 486400.0 |
| 2000-12-07 11:00:00 | CL | Stock | 28.805 | 29.0 | 28.79 | 28.99 | 243000.0 |
| 2000-12-07 12:00:00 | CL | Stock | 28.97 | 28.97 | 28.775 | 28.815 | 121600.0 |
| 2000-12-07 13:00:00 | CL | Stock | 28.815 | 29.5 | 28.81 | 29.495 | 648400.0 |
| 2000-12-07 14:00:00 | CL | Stock | 29.49 | 29.6 | 29.4 | 29.55 | 917200.0 |
> showing 50 of 16,055 rows — these rows as CSV