PREVIEW / stock_1hour / 2000-05-12
file: by_date/stock_1hour/2000/2000-05-12.parquet size: 278 KB rows: 14,198 symbols: 1,162
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-05-12 09:00:00 | AAPL | Stock | 0.9464 | 0.9598 | 0.9353 | 0.9509 | 56044800.0 |
| 2000-05-12 10:00:00 | AAPL | Stock | 0.9515 | 0.9777 | 0.9498 | 0.9693 | 90910400.0 |
| 2000-05-12 11:00:00 | AAPL | Stock | 0.9688 | 0.9777 | 0.9671 | 0.9738 | 14224000.0 |
| 2000-05-12 12:00:00 | AAPL | Stock | 0.9738 | 0.9866 | 0.9732 | 0.9827 | 34171200.0 |
| 2000-05-12 13:00:00 | AAPL | Stock | 0.9821 | 0.9844 | 0.9754 | 0.9821 | 24091200.0 |
| 2000-05-12 14:00:00 | AAPL | Stock | 0.9816 | 0.9844 | 0.9643 | 0.9693 | 34339200.0 |
| 2000-05-12 15:00:00 | AAPL | Stock | 0.9693 | 0.9727 | 0.9509 | 0.9565 | 36758400.0 |
| 2000-05-12 16:00:00 | AAPL | Stock | 0.9609 | 0.9609 | 0.9565 | 0.9609 | 1478400.0 |
| 2000-05-12 09:00:00 | MSFT | Stock | 34.2188 | 34.6875 | 34.125 | 34.5938 | 7990400.0 |
| 2000-05-12 10:00:00 | MSFT | Stock | 34.6094 | 34.8438 | 34.5625 | 34.7188 | 9129200.0 |
| 2000-05-12 11:00:00 | MSFT | Stock | 34.7188 | 34.875 | 34.6562 | 34.7812 | 4080200.0 |
| 2000-05-12 12:00:00 | MSFT | Stock | 34.7812 | 34.8125 | 34.5938 | 34.5938 | 2618400.0 |
| 2000-05-12 13:00:00 | MSFT | Stock | 34.625 | 34.7188 | 34.5312 | 34.6562 | 2569400.0 |
| 2000-05-12 14:00:00 | MSFT | Stock | 34.6562 | 34.6562 | 34.375 | 34.625 | 4018200.0 |
| 2000-05-12 15:00:00 | MSFT | Stock | 34.5938 | 34.7188 | 34.25 | 34.4688 | 4769800.0 |
| 2000-05-12 16:00:00 | MSFT | Stock | 34.4062 | 34.4375 | 34.375 | 34.4062 | 119800.0 |
| 2000-05-12 09:00:00 | NVDA | Stock | 0.176 | 0.1854 | 0.1729 | 0.1807 | 31440000.0 |
| 2000-05-12 10:00:00 | NVDA | Stock | 0.1802 | 0.1812 | 0.1766 | 0.1799 | 32208000.0 |
| 2000-05-12 11:00:00 | NVDA | Stock | 0.1798 | 0.1828 | 0.1794 | 0.1826 | 23520000.0 |
| 2000-05-12 12:00:00 | NVDA | Stock | 0.1812 | 0.1823 | 0.1797 | 0.1818 | 25344000.0 |
| 2000-05-12 13:00:00 | NVDA | Stock | 0.1815 | 0.1815 | 0.1785 | 0.1789 | 19872000.0 |
| 2000-05-12 14:00:00 | NVDA | Stock | 0.179 | 0.1797 | 0.1767 | 0.1776 | 12288000.0 |
| 2000-05-12 15:00:00 | NVDA | Stock | 0.1771 | 0.1772 | 0.1661 | 0.1661 | 33984000.0 |
| 2000-05-12 16:00:00 | NVDA | Stock | 0.1663 | 0.1663 | 0.1661 | 0.1661 | 6144000.0 |
| 2000-05-12 09:00:00 | AMZN | Stock | 2.7344 | 2.8125 | 2.725 | 2.7812 | 8752000.0 |
| 2000-05-12 10:00:00 | AMZN | Stock | 2.7812 | 2.825 | 2.7562 | 2.8 | 10492000.0 |
| 2000-05-12 11:00:00 | AMZN | Stock | 2.7969 | 2.8188 | 2.7906 | 2.8063 | 4656000.0 |
| 2000-05-12 12:00:00 | AMZN | Stock | 2.8031 | 2.8063 | 2.7688 | 2.7719 | 4722000.0 |
| 2000-05-12 13:00:00 | AMZN | Stock | 2.7719 | 2.7844 | 2.7188 | 2.7625 | 16676000.0 |
| 2000-05-12 14:00:00 | AMZN | Stock | 2.7625 | 2.7672 | 2.7 | 2.7312 | 8020000.0 |
| 2000-05-12 15:00:00 | AMZN | Stock | 2.7281 | 2.7312 | 2.6562 | 2.6906 | 23876000.0 |
| 2000-05-12 16:00:00 | AMZN | Stock | 2.6906 | 2.6906 | 2.6875 | 2.6875 | 68000.0 |
| 2000-05-12 09:00:00 | CL | Stock | 30.0938 | 30.0938 | 29.4375 | 29.625 | 332600.0 |
| 2000-05-12 10:00:00 | CL | Stock | 29.6875 | 29.8438 | 29.5312 | 29.5312 | 399600.0 |
| 2000-05-12 11:00:00 | CL | Stock | 29.5 | 29.625 | 29.4375 | 29.5 | 224800.0 |
| 2000-05-12 12:00:00 | CL | Stock | 29.4688 | 29.5625 | 29.4688 | 29.5312 | 197400.0 |
| 2000-05-12 13:00:00 | CL | Stock | 29.5312 | 29.5625 | 29.0625 | 29.0938 | 164800.0 |
| 2000-05-12 14:00:00 | CL | Stock | 29.0938 | 29.25 | 28.9375 | 29.2188 | 325400.0 |
| 2000-05-12 15:00:00 | CL | Stock | 29.2188 | 29.5 | 29.1562 | 29.4062 | 246000.0 |
| 2000-05-12 16:00:00 | CL | Stock | 29.4062 | 29.4375 | 29.4062 | 29.4062 | 52600.0 |
> showing 40 of 14,198 rows — these rows as CSV