PREVIEW / stock_30min / 2000-01-18
file: by_date/stock_30min/2000/2000-01-18.parquet size: 412 KB rows: 23,979 symbols: 1,130
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-01-18 09:30:00 | AAPL | Stock | 0.9018 | 0.9129 | 0.8984 | 0.904 | 57702400.0 |
| 2000-01-18 10:00:00 | AAPL | Stock | 0.9035 | 0.9035 | 0.8968 | 0.899 | 25323200.0 |
| 2000-01-18 10:30:00 | AAPL | Stock | 0.9001 | 0.9079 | 0.8968 | 0.8987 | 22131200.0 |
| 2000-01-18 11:00:00 | AAPL | Stock | 0.8984 | 0.9035 | 0.8968 | 0.9026 | 28481600.0 |
| 2000-01-18 11:30:00 | AAPL | Stock | 0.9023 | 0.9235 | 0.9012 | 0.9174 | 34809600.0 |
| 2000-01-18 12:00:00 | AAPL | Stock | 0.9185 | 0.9369 | 0.9107 | 0.9353 | 36691200.0 |
| 2000-01-18 12:30:00 | AAPL | Stock | 0.9353 | 0.9375 | 0.9247 | 0.9353 | 23564800.0 |
| 2000-01-18 13:00:00 | AAPL | Stock | 0.9353 | 0.9375 | 0.9252 | 0.9364 | 31180800.0 |
| 2000-01-18 13:30:00 | AAPL | Stock | 0.9364 | 0.9369 | 0.9252 | 0.9252 | 18950400.0 |
| 2000-01-18 14:00:00 | AAPL | Stock | 0.9252 | 0.9325 | 0.9213 | 0.9241 | 28078400.0 |
| 2000-01-18 14:30:00 | AAPL | Stock | 0.9241 | 0.9369 | 0.923 | 0.9319 | 26331200.0 |
| 2000-01-18 15:00:00 | AAPL | Stock | 0.9319 | 0.9431 | 0.9302 | 0.942 | 41216000.0 |
| 2000-01-18 15:30:00 | AAPL | Stock | 0.9425 | 0.9464 | 0.9275 | 0.9286 | 43232000.0 |
| 2000-01-18 16:00:00 | AAPL | Stock | 0.9291 | 0.9291 | 0.928 | 0.928 | 1948800.0 |
| 2000-01-18 09:30:00 | MSFT | Stock | 55.9062 | 57.25 | 55.875 | 57.0938 | 13704800.0 |
| 2000-01-18 10:00:00 | MSFT | Stock | 57.125 | 57.375 | 56.875 | 57.2812 | 6783000.0 |
| 2000-01-18 10:30:00 | MSFT | Stock | 57.2812 | 57.5 | 57.1875 | 57.4062 | 6530200.0 |
| 2000-01-18 11:00:00 | MSFT | Stock | 57.4375 | 57.6875 | 57.1875 | 57.625 | 7956600.0 |
| 2000-01-18 11:30:00 | MSFT | Stock | 57.5938 | 57.75 | 57.2812 | 57.5 | 3214800.0 |
| 2000-01-18 12:00:00 | MSFT | Stock | 57.5 | 57.5 | 57.2812 | 57.5 | 2180000.0 |
| 2000-01-18 12:30:00 | MSFT | Stock | 57.4688 | 57.5312 | 57.25 | 57.2812 | 2004800.0 |
| 2000-01-18 13:00:00 | MSFT | Stock | 57.3438 | 57.5312 | 57.3125 | 57.375 | 2621600.0 |
| 2000-01-18 13:30:00 | MSFT | Stock | 57.3438 | 57.625 | 57.3125 | 57.4375 | 2771400.0 |
| 2000-01-18 14:00:00 | MSFT | Stock | 57.4375 | 57.9375 | 57.3438 | 57.9062 | 4425000.0 |
| 2000-01-18 14:30:00 | MSFT | Stock | 57.875 | 58.0 | 57.625 | 57.7969 | 5033400.0 |
| 2000-01-18 15:00:00 | MSFT | Stock | 57.8125 | 58.0 | 57.5 | 57.7656 | 5335800.0 |
| 2000-01-18 15:30:00 | MSFT | Stock | 57.8125 | 58.0312 | 57.375 | 57.6875 | 9968400.0 |
| 2000-01-18 16:00:00 | MSFT | Stock | 57.6875 | 57.8125 | 57.6094 | 57.6562 | 299400.0 |
| 2000-01-18 09:30:00 | NVDA | Stock | 0.0927 | 0.0935 | 0.0926 | 0.0927 | 21456000.0 |
| 2000-01-18 10:00:00 | NVDA | Stock | 0.0932 | 0.0945 | 0.0902 | 0.0904 | 57264000.0 |
| 2000-01-18 10:30:00 | NVDA | Stock | 0.0902 | 0.0919 | 0.0885 | 0.0885 | 20976000.0 |
| 2000-01-18 11:00:00 | NVDA | Stock | 0.0885 | 0.091 | 0.0885 | 0.0898 | 16608000.0 |
| 2000-01-18 11:30:00 | NVDA | Stock | 0.091 | 0.0924 | 0.0898 | 0.0906 | 10032000.0 |
| 2000-01-18 12:00:00 | NVDA | Stock | 0.0911 | 0.0927 | 0.0911 | 0.0927 | 4512000.0 |
| 2000-01-18 12:30:00 | NVDA | Stock | 0.0922 | 0.0924 | 0.0919 | 0.0924 | 7968000.0 |
| 2000-01-18 13:00:00 | NVDA | Stock | 0.0919 | 0.0922 | 0.0911 | 0.0918 | 8016000.0 |
| 2000-01-18 13:30:00 | NVDA | Stock | 0.0918 | 0.0953 | 0.0911 | 0.0943 | 23184000.0 |
| 2000-01-18 14:00:00 | NVDA | Stock | 0.0943 | 0.0951 | 0.0924 | 0.0943 | 11616000.0 |
| 2000-01-18 14:30:00 | NVDA | Stock | 0.0949 | 0.0956 | 0.0943 | 0.0944 | 22848000.0 |
| 2000-01-18 15:00:00 | NVDA | Stock | 0.0947 | 0.0958 | 0.0941 | 0.0958 | 15936000.0 |
| 2000-01-18 15:30:00 | NVDA | Stock | 0.0958 | 0.0958 | 0.0947 | 0.0954 | 18048000.0 |
| 2000-01-18 09:30:00 | AMZN | Stock | 3.1719 | 3.1969 | 3.15 | 3.1594 | 19804000.0 |
| 2000-01-18 10:00:00 | AMZN | Stock | 3.1656 | 3.2156 | 3.15 | 3.2 | 11692000.0 |
| 2000-01-18 10:30:00 | AMZN | Stock | 3.2 | 3.2312 | 3.1781 | 3.1781 | 7764000.0 |
| 2000-01-18 11:00:00 | AMZN | Stock | 3.1781 | 3.2 | 3.1688 | 3.1781 | 4480000.0 |
| 2000-01-18 11:30:00 | AMZN | Stock | 3.1813 | 3.1969 | 3.1531 | 3.1625 | 5050000.0 |
| 2000-01-18 12:00:00 | AMZN | Stock | 3.1625 | 3.2 | 3.1562 | 3.1906 | 5220000.0 |
| 2000-01-18 12:30:00 | AMZN | Stock | 3.1844 | 3.2063 | 3.175 | 3.1969 | 4168000.0 |
| 2000-01-18 13:00:00 | AMZN | Stock | 3.1969 | 3.2219 | 3.1875 | 3.1875 | 4562000.0 |
| 2000-01-18 13:30:00 | AMZN | Stock | 3.1875 | 3.2 | 3.175 | 3.175 | 2770000.0 |
> showing 50 of 23,979 rows — these rows as CSV