PREVIEW / stock_30min / 2005-11-28
file: by_date/stock_30min/2005/2005-11-28.parquet size: 874 KB rows: 46,991 symbols: 2,134
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-28 07:00:00 | AAPL | Stock | 2.5007 | 2.5286 | 2.5004 | 2.525 | 285600.0 |
| 2005-11-28 07:30:00 | AAPL | Stock | 2.5179 | 2.5179 | 2.5107 | 2.5143 | 306600.0 |
| 2005-11-28 08:00:00 | AAPL | Stock | 2.5179 | 2.5307 | 2.5114 | 2.5257 | 7343448.0 |
| 2005-11-28 08:30:00 | AAPL | Stock | 2.5264 | 2.535 | 2.5243 | 2.5296 | 6310808.0 |
| 2005-11-28 09:00:00 | AAPL | Stock | 2.5296 | 2.5332 | 2.5218 | 2.5264 | 10592876.0 |
| 2005-11-28 09:30:00 | AAPL | Stock | 2.5257 | 2.5382 | 2.5036 | 2.5093 | 260523312.0 |
| 2005-11-28 10:00:00 | AAPL | Stock | 2.5093 | 2.5175 | 2.4975 | 2.5107 | 124937848.0 |
| 2005-11-28 10:30:00 | AAPL | Stock | 2.5104 | 2.5264 | 2.4875 | 2.4889 | 85123584.0 |
| 2005-11-28 11:00:00 | AAPL | Stock | 2.4886 | 2.5089 | 2.4668 | 2.4711 | 109951604.0 |
| 2005-11-28 11:30:00 | AAPL | Stock | 2.4711 | 2.4911 | 2.4704 | 2.4879 | 78147972.0 |
| 2005-11-28 12:00:00 | AAPL | Stock | 2.4875 | 2.5057 | 2.4864 | 2.4964 | 45625636.0 |
| 2005-11-28 12:30:00 | AAPL | Stock | 2.4964 | 2.5 | 2.4804 | 2.4821 | 42734720.0 |
| 2005-11-28 13:00:00 | AAPL | Stock | 2.4821 | 2.4982 | 2.4768 | 2.4979 | 49207872.0 |
| 2005-11-28 13:30:00 | AAPL | Stock | 2.4975 | 2.4989 | 2.4857 | 2.4925 | 33123916.0 |
| 2005-11-28 14:00:00 | AAPL | Stock | 2.4929 | 2.4961 | 2.4843 | 2.4917 | 32219740.0 |
| 2005-11-28 14:30:00 | AAPL | Stock | 2.4918 | 2.4936 | 2.4829 | 2.4857 | 26789616.0 |
| 2005-11-28 15:00:00 | AAPL | Stock | 2.485 | 2.49 | 2.4754 | 2.4793 | 38286892.0 |
| 2005-11-28 15:30:00 | AAPL | Stock | 2.4793 | 2.4946 | 2.4775 | 2.4898 | 52569524.0 |
| 2005-11-28 16:00:00 | AAPL | Stock | 2.4889 | 2.4925 | 2.4862 | 2.4889 | 2922472.0 |
| 2005-11-28 16:30:00 | AAPL | Stock | 2.4889 | 2.4907 | 2.4858 | 2.4893 | 1007552.0 |
| 2005-11-28 17:00:00 | AAPL | Stock | 2.4893 | 2.4907 | 2.4893 | 2.4893 | 230720.0 |
| 2005-11-28 17:30:00 | AAPL | Stock | 2.4893 | 2.4929 | 2.4857 | 2.4896 | 229516.0 |
| 2005-11-28 18:00:00 | AAPL | Stock | 2.4918 | 2.4918 | 2.4875 | 2.4889 | 386456.0 |
| 2005-11-28 07:30:00 | MSFT | Stock | 27.84 | 27.84 | 27.84 | 27.84 | 300.0 |
| 2005-11-28 08:00:00 | MSFT | Stock | 27.81 | 27.9 | 27.8 | 27.85 | 29854.0 |
| 2005-11-28 08:30:00 | MSFT | Stock | 27.85 | 27.9 | 27.83 | 27.87 | 58054.0 |
| 2005-11-28 09:00:00 | MSFT | Stock | 27.87 | 27.89 | 27.77 | 27.78 | 397364.0 |
| 2005-11-28 09:30:00 | MSFT | Stock | 27.79 | 27.851 | 27.53 | 27.54 | 7407054.0 |
| 2005-11-28 10:00:00 | MSFT | Stock | 27.54 | 27.721 | 27.53 | 27.67 | 7991618.0 |
| 2005-11-28 10:30:00 | MSFT | Stock | 27.67 | 27.77 | 27.66 | 27.702 | 4640125.0 |
| 2005-11-28 11:00:00 | MSFT | Stock | 27.7 | 27.79 | 27.699 | 27.73 | 3645532.0 |
| 2005-11-28 11:30:00 | MSFT | Stock | 27.73 | 27.79 | 27.699 | 27.73 | 2630457.0 |
| 2005-11-28 12:00:00 | MSFT | Stock | 27.73 | 27.77 | 27.7 | 27.72 | 1878909.0 |
| 2005-11-28 12:30:00 | MSFT | Stock | 27.71 | 27.78 | 27.65 | 27.68 | 4891610.0 |
| 2005-11-28 13:00:00 | MSFT | Stock | 27.68 | 27.72 | 27.65 | 27.7 | 3600396.0 |
| 2005-11-28 13:30:00 | MSFT | Stock | 27.7 | 27.721 | 27.655 | 27.7 | 2367252.0 |
| 2005-11-28 14:00:00 | MSFT | Stock | 27.7 | 27.77 | 27.7 | 27.74 | 2856053.0 |
| 2005-11-28 14:30:00 | MSFT | Stock | 27.74 | 27.78 | 27.7 | 27.76 | 2552602.0 |
| 2005-11-28 15:00:00 | MSFT | Stock | 27.75 | 27.78 | 27.69 | 27.75 | 4818434.0 |
| 2005-11-28 15:30:00 | MSFT | Stock | 27.75 | 27.77 | 27.71 | 27.77 | 5943049.0 |
| 2005-11-28 16:00:00 | MSFT | Stock | 27.77 | 27.79 | 27.738 | 27.76 | 223936.0 |
| 2005-11-28 16:30:00 | MSFT | Stock | 27.75 | 27.77 | 27.75 | 27.75 | 25500.0 |
| 2005-11-28 17:00:00 | MSFT | Stock | 27.75 | 27.77 | 27.75 | 27.77 | 3200.0 |
| 2005-11-28 17:30:00 | MSFT | Stock | 27.76 | 27.78 | 27.716 | 27.77 | 11900.0 |
| 2005-11-28 18:00:00 | MSFT | Stock | 27.77 | 27.79 | 27.76 | 27.76 | 3610.0 |
| 2005-11-28 08:00:00 | NVDA | Stock | 0.3167 | 0.3167 | 0.3167 | 0.3167 | 27720.0 |
| 2005-11-28 08:30:00 | NVDA | Stock | 0.3167 | 0.3181 | 0.3167 | 0.3181 | 72000.0 |
| 2005-11-28 09:00:00 | NVDA | Stock | 0.3181 | 0.3181 | 0.3177 | 0.318 | 204000.0 |
| 2005-11-28 09:30:00 | NVDA | Stock | 0.3181 | 0.3208 | 0.317 | 0.3184 | 50110680.0 |
| 2005-11-28 10:00:00 | NVDA | Stock | 0.3184 | 0.3186 | 0.3169 | 0.3175 | 38694480.0 |
> showing 50 of 46,991 rows — these rows as CSV