PREVIEW / stock_1hour / 2000-02-29
file: by_date/stock_1hour/2000/2000-02-29.parquet size: 292 KB rows: 14,878 symbols: 1,146
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-02-29 09:00:00 | AAPL | Stock | 1.014 | 1.0313 | 1.005 | 1.0268 | 41395200.0 |
| 2000-02-29 10:00:00 | AAPL | Stock | 1.0313 | 1.0469 | 1.0307 | 1.0335 | 64456000.0 |
| 2000-02-29 11:00:00 | AAPL | Stock | 1.0363 | 1.0419 | 1.019 | 1.0273 | 57915200.0 |
| 2000-02-29 12:00:00 | AAPL | Stock | 1.0273 | 1.0346 | 1.0273 | 1.0296 | 35896000.0 |
| 2000-02-29 13:00:00 | AAPL | Stock | 1.029 | 1.0301 | 1.0167 | 1.0212 | 48675200.0 |
| 2000-02-29 14:00:00 | AAPL | Stock | 1.0218 | 1.0246 | 1.014 | 1.0162 | 37262400.0 |
| 2000-02-29 15:00:00 | AAPL | Stock | 1.0151 | 1.0257 | 1.0112 | 1.0234 | 47768000.0 |
| 2000-02-29 16:00:00 | AAPL | Stock | 1.0234 | 1.0246 | 1.0234 | 1.0234 | 3382400.0 |
| 2000-02-29 09:00:00 | MSFT | Stock | 45.875 | 45.875 | 44.5625 | 44.6875 | 8141200.0 |
| 2000-02-29 10:00:00 | MSFT | Stock | 44.7188 | 45.0 | 44.4375 | 44.8438 | 10404800.0 |
| 2000-02-29 11:00:00 | MSFT | Stock | 44.8125 | 45.25 | 44.5625 | 44.75 | 8089200.0 |
| 2000-02-29 12:00:00 | MSFT | Stock | 44.75 | 45.0 | 44.6562 | 44.75 | 4546200.0 |
| 2000-02-29 13:00:00 | MSFT | Stock | 44.8125 | 44.875 | 44.625 | 44.6562 | 5146400.0 |
| 2000-02-29 14:00:00 | MSFT | Stock | 44.6875 | 44.7812 | 44.5312 | 44.6875 | 5484200.0 |
| 2000-02-29 15:00:00 | MSFT | Stock | 44.6562 | 44.875 | 44.5 | 44.6562 | 10815000.0 |
| 2000-02-29 16:00:00 | MSFT | Stock | 44.7188 | 44.7188 | 44.6562 | 44.6875 | 449600.0 |
| 2000-02-29 09:00:00 | NVDA | Stock | 0.1258 | 0.1326 | 0.1258 | 0.1312 | 34176000.0 |
| 2000-02-29 10:00:00 | NVDA | Stock | 0.1312 | 0.1316 | 0.1281 | 0.1294 | 65952000.0 |
| 2000-02-29 11:00:00 | NVDA | Stock | 0.1294 | 0.1318 | 0.1294 | 0.1302 | 43872000.0 |
| 2000-02-29 12:00:00 | NVDA | Stock | 0.1302 | 0.1322 | 0.1298 | 0.1309 | 24576000.0 |
| 2000-02-29 13:00:00 | NVDA | Stock | 0.1312 | 0.1341 | 0.1312 | 0.1331 | 36480000.0 |
| 2000-02-29 14:00:00 | NVDA | Stock | 0.1328 | 0.1331 | 0.1307 | 0.1311 | 34752000.0 |
| 2000-02-29 15:00:00 | NVDA | Stock | 0.1306 | 0.1349 | 0.1306 | 0.1333 | 52608000.0 |
| 2000-02-29 16:00:00 | NVDA | Stock | 0.1333 | 0.1333 | 0.1333 | 0.1333 | 144000.0 |
| 2000-02-29 09:00:00 | AMZN | Stock | 3.3 | 3.3562 | 3.2938 | 3.35 | 15230000.0 |
| 2000-02-29 10:00:00 | AMZN | Stock | 3.3531 | 3.375 | 3.325 | 3.3531 | 31448000.0 |
| 2000-02-29 11:00:00 | AMZN | Stock | 3.35 | 3.3812 | 3.35 | 3.3688 | 20646000.0 |
| 2000-02-29 12:00:00 | AMZN | Stock | 3.3625 | 3.4312 | 3.3625 | 3.4219 | 17202000.0 |
| 2000-02-29 13:00:00 | AMZN | Stock | 3.4219 | 3.4281 | 3.4 | 3.4094 | 9328000.0 |
| 2000-02-29 14:00:00 | AMZN | Stock | 3.4062 | 3.4219 | 3.4 | 3.4031 | 10484000.0 |
| 2000-02-29 15:00:00 | AMZN | Stock | 3.4031 | 3.4484 | 3.3875 | 3.4406 | 30588000.0 |
| 2000-02-29 16:00:00 | AMZN | Stock | 3.4406 | 3.4438 | 3.4375 | 3.4438 | 802000.0 |
| 2000-02-29 09:00:00 | CL | Stock | 25.625 | 25.875 | 25.3125 | 25.75 | 875600.0 |
| 2000-02-29 10:00:00 | CL | Stock | 25.75 | 25.875 | 25.5312 | 25.7812 | 783000.0 |
| 2000-02-29 11:00:00 | CL | Stock | 25.8125 | 25.9688 | 25.75 | 25.9375 | 723600.0 |
| 2000-02-29 12:00:00 | CL | Stock | 25.9688 | 26.125 | 25.9375 | 26.0938 | 460000.0 |
| 2000-02-29 13:00:00 | CL | Stock | 26.125 | 26.75 | 26.125 | 26.625 | 645400.0 |
| 2000-02-29 14:00:00 | CL | Stock | 26.6562 | 26.6562 | 26.1875 | 26.2188 | 545000.0 |
| 2000-02-29 15:00:00 | CL | Stock | 26.2188 | 26.3125 | 25.9375 | 26.0938 | 696000.0 |
| 2000-02-29 16:00:00 | CL | Stock | 26.0938 | 26.0938 | 26.0938 | 26.0938 | 166400.0 |
> showing 40 of 14,878 rows — these rows as CSV