PREVIEW / stock_1hour / 2001-11-23
file: by_date/stock_1hour/2001/2001-11-23.parquet size: 231 KB rows: 9,697 symbols: 1,312
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 |
|---|---|---|---|---|---|---|---|
| 2001-11-23 08:00:00 | AAPL | Stock | 0.3518 | 0.3518 | 0.3518 | 0.3518 | 5600.0 |
| 2001-11-23 09:00:00 | AAPL | Stock | 0.3518 | 0.353 | 0.3495 | 0.352 | 6988800.0 |
| 2001-11-23 10:00:00 | AAPL | Stock | 0.352 | 0.3534 | 0.3511 | 0.3521 | 15187200.0 |
| 2001-11-23 11:00:00 | AAPL | Stock | 0.3525 | 0.3529 | 0.3505 | 0.352 | 11463200.0 |
| 2001-11-23 12:00:00 | AAPL | Stock | 0.352 | 0.3563 | 0.3513 | 0.3543 | 24074400.0 |
| 2001-11-23 13:00:00 | AAPL | Stock | 0.3543 | 0.3543 | 0.3543 | 0.3543 | 11200.0 |
| 2001-11-23 08:00:00 | MSFT | Stock | 32.105 | 32.11 | 32.015 | 32.045 | 15200.0 |
| 2001-11-23 09:00:00 | MSFT | Stock | 32.07 | 32.245 | 31.96 | 31.966 | 3563600.0 |
| 2001-11-23 10:00:00 | MSFT | Stock | 31.965 | 32.09 | 31.81 | 31.895 | 4454400.0 |
| 2001-11-23 11:00:00 | MSFT | Stock | 31.8945 | 32.2 | 31.88 | 32.155 | 3027000.0 |
| 2001-11-23 12:00:00 | MSFT | Stock | 32.17 | 32.405 | 32.1445 | 32.37 | 3875600.0 |
| 2001-11-23 13:00:00 | MSFT | Stock | 32.365 | 32.37 | 32.36 | 32.36 | 16400.0 |
| 2001-11-23 08:00:00 | NVDA | Stock | 0.4091 | 0.4125 | 0.4083 | 0.4083 | 72000.0 |
| 2001-11-23 09:00:00 | NVDA | Stock | 0.4108 | 0.4167 | 0.405 | 0.4062 | 51480000.0 |
| 2001-11-23 10:00:00 | NVDA | Stock | 0.4062 | 0.4086 | 0.4054 | 0.4072 | 59136000.0 |
| 2001-11-23 11:00:00 | NVDA | Stock | 0.4072 | 0.4142 | 0.4067 | 0.4132 | 66684000.0 |
| 2001-11-23 12:00:00 | NVDA | Stock | 0.4132 | 0.4165 | 0.4128 | 0.4162 | 60492000.0 |
| 2001-11-23 13:00:00 | NVDA | Stock | 0.4162 | 0.4162 | 0.4162 | 0.4162 | 36000.0 |
| 2001-11-23 08:00:00 | AMZN | Stock | 0.4425 | 0.4445 | 0.44 | 0.4415 | 98000.0 |
| 2001-11-23 09:00:00 | AMZN | Stock | 0.443 | 0.451 | 0.4315 | 0.432 | 19972000.0 |
| 2001-11-23 10:00:00 | AMZN | Stock | 0.4315 | 0.4465 | 0.428 | 0.445 | 21906000.0 |
| 2001-11-23 11:00:00 | AMZN | Stock | 0.4455 | 0.453 | 0.445 | 0.4495 | 17384000.0 |
| 2001-11-23 12:00:00 | AMZN | Stock | 0.4495 | 0.457 | 0.4485 | 0.454 | 17722000.0 |
| 2001-11-23 13:00:00 | AMZN | Stock | 0.456 | 0.456 | 0.454 | 0.454 | 56000.0 |
| 2001-11-23 09:00:00 | CL | Stock | 29.225 | 29.315 | 29.135 | 29.155 | 157800.0 |
| 2001-11-23 10:00:00 | CL | Stock | 29.15 | 29.195 | 29.03 | 29.075 | 211800.0 |
| 2001-11-23 11:00:00 | CL | Stock | 29.1 | 29.25 | 29.065 | 29.23 | 136800.0 |
| 2001-11-23 12:00:00 | CL | Stock | 29.225 | 29.375 | 29.205 | 29.32 | 271400.0 |
| 2001-11-23 13:00:00 | CL | Stock | 29.325 | 29.325 | 29.315 | 29.315 | 22400.0 |
> showing 29 of 9,697 rows — these rows as CSV