PREVIEW / stock_1hour / 2003-06-30
file: by_date/stock_1hour/2003/2003-06-30.parquet size: 537 KB rows: 24,507 symbols: 1,593
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-30 08:00:00 | AAPL | Stock | 0.3357 | 0.3375 | 0.3357 | 0.3375 | 173600.0 |
| 2003-06-30 09:00:00 | AAPL | Stock | 0.3375 | 0.3427 | 0.332 | 0.3427 | 27459376.0 |
| 2003-06-30 10:00:00 | AAPL | Stock | 0.3425 | 0.343 | 0.3393 | 0.3416 | 41104840.0 |
| 2003-06-30 11:00:00 | AAPL | Stock | 0.3414 | 0.3429 | 0.3402 | 0.3405 | 22357160.0 |
| 2003-06-30 12:00:00 | AAPL | Stock | 0.3407 | 0.3422 | 0.3398 | 0.342 | 14676536.0 |
| 2003-06-30 13:00:00 | AAPL | Stock | 0.342 | 0.3429 | 0.3416 | 0.3423 | 18586232.0 |
| 2003-06-30 14:00:00 | AAPL | Stock | 0.3425 | 0.3429 | 0.3407 | 0.3411 | 13893320.0 |
| 2003-06-30 15:00:00 | AAPL | Stock | 0.3411 | 0.3411 | 0.3388 | 0.3395 | 26770296.0 |
| 2003-06-30 16:00:00 | AAPL | Stock | 0.3395 | 0.3415 | 0.3393 | 0.3415 | 10236800.0 |
| 2003-06-30 17:00:00 | AAPL | Stock | 0.3402 | 0.3414 | 0.3402 | 0.3414 | 5930400.0 |
| 2003-06-30 18:00:00 | AAPL | Stock | 0.3413 | 0.3421 | 0.3407 | 0.3414 | 5051200.0 |
| 2003-06-30 08:00:00 | MSFT | Stock | 25.78 | 26.12 | 25.72 | 26.09 | 457135.0 |
| 2003-06-30 09:00:00 | MSFT | Stock | 26.08 | 26.12 | 25.9 | 26.03 | 7865132.0 |
| 2003-06-30 10:00:00 | MSFT | Stock | 26.01 | 26.1 | 25.83 | 25.96 | 8213854.0 |
| 2003-06-30 11:00:00 | MSFT | Stock | 25.957 | 25.98 | 25.75 | 25.77 | 4700841.0 |
| 2003-06-30 12:00:00 | MSFT | Stock | 25.77 | 25.88 | 25.7399 | 25.81 | 3515825.0 |
| 2003-06-30 13:00:00 | MSFT | Stock | 25.81 | 25.991 | 25.7999 | 25.93 | 3624862.0 |
| 2003-06-30 14:00:00 | MSFT | Stock | 25.92 | 25.96 | 25.8499 | 25.93 | 3907102.0 |
| 2003-06-30 15:00:00 | MSFT | Stock | 25.92 | 25.95 | 25.57 | 25.6 | 7151628.0 |
| 2003-06-30 16:00:00 | MSFT | Stock | 25.63 | 25.82 | 25.5 | 25.6133 | 2312927.0 |
| 2003-06-30 17:00:00 | MSFT | Stock | 25.66 | 25.9256 | 25.607 | 25.61 | 2089140.0 |
| 2003-06-30 18:00:00 | MSFT | Stock | 25.616 | 25.699 | 25.5652 | 25.6049 | 1152278.0 |
| 2003-06-30 08:00:00 | NVDA | Stock | 0.19 | 0.1917 | 0.19 | 0.1916 | 984000.0 |
| 2003-06-30 09:00:00 | NVDA | Stock | 0.1925 | 0.1942 | 0.1902 | 0.1926 | 89636640.0 |
| 2003-06-30 10:00:00 | NVDA | Stock | 0.1926 | 0.1935 | 0.1891 | 0.19 | 89398800.0 |
| 2003-06-30 11:00:00 | NVDA | Stock | 0.19 | 0.1914 | 0.1887 | 0.1893 | 68608920.0 |
| 2003-06-30 12:00:00 | NVDA | Stock | 0.1893 | 0.191 | 0.1883 | 0.1909 | 49384080.0 |
| 2003-06-30 13:00:00 | NVDA | Stock | 0.1909 | 0.1917 | 0.1901 | 0.1907 | 33089760.0 |
| 2003-06-30 14:00:00 | NVDA | Stock | 0.1907 | 0.1909 | 0.1894 | 0.1906 | 31020480.0 |
| 2003-06-30 15:00:00 | NVDA | Stock | 0.1906 | 0.1917 | 0.1894 | 0.1912 | 106670640.0 |
| 2003-06-30 16:00:00 | NVDA | Stock | 0.1911 | 0.1918 | 0.1904 | 0.1917 | 33307200.0 |
| 2003-06-30 17:00:00 | NVDA | Stock | 0.1917 | 0.1917 | 0.1903 | 0.1917 | 2219880.0 |
| 2003-06-30 18:00:00 | NVDA | Stock | 0.1917 | 0.1921 | 0.1914 | 0.1917 | 33876000.0 |
| 2003-06-30 08:00:00 | AMZN | Stock | 1.816 | 1.832 | 1.816 | 1.832 | 18300.0 |
| 2003-06-30 09:00:00 | AMZN | Stock | 1.83 | 1.841 | 1.824 | 1.827 | 9974320.0 |
| 2003-06-30 10:00:00 | AMZN | Stock | 1.827 | 1.8285 | 1.8045 | 1.8155 | 17172920.0 |
| 2003-06-30 11:00:00 | AMZN | Stock | 1.815 | 1.818 | 1.8085 | 1.8125 | 7140000.0 |
| 2003-06-30 12:00:00 | AMZN | Stock | 1.813 | 1.8135 | 1.8015 | 1.809 | 7793800.0 |
| 2003-06-30 13:00:00 | AMZN | Stock | 1.8085 | 1.8145 | 1.804 | 1.8125 | 9321800.0 |
| 2003-06-30 14:00:00 | AMZN | Stock | 1.8122 | 1.8185 | 1.801 | 1.8075 | 8706600.0 |
| 2003-06-30 15:00:00 | AMZN | Stock | 1.8065 | 1.824 | 1.8015 | 1.815 | 19932500.0 |
| 2003-06-30 16:00:00 | AMZN | Stock | 1.8175 | 1.8265 | 1.812 | 1.824 | 10771700.0 |
| 2003-06-30 17:00:00 | AMZN | Stock | 1.824 | 1.8267 | 1.8102 | 1.8244 | 1984000.0 |
| 2003-06-30 18:00:00 | AMZN | Stock | 1.8245 | 1.8258 | 1.82 | 1.8241 | 11500000.0 |
| 2003-06-30 09:00:00 | CL | Stock | 28.9 | 29.005 | 28.871 | 28.99 | 231800.0 |
| 2003-06-30 10:00:00 | CL | Stock | 28.985 | 29.05 | 28.88 | 28.96 | 565800.0 |
| 2003-06-30 11:00:00 | CL | Stock | 28.96 | 28.965 | 28.85 | 28.92 | 243600.0 |
| 2003-06-30 12:00:00 | CL | Stock | 28.92 | 29.08 | 28.92 | 29.08 | 314400.0 |
| 2003-06-30 13:00:00 | CL | Stock | 29.08 | 29.195 | 29.06 | 29.195 | 398800.0 |
| 2003-06-30 14:00:00 | CL | Stock | 29.2 | 29.265 | 29.075 | 29.105 | 290400.0 |
> showing 50 of 24,507 rows — these rows as CSV