PREVIEW / stock_1hour / 2000-12-14
file: by_date/stock_1hour/2000/2000-12-14.parquet size: 316 KB rows: 16,267 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-14 08:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2656 | 0.2656 | 257600.0 |
| 2000-12-14 09:00:00 | AAPL | Stock | 0.2656 | 0.2723 | 0.2656 | 0.2679 | 34848800.0 |
| 2000-12-14 10:00:00 | AAPL | Stock | 0.2679 | 0.269 | 0.2634 | 0.2667 | 42078400.0 |
| 2000-12-14 11:00:00 | AAPL | Stock | 0.2656 | 0.2701 | 0.2656 | 0.2679 | 24404800.0 |
| 2000-12-14 12:00:00 | AAPL | Stock | 0.2679 | 0.2723 | 0.2656 | 0.2667 | 38908800.0 |
| 2000-12-14 13:00:00 | AAPL | Stock | 0.2667 | 0.2679 | 0.2634 | 0.2634 | 24656800.0 |
| 2000-12-14 14:00:00 | AAPL | Stock | 0.2634 | 0.2656 | 0.2634 | 0.2645 | 23615200.0 |
| 2000-12-14 15:00:00 | AAPL | Stock | 0.2645 | 0.2667 | 0.2578 | 0.2578 | 45796800.0 |
| 2000-12-14 16:00:00 | AAPL | Stock | 0.2578 | 0.2634 | 0.2478 | 0.2511 | 13580000.0 |
| 2000-12-14 17:00:00 | AAPL | Stock | 0.2511 | 0.2578 | 0.25 | 0.2533 | 319200.0 |
| 2000-12-14 18:00:00 | AAPL | Stock | 0.2533 | 0.2567 | 0.2533 | 0.2567 | 61600.0 |
| 2000-12-14 08:00:00 | MSFT | Stock | 28.8125 | 29.0 | 28.5 | 28.9688 | 159600.0 |
| 2000-12-14 09:00:00 | MSFT | Stock | 28.9688 | 29.3594 | 28.5625 | 28.9062 | 10132600.0 |
| 2000-12-14 10:00:00 | MSFT | Stock | 28.9062 | 29.0312 | 28.5625 | 28.875 | 8524800.0 |
| 2000-12-14 11:00:00 | MSFT | Stock | 28.875 | 29.125 | 28.6875 | 28.875 | 6324600.0 |
| 2000-12-14 12:00:00 | MSFT | Stock | 28.8125 | 28.875 | 28.4375 | 28.5625 | 9023800.0 |
| 2000-12-14 13:00:00 | MSFT | Stock | 28.5625 | 28.75 | 28.4062 | 28.5312 | 3207600.0 |
| 2000-12-14 14:00:00 | MSFT | Stock | 28.5312 | 28.625 | 28.0625 | 28.1094 | 6458600.0 |
| 2000-12-14 15:00:00 | MSFT | Stock | 28.125 | 28.4688 | 27.6875 | 27.75 | 12745400.0 |
| 2000-12-14 16:00:00 | MSFT | Stock | 27.7812 | 28.5312 | 26.0 | 26.5 | 5109800.0 |
| 2000-12-14 17:00:00 | MSFT | Stock | 26.5469 | 27.75 | 26.0 | 26.125 | 5219200.0 |
| 2000-12-14 18:00:00 | MSFT | Stock | 26.125 | 26.1562 | 25.875 | 26.0312 | 197800.0 |
| 2000-12-14 08:00:00 | NVDA | Stock | 0.1833 | 0.1833 | 0.1833 | 0.1833 | 48000.0 |
| 2000-12-14 09:00:00 | NVDA | Stock | 0.1854 | 0.1862 | 0.1747 | 0.1747 | 54264000.0 |
| 2000-12-14 10:00:00 | NVDA | Stock | 0.1747 | 0.1758 | 0.1688 | 0.175 | 107088000.0 |
| 2000-12-14 11:00:00 | NVDA | Stock | 0.1745 | 0.1786 | 0.1734 | 0.1766 | 80544000.0 |
| 2000-12-14 12:00:00 | NVDA | Stock | 0.176 | 0.1807 | 0.1719 | 0.175 | 62496000.0 |
| 2000-12-14 13:00:00 | NVDA | Stock | 0.175 | 0.1755 | 0.1729 | 0.1742 | 10872000.0 |
| 2000-12-14 14:00:00 | NVDA | Stock | 0.1742 | 0.1747 | 0.1729 | 0.1745 | 49320000.0 |
| 2000-12-14 15:00:00 | NVDA | Stock | 0.175 | 0.1755 | 0.1716 | 0.1732 | 122760000.0 |
| 2000-12-14 16:00:00 | NVDA | Stock | 0.1727 | 0.1732 | 0.1667 | 0.1667 | 50088000.0 |
| 2000-12-14 17:00:00 | NVDA | Stock | 0.1667 | 0.1667 | 0.1646 | 0.1646 | 240000.0 |
| 2000-12-14 08:00:00 | AMZN | Stock | 1.1875 | 1.225 | 1.1875 | 1.2062 | 996000.0 |
| 2000-12-14 09:00:00 | AMZN | Stock | 1.2188 | 1.2438 | 1.175 | 1.1938 | 29222000.0 |
| 2000-12-14 10:00:00 | AMZN | Stock | 1.1922 | 1.1938 | 1.1297 | 1.1562 | 26258000.0 |
| 2000-12-14 11:00:00 | AMZN | Stock | 1.1594 | 1.2031 | 1.1562 | 1.2031 | 12822000.0 |
| 2000-12-14 12:00:00 | AMZN | Stock | 1.2 | 1.225 | 1.1844 | 1.1906 | 11888000.0 |
| 2000-12-14 13:00:00 | AMZN | Stock | 1.1969 | 1.1969 | 1.1531 | 1.1656 | 8682000.0 |
| 2000-12-14 14:00:00 | AMZN | Stock | 1.1656 | 1.1688 | 1.1344 | 1.1344 | 16178000.0 |
| 2000-12-14 15:00:00 | AMZN | Stock | 1.1375 | 1.1625 | 1.1312 | 1.1375 | 23888000.0 |
| 2000-12-14 16:00:00 | AMZN | Stock | 1.1375 | 1.2125 | 1.1031 | 1.2125 | 2726000.0 |
| 2000-12-14 17:00:00 | AMZN | Stock | 1.1344 | 1.1375 | 1.1188 | 1.1375 | 80000.0 |
| 2000-12-14 18:00:00 | AMZN | Stock | 1.1344 | 1.1344 | 1.125 | 1.125 | 62000.0 |
| 2000-12-14 09:00:00 | CL | Stock | 28.625 | 28.8 | 28.625 | 28.8 | 244800.0 |
| 2000-12-14 10:00:00 | CL | Stock | 28.875 | 28.875 | 28.625 | 28.65 | 647200.0 |
| 2000-12-14 11:00:00 | CL | Stock | 28.65 | 28.745 | 28.625 | 28.7 | 292400.0 |
| 2000-12-14 12:00:00 | CL | Stock | 28.72 | 29.0 | 28.72 | 28.85 | 431400.0 |
| 2000-12-14 13:00:00 | CL | Stock | 28.85 | 28.855 | 28.63 | 28.765 | 270800.0 |
| 2000-12-14 14:00:00 | CL | Stock | 28.765 | 28.9 | 28.7 | 28.875 | 424000.0 |
| 2000-12-14 15:00:00 | CL | Stock | 28.88 | 28.995 | 28.81 | 28.825 | 581000.0 |
> showing 50 of 16,267 rows — these rows as CSV