PREVIEW / stock_1hour / 2000-11-06
file: by_date/stock_1hour/2000/2000-11-06.parquet size: 306 KB rows: 15,775 symbols: 1,239
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-11-06 08:00:00 | AAPL | Stock | 0.3984 | 0.3996 | 0.3979 | 0.3996 | 1831200.0 |
| 2000-11-06 09:00:00 | AAPL | Stock | 0.3996 | 0.404 | 0.3984 | 0.4007 | 33303200.0 |
| 2000-11-06 10:00:00 | AAPL | Stock | 0.3996 | 0.4018 | 0.3817 | 0.3828 | 83496000.0 |
| 2000-11-06 11:00:00 | AAPL | Stock | 0.3828 | 0.3884 | 0.3806 | 0.3806 | 55272000.0 |
| 2000-11-06 12:00:00 | AAPL | Stock | 0.3806 | 0.3828 | 0.3772 | 0.3795 | 55932800.0 |
| 2000-11-06 13:00:00 | AAPL | Stock | 0.3795 | 0.3806 | 0.3728 | 0.375 | 48160000.0 |
| 2000-11-06 14:00:00 | AAPL | Stock | 0.3761 | 0.3817 | 0.375 | 0.3795 | 27658400.0 |
| 2000-11-06 15:00:00 | AAPL | Stock | 0.3795 | 0.3839 | 0.3772 | 0.3817 | 49280000.0 |
| 2000-11-06 16:00:00 | AAPL | Stock | 0.3817 | 0.3862 | 0.3761 | 0.385 | 9794400.0 |
| 2000-11-06 17:00:00 | AAPL | Stock | 0.3783 | 0.3783 | 0.3783 | 0.3783 | 22400.0 |
| 2000-11-06 18:00:00 | AAPL | Stock | 0.3795 | 0.3795 | 0.3795 | 0.3795 | 5600.0 |
| 2000-11-06 08:00:00 | MSFT | Stock | 34.1406 | 34.4375 | 34.0 | 34.375 | 106800.0 |
| 2000-11-06 09:00:00 | MSFT | Stock | 34.3125 | 34.9375 | 33.875 | 34.5938 | 10474600.0 |
| 2000-11-06 10:00:00 | MSFT | Stock | 34.5625 | 35.0 | 34.4375 | 34.9688 | 12926400.0 |
| 2000-11-06 11:00:00 | MSFT | Stock | 34.9688 | 35.0625 | 34.8125 | 34.9375 | 10147000.0 |
| 2000-11-06 12:00:00 | MSFT | Stock | 34.9375 | 35.0 | 34.875 | 35.0 | 5339200.0 |
| 2000-11-06 13:00:00 | MSFT | Stock | 35.0 | 35.0312 | 34.6406 | 34.8125 | 7435600.0 |
| 2000-11-06 14:00:00 | MSFT | Stock | 34.8125 | 34.9062 | 34.5938 | 34.7188 | 7333600.0 |
| 2000-11-06 15:00:00 | MSFT | Stock | 34.7188 | 34.8438 | 34.4062 | 34.75 | 14042000.0 |
| 2000-11-06 16:00:00 | MSFT | Stock | 34.75 | 35.0625 | 34.375 | 34.5938 | 1716600.0 |
| 2000-11-06 17:00:00 | MSFT | Stock | 34.6875 | 34.8125 | 34.4688 | 34.625 | 138200.0 |
| 2000-11-06 18:00:00 | MSFT | Stock | 34.75 | 34.9688 | 34.625 | 34.9375 | 12200.0 |
| 2000-11-06 09:00:00 | NVDA | Stock | 0.2969 | 0.3083 | 0.2969 | 0.3057 | 38400000.0 |
| 2000-11-06 10:00:00 | NVDA | Stock | 0.3055 | 0.3193 | 0.3042 | 0.3141 | 100872000.0 |
| 2000-11-06 11:00:00 | NVDA | Stock | 0.3146 | 0.3208 | 0.3091 | 0.313 | 91848000.0 |
| 2000-11-06 12:00:00 | NVDA | Stock | 0.3122 | 0.3242 | 0.312 | 0.3232 | 58704000.0 |
| 2000-11-06 13:00:00 | NVDA | Stock | 0.3227 | 0.3333 | 0.3206 | 0.3284 | 106656000.0 |
| 2000-11-06 14:00:00 | NVDA | Stock | 0.3286 | 0.3313 | 0.3208 | 0.3251 | 84024000.0 |
| 2000-11-06 15:00:00 | NVDA | Stock | 0.3251 | 0.3281 | 0.3195 | 0.3195 | 101352000.0 |
| 2000-11-06 16:00:00 | NVDA | Stock | 0.3198 | 0.3208 | 0.3195 | 0.3198 | 6888000.0 |
| 2000-11-06 17:00:00 | NVDA | Stock | 0.3168 | 0.3229 | 0.3168 | 0.3229 | 264000.0 |
| 2000-11-06 08:00:00 | AMZN | Stock | 1.9 | 1.95 | 1.8766 | 1.9125 | 336000.0 |
| 2000-11-06 09:00:00 | AMZN | Stock | 1.9156 | 1.95 | 1.85 | 1.8625 | 12928000.0 |
| 2000-11-06 10:00:00 | AMZN | Stock | 1.8625 | 1.8688 | 1.775 | 1.8 | 37034000.0 |
| 2000-11-06 11:00:00 | AMZN | Stock | 1.7812 | 1.8062 | 1.7594 | 1.7938 | 16662000.0 |
| 2000-11-06 12:00:00 | AMZN | Stock | 1.7906 | 1.8312 | 1.7812 | 1.8312 | 11848000.0 |
| 2000-11-06 13:00:00 | AMZN | Stock | 1.8281 | 1.875 | 1.825 | 1.8594 | 14332000.0 |
| 2000-11-06 14:00:00 | AMZN | Stock | 1.8594 | 1.9 | 1.8438 | 1.8875 | 11640000.0 |
| 2000-11-06 15:00:00 | AMZN | Stock | 1.8844 | 1.8906 | 1.825 | 1.8312 | 13384000.0 |
| 2000-11-06 16:00:00 | AMZN | Stock | 1.8312 | 1.8531 | 1.825 | 1.8406 | 1488000.0 |
| 2000-11-06 17:00:00 | AMZN | Stock | 1.8281 | 1.8281 | 1.825 | 1.825 | 10000.0 |
| 2000-11-06 18:00:00 | AMZN | Stock | 1.8281 | 1.8281 | 1.8281 | 1.8281 | 10000.0 |
| 2000-11-06 09:00:00 | CL | Stock | 29.0 | 29.05 | 28.9 | 29.0 | 260600.0 |
| 2000-11-06 10:00:00 | CL | Stock | 29.0 | 29.03 | 28.635 | 28.77 | 458800.0 |
| 2000-11-06 11:00:00 | CL | Stock | 28.775 | 28.775 | 28.65 | 28.75 | 171400.0 |
| 2000-11-06 12:00:00 | CL | Stock | 28.745 | 28.8 | 28.68 | 28.77 | 192400.0 |
| 2000-11-06 13:00:00 | CL | Stock | 28.775 | 28.85 | 28.7 | 28.8 | 170000.0 |
| 2000-11-06 14:00:00 | CL | Stock | 28.795 | 28.975 | 28.73 | 28.9 | 405200.0 |
| 2000-11-06 15:00:00 | CL | Stock | 28.9 | 28.965 | 28.8 | 28.83 | 433800.0 |
| 2000-11-06 16:00:00 | CL | Stock | 28.83 | 28.85 | 28.825 | 28.85 | 134800.0 |
> showing 50 of 15,775 rows — these rows as CSV