PREVIEW / stock_30min / 2001-01-17
file: by_date/stock_30min/2001/2001-01-17.parquet size: 475 KB rows: 27,795 symbols: 1,269
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-17 08:00:00 | AAPL | Stock | 0.3147 | 0.3147 | 0.3125 | 0.3147 | 89600.0 |
| 2001-01-17 08:30:00 | AAPL | Stock | 0.3147 | 0.317 | 0.3125 | 0.3125 | 380800.0 |
| 2001-01-17 09:00:00 | AAPL | Stock | 0.3125 | 0.317 | 0.3125 | 0.3136 | 1131200.0 |
| 2001-01-17 09:30:00 | AAPL | Stock | 0.3136 | 0.3136 | 0.3058 | 0.3069 | 58688000.0 |
| 2001-01-17 10:00:00 | AAPL | Stock | 0.308 | 0.308 | 0.3025 | 0.303 | 51111200.0 |
| 2001-01-17 10:30:00 | AAPL | Stock | 0.3025 | 0.3058 | 0.3025 | 0.3047 | 42492800.0 |
| 2001-01-17 11:00:00 | AAPL | Stock | 0.3036 | 0.3047 | 0.3013 | 0.3025 | 35016800.0 |
| 2001-01-17 11:30:00 | AAPL | Stock | 0.3025 | 0.3047 | 0.298 | 0.2991 | 92982400.0 |
| 2001-01-17 12:00:00 | AAPL | Stock | 0.2991 | 0.3013 | 0.298 | 0.2997 | 43680000.0 |
| 2001-01-17 12:30:00 | AAPL | Stock | 0.3002 | 0.3002 | 0.298 | 0.3002 | 29528800.0 |
| 2001-01-17 13:00:00 | AAPL | Stock | 0.3002 | 0.3058 | 0.2991 | 0.3025 | 43237600.0 |
| 2001-01-17 13:30:00 | AAPL | Stock | 0.3036 | 0.3069 | 0.3025 | 0.3058 | 32911200.0 |
| 2001-01-17 14:00:00 | AAPL | Stock | 0.3058 | 0.3069 | 0.3002 | 0.3025 | 62675200.0 |
| 2001-01-17 14:30:00 | AAPL | Stock | 0.3025 | 0.3025 | 0.2991 | 0.2991 | 32379200.0 |
| 2001-01-17 15:00:00 | AAPL | Stock | 0.2991 | 0.3013 | 0.2946 | 0.2991 | 35935200.0 |
| 2001-01-17 15:30:00 | AAPL | Stock | 0.298 | 0.3013 | 0.2946 | 0.2991 | 52220000.0 |
| 2001-01-17 16:00:00 | AAPL | Stock | 0.2991 | 0.3036 | 0.2958 | 0.2997 | 5482400.0 |
| 2001-01-17 16:30:00 | AAPL | Stock | 0.3036 | 0.327 | 0.2969 | 0.3125 | 63140000.0 |
| 2001-01-17 17:00:00 | AAPL | Stock | 0.3147 | 0.3209 | 0.3125 | 0.3147 | 28716800.0 |
| 2001-01-17 17:30:00 | AAPL | Stock | 0.3147 | 0.3158 | 0.3125 | 0.3136 | 9268000.0 |
| 2001-01-17 18:00:00 | AAPL | Stock | 0.3136 | 0.3158 | 0.3136 | 0.3136 | 1719200.0 |
| 2001-01-17 08:00:00 | MSFT | Stock | 26.9375 | 27.0 | 26.5312 | 26.9375 | 56000.0 |
| 2001-01-17 08:30:00 | MSFT | Stock | 26.9688 | 27.25 | 26.9375 | 27.125 | 358000.0 |
| 2001-01-17 09:00:00 | MSFT | Stock | 27.0 | 27.125 | 26.2812 | 26.8125 | 283600.0 |
| 2001-01-17 09:30:00 | MSFT | Stock | 26.8125 | 27.0 | 26.7188 | 26.9688 | 7882200.0 |
| 2001-01-17 10:00:00 | MSFT | Stock | 26.9688 | 27.25 | 26.9375 | 27.2188 | 7000800.0 |
| 2001-01-17 10:30:00 | MSFT | Stock | 27.2344 | 27.375 | 27.125 | 27.3125 | 3085400.0 |
| 2001-01-17 11:00:00 | MSFT | Stock | 27.3125 | 27.4375 | 27.125 | 27.2188 | 5534000.0 |
| 2001-01-17 11:30:00 | MSFT | Stock | 27.25 | 27.3125 | 27.1875 | 27.2812 | 3058000.0 |
| 2001-01-17 12:00:00 | MSFT | Stock | 27.2812 | 27.4375 | 27.25 | 27.375 | 3296400.0 |
| 2001-01-17 12:30:00 | MSFT | Stock | 27.3438 | 27.4062 | 27.1875 | 27.1875 | 2566800.0 |
| 2001-01-17 13:00:00 | MSFT | Stock | 27.1875 | 27.2188 | 27.0 | 27.0938 | 4274000.0 |
| 2001-01-17 13:30:00 | MSFT | Stock | 27.0938 | 27.25 | 27.0469 | 27.125 | 2764400.0 |
| 2001-01-17 14:00:00 | MSFT | Stock | 27.1406 | 27.1875 | 26.8125 | 27.0 | 3563400.0 |
| 2001-01-17 14:30:00 | MSFT | Stock | 26.9688 | 27.0 | 26.6875 | 26.75 | 3403000.0 |
| 2001-01-17 15:00:00 | MSFT | Stock | 26.75 | 26.7812 | 26.3125 | 26.5625 | 7325200.0 |
| 2001-01-17 15:30:00 | MSFT | Stock | 26.5625 | 26.625 | 26.2812 | 26.4375 | 6281200.0 |
| 2001-01-17 16:00:00 | MSFT | Stock | 26.4375 | 27.0 | 26.4062 | 26.4688 | 1396600.0 |
| 2001-01-17 16:30:00 | MSFT | Stock | 26.6875 | 26.875 | 26.375 | 26.75 | 110200.0 |
| 2001-01-17 17:00:00 | MSFT | Stock | 26.75 | 26.7812 | 26.4688 | 26.75 | 2837200.0 |
| 2001-01-17 17:30:00 | MSFT | Stock | 26.75 | 26.75 | 26.625 | 26.75 | 11200.0 |
| 2001-01-17 18:00:00 | MSFT | Stock | 26.75 | 26.75 | 26.5625 | 26.75 | 9200.0 |
| 2001-01-17 08:00:00 | NVDA | Stock | 0.1803 | 0.1803 | 0.1803 | 0.1803 | 4728000.0 |
| 2001-01-17 08:30:00 | NVDA | Stock | 0.1875 | 0.1875 | 0.1875 | 0.1875 | 384000.0 |
| 2001-01-17 09:00:00 | NVDA | Stock | 0.1938 | 0.1938 | 0.1876 | 0.1938 | 864000.0 |
| 2001-01-17 09:30:00 | NVDA | Stock | 0.1943 | 0.1984 | 0.1896 | 0.1914 | 70776000.0 |
| 2001-01-17 10:00:00 | NVDA | Stock | 0.1919 | 0.1961 | 0.1906 | 0.1927 | 65904000.0 |
| 2001-01-17 10:30:00 | NVDA | Stock | 0.1932 | 0.1969 | 0.1927 | 0.1958 | 38520000.0 |
| 2001-01-17 11:00:00 | NVDA | Stock | 0.1951 | 0.1979 | 0.1945 | 0.1971 | 33984000.0 |
| 2001-01-17 11:30:00 | NVDA | Stock | 0.1971 | 0.2 | 0.1961 | 0.1984 | 25824000.0 |
> showing 50 of 27,795 rows — these rows as CSV