PREVIEW / stock_1hour / 2000-09-22
file: by_date/stock_1hour/2000/2000-09-22.parquet size: 307 KB rows: 15,747 symbols: 1,218
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-09-22 08:00:00 | AAPL | Stock | 0.9118 | 1.0134 | 0.904 | 0.9085 | 5868800.0 |
| 2000-09-22 09:00:00 | AAPL | Stock | 0.9107 | 0.9252 | 0.8929 | 0.9208 | 160199200.0 |
| 2000-09-22 10:00:00 | AAPL | Stock | 0.9219 | 0.933 | 0.9169 | 0.9286 | 158664800.0 |
| 2000-09-22 11:00:00 | AAPL | Stock | 0.9263 | 0.9342 | 0.9219 | 0.9308 | 62860000.0 |
| 2000-09-22 12:00:00 | AAPL | Stock | 0.9308 | 0.9364 | 0.9196 | 0.923 | 44732800.0 |
| 2000-09-22 13:00:00 | AAPL | Stock | 0.923 | 0.9308 | 0.923 | 0.9286 | 35285600.0 |
| 2000-09-22 14:00:00 | AAPL | Stock | 0.9286 | 0.9308 | 0.9174 | 0.9241 | 42554400.0 |
| 2000-09-22 15:00:00 | AAPL | Stock | 0.9241 | 0.933 | 0.9141 | 0.9319 | 144827200.0 |
| 2000-09-22 16:00:00 | AAPL | Stock | 0.9319 | 0.9542 | 0.9174 | 0.9542 | 32989600.0 |
| 2000-09-22 17:00:00 | AAPL | Stock | 0.9464 | 0.9464 | 0.9464 | 0.9464 | 5600.0 |
| 2000-09-22 18:00:00 | AAPL | Stock | 0.9464 | 0.9542 | 0.9464 | 0.9498 | 61600.0 |
| 2000-09-22 08:00:00 | MSFT | Stock | 30.125 | 32.2031 | 30.0 | 30.2188 | 5502800.0 |
| 2000-09-22 09:00:00 | MSFT | Stock | 30.375 | 31.3438 | 30.125 | 30.9375 | 18761000.0 |
| 2000-09-22 10:00:00 | MSFT | Stock | 30.9375 | 31.375 | 30.8125 | 31.0312 | 14456800.0 |
| 2000-09-22 11:00:00 | MSFT | Stock | 31.0312 | 31.125 | 30.8438 | 30.9375 | 10458400.0 |
| 2000-09-22 12:00:00 | MSFT | Stock | 30.9375 | 31.0312 | 30.75 | 30.8125 | 4198800.0 |
| 2000-09-22 13:00:00 | MSFT | Stock | 30.7812 | 31.2188 | 30.7812 | 31.1875 | 5323200.0 |
| 2000-09-22 14:00:00 | MSFT | Stock | 31.1875 | 31.3438 | 31.125 | 31.1562 | 7830000.0 |
| 2000-09-22 15:00:00 | MSFT | Stock | 31.1875 | 31.75 | 31.1562 | 31.5938 | 12964400.0 |
| 2000-09-22 16:00:00 | MSFT | Stock | 31.625 | 31.75 | 31.5938 | 31.75 | 1188800.0 |
| 2000-09-22 17:00:00 | MSFT | Stock | 31.6875 | 31.75 | 31.625 | 31.625 | 75600.0 |
| 2000-09-22 18:00:00 | MSFT | Stock | 31.5625 | 31.5625 | 31.5625 | 31.5625 | 400.0 |
| 2000-09-22 08:00:00 | NVDA | Stock | 0.2708 | 0.2891 | 0.2677 | 0.2703 | 2640000.0 |
| 2000-09-22 09:00:00 | NVDA | Stock | 0.2708 | 0.2729 | 0.2604 | 0.2677 | 78696000.0 |
| 2000-09-22 10:00:00 | NVDA | Stock | 0.2677 | 0.275 | 0.2641 | 0.2708 | 80664000.0 |
| 2000-09-22 11:00:00 | NVDA | Stock | 0.2708 | 0.276 | 0.2693 | 0.2745 | 36768000.0 |
| 2000-09-22 12:00:00 | NVDA | Stock | 0.2747 | 0.2784 | 0.2746 | 0.2755 | 19488000.0 |
| 2000-09-22 13:00:00 | NVDA | Stock | 0.2753 | 0.2784 | 0.2747 | 0.2771 | 35592000.0 |
| 2000-09-22 14:00:00 | NVDA | Stock | 0.2763 | 0.2823 | 0.2755 | 0.2823 | 24216000.0 |
| 2000-09-22 15:00:00 | NVDA | Stock | 0.281 | 0.2979 | 0.281 | 0.2943 | 76776000.0 |
| 2000-09-22 16:00:00 | NVDA | Stock | 0.2943 | 0.2945 | 0.2911 | 0.2917 | 6336000.0 |
| 2000-09-22 17:00:00 | NVDA | Stock | 0.2938 | 0.2938 | 0.2938 | 0.2938 | 24000.0 |
| 2000-09-22 18:00:00 | NVDA | Stock | 0.2958 | 0.2958 | 0.2958 | 0.2958 | 24000.0 |
| 2000-09-22 08:00:00 | AMZN | Stock | 2.0047 | 2.0047 | 1.8625 | 1.9094 | 340000.0 |
| 2000-09-22 09:00:00 | AMZN | Stock | 1.95 | 2.0 | 1.9156 | 1.9625 | 19242000.0 |
| 2000-09-22 10:00:00 | AMZN | Stock | 1.9672 | 2.0312 | 1.9406 | 2.0094 | 18358000.0 |
| 2000-09-22 11:00:00 | AMZN | Stock | 2.0125 | 2.1062 | 1.9875 | 2.075 | 24620000.0 |
| 2000-09-22 12:00:00 | AMZN | Stock | 2.075 | 2.0844 | 2.0156 | 2.0188 | 12390000.0 |
| 2000-09-22 13:00:00 | AMZN | Stock | 2.0188 | 2.0844 | 2.0156 | 2.0719 | 10436000.0 |
| 2000-09-22 14:00:00 | AMZN | Stock | 2.075 | 2.0922 | 2.0562 | 2.0719 | 8454000.0 |
| 2000-09-22 15:00:00 | AMZN | Stock | 2.075 | 2.0844 | 2.0625 | 2.075 | 14312000.0 |
| 2000-09-22 16:00:00 | AMZN | Stock | 2.0688 | 2.0969 | 1.9938 | 2.0781 | 1080000.0 |
| 2000-09-22 17:00:00 | AMZN | Stock | 2.075 | 2.0813 | 2.0625 | 2.0625 | 78000.0 |
| 2000-09-22 18:00:00 | AMZN | Stock | 2.0625 | 2.0625 | 2.0625 | 2.0625 | 2000.0 |
| 2000-09-22 09:00:00 | CL | Stock | 22.25 | 22.5 | 22.1875 | 22.4688 | 1350600.0 |
| 2000-09-22 10:00:00 | CL | Stock | 22.5 | 23.0938 | 22.4688 | 22.7812 | 2816600.0 |
| 2000-09-22 11:00:00 | CL | Stock | 22.75 | 22.8438 | 22.5625 | 22.5625 | 1253600.0 |
| 2000-09-22 12:00:00 | CL | Stock | 22.5625 | 22.75 | 22.5625 | 22.5625 | 524400.0 |
| 2000-09-22 13:00:00 | CL | Stock | 22.5625 | 22.625 | 22.5 | 22.5312 | 866200.0 |
| 2000-09-22 14:00:00 | CL | Stock | 22.5312 | 22.6875 | 22.5312 | 22.625 | 906400.0 |
> showing 50 of 15,747 rows — these rows as CSV