PREVIEW / stock_1hour / 2001-07-03
file: by_date/stock_1hour/2001/2001-07-03.parquet size: 241 KB rows: 10,065 symbols: 1,279
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-07-03 09:00:00 | AAPL | Stock | 0.4232 | 0.4304 | 0.4196 | 0.4302 | 34591200.0 |
| 2001-07-03 10:00:00 | AAPL | Stock | 0.4302 | 0.4318 | 0.4252 | 0.4293 | 27473600.0 |
| 2001-07-03 11:00:00 | AAPL | Stock | 0.4286 | 0.43 | 0.4252 | 0.4291 | 19392800.0 |
| 2001-07-03 12:00:00 | AAPL | Stock | 0.4291 | 0.4291 | 0.4232 | 0.425 | 25032000.0 |
| 2001-07-03 13:00:00 | AAPL | Stock | 0.4257 | 0.4259 | 0.4257 | 0.4257 | 302400.0 |
| 2001-07-03 08:00:00 | MSFT | Stock | 35.29 | 35.29 | 35.15 | 35.15 | 8000.0 |
| 2001-07-03 09:00:00 | MSFT | Stock | 35.25 | 35.4 | 35.085 | 35.2 | 6986800.0 |
| 2001-07-03 10:00:00 | MSFT | Stock | 35.19 | 35.33 | 34.965 | 35.195 | 9597800.0 |
| 2001-07-03 11:00:00 | MSFT | Stock | 35.195 | 35.255 | 35.015 | 35.195 | 4661400.0 |
| 2001-07-03 12:00:00 | MSFT | Stock | 35.19 | 35.3 | 35.115 | 35.24 | 4544400.0 |
| 2001-07-03 13:00:00 | MSFT | Stock | 35.255 | 35.255 | 35.23 | 35.235 | 194800.0 |
| 2001-07-03 08:00:00 | NVDA | Stock | 0.3681 | 0.3693 | 0.3667 | 0.3671 | 3888000.0 |
| 2001-07-03 09:00:00 | NVDA | Stock | 0.3646 | 0.3688 | 0.3646 | 0.3675 | 97008000.0 |
| 2001-07-03 10:00:00 | NVDA | Stock | 0.3675 | 0.374 | 0.3675 | 0.3725 | 123720000.0 |
| 2001-07-03 11:00:00 | NVDA | Stock | 0.3725 | 0.3779 | 0.3725 | 0.3768 | 71088000.0 |
| 2001-07-03 12:00:00 | NVDA | Stock | 0.3768 | 0.3771 | 0.3736 | 0.3739 | 91776000.0 |
| 2001-07-03 13:00:00 | NVDA | Stock | 0.374 | 0.374 | 0.374 | 0.374 | 24000.0 |
| 2001-07-03 09:00:00 | AMZN | Stock | 0.72 | 0.725 | 0.703 | 0.7095 | 8888000.0 |
| 2001-07-03 10:00:00 | AMZN | Stock | 0.71 | 0.7185 | 0.7085 | 0.709 | 13414000.0 |
| 2001-07-03 11:00:00 | AMZN | Stock | 0.708 | 0.7115 | 0.704 | 0.7055 | 5562000.0 |
| 2001-07-03 12:00:00 | AMZN | Stock | 0.7065 | 0.7085 | 0.7 | 0.7075 | 9552000.0 |
| 2001-07-03 13:00:00 | AMZN | Stock | 0.7065 | 0.7065 | 0.7055 | 0.7065 | 334000.0 |
| 2001-07-03 09:00:00 | CL | Stock | 30.0 | 30.0 | 29.775 | 29.78 | 322400.0 |
| 2001-07-03 10:00:00 | CL | Stock | 29.755 | 29.94 | 29.69 | 29.78 | 343400.0 |
| 2001-07-03 11:00:00 | CL | Stock | 29.785 | 30.04 | 29.775 | 30.03 | 300400.0 |
| 2001-07-03 12:00:00 | CL | Stock | 30.03 | 30.225 | 30.0 | 30.225 | 348400.0 |
| 2001-07-03 13:00:00 | CL | Stock | 30.2 | 30.2 | 30.125 | 30.125 | 61200.0 |
> showing 27 of 10,065 rows — these rows as CSV