PREVIEW / stock_1hour / 2003-03-24
file: by_date/stock_1hour/2003/2003-03-24.parquet size: 416 KB rows: 20,407 symbols: 1,548
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-24 08:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 16800.0 |
| 2003-03-24 09:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2616 | 0.2621 | 22806560.0 |
| 2003-03-24 10:00:00 | AAPL | Stock | 0.2621 | 0.2627 | 0.2588 | 0.2605 | 25227552.0 |
| 2003-03-24 11:00:00 | AAPL | Stock | 0.2607 | 0.2611 | 0.2593 | 0.2593 | 8153376.0 |
| 2003-03-24 12:00:00 | AAPL | Stock | 0.2593 | 0.2604 | 0.2589 | 0.2596 | 8764392.0 |
| 2003-03-24 13:00:00 | AAPL | Stock | 0.2595 | 0.2598 | 0.2568 | 0.2573 | 16418584.0 |
| 2003-03-24 14:00:00 | AAPL | Stock | 0.2571 | 0.2593 | 0.2568 | 0.2582 | 19540864.0 |
| 2003-03-24 15:00:00 | AAPL | Stock | 0.2586 | 0.2598 | 0.2563 | 0.2564 | 36988000.0 |
| 2003-03-24 16:00:00 | AAPL | Stock | 0.2564 | 0.2582 | 0.2554 | 0.257 | 7686000.0 |
| 2003-03-24 17:00:00 | AAPL | Stock | 0.2566 | 0.2595 | 0.2566 | 0.2595 | 156800.0 |
| 2003-03-24 08:00:00 | MSFT | Stock | 26.01 | 26.6 | 25.5 | 25.75 | 327162.0 |
| 2003-03-24 09:00:00 | MSFT | Stock | 25.75 | 26.6 | 25.5 | 25.75 | 10105397.0 |
| 2003-03-24 10:00:00 | MSFT | Stock | 25.76 | 25.84 | 25.57 | 25.6 | 9236532.0 |
| 2003-03-24 11:00:00 | MSFT | Stock | 25.6089 | 25.7 | 25.53 | 25.6 | 5124924.0 |
| 2003-03-24 12:00:00 | MSFT | Stock | 25.6 | 25.62 | 25.46 | 25.48 | 5402749.0 |
| 2003-03-24 13:00:00 | MSFT | Stock | 25.48 | 25.55 | 25.29 | 25.39 | 4733138.0 |
| 2003-03-24 14:00:00 | MSFT | Stock | 25.39 | 25.52 | 25.2 | 25.41 | 9007695.0 |
| 2003-03-24 15:00:00 | MSFT | Stock | 25.42 | 25.549 | 25.24 | 25.29 | 10240725.0 |
| 2003-03-24 16:00:00 | MSFT | Stock | 25.3 | 25.439 | 25.25 | 25.32 | 966662.0 |
| 2003-03-24 17:00:00 | MSFT | Stock | 25.32 | 25.5296 | 25.29 | 25.32 | 324990.0 |
| 2003-03-24 18:00:00 | MSFT | Stock | 25.3 | 25.31 | 25.29 | 25.29 | 5600.0 |
| 2003-03-24 08:00:00 | NVDA | Stock | 0.1152 | 0.1229 | 0.1125 | 0.1128 | 7620000.0 |
| 2003-03-24 09:00:00 | NVDA | Stock | 0.1129 | 0.1181 | 0.1125 | 0.1163 | 244352880.0 |
| 2003-03-24 10:00:00 | NVDA | Stock | 0.1162 | 0.1165 | 0.1143 | 0.1156 | 187779600.0 |
| 2003-03-24 11:00:00 | NVDA | Stock | 0.1155 | 0.1158 | 0.1147 | 0.1153 | 55293600.0 |
| 2003-03-24 12:00:00 | NVDA | Stock | 0.1152 | 0.1157 | 0.1147 | 0.1151 | 57243960.0 |
| 2003-03-24 13:00:00 | NVDA | Stock | 0.1151 | 0.1153 | 0.1137 | 0.1148 | 61569240.0 |
| 2003-03-24 14:00:00 | NVDA | Stock | 0.1148 | 0.1148 | 0.1141 | 0.1144 | 70374480.0 |
| 2003-03-24 15:00:00 | NVDA | Stock | 0.1143 | 0.1149 | 0.1133 | 0.1136 | 90502080.0 |
| 2003-03-24 16:00:00 | NVDA | Stock | 0.1134 | 0.1146 | 0.1134 | 0.1138 | 6623160.0 |
| 2003-03-24 17:00:00 | NVDA | Stock | 0.1141 | 0.1141 | 0.1138 | 0.1138 | 156000.0 |
| 2003-03-24 18:00:00 | NVDA | Stock | 0.1137 | 0.114 | 0.1137 | 0.114 | 500400.0 |
| 2003-03-24 08:00:00 | AMZN | Stock | 1.3955 | 1.3955 | 1.349 | 1.3555 | 296640.0 |
| 2003-03-24 09:00:00 | AMZN | Stock | 1.355 | 1.3965 | 1.346 | 1.3485 | 34969600.0 |
| 2003-03-24 10:00:00 | AMZN | Stock | 1.348 | 1.352 | 1.326 | 1.3395 | 40910500.0 |
| 2003-03-24 11:00:00 | AMZN | Stock | 1.3395 | 1.3395 | 1.3235 | 1.329 | 24168900.0 |
| 2003-03-24 12:00:00 | AMZN | Stock | 1.329 | 1.3295 | 1.3215 | 1.3281 | 23021760.0 |
| 2003-03-24 13:00:00 | AMZN | Stock | 1.328 | 1.329 | 1.3175 | 1.32 | 13863000.0 |
| 2003-03-24 14:00:00 | AMZN | Stock | 1.3195 | 1.323 | 1.31 | 1.318 | 26383680.0 |
| 2003-03-24 15:00:00 | AMZN | Stock | 1.3181 | 1.325 | 1.3105 | 1.3115 | 28203500.0 |
| 2003-03-24 16:00:00 | AMZN | Stock | 1.311 | 1.316 | 1.31 | 1.3105 | 1602300.0 |
| 2003-03-24 17:00:00 | AMZN | Stock | 1.31 | 1.3309 | 1.307 | 1.307 | 400000.0 |
| 2003-03-24 09:00:00 | CL | Stock | 27.525 | 27.53 | 27.35 | 27.38 | 416000.0 |
| 2003-03-24 10:00:00 | CL | Stock | 27.375 | 27.425 | 27.09 | 27.14 | 476600.0 |
| 2003-03-24 11:00:00 | CL | Stock | 27.14 | 27.155 | 26.98 | 26.99 | 341600.0 |
| 2003-03-24 12:00:00 | CL | Stock | 26.995 | 27.045 | 26.925 | 26.97 | 686200.0 |
| 2003-03-24 13:00:00 | CL | Stock | 26.975 | 26.98 | 26.865 | 26.95 | 317600.0 |
| 2003-03-24 14:00:00 | CL | Stock | 26.95 | 27.035 | 26.85 | 27.02 | 410800.0 |
| 2003-03-24 15:00:00 | CL | Stock | 27.02 | 27.155 | 27.0 | 27.05 | 441800.0 |
| 2003-03-24 16:00:00 | CL | Stock | 27.055 | 27.06 | 27.05 | 27.06 | 83400.0 |
> showing 50 of 20,407 rows — these rows as CSV