PREVIEW / stock_1hour / 2002-12-11
file: by_date/stock_1hour/2002/2002-12-11.parquet size: 415 KB rows: 19,366 symbols: 1,523
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-11 09:00:00 | AAPL | Stock | 0.273 | 0.2741 | 0.2693 | 0.2711 | 21604464.0 |
| 2002-12-11 10:00:00 | AAPL | Stock | 0.2711 | 0.2732 | 0.2696 | 0.2709 | 35936040.0 |
| 2002-12-11 11:00:00 | AAPL | Stock | 0.2709 | 0.2723 | 0.2693 | 0.2714 | 23077376.0 |
| 2002-12-11 12:00:00 | AAPL | Stock | 0.2716 | 0.2734 | 0.2713 | 0.2729 | 18307296.0 |
| 2002-12-11 13:00:00 | AAPL | Stock | 0.2729 | 0.2745 | 0.2725 | 0.2738 | 37477160.0 |
| 2002-12-11 14:00:00 | AAPL | Stock | 0.2739 | 0.2752 | 0.272 | 0.2732 | 34635664.0 |
| 2002-12-11 15:00:00 | AAPL | Stock | 0.2729 | 0.2764 | 0.2727 | 0.2764 | 51836960.0 |
| 2002-12-11 16:00:00 | AAPL | Stock | 0.2766 | 0.2768 | 0.2732 | 0.2754 | 10163216.0 |
| 2002-12-11 17:00:00 | AAPL | Stock | 0.2766 | 0.2766 | 0.2759 | 0.2759 | 750400.0 |
| 2002-12-11 18:00:00 | AAPL | Stock | 0.2766 | 0.2768 | 0.2748 | 0.2748 | 187600.0 |
| 2002-12-11 08:00:00 | MSFT | Stock | 26.975 | 27.065 | 26.975 | 27.05 | 92378.0 |
| 2002-12-11 09:00:00 | MSFT | Stock | 27.05 | 27.5 | 26.7915 | 26.915 | 7915014.0 |
| 2002-12-11 10:00:00 | MSFT | Stock | 26.915 | 27.375 | 26.855 | 27.26 | 13388220.0 |
| 2002-12-11 11:00:00 | MSFT | Stock | 27.255 | 27.5095 | 27.23 | 27.385 | 9952848.0 |
| 2002-12-11 12:00:00 | MSFT | Stock | 27.395 | 27.45 | 27.315 | 27.365 | 5753094.0 |
| 2002-12-11 13:00:00 | MSFT | Stock | 27.365 | 27.475 | 27.25 | 27.455 | 4972972.0 |
| 2002-12-11 14:00:00 | MSFT | Stock | 27.455 | 27.485 | 27.175 | 27.25 | 7941896.0 |
| 2002-12-11 15:00:00 | MSFT | Stock | 27.25 | 27.475 | 27.175 | 27.335 | 11300524.0 |
| 2002-12-11 16:00:00 | MSFT | Stock | 27.34 | 27.4224 | 27.305 | 27.405 | 1967258.0 |
| 2002-12-11 17:00:00 | MSFT | Stock | 27.385 | 27.4 | 27.33 | 27.39 | 95600.0 |
| 2002-12-11 18:00:00 | MSFT | Stock | 27.4 | 27.4 | 27.33 | 27.33 | 25960.0 |
| 2002-12-11 08:00:00 | NVDA | Stock | 0.1168 | 0.1179 | 0.1166 | 0.1167 | 2090160.0 |
| 2002-12-11 09:00:00 | NVDA | Stock | 0.1165 | 0.1173 | 0.1142 | 0.1146 | 153418560.0 |
| 2002-12-11 10:00:00 | NVDA | Stock | 0.1147 | 0.1192 | 0.1127 | 0.1172 | 298645440.0 |
| 2002-12-11 11:00:00 | NVDA | Stock | 0.1172 | 0.12 | 0.1161 | 0.1183 | 263114640.0 |
| 2002-12-11 12:00:00 | NVDA | Stock | 0.1183 | 0.119 | 0.1168 | 0.1181 | 111604200.0 |
| 2002-12-11 13:00:00 | NVDA | Stock | 0.1181 | 0.1183 | 0.1158 | 0.1172 | 141264360.0 |
| 2002-12-11 14:00:00 | NVDA | Stock | 0.1172 | 0.1175 | 0.1145 | 0.116 | 107218080.0 |
| 2002-12-11 15:00:00 | NVDA | Stock | 0.1159 | 0.1175 | 0.1154 | 0.1167 | 153158160.0 |
| 2002-12-11 16:00:00 | NVDA | Stock | 0.1167 | 0.1171 | 0.1162 | 0.1167 | 7601400.0 |
| 2002-12-11 17:00:00 | NVDA | Stock | 0.1167 | 0.1172 | 0.1167 | 0.1171 | 1650000.0 |
| 2002-12-11 18:00:00 | NVDA | Stock | 0.1171 | 0.1171 | 0.1171 | 0.1171 | 12000.0 |
| 2002-12-11 08:00:00 | AMZN | Stock | 1.0928 | 1.093 | 1.0895 | 1.09 | 2861000.0 |
| 2002-12-11 09:00:00 | AMZN | Stock | 1.09 | 1.119 | 1.081 | 1.1055 | 18318760.0 |
| 2002-12-11 10:00:00 | AMZN | Stock | 1.1055 | 1.113 | 1.095 | 1.106 | 26898220.0 |
| 2002-12-11 11:00:00 | AMZN | Stock | 1.106 | 1.1165 | 1.1055 | 1.112 | 11167480.0 |
| 2002-12-11 12:00:00 | AMZN | Stock | 1.1125 | 1.1125 | 1.1055 | 1.1065 | 6184740.0 |
| 2002-12-11 13:00:00 | AMZN | Stock | 1.1065 | 1.1075 | 1.0975 | 1.102 | 9422820.0 |
| 2002-12-11 14:00:00 | AMZN | Stock | 1.102 | 1.1045 | 1.095 | 1.102 | 12510280.0 |
| 2002-12-11 15:00:00 | AMZN | Stock | 1.102 | 1.1075 | 1.0995 | 1.107 | 23224460.0 |
| 2002-12-11 16:00:00 | AMZN | Stock | 1.107 | 1.1095 | 1.106 | 1.1089 | 9156500.0 |
| 2002-12-11 17:00:00 | AMZN | Stock | 1.1065 | 1.109 | 1.1046 | 1.109 | 174000.0 |
| 2002-12-11 18:00:00 | AMZN | Stock | 1.1105 | 1.1105 | 1.1095 | 1.1095 | 20000.0 |
| 2002-12-11 09:00:00 | CL | Stock | 27.055 | 27.055 | 26.81 | 26.825 | 342600.0 |
| 2002-12-11 10:00:00 | CL | Stock | 26.825 | 26.95 | 26.59 | 26.66 | 569000.0 |
| 2002-12-11 11:00:00 | CL | Stock | 26.68 | 26.775 | 26.66 | 26.755 | 260800.0 |
| 2002-12-11 12:00:00 | CL | Stock | 26.76 | 26.79 | 26.685 | 26.73 | 239800.0 |
| 2002-12-11 13:00:00 | CL | Stock | 26.73 | 26.735 | 26.65 | 26.675 | 268600.0 |
| 2002-12-11 14:00:00 | CL | Stock | 26.675 | 26.725 | 26.545 | 26.675 | 815200.0 |
| 2002-12-11 15:00:00 | CL | Stock | 26.675 | 26.82 | 26.65 | 26.77 | 845800.0 |
> showing 50 of 19,366 rows — these rows as CSV