PREVIEW / stock_1hour / 2004-12-21
file: by_date/stock_1hour/2004/2004-12-21.parquet size: 554 KB rows: 25,613 symbols: 1,910
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-21 08:00:00 | AAPL | Stock | 1.1211 | 1.1375 | 1.1211 | 1.1321 | 5017432.0 |
| 2004-12-21 09:00:00 | AAPL | Stock | 1.1321 | 1.1357 | 1.1 | 1.1163 | 239343104.0 |
| 2004-12-21 10:00:00 | AAPL | Stock | 1.1163 | 1.1314 | 1.1113 | 1.1255 | 216178200.0 |
| 2004-12-21 11:00:00 | AAPL | Stock | 1.1257 | 1.1314 | 1.1223 | 1.1286 | 109181016.0 |
| 2004-12-21 12:00:00 | AAPL | Stock | 1.1284 | 1.1304 | 1.1161 | 1.1277 | 129993640.0 |
| 2004-12-21 13:00:00 | AAPL | Stock | 1.1275 | 1.133 | 1.1241 | 1.1268 | 90308400.0 |
| 2004-12-21 14:00:00 | AAPL | Stock | 1.1264 | 1.1277 | 1.1227 | 1.1234 | 60815552.0 |
| 2004-12-21 15:00:00 | AAPL | Stock | 1.123 | 1.1388 | 1.123 | 1.1366 | 185710560.0 |
| 2004-12-21 16:00:00 | AAPL | Stock | 1.137 | 1.1379 | 1.1288 | 1.1323 | 10673488.0 |
| 2004-12-21 17:00:00 | AAPL | Stock | 1.1321 | 1.1373 | 1.1275 | 1.1348 | 1679608.0 |
| 2004-12-21 18:00:00 | AAPL | Stock | 1.1346 | 1.1346 | 1.1313 | 1.1343 | 114800.0 |
| 2004-12-21 08:00:00 | MSFT | Stock | 27.0 | 27.04 | 26.902 | 26.99 | 31411.0 |
| 2004-12-21 09:00:00 | MSFT | Stock | 26.98 | 27.06 | 26.97 | 27.02 | 7328322.0 |
| 2004-12-21 10:00:00 | MSFT | Stock | 27.02 | 27.04 | 26.95 | 26.96 | 14329699.0 |
| 2004-12-21 11:00:00 | MSFT | Stock | 26.96 | 27.05 | 26.94 | 27.03 | 12049426.0 |
| 2004-12-21 12:00:00 | MSFT | Stock | 27.03 | 27.06 | 27.0 | 27.031 | 10407520.0 |
| 2004-12-21 13:00:00 | MSFT | Stock | 27.04 | 27.04 | 26.99 | 27.01 | 9632995.0 |
| 2004-12-21 14:00:00 | MSFT | Stock | 27.01 | 27.11 | 26.99 | 27.101 | 13304106.0 |
| 2004-12-21 15:00:00 | MSFT | Stock | 27.11 | 27.16 | 27.04 | 27.06 | 23254539.0 |
| 2004-12-21 16:00:00 | MSFT | Stock | 27.06 | 27.09 | 27.03 | 27.05 | 3368544.0 |
| 2004-12-21 17:00:00 | MSFT | Stock | 27.05 | 27.07 | 26.9094 | 27.05 | 37343.0 |
| 2004-12-21 18:00:00 | MSFT | Stock | 27.04 | 27.06 | 27.04 | 27.06 | 1725.0 |
| 2004-12-21 08:00:00 | NVDA | Stock | 0.1879 | 0.1903 | 0.1871 | 0.1895 | 2323200.0 |
| 2004-12-21 09:00:00 | NVDA | Stock | 0.1904 | 0.1928 | 0.1888 | 0.1903 | 121073160.0 |
| 2004-12-21 10:00:00 | NVDA | Stock | 0.1903 | 0.1903 | 0.1868 | 0.1875 | 155756760.0 |
| 2004-12-21 11:00:00 | NVDA | Stock | 0.1875 | 0.1876 | 0.1854 | 0.187 | 142816800.0 |
| 2004-12-21 12:00:00 | NVDA | Stock | 0.1869 | 0.1913 | 0.1865 | 0.1911 | 105210840.0 |
| 2004-12-21 13:00:00 | NVDA | Stock | 0.1912 | 0.1912 | 0.189 | 0.1894 | 67314840.0 |
| 2004-12-21 14:00:00 | NVDA | Stock | 0.1894 | 0.1918 | 0.1887 | 0.1911 | 95790600.0 |
| 2004-12-21 15:00:00 | NVDA | Stock | 0.1911 | 0.1915 | 0.1896 | 0.1912 | 165873480.0 |
| 2004-12-21 16:00:00 | NVDA | Stock | 0.1912 | 0.1917 | 0.1892 | 0.1913 | 6421200.0 |
| 2004-12-21 17:00:00 | NVDA | Stock | 0.1908 | 0.1915 | 0.1904 | 0.1915 | 247560.0 |
| 2004-12-21 18:00:00 | NVDA | Stock | 0.1913 | 0.1913 | 0.1913 | 0.1913 | 39480.0 |
| 2004-12-21 08:00:00 | AMZN | Stock | 1.9455 | 1.9455 | 1.945 | 1.945 | 30000.0 |
| 2004-12-21 09:00:00 | AMZN | Stock | 1.945 | 1.967 | 1.9415 | 1.965 | 20516880.0 |
| 2004-12-21 10:00:00 | AMZN | Stock | 1.9655 | 1.9685 | 1.938 | 1.938 | 17706900.0 |
| 2004-12-21 11:00:00 | AMZN | Stock | 1.939 | 1.9585 | 1.932 | 1.9545 | 18525180.0 |
| 2004-12-21 12:00:00 | AMZN | Stock | 1.9544 | 1.968 | 1.952 | 1.967 | 12093120.0 |
| 2004-12-21 13:00:00 | AMZN | Stock | 1.9665 | 1.968 | 1.96 | 1.9675 | 6966500.0 |
| 2004-12-21 14:00:00 | AMZN | Stock | 1.9674 | 1.9675 | 1.963 | 1.9665 | 8268640.0 |
| 2004-12-21 15:00:00 | AMZN | Stock | 1.9665 | 1.9685 | 1.953 | 1.9665 | 15493100.0 |
| 2004-12-21 16:00:00 | AMZN | Stock | 1.967 | 1.971 | 1.961 | 1.9694 | 2153140.0 |
| 2004-12-21 17:00:00 | AMZN | Stock | 1.968 | 1.968 | 1.9445 | 1.9655 | 95200.0 |
| 2004-12-21 09:00:00 | CL | Stock | 25.1 | 25.27 | 25.025 | 25.26 | 466800.0 |
| 2004-12-21 10:00:00 | CL | Stock | 25.26 | 25.3 | 25.16 | 25.165 | 873200.0 |
| 2004-12-21 11:00:00 | CL | Stock | 25.17 | 25.255 | 25.13 | 25.17 | 591800.0 |
| 2004-12-21 12:00:00 | CL | Stock | 25.17 | 25.205 | 25.11 | 25.2 | 387200.0 |
| 2004-12-21 13:00:00 | CL | Stock | 25.21 | 25.245 | 25.12 | 25.245 | 470800.0 |
| 2004-12-21 14:00:00 | CL | Stock | 25.245 | 25.27 | 25.215 | 25.265 | 502800.0 |
| 2004-12-21 15:00:00 | CL | Stock | 25.265 | 25.295 | 25.18 | 25.225 | 931000.0 |
> showing 50 of 25,613 rows — these rows as CSV