PREVIEW / stock_1hour / 2004-12-28
file: by_date/stock_1hour/2004/2004-12-28.parquet size: 544 KB rows: 25,892 symbols: 1,913
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-28 08:00:00 | AAPL | Stock | 1.1279 | 1.1293 | 1.1279 | 1.1293 | 117600.0 |
| 2004-12-28 09:00:00 | AAPL | Stock | 1.1286 | 1.1318 | 1.1134 | 1.1152 | 71570744.0 |
| 2004-12-28 10:00:00 | AAPL | Stock | 1.1149 | 1.1205 | 1.108 | 1.1198 | 147471240.0 |
| 2004-12-28 11:00:00 | AAPL | Stock | 1.1196 | 1.1209 | 1.1161 | 1.1188 | 56963816.0 |
| 2004-12-28 12:00:00 | AAPL | Stock | 1.1188 | 1.1377 | 1.118 | 1.1361 | 96390224.0 |
| 2004-12-28 13:00:00 | AAPL | Stock | 1.1363 | 1.1434 | 1.1341 | 1.1425 | 64668464.0 |
| 2004-12-28 14:00:00 | AAPL | Stock | 1.1425 | 1.1463 | 1.1391 | 1.1396 | 74478544.0 |
| 2004-12-28 15:00:00 | AAPL | Stock | 1.1396 | 1.1473 | 1.1396 | 1.1455 | 82892880.0 |
| 2004-12-28 16:00:00 | AAPL | Stock | 1.1454 | 1.147 | 1.1446 | 1.1464 | 6992272.0 |
| 2004-12-28 17:00:00 | AAPL | Stock | 1.1461 | 1.1464 | 1.1431 | 1.1431 | 137200.0 |
| 2004-12-28 18:00:00 | AAPL | Stock | 1.147 | 1.1471 | 1.147 | 1.1471 | 39200.0 |
| 2004-12-28 08:00:00 | MSFT | Stock | 26.96 | 26.96 | 26.88 | 26.88 | 7299.0 |
| 2004-12-28 09:00:00 | MSFT | Stock | 26.87 | 26.92 | 26.8 | 26.83 | 5430686.0 |
| 2004-12-28 10:00:00 | MSFT | Stock | 26.84 | 27.021 | 26.83 | 27.01 | 13718117.0 |
| 2004-12-28 11:00:00 | MSFT | Stock | 27.009 | 27.03 | 26.88 | 26.95 | 7400053.0 |
| 2004-12-28 12:00:00 | MSFT | Stock | 26.95 | 26.95 | 26.88 | 26.9 | 5255730.0 |
| 2004-12-28 13:00:00 | MSFT | Stock | 26.9 | 26.959 | 26.89 | 26.93 | 5654419.0 |
| 2004-12-28 14:00:00 | MSFT | Stock | 26.94 | 26.9502 | 26.86 | 26.87 | 7846321.0 |
| 2004-12-28 15:00:00 | MSFT | Stock | 26.878 | 26.97 | 26.86 | 26.96 | 7731108.0 |
| 2004-12-28 16:00:00 | MSFT | Stock | 26.95 | 26.97 | 26.92 | 26.97 | 768636.0 |
| 2004-12-28 17:00:00 | MSFT | Stock | 26.95 | 26.95 | 26.94 | 26.94 | 28280.0 |
| 2004-12-28 18:00:00 | MSFT | Stock | 26.93 | 26.98 | 26.93 | 26.97 | 5705.0 |
| 2004-12-28 09:00:00 | NVDA | Stock | 0.1911 | 0.1921 | 0.1904 | 0.1908 | 27458160.0 |
| 2004-12-28 10:00:00 | NVDA | Stock | 0.1907 | 0.1925 | 0.1907 | 0.1916 | 65515920.0 |
| 2004-12-28 11:00:00 | NVDA | Stock | 0.1916 | 0.1917 | 0.1901 | 0.1902 | 36518640.0 |
| 2004-12-28 12:00:00 | NVDA | Stock | 0.1902 | 0.1902 | 0.1895 | 0.1897 | 33344040.0 |
| 2004-12-28 13:00:00 | NVDA | Stock | 0.1897 | 0.1899 | 0.1892 | 0.1896 | 26128920.0 |
| 2004-12-28 14:00:00 | NVDA | Stock | 0.1896 | 0.1896 | 0.1892 | 0.1892 | 31061040.0 |
| 2004-12-28 15:00:00 | NVDA | Stock | 0.1892 | 0.1895 | 0.1888 | 0.1889 | 60544800.0 |
| 2004-12-28 16:00:00 | NVDA | Stock | 0.1889 | 0.1901 | 0.1886 | 0.1896 | 2849400.0 |
| 2004-12-28 17:00:00 | NVDA | Stock | 0.1894 | 0.1894 | 0.1889 | 0.1889 | 334200.0 |
| 2004-12-28 08:00:00 | AMZN | Stock | 2.1555 | 2.1975 | 2.1555 | 2.1845 | 9900080.0 |
| 2004-12-28 09:00:00 | AMZN | Stock | 2.1845 | 2.2 | 2.1155 | 2.187 | 89565140.0 |
| 2004-12-28 10:00:00 | AMZN | Stock | 2.187 | 2.254 | 2.187 | 2.2515 | 167739680.0 |
| 2004-12-28 11:00:00 | AMZN | Stock | 2.2515 | 2.256 | 2.2315 | 2.238 | 63600980.0 |
| 2004-12-28 12:00:00 | AMZN | Stock | 2.238 | 2.2425 | 2.225 | 2.231 | 43689780.0 |
| 2004-12-28 13:00:00 | AMZN | Stock | 2.2315 | 2.2365 | 2.219 | 2.2325 | 35907520.0 |
| 2004-12-28 14:00:00 | AMZN | Stock | 2.2325 | 2.2405 | 2.229 | 2.2335 | 23143160.0 |
| 2004-12-28 15:00:00 | AMZN | Stock | 2.2335 | 2.242 | 2.228 | 2.231 | 57444160.0 |
| 2004-12-28 16:00:00 | AMZN | Stock | 2.2315 | 2.2425 | 2.231 | 2.236 | 3163020.0 |
| 2004-12-28 17:00:00 | AMZN | Stock | 2.2375 | 2.241 | 2.2315 | 2.241 | 354080.0 |
| 2004-12-28 18:00:00 | AMZN | Stock | 2.241 | 2.241 | 2.234 | 2.24 | 17720.0 |
| 2004-12-28 09:00:00 | CL | Stock | 25.175 | 25.305 | 25.11 | 25.22 | 250200.0 |
| 2004-12-28 10:00:00 | CL | Stock | 25.22 | 25.29 | 25.155 | 25.18 | 420200.0 |
| 2004-12-28 11:00:00 | CL | Stock | 25.19 | 25.23 | 25.165 | 25.225 | 244400.0 |
| 2004-12-28 12:00:00 | CL | Stock | 25.225 | 25.225 | 25.15 | 25.19 | 239400.0 |
| 2004-12-28 13:00:00 | CL | Stock | 25.195 | 25.215 | 25.135 | 25.175 | 281000.0 |
| 2004-12-28 14:00:00 | CL | Stock | 25.185 | 25.19 | 25.135 | 25.15 | 293600.0 |
| 2004-12-28 15:00:00 | CL | Stock | 25.15 | 25.215 | 25.12 | 25.165 | 872200.0 |
| 2004-12-28 16:00:00 | CL | Stock | 25.165 | 25.165 | 25.165 | 25.165 | 1600.0 |
> showing 50 of 25,892 rows — these rows as CSV