PREVIEW / stock_1hour / 2003-03-19
file: by_date/stock_1hour/2003/2003-03-19.parquet size: 415 KB rows: 20,754 symbols: 1,564
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-19 08:00:00 | AAPL | Stock | 0.2682 | 0.2691 | 0.268 | 0.2691 | 655200.0 |
| 2003-03-19 09:00:00 | AAPL | Stock | 0.2688 | 0.2705 | 0.267 | 0.2688 | 24470152.0 |
| 2003-03-19 10:00:00 | AAPL | Stock | 0.2686 | 0.2698 | 0.2677 | 0.2677 | 21478968.0 |
| 2003-03-19 11:00:00 | AAPL | Stock | 0.2677 | 0.2677 | 0.2641 | 0.2645 | 19264504.0 |
| 2003-03-19 12:00:00 | AAPL | Stock | 0.2646 | 0.2684 | 0.2645 | 0.2682 | 12665520.0 |
| 2003-03-19 13:00:00 | AAPL | Stock | 0.2682 | 0.2684 | 0.2664 | 0.267 | 7696192.0 |
| 2003-03-19 14:00:00 | AAPL | Stock | 0.2669 | 0.2691 | 0.2657 | 0.2688 | 13007064.0 |
| 2003-03-19 15:00:00 | AAPL | Stock | 0.2688 | 0.2689 | 0.2657 | 0.2671 | 25611376.0 |
| 2003-03-19 16:00:00 | AAPL | Stock | 0.2673 | 0.268 | 0.2662 | 0.2668 | 1880144.0 |
| 2003-03-19 08:00:00 | MSFT | Stock | 25.95 | 26.25 | 25.95 | 26.044 | 465418.0 |
| 2003-03-19 09:00:00 | MSFT | Stock | 26.031 | 26.26 | 25.778 | 25.89 | 9861981.0 |
| 2003-03-19 10:00:00 | MSFT | Stock | 25.9 | 26.15 | 25.87 | 25.93 | 10753149.0 |
| 2003-03-19 11:00:00 | MSFT | Stock | 25.92 | 25.94 | 25.74 | 25.77 | 8964044.0 |
| 2003-03-19 12:00:00 | MSFT | Stock | 25.77 | 26.021 | 25.77 | 25.99 | 6940322.0 |
| 2003-03-19 13:00:00 | MSFT | Stock | 25.989 | 26.08 | 25.89 | 26.022 | 6840120.0 |
| 2003-03-19 14:00:00 | MSFT | Stock | 26.02 | 26.26 | 25.85 | 26.2 | 10052907.0 |
| 2003-03-19 15:00:00 | MSFT | Stock | 26.2 | 26.4 | 26.05 | 26.301 | 13236605.0 |
| 2003-03-19 16:00:00 | MSFT | Stock | 26.3 | 26.36 | 26.13 | 26.19 | 1230842.0 |
| 2003-03-19 17:00:00 | MSFT | Stock | 26.33 | 26.33 | 26.17 | 26.22 | 39120.0 |
| 2003-03-19 18:00:00 | MSFT | Stock | 26.24 | 26.26 | 26.24 | 26.26 | 12875.0 |
| 2003-03-19 08:00:00 | NVDA | Stock | 0.1174 | 0.1183 | 0.1174 | 0.1179 | 1428000.0 |
| 2003-03-19 09:00:00 | NVDA | Stock | 0.1179 | 0.1183 | 0.1155 | 0.1162 | 87612360.0 |
| 2003-03-19 10:00:00 | NVDA | Stock | 0.1163 | 0.1171 | 0.1158 | 0.1165 | 83464080.0 |
| 2003-03-19 11:00:00 | NVDA | Stock | 0.1165 | 0.1166 | 0.114 | 0.114 | 97357560.0 |
| 2003-03-19 12:00:00 | NVDA | Stock | 0.114 | 0.1167 | 0.1138 | 0.1164 | 75917880.0 |
| 2003-03-19 13:00:00 | NVDA | Stock | 0.1163 | 0.1167 | 0.1156 | 0.1162 | 34772160.0 |
| 2003-03-19 14:00:00 | NVDA | Stock | 0.1162 | 0.1175 | 0.1156 | 0.1172 | 82942320.0 |
| 2003-03-19 15:00:00 | NVDA | Stock | 0.1172 | 0.1188 | 0.116 | 0.1178 | 188100600.0 |
| 2003-03-19 16:00:00 | NVDA | Stock | 0.1178 | 0.1217 | 0.1175 | 0.1179 | 20328000.0 |
| 2003-03-19 17:00:00 | NVDA | Stock | 0.1179 | 0.1179 | 0.1176 | 0.1179 | 1036800.0 |
| 2003-03-19 18:00:00 | NVDA | Stock | 0.1176 | 0.1177 | 0.1175 | 0.1175 | 741480.0 |
| 2003-03-19 08:00:00 | AMZN | Stock | 1.3115 | 1.3388 | 1.3 | 1.3135 | 1929900.0 |
| 2003-03-19 09:00:00 | AMZN | Stock | 1.312 | 1.3385 | 1.3075 | 1.3185 | 32301200.0 |
| 2003-03-19 10:00:00 | AMZN | Stock | 1.3185 | 1.3201 | 1.312 | 1.314 | 20612600.0 |
| 2003-03-19 11:00:00 | AMZN | Stock | 1.314 | 1.316 | 1.3083 | 1.3155 | 23100800.0 |
| 2003-03-19 12:00:00 | AMZN | Stock | 1.315 | 1.329 | 1.3145 | 1.3235 | 22863400.0 |
| 2003-03-19 13:00:00 | AMZN | Stock | 1.3235 | 1.3275 | 1.3195 | 1.322 | 10248020.0 |
| 2003-03-19 14:00:00 | AMZN | Stock | 1.3215 | 1.3345 | 1.3175 | 1.326 | 16704620.0 |
| 2003-03-19 15:00:00 | AMZN | Stock | 1.3257 | 1.33 | 1.3235 | 1.3266 | 26884920.0 |
| 2003-03-19 16:00:00 | AMZN | Stock | 1.327 | 1.33 | 1.3255 | 1.3275 | 5671080.0 |
| 2003-03-19 17:00:00 | AMZN | Stock | 1.3255 | 1.3275 | 1.3255 | 1.3275 | 75260.0 |
| 2003-03-19 18:00:00 | AMZN | Stock | 1.3275 | 1.3275 | 1.3275 | 1.3275 | 6000.0 |
| 2003-03-19 09:00:00 | CL | Stock | 26.85 | 27.0 | 26.815 | 26.9 | 300200.0 |
| 2003-03-19 10:00:00 | CL | Stock | 26.9 | 27.02 | 26.9 | 26.95 | 445600.0 |
| 2003-03-19 11:00:00 | CL | Stock | 26.94 | 26.945 | 26.8 | 26.82 | 523600.0 |
| 2003-03-19 12:00:00 | CL | Stock | 26.825 | 26.965 | 26.78 | 26.92 | 434600.0 |
| 2003-03-19 13:00:00 | CL | Stock | 26.92 | 26.965 | 26.845 | 26.955 | 399800.0 |
| 2003-03-19 14:00:00 | CL | Stock | 26.96 | 27.05 | 26.83 | 27.05 | 361400.0 |
| 2003-03-19 15:00:00 | CL | Stock | 27.055 | 27.2 | 26.97 | 27.195 | 718800.0 |
| 2003-03-19 16:00:00 | CL | Stock | 27.195 | 27.21 | 27.195 | 27.21 | 108000.0 |
> showing 50 of 20,754 rows — these rows as CSV