PREVIEW / stock_1hour / 2004-04-22
file: by_date/stock_1hour/2004/2004-04-22.parquet size: 537 KB rows: 24,839 symbols: 1,758
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-04-22 08:00:00 | AAPL | Stock | 0.4941 | 0.4948 | 0.4939 | 0.4948 | 78400.0 |
| 2004-04-22 09:00:00 | AAPL | Stock | 0.4945 | 0.4945 | 0.4841 | 0.4888 | 40273296.0 |
| 2004-04-22 10:00:00 | AAPL | Stock | 0.4886 | 0.4938 | 0.4871 | 0.4923 | 43725472.0 |
| 2004-04-22 11:00:00 | AAPL | Stock | 0.4925 | 0.5032 | 0.4925 | 0.5013 | 78788192.0 |
| 2004-04-22 12:00:00 | AAPL | Stock | 0.5014 | 0.502 | 0.4973 | 0.4982 | 40411112.0 |
| 2004-04-22 13:00:00 | AAPL | Stock | 0.4982 | 0.5002 | 0.498 | 0.4988 | 28331464.0 |
| 2004-04-22 14:00:00 | AAPL | Stock | 0.4984 | 0.4989 | 0.4955 | 0.4975 | 29728776.0 |
| 2004-04-22 15:00:00 | AAPL | Stock | 0.4977 | 0.4989 | 0.4952 | 0.4963 | 67866120.0 |
| 2004-04-22 16:00:00 | AAPL | Stock | 0.4968 | 0.498 | 0.4961 | 0.4964 | 2213120.0 |
| 2004-04-22 17:00:00 | AAPL | Stock | 0.4964 | 0.4965 | 0.4964 | 0.4964 | 86744.0 |
| 2004-04-22 18:00:00 | AAPL | Stock | 0.4979 | 0.4979 | 0.4979 | 0.4979 | 33600.0 |
| 2004-04-22 08:00:00 | MSFT | Stock | 25.455 | 25.6 | 25.44 | 25.5 | 113280.0 |
| 2004-04-22 09:00:00 | MSFT | Stock | 25.5 | 25.8 | 25.45 | 25.66 | 9428327.0 |
| 2004-04-22 10:00:00 | MSFT | Stock | 25.66 | 25.7 | 25.48 | 25.57 | 10048059.0 |
| 2004-04-22 11:00:00 | MSFT | Stock | 25.57 | 25.84 | 25.56 | 25.769 | 14403077.0 |
| 2004-04-22 12:00:00 | MSFT | Stock | 25.77 | 25.82 | 25.72 | 25.75 | 8223305.0 |
| 2004-04-22 13:00:00 | MSFT | Stock | 25.75 | 25.85 | 25.67 | 25.68 | 9472768.0 |
| 2004-04-22 14:00:00 | MSFT | Stock | 25.679 | 25.82 | 25.67 | 25.79 | 9448525.0 |
| 2004-04-22 15:00:00 | MSFT | Stock | 25.8 | 25.99 | 25.75 | 25.95 | 17457540.0 |
| 2004-04-22 16:00:00 | MSFT | Stock | 25.97 | 27.65 | 25.51 | 27.3 | 13855876.0 |
| 2004-04-22 17:00:00 | MSFT | Stock | 27.33 | 27.48 | 25.7618 | 27.33 | 2070665.0 |
| 2004-04-22 18:00:00 | MSFT | Stock | 27.33 | 27.46 | 27.2 | 27.2 | 344482.0 |
| 2004-04-22 08:00:00 | NVDA | Stock | 0.1877 | 0.1883 | 0.1877 | 0.1883 | 72000.0 |
| 2004-04-22 09:00:00 | NVDA | Stock | 0.1883 | 0.1883 | 0.1831 | 0.1832 | 84889800.0 |
| 2004-04-22 10:00:00 | NVDA | Stock | 0.1832 | 0.185 | 0.1827 | 0.1849 | 128453400.0 |
| 2004-04-22 11:00:00 | NVDA | Stock | 0.185 | 0.1887 | 0.185 | 0.1887 | 116400600.0 |
| 2004-04-22 12:00:00 | NVDA | Stock | 0.1887 | 0.19 | 0.1877 | 0.1895 | 75008640.0 |
| 2004-04-22 13:00:00 | NVDA | Stock | 0.1895 | 0.1922 | 0.1895 | 0.1919 | 86194680.0 |
| 2004-04-22 14:00:00 | NVDA | Stock | 0.1917 | 0.1927 | 0.191 | 0.1922 | 47611560.0 |
| 2004-04-22 15:00:00 | NVDA | Stock | 0.1924 | 0.1924 | 0.1889 | 0.1896 | 111556800.0 |
| 2004-04-22 16:00:00 | NVDA | Stock | 0.1893 | 0.1899 | 0.1889 | 0.1898 | 4721760.0 |
| 2004-04-22 17:00:00 | NVDA | Stock | 0.192 | 0.192 | 0.1899 | 0.1899 | 79200.0 |
| 2004-04-22 18:00:00 | NVDA | Stock | 0.1898 | 0.1899 | 0.1898 | 0.1899 | 168000.0 |
| 2004-04-22 08:00:00 | AMZN | Stock | 2.319 | 2.319 | 2.2825 | 2.2955 | 310600.0 |
| 2004-04-22 09:00:00 | AMZN | Stock | 2.3 | 2.339 | 2.2885 | 2.334 | 16549620.0 |
| 2004-04-22 10:00:00 | AMZN | Stock | 2.334 | 2.3485 | 2.3135 | 2.3415 | 24278140.0 |
| 2004-04-22 11:00:00 | AMZN | Stock | 2.3415 | 2.417 | 2.3414 | 2.408 | 50721500.0 |
| 2004-04-22 12:00:00 | AMZN | Stock | 2.4075 | 2.4125 | 2.3815 | 2.4005 | 27409120.0 |
| 2004-04-22 13:00:00 | AMZN | Stock | 2.4005 | 2.447 | 2.397 | 2.4195 | 36670840.0 |
| 2004-04-22 14:00:00 | AMZN | Stock | 2.42 | 2.4285 | 2.416 | 2.422 | 37584780.0 |
| 2004-04-22 15:00:00 | AMZN | Stock | 2.422 | 2.455 | 2.4135 | 2.4425 | 66750080.0 |
| 2004-04-22 16:00:00 | AMZN | Stock | 2.443 | 2.4875 | 2.326 | 2.387 | 43213360.0 |
| 2004-04-22 17:00:00 | AMZN | Stock | 2.3865 | 2.4035 | 2.365 | 2.3725 | 5355420.0 |
| 2004-04-22 18:00:00 | AMZN | Stock | 2.37 | 2.38 | 2.3525 | 2.375 | 1691940.0 |
| 2004-04-22 09:00:00 | CL | Stock | 28.05 | 28.05 | 27.765 | 27.835 | 519800.0 |
| 2004-04-22 10:00:00 | CL | Stock | 27.835 | 28.0 | 27.825 | 27.98 | 494600.0 |
| 2004-04-22 11:00:00 | CL | Stock | 27.99 | 28.26 | 27.98 | 28.06 | 701600.0 |
| 2004-04-22 12:00:00 | CL | Stock | 28.06 | 28.13 | 27.975 | 27.98 | 622800.0 |
| 2004-04-22 13:00:00 | CL | Stock | 27.98 | 28.095 | 27.975 | 28.015 | 636400.0 |
| 2004-04-22 14:00:00 | CL | Stock | 28.02 | 28.075 | 27.975 | 28.07 | 586600.0 |
> showing 50 of 24,839 rows — these rows as CSV