PREVIEW / stock_1hour / 2004-10-14
file: by_date/stock_1hour/2004/2004-10-14.parquet size: 520 KB rows: 24,266 symbols: 1,833
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-10-14 08:00:00 | AAPL | Stock | 0.7696 | 0.7773 | 0.7661 | 0.7746 | 71276408.0 |
| 2004-10-14 09:00:00 | AAPL | Stock | 0.7745 | 0.7804 | 0.7043 | 0.7611 | 559458536.0 |
| 2004-10-14 10:00:00 | AAPL | Stock | 0.7611 | 0.7925 | 0.7607 | 0.7873 | 557563104.0 |
| 2004-10-14 11:00:00 | AAPL | Stock | 0.7875 | 0.8039 | 0.7864 | 0.7959 | 439068896.0 |
| 2004-10-14 12:00:00 | AAPL | Stock | 0.7957 | 0.8029 | 0.7902 | 0.8007 | 164505880.0 |
| 2004-10-14 13:00:00 | AAPL | Stock | 0.8004 | 0.8155 | 0.8004 | 0.8132 | 274407896.0 |
| 2004-10-14 14:00:00 | AAPL | Stock | 0.8136 | 0.817 | 0.8038 | 0.8102 | 264160848.0 |
| 2004-10-14 15:00:00 | AAPL | Stock | 0.8102 | 0.8125 | 0.7996 | 0.803 | 380541112.0 |
| 2004-10-14 16:00:00 | AAPL | Stock | 0.803 | 0.8039 | 0.8018 | 0.8027 | 7699496.0 |
| 2004-10-14 17:00:00 | AAPL | Stock | 0.8027 | 0.8032 | 0.8007 | 0.8007 | 856016.0 |
| 2004-10-14 18:00:00 | AAPL | Stock | 0.8011 | 0.8011 | 0.8005 | 0.8005 | 235200.0 |
| 2004-10-14 08:00:00 | MSFT | Stock | 28.05 | 28.05 | 28.03 | 28.03 | 2660.0 |
| 2004-10-14 09:00:00 | MSFT | Stock | 28.02 | 28.08 | 27.9 | 28.04 | 4170600.0 |
| 2004-10-14 10:00:00 | MSFT | Stock | 28.04 | 28.16 | 27.98 | 27.99 | 6589618.0 |
| 2004-10-14 11:00:00 | MSFT | Stock | 27.98 | 28.03 | 27.92 | 27.94 | 4750670.0 |
| 2004-10-14 12:00:00 | MSFT | Stock | 27.93 | 28.04 | 27.89 | 27.92 | 4237186.0 |
| 2004-10-14 13:00:00 | MSFT | Stock | 27.92 | 27.97 | 27.81 | 27.88 | 6702291.0 |
| 2004-10-14 14:00:00 | MSFT | Stock | 27.88 | 27.91 | 27.8 | 27.88 | 4944082.0 |
| 2004-10-14 15:00:00 | MSFT | Stock | 27.87 | 27.98 | 27.799 | 27.81 | 7403497.0 |
| 2004-10-14 16:00:00 | MSFT | Stock | 27.8 | 27.83 | 27.78 | 27.79 | 371474.0 |
| 2004-10-14 17:00:00 | MSFT | Stock | 27.8 | 27.85 | 27.8 | 27.85 | 5320.0 |
| 2004-10-14 18:00:00 | MSFT | Stock | 27.85 | 27.85 | 27.85 | 27.85 | 1900.0 |
| 2004-10-14 08:00:00 | NVDA | Stock | 0.1167 | 0.1172 | 0.1167 | 0.1172 | 149400.0 |
| 2004-10-14 09:00:00 | NVDA | Stock | 0.1172 | 0.1188 | 0.1162 | 0.1165 | 52576800.0 |
| 2004-10-14 10:00:00 | NVDA | Stock | 0.1165 | 0.1169 | 0.1154 | 0.1157 | 97486800.0 |
| 2004-10-14 11:00:00 | NVDA | Stock | 0.1157 | 0.1159 | 0.1149 | 0.1152 | 62707200.0 |
| 2004-10-14 12:00:00 | NVDA | Stock | 0.1152 | 0.116 | 0.1149 | 0.1155 | 41712120.0 |
| 2004-10-14 13:00:00 | NVDA | Stock | 0.1155 | 0.1165 | 0.1152 | 0.1163 | 28918080.0 |
| 2004-10-14 14:00:00 | NVDA | Stock | 0.1164 | 0.1164 | 0.1147 | 0.1148 | 56902200.0 |
| 2004-10-14 15:00:00 | NVDA | Stock | 0.1148 | 0.115 | 0.1142 | 0.1146 | 128215440.0 |
| 2004-10-14 16:00:00 | NVDA | Stock | 0.1146 | 0.115 | 0.1142 | 0.1149 | 2987400.0 |
| 2004-10-14 08:00:00 | AMZN | Stock | 2.0 | 2.0 | 1.98 | 1.9825 | 229000.0 |
| 2004-10-14 09:00:00 | AMZN | Stock | 1.985 | 1.989 | 1.9365 | 1.943 | 36589360.0 |
| 2004-10-14 10:00:00 | AMZN | Stock | 1.9435 | 1.9735 | 1.941 | 1.9545 | 38182900.0 |
| 2004-10-14 11:00:00 | AMZN | Stock | 1.9545 | 1.9545 | 1.942 | 1.945 | 26607760.0 |
| 2004-10-14 12:00:00 | AMZN | Stock | 1.945 | 1.9465 | 1.939 | 1.939 | 16252240.0 |
| 2004-10-14 13:00:00 | AMZN | Stock | 1.9395 | 1.951 | 1.9385 | 1.951 | 15283560.0 |
| 2004-10-14 14:00:00 | AMZN | Stock | 1.951 | 1.953 | 1.9415 | 1.9435 | 12031040.0 |
| 2004-10-14 15:00:00 | AMZN | Stock | 1.943 | 1.9545 | 1.939 | 1.953 | 26642640.0 |
| 2004-10-14 16:00:00 | AMZN | Stock | 1.954 | 1.9555 | 1.951 | 1.955 | 1719440.0 |
| 2004-10-14 17:00:00 | AMZN | Stock | 1.955 | 1.961 | 1.9505 | 1.96 | 916180.0 |
| 2004-10-14 09:00:00 | CL | Stock | 21.85 | 21.85 | 21.755 | 21.79 | 746000.0 |
| 2004-10-14 10:00:00 | CL | Stock | 21.79 | 21.82 | 21.73 | 21.745 | 951600.0 |
| 2004-10-14 11:00:00 | CL | Stock | 21.745 | 21.755 | 21.66 | 21.725 | 776000.0 |
| 2004-10-14 12:00:00 | CL | Stock | 21.715 | 21.725 | 21.675 | 21.68 | 467600.0 |
| 2004-10-14 13:00:00 | CL | Stock | 21.68 | 21.76 | 21.61 | 21.76 | 788000.0 |
| 2004-10-14 14:00:00 | CL | Stock | 21.75 | 21.76 | 21.71 | 21.715 | 1188800.0 |
| 2004-10-14 15:00:00 | CL | Stock | 21.72 | 21.755 | 21.665 | 21.725 | 1368800.0 |
| 2004-10-14 16:00:00 | CL | Stock | 21.72 | 21.725 | 21.72 | 21.72 | 7200.0 |
> showing 49 of 24,266 rows — these rows as CSV