PREVIEW / stock_1hour / 2003-03-17
file: by_date/stock_1hour/2003/2003-03-17.parquet size: 431 KB rows: 21,295 symbols: 1,563
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-17 08:00:00 | AAPL | Stock | 0.2607 | 0.2641 | 0.2607 | 0.2641 | 2525600.0 |
| 2003-03-17 09:00:00 | AAPL | Stock | 0.2636 | 0.2688 | 0.2627 | 0.268 | 28488264.0 |
| 2003-03-17 10:00:00 | AAPL | Stock | 0.2679 | 0.269 | 0.2653 | 0.268 | 115994256.0 |
| 2003-03-17 11:00:00 | AAPL | Stock | 0.268 | 0.2689 | 0.2643 | 0.2677 | 45770872.0 |
| 2003-03-17 12:00:00 | AAPL | Stock | 0.2677 | 0.2686 | 0.2671 | 0.268 | 24668728.0 |
| 2003-03-17 13:00:00 | AAPL | Stock | 0.268 | 0.268 | 0.2669 | 0.2679 | 16540384.0 |
| 2003-03-17 14:00:00 | AAPL | Stock | 0.2679 | 0.2689 | 0.2675 | 0.2686 | 48069168.0 |
| 2003-03-17 15:00:00 | AAPL | Stock | 0.2684 | 0.2691 | 0.2671 | 0.2679 | 82406856.0 |
| 2003-03-17 16:00:00 | AAPL | Stock | 0.268 | 0.2682 | 0.2646 | 0.2661 | 9255680.0 |
| 2003-03-17 17:00:00 | AAPL | Stock | 0.2675 | 0.2675 | 0.2675 | 0.2675 | 22400.0 |
| 2003-03-17 08:00:00 | MSFT | Stock | 24.63 | 24.84 | 23.9 | 24.53 | 187960.0 |
| 2003-03-17 09:00:00 | MSFT | Stock | 24.529 | 25.04 | 24.33 | 24.98 | 11191992.0 |
| 2003-03-17 10:00:00 | MSFT | Stock | 24.971 | 25.71 | 24.75 | 25.427 | 24714954.0 |
| 2003-03-17 11:00:00 | MSFT | Stock | 25.42 | 25.95 | 25.34 | 25.68 | 16326940.0 |
| 2003-03-17 12:00:00 | MSFT | Stock | 25.67 | 25.75 | 25.47 | 25.59 | 7494162.0 |
| 2003-03-17 13:00:00 | MSFT | Stock | 25.59 | 25.65 | 25.4 | 25.54 | 8901639.0 |
| 2003-03-17 14:00:00 | MSFT | Stock | 25.54 | 25.8 | 25.53 | 25.6 | 9136017.0 |
| 2003-03-17 15:00:00 | MSFT | Stock | 25.6 | 25.92 | 25.51 | 25.9 | 15493375.0 |
| 2003-03-17 16:00:00 | MSFT | Stock | 25.9 | 25.947 | 25.7 | 25.89 | 1387349.0 |
| 2003-03-17 17:00:00 | MSFT | Stock | 25.88 | 25.89 | 25.1625 | 25.87 | 44350.0 |
| 2003-03-17 18:00:00 | MSFT | Stock | 25.85 | 25.87 | 25.83 | 25.84 | 8575.0 |
| 2003-03-17 08:00:00 | NVDA | Stock | 0.1108 | 0.1108 | 0.1087 | 0.1093 | 692400.0 |
| 2003-03-17 09:00:00 | NVDA | Stock | 0.1093 | 0.1138 | 0.1084 | 0.1137 | 127589160.0 |
| 2003-03-17 10:00:00 | NVDA | Stock | 0.1137 | 0.1206 | 0.1125 | 0.1187 | 377667600.0 |
| 2003-03-17 11:00:00 | NVDA | Stock | 0.1188 | 0.1203 | 0.1162 | 0.1177 | 256737840.0 |
| 2003-03-17 12:00:00 | NVDA | Stock | 0.1177 | 0.1196 | 0.1175 | 0.119 | 101651520.0 |
| 2003-03-17 13:00:00 | NVDA | Stock | 0.119 | 0.1192 | 0.1182 | 0.1184 | 71070960.0 |
| 2003-03-17 14:00:00 | NVDA | Stock | 0.1184 | 0.1202 | 0.1182 | 0.1191 | 126282120.0 |
| 2003-03-17 15:00:00 | NVDA | Stock | 0.1191 | 0.1198 | 0.1179 | 0.1184 | 170067480.0 |
| 2003-03-17 16:00:00 | NVDA | Stock | 0.118 | 0.1186 | 0.1163 | 0.1179 | 12193440.0 |
| 2003-03-17 17:00:00 | NVDA | Stock | 0.1178 | 0.1183 | 0.1178 | 0.1179 | 1770000.0 |
| 2003-03-17 18:00:00 | NVDA | Stock | 0.1178 | 0.1179 | 0.1178 | 0.1178 | 1212000.0 |
| 2003-03-17 08:00:00 | AMZN | Stock | 1.2305 | 1.235 | 1.224 | 1.2295 | 296000.0 |
| 2003-03-17 09:00:00 | AMZN | Stock | 1.235 | 1.2515 | 1.22 | 1.25 | 22802740.0 |
| 2003-03-17 10:00:00 | AMZN | Stock | 1.25 | 1.3 | 1.236 | 1.284 | 72803820.0 |
| 2003-03-17 11:00:00 | AMZN | Stock | 1.2855 | 1.29 | 1.2645 | 1.287 | 42447600.0 |
| 2003-03-17 12:00:00 | AMZN | Stock | 1.287 | 1.2975 | 1.279 | 1.295 | 25415300.0 |
| 2003-03-17 13:00:00 | AMZN | Stock | 1.2945 | 1.2976 | 1.2895 | 1.2915 | 16439840.0 |
| 2003-03-17 14:00:00 | AMZN | Stock | 1.2915 | 1.31 | 1.2905 | 1.3076 | 36102140.0 |
| 2003-03-17 15:00:00 | AMZN | Stock | 1.3075 | 1.3345 | 1.3072 | 1.3265 | 63300420.0 |
| 2003-03-17 16:00:00 | AMZN | Stock | 1.329 | 1.3325 | 1.325 | 1.3275 | 2445440.0 |
| 2003-03-17 17:00:00 | AMZN | Stock | 1.3276 | 1.3325 | 1.326 | 1.33 | 234740.0 |
| 2003-03-17 18:00:00 | AMZN | Stock | 1.331 | 1.332 | 1.328 | 1.33 | 271500.0 |
| 2003-03-17 09:00:00 | CL | Stock | 25.95 | 26.1 | 25.95 | 26.085 | 329000.0 |
| 2003-03-17 10:00:00 | CL | Stock | 26.08 | 26.525 | 25.985 | 26.43 | 675800.0 |
| 2003-03-17 11:00:00 | CL | Stock | 26.4 | 26.65 | 26.38 | 26.645 | 487800.0 |
| 2003-03-17 12:00:00 | CL | Stock | 26.625 | 26.75 | 26.54 | 26.7 | 406600.0 |
| 2003-03-17 13:00:00 | CL | Stock | 26.71 | 26.85 | 26.66 | 26.73 | 362200.0 |
| 2003-03-17 14:00:00 | CL | Stock | 26.73 | 26.925 | 26.73 | 26.895 | 449800.0 |
| 2003-03-17 15:00:00 | CL | Stock | 26.9 | 26.95 | 26.805 | 26.875 | 932200.0 |
> showing 50 of 21,295 rows — these rows as CSV