PREVIEW / stock_1hour / 2000-11-29
file: by_date/stock_1hour/2000/2000-11-29.parquet size: 305 KB rows: 16,117 symbols: 1,253
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-29 08:00:00 | AAPL | Stock | 0.322 | 0.3393 | 0.322 | 0.3292 | 1103200.0 |
| 2000-11-29 09:00:00 | AAPL | Stock | 0.3281 | 0.3281 | 0.3192 | 0.3203 | 42946400.0 |
| 2000-11-29 10:00:00 | AAPL | Stock | 0.3203 | 0.3214 | 0.3158 | 0.317 | 80119200.0 |
| 2000-11-29 11:00:00 | AAPL | Stock | 0.317 | 0.3214 | 0.3158 | 0.317 | 30368800.0 |
| 2000-11-29 12:00:00 | AAPL | Stock | 0.317 | 0.3181 | 0.3147 | 0.3147 | 55580000.0 |
| 2000-11-29 13:00:00 | AAPL | Stock | 0.3147 | 0.317 | 0.3125 | 0.3136 | 81810400.0 |
| 2000-11-29 14:00:00 | AAPL | Stock | 0.3136 | 0.3147 | 0.308 | 0.3103 | 90468000.0 |
| 2000-11-29 15:00:00 | AAPL | Stock | 0.3103 | 0.3192 | 0.3092 | 0.3147 | 56929600.0 |
| 2000-11-29 16:00:00 | AAPL | Stock | 0.3147 | 0.3153 | 0.2879 | 0.2941 | 19140800.0 |
| 2000-11-29 17:00:00 | AAPL | Stock | 0.2946 | 0.317 | 0.2924 | 0.298 | 2492000.0 |
| 2000-11-29 18:00:00 | AAPL | Stock | 0.2969 | 0.2969 | 0.2857 | 0.2902 | 6753600.0 |
| 2000-11-29 08:00:00 | MSFT | Stock | 33.5 | 33.9375 | 33.0 | 33.7812 | 218400.0 |
| 2000-11-29 09:00:00 | MSFT | Stock | 33.8125 | 33.8125 | 33.0625 | 33.0625 | 11772400.0 |
| 2000-11-29 10:00:00 | MSFT | Stock | 33.0938 | 33.5625 | 32.875 | 33.3125 | 14870200.0 |
| 2000-11-29 11:00:00 | MSFT | Stock | 33.3125 | 33.4688 | 32.625 | 32.7812 | 10774800.0 |
| 2000-11-29 12:00:00 | MSFT | Stock | 32.7812 | 32.7812 | 32.25 | 32.5 | 10492000.0 |
| 2000-11-29 13:00:00 | MSFT | Stock | 32.4688 | 32.5312 | 32.125 | 32.2812 | 8215600.0 |
| 2000-11-29 14:00:00 | MSFT | Stock | 32.2812 | 32.3125 | 31.625 | 32.0938 | 15836200.0 |
| 2000-11-29 15:00:00 | MSFT | Stock | 32.125 | 32.625 | 31.875 | 32.5312 | 15448200.0 |
| 2000-11-29 16:00:00 | MSFT | Stock | 32.5 | 32.6875 | 31.4062 | 31.5 | 3047000.0 |
| 2000-11-29 17:00:00 | MSFT | Stock | 32.5 | 32.5312 | 31.0 | 31.1562 | 1099000.0 |
| 2000-11-29 18:00:00 | MSFT | Stock | 31.1875 | 31.25 | 31.0938 | 31.25 | 100000.0 |
| 2000-11-29 08:00:00 | NVDA | Stock | 0.2167 | 0.2167 | 0.2167 | 0.2167 | 120000.0 |
| 2000-11-29 09:00:00 | NVDA | Stock | 0.2125 | 0.2177 | 0.2036 | 0.2063 | 72576000.0 |
| 2000-11-29 10:00:00 | NVDA | Stock | 0.206 | 0.2078 | 0.1979 | 0.2042 | 106584000.0 |
| 2000-11-29 11:00:00 | NVDA | Stock | 0.2042 | 0.2104 | 0.2042 | 0.2083 | 71472000.0 |
| 2000-11-29 12:00:00 | NVDA | Stock | 0.2081 | 0.2083 | 0.2047 | 0.2055 | 49800000.0 |
| 2000-11-29 13:00:00 | NVDA | Stock | 0.2055 | 0.2055 | 0.188 | 0.188 | 102552000.0 |
| 2000-11-29 14:00:00 | NVDA | Stock | 0.188 | 0.1927 | 0.1849 | 0.187 | 78384000.0 |
| 2000-11-29 15:00:00 | NVDA | Stock | 0.1865 | 0.2044 | 0.1859 | 0.201 | 105888000.0 |
| 2000-11-29 16:00:00 | NVDA | Stock | 0.2005 | 0.2013 | 0.1865 | 0.2013 | 5640000.0 |
| 2000-11-29 17:00:00 | NVDA | Stock | 0.1865 | 0.1865 | 0.1792 | 0.1792 | 312000.0 |
| 2000-11-29 18:00:00 | NVDA | Stock | 0.1794 | 0.1802 | 0.1792 | 0.1802 | 336000.0 |
| 2000-11-29 08:00:00 | AMZN | Stock | 1.2469 | 1.2625 | 1.2469 | 1.2625 | 42000.0 |
| 2000-11-29 09:00:00 | AMZN | Stock | 1.2688 | 1.2969 | 1.2438 | 1.2719 | 24740000.0 |
| 2000-11-29 10:00:00 | AMZN | Stock | 1.275 | 1.2844 | 1.2125 | 1.2781 | 48538000.0 |
| 2000-11-29 11:00:00 | AMZN | Stock | 1.2844 | 1.3031 | 1.2344 | 1.2719 | 24162000.0 |
| 2000-11-29 12:00:00 | AMZN | Stock | 1.2719 | 1.3 | 1.2625 | 1.2969 | 11894000.0 |
| 2000-11-29 13:00:00 | AMZN | Stock | 1.2938 | 1.3 | 1.2469 | 1.2562 | 18856000.0 |
| 2000-11-29 14:00:00 | AMZN | Stock | 1.2531 | 1.35 | 1.2438 | 1.325 | 39206000.0 |
| 2000-11-29 15:00:00 | AMZN | Stock | 1.3281 | 1.375 | 1.3156 | 1.3484 | 35806000.0 |
| 2000-11-29 16:00:00 | AMZN | Stock | 1.35 | 1.3688 | 1.2562 | 1.3469 | 9404000.0 |
| 2000-11-29 17:00:00 | AMZN | Stock | 1.3 | 1.35 | 1.275 | 1.2781 | 174000.0 |
| 2000-11-29 18:00:00 | AMZN | Stock | 1.275 | 1.2906 | 1.2688 | 1.275 | 104000.0 |
| 2000-11-29 09:00:00 | CL | Stock | 29.125 | 29.15 | 29.095 | 29.13 | 474400.0 |
| 2000-11-29 10:00:00 | CL | Stock | 29.14 | 29.34 | 29.125 | 29.335 | 465400.0 |
| 2000-11-29 11:00:00 | CL | Stock | 29.4 | 30.05 | 29.39 | 29.945 | 579600.0 |
| 2000-11-29 12:00:00 | CL | Stock | 29.97 | 30.065 | 29.875 | 29.875 | 398200.0 |
| 2000-11-29 13:00:00 | CL | Stock | 29.875 | 29.875 | 29.675 | 29.8 | 181600.0 |
| 2000-11-29 14:00:00 | CL | Stock | 29.785 | 29.85 | 29.75 | 29.8 | 223400.0 |
> showing 50 of 16,117 rows — these rows as CSV