PREVIEW / stock_1hour / 2000-12-11
file: by_date/stock_1hour/2000/2000-12-11.parquet size: 326 KB rows: 16,690 symbols: 1,257
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-12-11 08:00:00 | AAPL | Stock | 0.2589 | 0.2857 | 0.2589 | 0.269 | 778400.0 |
| 2000-12-11 09:00:00 | AAPL | Stock | 0.2679 | 0.2746 | 0.2679 | 0.2723 | 43640800.0 |
| 2000-12-11 10:00:00 | AAPL | Stock | 0.2723 | 0.2734 | 0.269 | 0.2712 | 35991200.0 |
| 2000-12-11 11:00:00 | AAPL | Stock | 0.2723 | 0.2746 | 0.2706 | 0.2723 | 39776800.0 |
| 2000-12-11 12:00:00 | AAPL | Stock | 0.2734 | 0.2734 | 0.2656 | 0.2679 | 52539200.0 |
| 2000-12-11 13:00:00 | AAPL | Stock | 0.2679 | 0.269 | 0.2656 | 0.2679 | 32821600.0 |
| 2000-12-11 14:00:00 | AAPL | Stock | 0.269 | 0.2701 | 0.2656 | 0.269 | 40779200.0 |
| 2000-12-11 15:00:00 | AAPL | Stock | 0.269 | 0.2723 | 0.2679 | 0.2701 | 53104800.0 |
| 2000-12-11 16:00:00 | AAPL | Stock | 0.2706 | 0.2734 | 0.2701 | 0.2723 | 7823200.0 |
| 2000-12-11 17:00:00 | AAPL | Stock | 0.2712 | 0.2723 | 0.2712 | 0.2723 | 487200.0 |
| 2000-12-11 18:00:00 | AAPL | Stock | 0.2734 | 0.2734 | 0.2734 | 0.2734 | 5600.0 |
| 2000-12-11 08:00:00 | MSFT | Stock | 27.5 | 27.8125 | 27.2812 | 27.5625 | 397600.0 |
| 2000-12-11 09:00:00 | MSFT | Stock | 27.5625 | 28.0 | 27.5 | 27.8438 | 12663800.0 |
| 2000-12-11 10:00:00 | MSFT | Stock | 27.8438 | 28.3438 | 27.6875 | 28.2188 | 11843200.0 |
| 2000-12-11 11:00:00 | MSFT | Stock | 28.25 | 29.1562 | 28.2188 | 28.9062 | 17241000.0 |
| 2000-12-11 12:00:00 | MSFT | Stock | 28.9375 | 29.0625 | 28.6875 | 28.7969 | 8000800.0 |
| 2000-12-11 13:00:00 | MSFT | Stock | 28.8125 | 28.875 | 28.5312 | 28.625 | 6570200.0 |
| 2000-12-11 14:00:00 | MSFT | Stock | 28.6562 | 29.2188 | 28.3125 | 29.0938 | 13003800.0 |
| 2000-12-11 15:00:00 | MSFT | Stock | 29.0938 | 29.375 | 28.9375 | 29.0 | 13423800.0 |
| 2000-12-11 16:00:00 | MSFT | Stock | 28.9688 | 29.3438 | 27.7188 | 28.9062 | 3480200.0 |
| 2000-12-11 17:00:00 | MSFT | Stock | 29.0312 | 29.1875 | 28.9375 | 29.125 | 401800.0 |
| 2000-12-11 18:00:00 | MSFT | Stock | 29.0625 | 29.2188 | 28.9375 | 29.2188 | 23000.0 |
| 2000-12-11 08:00:00 | NVDA | Stock | 0.2068 | 0.2068 | 0.2063 | 0.2063 | 216000.0 |
| 2000-12-11 09:00:00 | NVDA | Stock | 0.206 | 0.206 | 0.1885 | 0.1995 | 91752000.0 |
| 2000-12-11 10:00:00 | NVDA | Stock | 0.1995 | 0.2115 | 0.1984 | 0.2086 | 136416000.0 |
| 2000-12-11 11:00:00 | NVDA | Stock | 0.2083 | 0.2109 | 0.2057 | 0.2081 | 113904000.0 |
| 2000-12-11 12:00:00 | NVDA | Stock | 0.2078 | 0.2081 | 0.2034 | 0.2057 | 84432000.0 |
| 2000-12-11 13:00:00 | NVDA | Stock | 0.2057 | 0.206 | 0.2016 | 0.2016 | 83568000.0 |
| 2000-12-11 14:00:00 | NVDA | Stock | 0.2016 | 0.2068 | 0.2016 | 0.206 | 59160000.0 |
| 2000-12-11 15:00:00 | NVDA | Stock | 0.2078 | 0.2094 | 0.2031 | 0.2076 | 95424000.0 |
| 2000-12-11 16:00:00 | NVDA | Stock | 0.2031 | 0.2073 | 0.2031 | 0.2072 | 29112000.0 |
| 2000-12-11 17:00:00 | NVDA | Stock | 0.2073 | 0.2073 | 0.2073 | 0.2073 | 2112000.0 |
| 2000-12-11 08:00:00 | AMZN | Stock | 1.2281 | 1.2281 | 1.15 | 1.1531 | 632000.0 |
| 2000-12-11 09:00:00 | AMZN | Stock | 1.1531 | 1.1625 | 1.0875 | 1.1469 | 29492000.0 |
| 2000-12-11 10:00:00 | AMZN | Stock | 1.1469 | 1.1922 | 1.1375 | 1.1813 | 29066000.0 |
| 2000-12-11 11:00:00 | AMZN | Stock | 1.1828 | 1.2688 | 1.1781 | 1.2672 | 45528000.0 |
| 2000-12-11 12:00:00 | AMZN | Stock | 1.2672 | 1.3063 | 1.2406 | 1.2656 | 41052000.0 |
| 2000-12-11 13:00:00 | AMZN | Stock | 1.2688 | 1.2812 | 1.225 | 1.2281 | 15778000.0 |
| 2000-12-11 14:00:00 | AMZN | Stock | 1.2281 | 1.2656 | 1.225 | 1.2438 | 17292000.0 |
| 2000-12-11 15:00:00 | AMZN | Stock | 1.2438 | 1.2688 | 1.225 | 1.2672 | 22136000.0 |
| 2000-12-11 16:00:00 | AMZN | Stock | 1.2656 | 1.2656 | 1.25 | 1.2625 | 2702000.0 |
| 2000-12-11 17:00:00 | AMZN | Stock | 1.2656 | 1.2938 | 1.2625 | 1.2688 | 90000.0 |
| 2000-12-11 18:00:00 | AMZN | Stock | 1.2688 | 1.275 | 1.2656 | 1.2656 | 52000.0 |
| 2000-12-11 09:00:00 | CL | Stock | 28.9 | 28.9 | 28.45 | 28.48 | 375600.0 |
| 2000-12-11 10:00:00 | CL | Stock | 28.46 | 28.675 | 28.46 | 28.495 | 403000.0 |
| 2000-12-11 11:00:00 | CL | Stock | 28.48 | 28.535 | 28.25 | 28.325 | 635800.0 |
| 2000-12-11 12:00:00 | CL | Stock | 28.31 | 28.325 | 28.025 | 28.125 | 576200.0 |
| 2000-12-11 13:00:00 | CL | Stock | 28.14 | 28.425 | 28.11 | 28.425 | 351800.0 |
| 2000-12-11 14:00:00 | CL | Stock | 28.425 | 28.65 | 28.425 | 28.475 | 415600.0 |
| 2000-12-11 15:00:00 | CL | Stock | 28.47 | 28.77 | 28.325 | 28.325 | 548000.0 |
> showing 50 of 16,690 rows — these rows as CSV