PREVIEW / stock_1hour / 2000-02-22
file: by_date/stock_1hour/2000/2000-02-22.parquet size: 280 KB rows: 14,543 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-22 09:00:00 | AAPL | Stock | 0.9833 | 0.9833 | 0.9632 | 0.9701 | 37228800.0 |
| 2000-02-22 10:00:00 | AAPL | Stock | 0.9693 | 0.9732 | 0.9526 | 0.9721 | 55529600.0 |
| 2000-02-22 11:00:00 | AAPL | Stock | 0.9721 | 0.9732 | 0.9565 | 0.9637 | 38673600.0 |
| 2000-02-22 12:00:00 | AAPL | Stock | 0.9643 | 0.9732 | 0.9637 | 0.9643 | 18009600.0 |
| 2000-02-22 13:00:00 | AAPL | Stock | 0.9654 | 0.9777 | 0.9637 | 0.9743 | 18860800.0 |
| 2000-02-22 14:00:00 | AAPL | Stock | 0.9743 | 1.0268 | 0.9654 | 1.0254 | 74760000.0 |
| 2000-02-22 15:00:00 | AAPL | Stock | 1.0259 | 1.0441 | 1.0145 | 1.0179 | 163116800.0 |
| 2000-02-22 16:00:00 | AAPL | Stock | 1.0162 | 1.0179 | 1.0162 | 1.0162 | 1064000.0 |
| 2000-02-22 09:00:00 | MSFT | Stock | 47.5625 | 48.5625 | 47.375 | 48.3125 | 9105400.0 |
| 2000-02-22 10:00:00 | MSFT | Stock | 48.3125 | 48.5 | 46.8438 | 47.0938 | 14770800.0 |
| 2000-02-22 11:00:00 | MSFT | Stock | 47.0938 | 47.375 | 46.4062 | 47.375 | 10583200.0 |
| 2000-02-22 12:00:00 | MSFT | Stock | 47.3438 | 47.375 | 46.7812 | 46.9375 | 5035200.0 |
| 2000-02-22 13:00:00 | MSFT | Stock | 46.9688 | 47.2812 | 46.6875 | 46.9688 | 3816000.0 |
| 2000-02-22 14:00:00 | MSFT | Stock | 46.9375 | 47.375 | 46.5 | 47.1562 | 5170000.0 |
| 2000-02-22 15:00:00 | MSFT | Stock | 47.1875 | 47.75 | 46.4375 | 46.9375 | 13606600.0 |
| 2000-02-22 16:00:00 | MSFT | Stock | 46.9375 | 46.9375 | 46.7812 | 46.9062 | 129400.0 |
| 2000-02-22 09:00:00 | NVDA | Stock | 0.1359 | 0.1378 | 0.1341 | 0.1367 | 105936000.0 |
| 2000-02-22 10:00:00 | NVDA | Stock | 0.1367 | 0.137 | 0.1354 | 0.1363 | 103584000.0 |
| 2000-02-22 11:00:00 | NVDA | Stock | 0.1362 | 0.1363 | 0.1318 | 0.1328 | 99600000.0 |
| 2000-02-22 12:00:00 | NVDA | Stock | 0.1331 | 0.1352 | 0.1323 | 0.1326 | 48048000.0 |
| 2000-02-22 13:00:00 | NVDA | Stock | 0.1324 | 0.1331 | 0.1312 | 0.1326 | 36720000.0 |
| 2000-02-22 14:00:00 | NVDA | Stock | 0.1328 | 0.1349 | 0.1323 | 0.1349 | 49728000.0 |
| 2000-02-22 15:00:00 | NVDA | Stock | 0.1341 | 0.1367 | 0.1341 | 0.1367 | 68640000.0 |
| 2000-02-22 16:00:00 | NVDA | Stock | 0.1365 | 0.1365 | 0.1365 | 0.1365 | 2112000.0 |
| 2000-02-22 09:00:00 | AMZN | Stock | 3.2469 | 3.25 | 3.1781 | 3.2063 | 14244000.0 |
| 2000-02-22 10:00:00 | AMZN | Stock | 3.2063 | 3.325 | 3.1813 | 3.2594 | 24984000.0 |
| 2000-02-22 11:00:00 | AMZN | Stock | 3.2594 | 3.2844 | 3.2219 | 3.2531 | 13276000.0 |
| 2000-02-22 12:00:00 | AMZN | Stock | 3.2531 | 3.2531 | 3.2 | 3.2188 | 6906000.0 |
| 2000-02-22 13:00:00 | AMZN | Stock | 3.2125 | 3.2625 | 3.1938 | 3.2125 | 9556000.0 |
| 2000-02-22 14:00:00 | AMZN | Stock | 3.225 | 3.225 | 3.1531 | 3.1813 | 14306000.0 |
| 2000-02-22 15:00:00 | AMZN | Stock | 3.1797 | 3.2375 | 3.1719 | 3.1781 | 22460000.0 |
| 2000-02-22 16:00:00 | AMZN | Stock | 3.1781 | 3.1875 | 3.175 | 3.1781 | 224000.0 |
| 2000-02-22 09:00:00 | CL | Stock | 26.5312 | 26.9688 | 26.5312 | 26.5938 | 234200.0 |
| 2000-02-22 10:00:00 | CL | Stock | 26.5938 | 26.625 | 26.0 | 26.0625 | 476000.0 |
| 2000-02-22 11:00:00 | CL | Stock | 26.0938 | 26.0938 | 25.3438 | 25.6562 | 762600.0 |
| 2000-02-22 12:00:00 | CL | Stock | 25.6562 | 25.875 | 25.375 | 25.875 | 266200.0 |
| 2000-02-22 13:00:00 | CL | Stock | 25.875 | 26.1562 | 25.875 | 25.9688 | 242800.0 |
| 2000-02-22 14:00:00 | CL | Stock | 25.9062 | 26.0 | 25.7188 | 25.9375 | 257000.0 |
| 2000-02-22 15:00:00 | CL | Stock | 26.0 | 26.5 | 25.9375 | 26.125 | 676400.0 |
| 2000-02-22 16:00:00 | CL | Stock | 26.1562 | 26.1875 | 26.1562 | 26.1875 | 58000.0 |
> showing 40 of 14,543 rows — these rows as CSV