PREVIEW / stock_1hour / 2002-12-10
file: by_date/stock_1hour/2002/2002-12-10.parquet size: 414 KB rows: 19,632 symbols: 1,524
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-10 08:00:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.2643 | 0.2643 | 78400.0 |
| 2002-12-10 09:00:00 | AAPL | Stock | 0.2645 | 0.2659 | 0.263 | 0.2645 | 17398472.0 |
| 2002-12-10 10:00:00 | AAPL | Stock | 0.2646 | 0.2666 | 0.2639 | 0.2666 | 28535024.0 |
| 2002-12-10 11:00:00 | AAPL | Stock | 0.2666 | 0.2723 | 0.2666 | 0.2714 | 52544016.0 |
| 2002-12-10 12:00:00 | AAPL | Stock | 0.2716 | 0.2725 | 0.2705 | 0.2714 | 33406016.0 |
| 2002-12-10 13:00:00 | AAPL | Stock | 0.2713 | 0.275 | 0.2702 | 0.2732 | 65170952.0 |
| 2002-12-10 14:00:00 | AAPL | Stock | 0.2732 | 0.2741 | 0.2709 | 0.2725 | 24221288.0 |
| 2002-12-10 15:00:00 | AAPL | Stock | 0.2723 | 0.2759 | 0.2711 | 0.2736 | 58214184.0 |
| 2002-12-10 16:00:00 | AAPL | Stock | 0.2734 | 0.2738 | 0.2714 | 0.2729 | 8835344.0 |
| 2002-12-10 17:00:00 | AAPL | Stock | 0.2729 | 0.2729 | 0.2729 | 0.2729 | 1282400.0 |
| 2002-12-10 08:00:00 | MSFT | Stock | 27.03 | 27.03 | 26.75 | 26.845 | 2136000.0 |
| 2002-12-10 09:00:00 | MSFT | Stock | 26.845 | 26.985 | 26.74 | 26.96 | 8132256.0 |
| 2002-12-10 10:00:00 | MSFT | Stock | 26.96 | 27.24 | 26.955 | 27.03 | 12423540.0 |
| 2002-12-10 11:00:00 | MSFT | Stock | 27.035 | 27.24 | 27.03 | 27.16 | 9750568.0 |
| 2002-12-10 12:00:00 | MSFT | Stock | 27.17 | 27.17 | 27.035 | 27.154 | 3123024.0 |
| 2002-12-10 13:00:00 | MSFT | Stock | 27.15 | 27.2 | 27.06 | 27.195 | 3813612.0 |
| 2002-12-10 14:00:00 | MSFT | Stock | 27.2 | 27.225 | 27.05 | 27.075 | 7879660.0 |
| 2002-12-10 15:00:00 | MSFT | Stock | 27.07 | 27.215 | 26.979 | 27.03 | 10082828.0 |
| 2002-12-10 16:00:00 | MSFT | Stock | 27.05 | 27.1048 | 26.875 | 26.94 | 2847148.0 |
| 2002-12-10 17:00:00 | MSFT | Stock | 27.005 | 27.005 | 26.94 | 26.99 | 31170.0 |
| 2002-12-10 18:00:00 | MSFT | Stock | 26.975 | 26.99 | 26.975 | 26.99 | 3200.0 |
| 2002-12-10 08:00:00 | NVDA | Stock | 0.1158 | 0.1158 | 0.1101 | 0.1116 | 4746000.0 |
| 2002-12-10 09:00:00 | NVDA | Stock | 0.1117 | 0.112 | 0.1097 | 0.1106 | 149659560.0 |
| 2002-12-10 10:00:00 | NVDA | Stock | 0.1107 | 0.1132 | 0.1101 | 0.1124 | 194137440.0 |
| 2002-12-10 11:00:00 | NVDA | Stock | 0.1123 | 0.1165 | 0.1122 | 0.1164 | 255226680.0 |
| 2002-12-10 12:00:00 | NVDA | Stock | 0.1164 | 0.1178 | 0.1153 | 0.1172 | 128963400.0 |
| 2002-12-10 13:00:00 | NVDA | Stock | 0.1173 | 0.1196 | 0.1164 | 0.1193 | 142764120.0 |
| 2002-12-10 14:00:00 | NVDA | Stock | 0.1194 | 0.1196 | 0.1176 | 0.1187 | 166828800.0 |
| 2002-12-10 15:00:00 | NVDA | Stock | 0.1188 | 0.1191 | 0.117 | 0.1174 | 252995040.0 |
| 2002-12-10 16:00:00 | NVDA | Stock | 0.1175 | 0.118 | 0.1161 | 0.1171 | 23426640.0 |
| 2002-12-10 17:00:00 | NVDA | Stock | 0.1171 | 0.1183 | 0.1171 | 0.1175 | 1333800.0 |
| 2002-12-10 18:00:00 | NVDA | Stock | 0.1176 | 0.1183 | 0.1172 | 0.1179 | 480000.0 |
| 2002-12-10 08:00:00 | AMZN | Stock | 1.1015 | 1.1375 | 1.09 | 1.101 | 866000.0 |
| 2002-12-10 09:00:00 | AMZN | Stock | 1.1025 | 1.1025 | 1.062 | 1.066 | 31110780.0 |
| 2002-12-10 10:00:00 | AMZN | Stock | 1.066 | 1.081 | 1.065 | 1.0785 | 26863080.0 |
| 2002-12-10 11:00:00 | AMZN | Stock | 1.0775 | 1.0855 | 1.074 | 1.0795 | 18930380.0 |
| 2002-12-10 12:00:00 | AMZN | Stock | 1.08 | 1.0835 | 1.0765 | 1.0825 | 13767480.0 |
| 2002-12-10 13:00:00 | AMZN | Stock | 1.0825 | 1.09 | 1.0815 | 1.089 | 9742640.0 |
| 2002-12-10 14:00:00 | AMZN | Stock | 1.0894 | 1.0896 | 1.08 | 1.0815 | 11434380.0 |
| 2002-12-10 15:00:00 | AMZN | Stock | 1.0815 | 1.095 | 1.08 | 1.0925 | 16927480.0 |
| 2002-12-10 16:00:00 | AMZN | Stock | 1.0925 | 1.093 | 1.089 | 1.089 | 3349740.0 |
| 2002-12-10 17:00:00 | AMZN | Stock | 1.093 | 1.095 | 1.093 | 1.095 | 250000.0 |
| 2002-12-10 18:00:00 | AMZN | Stock | 1.095 | 1.095 | 1.095 | 1.095 | 6000.0 |
| 2002-12-10 09:00:00 | CL | Stock | 26.83 | 26.83 | 26.62 | 26.765 | 443200.0 |
| 2002-12-10 10:00:00 | CL | Stock | 26.755 | 26.865 | 26.72 | 26.78 | 266400.0 |
| 2002-12-10 11:00:00 | CL | Stock | 26.795 | 26.91 | 26.7 | 26.725 | 295800.0 |
| 2002-12-10 12:00:00 | CL | Stock | 26.725 | 26.75 | 26.625 | 26.72 | 186400.0 |
| 2002-12-10 13:00:00 | CL | Stock | 26.745 | 26.85 | 26.725 | 26.815 | 153600.0 |
| 2002-12-10 14:00:00 | CL | Stock | 26.82 | 26.92 | 26.75 | 26.86 | 293200.0 |
| 2002-12-10 15:00:00 | CL | Stock | 26.86 | 27.07 | 26.835 | 27.04 | 545400.0 |
> showing 50 of 19,632 rows — these rows as CSV