PREVIEW / stock_1hour / 2004-12-20
file: by_date/stock_1hour/2004/2004-12-20.parquet size: 543 KB rows: 25,402 symbols: 1,908
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-12-20 08:00:00 | AAPL | Stock | 1.1696 | 1.1786 | 1.1661 | 1.1673 | 3044440.0 |
| 2004-12-20 09:00:00 | AAPL | Stock | 1.1684 | 1.1786 | 1.1625 | 1.1677 | 117375104.0 |
| 2004-12-20 10:00:00 | AAPL | Stock | 1.1675 | 1.1716 | 1.133 | 1.1371 | 233358944.0 |
| 2004-12-20 11:00:00 | AAPL | Stock | 1.1375 | 1.1429 | 1.1277 | 1.1304 | 134013432.0 |
| 2004-12-20 12:00:00 | AAPL | Stock | 1.1307 | 1.1348 | 1.128 | 1.1314 | 72942632.0 |
| 2004-12-20 13:00:00 | AAPL | Stock | 1.1316 | 1.1368 | 1.1188 | 1.1205 | 113173480.0 |
| 2004-12-20 14:00:00 | AAPL | Stock | 1.1202 | 1.1243 | 1.112 | 1.1141 | 147892192.0 |
| 2004-12-20 15:00:00 | AAPL | Stock | 1.1141 | 1.1223 | 1.1029 | 1.1193 | 292338760.0 |
| 2004-12-20 16:00:00 | AAPL | Stock | 1.1196 | 1.1209 | 1.1161 | 1.1166 | 11703832.0 |
| 2004-12-20 17:00:00 | AAPL | Stock | 1.118 | 1.1196 | 1.1161 | 1.1188 | 601272.0 |
| 2004-12-20 18:00:00 | AAPL | Stock | 1.1188 | 1.1188 | 1.1161 | 1.1166 | 201600.0 |
| 2004-12-20 08:00:00 | MSFT | Stock | 27.0 | 27.1 | 27.0 | 27.04 | 53937.0 |
| 2004-12-20 09:00:00 | MSFT | Stock | 27.04 | 27.15 | 26.94 | 27.12 | 8745034.0 |
| 2004-12-20 10:00:00 | MSFT | Stock | 27.13 | 27.14 | 27.0 | 27.03 | 16254817.0 |
| 2004-12-20 11:00:00 | MSFT | Stock | 27.03 | 27.12 | 26.99 | 27.02 | 15846683.0 |
| 2004-12-20 12:00:00 | MSFT | Stock | 27.02 | 27.03 | 26.92 | 26.93 | 10934020.0 |
| 2004-12-20 13:00:00 | MSFT | Stock | 26.93 | 26.98 | 26.89 | 26.91 | 10014339.0 |
| 2004-12-20 14:00:00 | MSFT | Stock | 26.908 | 26.97 | 26.89 | 26.92 | 9592750.0 |
| 2004-12-20 15:00:00 | MSFT | Stock | 26.92 | 26.981 | 26.89 | 26.93 | 9795346.0 |
| 2004-12-20 16:00:00 | MSFT | Stock | 26.94 | 26.99 | 26.92 | 26.95 | 2895462.0 |
| 2004-12-20 17:00:00 | MSFT | Stock | 26.98 | 27.02 | 26.94 | 27.0 | 60410.0 |
| 2004-12-20 18:00:00 | MSFT | Stock | 26.97 | 27.0 | 26.97 | 27.0 | 4900.0 |
| 2004-12-20 08:00:00 | NVDA | Stock | 0.1938 | 0.1951 | 0.193 | 0.1939 | 3015000.0 |
| 2004-12-20 09:00:00 | NVDA | Stock | 0.1946 | 0.1974 | 0.193 | 0.1957 | 194235360.0 |
| 2004-12-20 10:00:00 | NVDA | Stock | 0.1956 | 0.1965 | 0.1937 | 0.1949 | 111013440.0 |
| 2004-12-20 11:00:00 | NVDA | Stock | 0.1949 | 0.1949 | 0.1916 | 0.1918 | 123602040.0 |
| 2004-12-20 12:00:00 | NVDA | Stock | 0.1917 | 0.1925 | 0.1909 | 0.1912 | 102312600.0 |
| 2004-12-20 13:00:00 | NVDA | Stock | 0.1912 | 0.1918 | 0.1894 | 0.1898 | 40626120.0 |
| 2004-12-20 14:00:00 | NVDA | Stock | 0.1899 | 0.191 | 0.1892 | 0.1903 | 62480400.0 |
| 2004-12-20 15:00:00 | NVDA | Stock | 0.1904 | 0.1907 | 0.1891 | 0.1902 | 162703080.0 |
| 2004-12-20 16:00:00 | NVDA | Stock | 0.1901 | 0.1908 | 0.1895 | 0.1901 | 6962520.0 |
| 2004-12-20 17:00:00 | NVDA | Stock | 0.1901 | 0.1901 | 0.1901 | 0.1901 | 42000.0 |
| 2004-12-20 18:00:00 | NVDA | Stock | 0.1908 | 0.1908 | 0.1902 | 0.1902 | 111000.0 |
| 2004-12-20 08:00:00 | AMZN | Stock | 2.001 | 2.0035 | 2.001 | 2.001 | 106000.0 |
| 2004-12-20 09:00:00 | AMZN | Stock | 2.001 | 2.0245 | 1.9785 | 2.02 | 28029100.0 |
| 2004-12-20 10:00:00 | AMZN | Stock | 2.02 | 2.022 | 1.992 | 1.9955 | 19032940.0 |
| 2004-12-20 11:00:00 | AMZN | Stock | 1.9955 | 1.9985 | 1.985 | 1.985 | 19072000.0 |
| 2004-12-20 12:00:00 | AMZN | Stock | 1.9854 | 1.9855 | 1.9665 | 1.972 | 19898760.0 |
| 2004-12-20 13:00:00 | AMZN | Stock | 1.9705 | 1.9765 | 1.958 | 1.9585 | 9072060.0 |
| 2004-12-20 14:00:00 | AMZN | Stock | 1.958 | 1.959 | 1.9475 | 1.954 | 19864680.0 |
| 2004-12-20 15:00:00 | AMZN | Stock | 1.9535 | 1.9588 | 1.9405 | 1.9475 | 22825160.0 |
| 2004-12-20 16:00:00 | AMZN | Stock | 1.9475 | 1.949 | 1.941 | 1.945 | 2395260.0 |
| 2004-12-20 17:00:00 | AMZN | Stock | 1.9475 | 1.9475 | 1.941 | 1.944 | 314760.0 |
| 2004-12-20 18:00:00 | AMZN | Stock | 1.9465 | 1.9465 | 1.944 | 1.946 | 655960.0 |
| 2004-12-20 09:00:00 | CL | Stock | 24.96 | 25.06 | 24.92 | 25.055 | 449400.0 |
| 2004-12-20 10:00:00 | CL | Stock | 25.05 | 25.225 | 25.0 | 25.2 | 701400.0 |
| 2004-12-20 11:00:00 | CL | Stock | 25.195 | 25.2 | 25.08 | 25.165 | 587400.0 |
| 2004-12-20 12:00:00 | CL | Stock | 25.2 | 25.27 | 25.13 | 25.2 | 578000.0 |
| 2004-12-20 13:00:00 | CL | Stock | 25.2 | 25.31 | 25.185 | 25.225 | 627800.0 |
| 2004-12-20 14:00:00 | CL | Stock | 25.225 | 25.26 | 25.18 | 25.185 | 693800.0 |
> showing 50 of 25,402 rows — these rows as CSV