PREVIEW / stock_1hour / 2000-03-01
file: by_date/stock_1hour/2000/2000-03-01.parquet size: 287 KB rows: 14,684 symbols: 1,147
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-01 09:00:00 | AAPL | Stock | 1.0586 | 1.1016 | 1.058 | 1.0932 | 154582400.0 |
| 2000-03-01 10:00:00 | AAPL | Stock | 1.0932 | 1.1462 | 1.0893 | 1.0982 | 296912000.0 |
| 2000-03-01 11:00:00 | AAPL | Stock | 1.0982 | 1.1138 | 1.0932 | 1.1116 | 99288000.0 |
| 2000-03-01 12:00:00 | AAPL | Stock | 1.1116 | 1.1116 | 1.1004 | 1.1027 | 51945600.0 |
| 2000-03-01 13:00:00 | AAPL | Stock | 1.1038 | 1.1557 | 1.1027 | 1.1306 | 166947200.0 |
| 2000-03-01 14:00:00 | AAPL | Stock | 1.1309 | 1.1473 | 1.1205 | 1.1339 | 60424000.0 |
| 2000-03-01 15:00:00 | AAPL | Stock | 1.1306 | 1.1791 | 1.1306 | 1.1629 | 156340800.0 |
| 2000-03-01 16:00:00 | AAPL | Stock | 1.1635 | 1.1635 | 1.1629 | 1.1635 | 526400.0 |
| 2000-03-01 09:00:00 | MSFT | Stock | 44.8125 | 45.5938 | 44.4688 | 45.5 | 10544400.0 |
| 2000-03-01 10:00:00 | MSFT | Stock | 45.4688 | 47.1875 | 45.375 | 46.125 | 26442000.0 |
| 2000-03-01 11:00:00 | MSFT | Stock | 46.0625 | 46.4375 | 45.3125 | 45.6562 | 14712800.0 |
| 2000-03-01 12:00:00 | MSFT | Stock | 45.6562 | 45.7812 | 45.25 | 45.6875 | 9863000.0 |
| 2000-03-01 13:00:00 | MSFT | Stock | 45.625 | 45.6562 | 45.0 | 45.1875 | 7343000.0 |
| 2000-03-01 14:00:00 | MSFT | Stock | 45.1875 | 45.9062 | 45.0 | 45.0625 | 13982000.0 |
| 2000-03-01 15:00:00 | MSFT | Stock | 45.0625 | 45.6094 | 45.0 | 45.4062 | 17060400.0 |
| 2000-03-01 16:00:00 | MSFT | Stock | 45.375 | 45.4531 | 45.25 | 45.25 | 169000.0 |
| 2000-03-01 09:00:00 | NVDA | Stock | 0.1333 | 0.1333 | 0.132 | 0.1323 | 35760000.0 |
| 2000-03-01 10:00:00 | NVDA | Stock | 0.1323 | 0.1323 | 0.1273 | 0.1292 | 106368000.0 |
| 2000-03-01 11:00:00 | NVDA | Stock | 0.1293 | 0.1294 | 0.1279 | 0.1279 | 53472000.0 |
| 2000-03-01 12:00:00 | NVDA | Stock | 0.128 | 0.1318 | 0.1277 | 0.1312 | 37344000.0 |
| 2000-03-01 13:00:00 | NVDA | Stock | 0.1312 | 0.1314 | 0.1289 | 0.1293 | 35664000.0 |
| 2000-03-01 14:00:00 | NVDA | Stock | 0.129 | 0.1297 | 0.1286 | 0.1292 | 35952000.0 |
| 2000-03-01 15:00:00 | NVDA | Stock | 0.1292 | 0.1302 | 0.1289 | 0.1294 | 65088000.0 |
| 2000-03-01 09:00:00 | AMZN | Stock | 3.3812 | 3.425 | 3.3688 | 3.3797 | 8280000.0 |
| 2000-03-01 10:00:00 | AMZN | Stock | 3.3812 | 3.3812 | 3.25 | 3.2906 | 33232000.0 |
| 2000-03-01 11:00:00 | AMZN | Stock | 3.2906 | 3.3188 | 3.275 | 3.2812 | 14612000.0 |
| 2000-03-01 12:00:00 | AMZN | Stock | 3.2844 | 3.3031 | 3.275 | 3.2922 | 12386000.0 |
| 2000-03-01 13:00:00 | AMZN | Stock | 3.2938 | 3.3031 | 3.275 | 3.2844 | 8098000.0 |
| 2000-03-01 14:00:00 | AMZN | Stock | 3.2875 | 3.2938 | 3.275 | 3.2906 | 6648000.0 |
| 2000-03-01 15:00:00 | AMZN | Stock | 3.2906 | 3.3 | 3.275 | 3.2938 | 16406000.0 |
| 2000-03-01 16:00:00 | AMZN | Stock | 3.2938 | 3.3 | 3.2906 | 3.2938 | 174000.0 |
| 2000-03-01 09:00:00 | CL | Stock | 26.125 | 26.125 | 25.75 | 25.9062 | 513800.0 |
| 2000-03-01 10:00:00 | CL | Stock | 25.875 | 26.0625 | 25.75 | 25.9688 | 416200.0 |
| 2000-03-01 11:00:00 | CL | Stock | 25.9688 | 26.8125 | 25.9375 | 26.6875 | 578000.0 |
| 2000-03-01 12:00:00 | CL | Stock | 26.6875 | 26.8125 | 26.5 | 26.5 | 398200.0 |
| 2000-03-01 13:00:00 | CL | Stock | 26.5 | 26.5625 | 26.3438 | 26.5312 | 209400.0 |
| 2000-03-01 14:00:00 | CL | Stock | 26.5 | 26.6562 | 26.4062 | 26.5312 | 453400.0 |
| 2000-03-01 15:00:00 | CL | Stock | 26.5625 | 26.8125 | 26.4375 | 26.5 | 752400.0 |
| 2000-03-01 16:00:00 | CL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 163400.0 |
> showing 39 of 14,684 rows — these rows as CSV