PREVIEW / stock_1hour / 2004-10-29
file: by_date/stock_1hour/2004/2004-10-29.parquet size: 532 KB rows: 25,428 symbols: 1,858
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-29 08:00:00 | AAPL | Stock | 0.9286 | 0.9311 | 0.9254 | 0.9284 | 696584.0 |
| 2004-10-29 09:00:00 | AAPL | Stock | 0.9282 | 0.9491 | 0.925 | 0.9491 | 152629960.0 |
| 2004-10-29 10:00:00 | AAPL | Stock | 0.9488 | 0.95 | 0.935 | 0.9461 | 217769664.0 |
| 2004-10-29 11:00:00 | AAPL | Stock | 0.9459 | 0.9464 | 0.9371 | 0.9441 | 100241120.0 |
| 2004-10-29 12:00:00 | AAPL | Stock | 0.9443 | 0.9448 | 0.9359 | 0.9386 | 77105728.0 |
| 2004-10-29 13:00:00 | AAPL | Stock | 0.9386 | 0.9446 | 0.9379 | 0.9411 | 54792192.0 |
| 2004-10-29 14:00:00 | AAPL | Stock | 0.9411 | 0.9414 | 0.9375 | 0.9402 | 52202528.0 |
| 2004-10-29 15:00:00 | AAPL | Stock | 0.9402 | 0.9446 | 0.9355 | 0.9357 | 124769512.0 |
| 2004-10-29 16:00:00 | AAPL | Stock | 0.9364 | 0.942 | 0.9355 | 0.9357 | 12758480.0 |
| 2004-10-29 17:00:00 | AAPL | Stock | 0.9357 | 0.938 | 0.9348 | 0.9348 | 798000.0 |
| 2004-10-29 18:00:00 | AAPL | Stock | 0.9348 | 0.9348 | 0.9348 | 0.9348 | 67760.0 |
| 2004-10-29 08:00:00 | MSFT | Stock | 28.15 | 28.15 | 28.04 | 28.12 | 25353.0 |
| 2004-10-29 09:00:00 | MSFT | Stock | 28.09 | 28.15 | 28.0 | 28.1 | 11563250.0 |
| 2004-10-29 10:00:00 | MSFT | Stock | 28.1 | 28.11 | 27.81 | 27.83 | 17221559.0 |
| 2004-10-29 11:00:00 | MSFT | Stock | 27.83 | 28.0 | 27.8 | 28.0 | 7135227.0 |
| 2004-10-29 12:00:00 | MSFT | Stock | 28.0 | 28.01 | 27.91 | 27.94 | 7000003.0 |
| 2004-10-29 13:00:00 | MSFT | Stock | 27.93 | 28.02 | 27.9 | 27.91 | 6806273.0 |
| 2004-10-29 14:00:00 | MSFT | Stock | 27.91 | 27.95 | 27.85 | 27.93 | 6608381.0 |
| 2004-10-29 15:00:00 | MSFT | Stock | 27.931 | 27.98 | 27.87 | 27.95 | 15729904.0 |
| 2004-10-29 16:00:00 | MSFT | Stock | 27.96 | 28.01 | 27.94 | 27.98 | 4416918.0 |
| 2004-10-29 17:00:00 | MSFT | Stock | 27.97 | 28.02 | 27.97 | 27.99 | 153280.0 |
| 2004-10-29 08:00:00 | NVDA | Stock | 0.1227 | 0.1228 | 0.1211 | 0.1211 | 474000.0 |
| 2004-10-29 09:00:00 | NVDA | Stock | 0.1218 | 0.1232 | 0.1212 | 0.1228 | 72815400.0 |
| 2004-10-29 10:00:00 | NVDA | Stock | 0.1228 | 0.1228 | 0.1213 | 0.1213 | 75862440.0 |
| 2004-10-29 11:00:00 | NVDA | Stock | 0.1213 | 0.1218 | 0.1205 | 0.1208 | 114597000.0 |
| 2004-10-29 12:00:00 | NVDA | Stock | 0.1208 | 0.1212 | 0.1202 | 0.1203 | 106283760.0 |
| 2004-10-29 13:00:00 | NVDA | Stock | 0.1203 | 0.1207 | 0.1197 | 0.12 | 107129880.0 |
| 2004-10-29 14:00:00 | NVDA | Stock | 0.1199 | 0.1206 | 0.1195 | 0.1202 | 59708400.0 |
| 2004-10-29 15:00:00 | NVDA | Stock | 0.1202 | 0.1204 | 0.1197 | 0.1202 | 147257280.0 |
| 2004-10-29 16:00:00 | NVDA | Stock | 0.1202 | 0.1207 | 0.1192 | 0.1197 | 15134880.0 |
| 2004-10-29 17:00:00 | NVDA | Stock | 0.1206 | 0.1206 | 0.1202 | 0.1202 | 472200.0 |
| 2004-10-29 18:00:00 | NVDA | Stock | 0.1206 | 0.1206 | 0.1206 | 0.1206 | 78600.0 |
| 2004-10-29 08:00:00 | AMZN | Stock | 1.7335 | 1.7365 | 1.7255 | 1.7255 | 27500.0 |
| 2004-10-29 09:00:00 | AMZN | Stock | 1.725 | 1.7275 | 1.712 | 1.72 | 15680340.0 |
| 2004-10-29 10:00:00 | AMZN | Stock | 1.72 | 1.7215 | 1.7035 | 1.7035 | 25074540.0 |
| 2004-10-29 11:00:00 | AMZN | Stock | 1.703 | 1.7075 | 1.7 | 1.7075 | 15614160.0 |
| 2004-10-29 12:00:00 | AMZN | Stock | 1.708 | 1.7115 | 1.704 | 1.7075 | 9530100.0 |
| 2004-10-29 13:00:00 | AMZN | Stock | 1.7075 | 1.712 | 1.707 | 1.7085 | 11842260.0 |
| 2004-10-29 14:00:00 | AMZN | Stock | 1.7085 | 1.7135 | 1.707 | 1.712 | 17813840.0 |
| 2004-10-29 15:00:00 | AMZN | Stock | 1.712 | 1.712 | 1.706 | 1.7075 | 26502220.0 |
| 2004-10-29 16:00:00 | AMZN | Stock | 1.7075 | 1.708 | 1.705 | 1.705 | 2592540.0 |
| 2004-10-29 17:00:00 | AMZN | Stock | 1.7065 | 1.7065 | 1.7065 | 1.7065 | 420780.0 |
| 2004-10-29 18:00:00 | AMZN | Stock | 1.709 | 1.709 | 1.709 | 1.709 | 38560.0 |
| 2004-10-29 09:00:00 | CL | Stock | 22.43 | 22.555 | 22.43 | 22.495 | 605800.0 |
| 2004-10-29 10:00:00 | CL | Stock | 22.495 | 22.5 | 22.295 | 22.48 | 963200.0 |
| 2004-10-29 11:00:00 | CL | Stock | 22.48 | 22.58 | 22.45 | 22.465 | 1052000.0 |
| 2004-10-29 12:00:00 | CL | Stock | 22.465 | 22.495 | 22.325 | 22.33 | 885600.0 |
| 2004-10-29 13:00:00 | CL | Stock | 22.325 | 22.405 | 22.275 | 22.28 | 1100400.0 |
| 2004-10-29 14:00:00 | CL | Stock | 22.285 | 22.327 | 22.245 | 22.265 | 1213200.0 |
| 2004-10-29 15:00:00 | CL | Stock | 22.26 | 22.355 | 22.22 | 22.31 | 1927400.0 |
> showing 50 of 25,428 rows — these rows as CSV