PREVIEW / stock_1hour / 2002-12-12
file: by_date/stock_1hour/2002/2002-12-12.parquet size: 408 KB rows: 19,480 symbols: 1,516
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-12 08:00:00 | AAPL | Stock | 0.2766 | 0.2766 | 0.2766 | 0.2766 | 123200.0 |
| 2002-12-12 09:00:00 | AAPL | Stock | 0.2768 | 0.2777 | 0.2721 | 0.2723 | 21462168.0 |
| 2002-12-12 10:00:00 | AAPL | Stock | 0.2725 | 0.275 | 0.2709 | 0.2741 | 26002704.0 |
| 2002-12-12 11:00:00 | AAPL | Stock | 0.2739 | 0.2739 | 0.27 | 0.2705 | 15752520.0 |
| 2002-12-12 12:00:00 | AAPL | Stock | 0.2702 | 0.2713 | 0.2682 | 0.2696 | 14123760.0 |
| 2002-12-12 13:00:00 | AAPL | Stock | 0.2696 | 0.2709 | 0.2682 | 0.2695 | 12282704.0 |
| 2002-12-12 14:00:00 | AAPL | Stock | 0.2696 | 0.2713 | 0.2691 | 0.2707 | 10807496.0 |
| 2002-12-12 15:00:00 | AAPL | Stock | 0.2706 | 0.2714 | 0.2693 | 0.2714 | 19481952.0 |
| 2002-12-12 16:00:00 | AAPL | Stock | 0.2714 | 0.2741 | 0.2705 | 0.2713 | 5678400.0 |
| 2002-12-12 17:00:00 | AAPL | Stock | 0.2709 | 0.2709 | 0.2709 | 0.2709 | 5600.0 |
| 2002-12-12 08:00:00 | MSFT | Stock | 27.2 | 27.535 | 27.2 | 27.535 | 119596.0 |
| 2002-12-12 09:00:00 | MSFT | Stock | 27.55 | 27.6 | 27.225 | 27.2755 | 9280944.0 |
| 2002-12-12 10:00:00 | MSFT | Stock | 27.27 | 27.46 | 27.185 | 27.33 | 9829020.0 |
| 2002-12-12 11:00:00 | MSFT | Stock | 27.328 | 27.375 | 26.94 | 26.96 | 7334278.0 |
| 2002-12-12 12:00:00 | MSFT | Stock | 26.945 | 27.075 | 26.845 | 26.975 | 7025148.0 |
| 2002-12-12 13:00:00 | MSFT | Stock | 26.975 | 27.18 | 26.965 | 26.9995 | 4885452.0 |
| 2002-12-12 14:00:00 | MSFT | Stock | 26.995 | 27.145 | 26.96 | 27.065 | 4193418.0 |
| 2002-12-12 15:00:00 | MSFT | Stock | 27.0695 | 27.125 | 26.95 | 27.075 | 7573596.0 |
| 2002-12-12 16:00:00 | MSFT | Stock | 27.08 | 27.125 | 27.045 | 27.05 | 1144936.0 |
| 2002-12-12 17:00:00 | MSFT | Stock | 27.07 | 27.095 | 27.05 | 27.05 | 16600.0 |
| 2002-12-12 18:00:00 | MSFT | Stock | 27.05 | 27.0895 | 27.05 | 27.0895 | 1000.0 |
| 2002-12-12 08:00:00 | NVDA | Stock | 0.1167 | 0.1208 | 0.1167 | 0.1207 | 9209520.0 |
| 2002-12-12 09:00:00 | NVDA | Stock | 0.1207 | 0.1229 | 0.1187 | 0.1197 | 241261560.0 |
| 2002-12-12 10:00:00 | NVDA | Stock | 0.1197 | 0.1209 | 0.1187 | 0.1203 | 256552200.0 |
| 2002-12-12 11:00:00 | NVDA | Stock | 0.1204 | 0.121 | 0.1169 | 0.1173 | 181458360.0 |
| 2002-12-12 12:00:00 | NVDA | Stock | 0.1173 | 0.1182 | 0.1163 | 0.1172 | 182342520.0 |
| 2002-12-12 13:00:00 | NVDA | Stock | 0.1172 | 0.1182 | 0.1167 | 0.1168 | 109851720.0 |
| 2002-12-12 14:00:00 | NVDA | Stock | 0.1168 | 0.1174 | 0.1161 | 0.1171 | 78541560.0 |
| 2002-12-12 15:00:00 | NVDA | Stock | 0.1171 | 0.1174 | 0.1146 | 0.1147 | 144099720.0 |
| 2002-12-12 16:00:00 | NVDA | Stock | 0.1147 | 0.1152 | 0.1137 | 0.1142 | 9336000.0 |
| 2002-12-12 17:00:00 | NVDA | Stock | 0.1145 | 0.1149 | 0.1142 | 0.1142 | 2184600.0 |
| 2002-12-12 18:00:00 | NVDA | Stock | 0.1144 | 0.1145 | 0.1144 | 0.1145 | 264000.0 |
| 2002-12-12 08:00:00 | AMZN | Stock | 1.107 | 1.1165 | 1.107 | 1.115 | 243000.0 |
| 2002-12-12 09:00:00 | AMZN | Stock | 1.115 | 1.131 | 1.101 | 1.1125 | 21220980.0 |
| 2002-12-12 10:00:00 | AMZN | Stock | 1.1123 | 1.1265 | 1.107 | 1.1195 | 24742660.0 |
| 2002-12-12 11:00:00 | AMZN | Stock | 1.12 | 1.126 | 1.0975 | 1.1005 | 20788520.0 |
| 2002-12-12 12:00:00 | AMZN | Stock | 1.0995 | 1.1085 | 1.0905 | 1.1 | 23541200.0 |
| 2002-12-12 13:00:00 | AMZN | Stock | 1.1005 | 1.11 | 1.098 | 1.1015 | 5474400.0 |
| 2002-12-12 14:00:00 | AMZN | Stock | 1.1015 | 1.1085 | 1.1 | 1.108 | 5622600.0 |
| 2002-12-12 15:00:00 | AMZN | Stock | 1.109 | 1.12 | 1.107 | 1.114 | 10433940.0 |
| 2002-12-12 16:00:00 | AMZN | Stock | 1.1145 | 1.1165 | 1.1105 | 1.1105 | 1584000.0 |
| 2002-12-12 17:00:00 | AMZN | Stock | 1.115 | 1.115 | 1.1135 | 1.1135 | 140000.0 |
| 2002-12-12 18:00:00 | AMZN | Stock | 1.117 | 1.12 | 1.117 | 1.12 | 72000.0 |
| 2002-12-12 09:00:00 | CL | Stock | 26.725 | 26.815 | 26.245 | 26.315 | 445400.0 |
| 2002-12-12 10:00:00 | CL | Stock | 26.315 | 26.685 | 26.27 | 26.56 | 563600.0 |
| 2002-12-12 11:00:00 | CL | Stock | 26.56 | 26.57 | 26.405 | 26.445 | 274000.0 |
| 2002-12-12 12:00:00 | CL | Stock | 26.435 | 26.53 | 26.385 | 26.505 | 207000.0 |
| 2002-12-12 13:00:00 | CL | Stock | 26.505 | 26.665 | 26.495 | 26.555 | 173600.0 |
| 2002-12-12 14:00:00 | CL | Stock | 26.535 | 26.58 | 26.475 | 26.5 | 228400.0 |
| 2002-12-12 15:00:00 | CL | Stock | 26.52 | 26.59 | 26.425 | 26.51 | 407400.0 |
> showing 50 of 19,480 rows — these rows as CSV