PREVIEW / stock_1hour / 2004-02-04
file: by_date/stock_1hour/2004/2004-02-04.parquet size: 513 KB rows: 23,483 symbols: 1,720
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 |
|---|---|---|---|---|---|---|---|
| 2004-02-04 08:00:00 | AAPL | Stock | 0.3946 | 0.3946 | 0.3934 | 0.3934 | 100800.0 |
| 2004-02-04 09:00:00 | AAPL | Stock | 0.3936 | 0.3943 | 0.3895 | 0.393 | 36680504.0 |
| 2004-02-04 10:00:00 | AAPL | Stock | 0.3929 | 0.3945 | 0.3896 | 0.3904 | 37687328.0 |
| 2004-02-04 11:00:00 | AAPL | Stock | 0.3904 | 0.3916 | 0.3884 | 0.3895 | 24353392.0 |
| 2004-02-04 12:00:00 | AAPL | Stock | 0.3893 | 0.3911 | 0.3888 | 0.3895 | 22567328.0 |
| 2004-02-04 13:00:00 | AAPL | Stock | 0.3893 | 0.3918 | 0.3891 | 0.3909 | 27886544.0 |
| 2004-02-04 14:00:00 | AAPL | Stock | 0.3909 | 0.3914 | 0.3879 | 0.3888 | 48883800.0 |
| 2004-02-04 15:00:00 | AAPL | Stock | 0.3889 | 0.3918 | 0.3875 | 0.3889 | 86132424.0 |
| 2004-02-04 16:00:00 | AAPL | Stock | 0.3889 | 0.3918 | 0.3888 | 0.3891 | 13843200.0 |
| 2004-02-04 17:00:00 | AAPL | Stock | 0.3891 | 0.3894 | 0.3891 | 0.3894 | 1155280.0 |
| 2004-02-04 08:00:00 | MSFT | Stock | 27.295 | 27.295 | 25.24 | 27.12 | 82105.0 |
| 2004-02-04 09:00:00 | MSFT | Stock | 27.15 | 27.24 | 27.12 | 27.19 | 6135270.0 |
| 2004-02-04 10:00:00 | MSFT | Stock | 27.19 | 27.24 | 27.05 | 27.18 | 9010455.0 |
| 2004-02-04 11:00:00 | MSFT | Stock | 27.19 | 27.21 | 27.1 | 27.16 | 5866264.0 |
| 2004-02-04 12:00:00 | MSFT | Stock | 27.16 | 27.35 | 27.15 | 27.25 | 7031979.0 |
| 2004-02-04 13:00:00 | MSFT | Stock | 27.25 | 27.43 | 27.2 | 27.22 | 6884165.0 |
| 2004-02-04 14:00:00 | MSFT | Stock | 27.21 | 27.25 | 27.06 | 27.13 | 10414223.0 |
| 2004-02-04 15:00:00 | MSFT | Stock | 27.13 | 27.19 | 27.01 | 27.02 | 10680101.0 |
| 2004-02-04 16:00:00 | MSFT | Stock | 27.03 | 27.12 | 27.0 | 27.05 | 2337729.0 |
| 2004-02-04 17:00:00 | MSFT | Stock | 27.03 | 27.1736 | 27.02 | 27.1736 | 416319.0 |
| 2004-02-04 18:00:00 | MSFT | Stock | 27.08 | 27.09 | 27.03 | 27.04 | 37725.0 |
| 2004-02-04 08:00:00 | NVDA | Stock | 0.1859 | 0.1859 | 0.1859 | 0.1859 | 24000.0 |
| 2004-02-04 09:00:00 | NVDA | Stock | 0.186 | 0.1866 | 0.1837 | 0.1851 | 34079400.0 |
| 2004-02-04 10:00:00 | NVDA | Stock | 0.1851 | 0.1862 | 0.1825 | 0.1852 | 75931560.0 |
| 2004-02-04 11:00:00 | NVDA | Stock | 0.1852 | 0.1859 | 0.1843 | 0.1852 | 40352880.0 |
| 2004-02-04 12:00:00 | NVDA | Stock | 0.1851 | 0.1852 | 0.1843 | 0.1844 | 29694960.0 |
| 2004-02-04 13:00:00 | NVDA | Stock | 0.1844 | 0.1858 | 0.1835 | 0.1836 | 34386960.0 |
| 2004-02-04 14:00:00 | NVDA | Stock | 0.1837 | 0.1846 | 0.1825 | 0.1836 | 70319640.0 |
| 2004-02-04 15:00:00 | NVDA | Stock | 0.1836 | 0.1843 | 0.1824 | 0.1831 | 126011280.0 |
| 2004-02-04 16:00:00 | NVDA | Stock | 0.1825 | 0.1831 | 0.1817 | 0.1817 | 1400280.0 |
| 2004-02-04 17:00:00 | NVDA | Stock | 0.1827 | 0.1827 | 0.1812 | 0.182 | 1224840.0 |
| 2004-02-04 08:00:00 | AMZN | Stock | 2.235 | 2.235 | 2.225 | 2.2275 | 337060.0 |
| 2004-02-04 09:00:00 | AMZN | Stock | 2.229 | 2.277 | 2.215 | 2.265 | 102980620.0 |
| 2004-02-04 10:00:00 | AMZN | Stock | 2.265 | 2.2955 | 2.247 | 2.2755 | 108209620.0 |
| 2004-02-04 11:00:00 | AMZN | Stock | 2.2775 | 2.2788 | 2.253 | 2.2625 | 50422840.0 |
| 2004-02-04 12:00:00 | AMZN | Stock | 2.2625 | 2.2725 | 2.26 | 2.2625 | 32824960.0 |
| 2004-02-04 13:00:00 | AMZN | Stock | 2.2625 | 2.2765 | 2.2625 | 2.2673 | 41659040.0 |
| 2004-02-04 14:00:00 | AMZN | Stock | 2.2674 | 2.2875 | 2.2635 | 2.27 | 38079400.0 |
| 2004-02-04 15:00:00 | AMZN | Stock | 2.2685 | 2.2925 | 2.2635 | 2.271 | 47159660.0 |
| 2004-02-04 16:00:00 | AMZN | Stock | 2.2745 | 2.2825 | 2.2641 | 2.2665 | 3031700.0 |
| 2004-02-04 17:00:00 | AMZN | Stock | 2.2695 | 2.271 | 2.2695 | 2.271 | 440080.0 |
| 2004-02-04 18:00:00 | AMZN | Stock | 2.2675 | 2.2675 | 2.2665 | 2.2675 | 40000.0 |
| 2004-02-04 09:00:00 | CL | Stock | 26.2 | 26.365 | 26.05 | 26.32 | 2083600.0 |
| 2004-02-04 10:00:00 | CL | Stock | 26.32 | 26.8 | 26.32 | 26.75 | 3079800.0 |
| 2004-02-04 11:00:00 | CL | Stock | 26.75 | 26.85 | 26.675 | 26.76 | 1703600.0 |
| 2004-02-04 12:00:00 | CL | Stock | 26.76 | 26.895 | 26.735 | 26.86 | 682600.0 |
| 2004-02-04 13:00:00 | CL | Stock | 26.86 | 26.895 | 26.81 | 26.825 | 1308000.0 |
| 2004-02-04 14:00:00 | CL | Stock | 26.83 | 27.0 | 26.785 | 26.92 | 1501600.0 |
| 2004-02-04 15:00:00 | CL | Stock | 26.925 | 27.08 | 26.88 | 26.885 | 2856000.0 |
| 2004-02-04 16:00:00 | CL | Stock | 26.88 | 26.97 | 26.3 | 26.88 | 588200.0 |
> showing 50 of 23,483 rows — these rows as CSV