PREVIEW / stock_30min / 2006-11-22
file: by_date/stock_30min/2006/2006-11-22.parquet size: 936 KB rows: 50,784 symbols: 2,451
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-22 07:30:00 | AAPL | Stock | 3.1893 | 3.1925 | 3.1839 | 3.1839 | 30240.0 |
| 2006-11-22 08:00:00 | AAPL | Stock | 3.1821 | 3.1925 | 3.1814 | 3.1904 | 1659924.0 |
| 2006-11-22 08:30:00 | AAPL | Stock | 3.1893 | 3.1911 | 3.1807 | 3.1814 | 1605716.0 |
| 2006-11-22 09:00:00 | AAPL | Stock | 3.1811 | 3.1843 | 3.1743 | 3.1764 | 1489236.0 |
| 2006-11-22 09:30:00 | AAPL | Stock | 3.1782 | 3.1786 | 3.1607 | 3.17 | 82700912.0 |
| 2006-11-22 10:00:00 | AAPL | Stock | 3.17 | 3.1701 | 3.1375 | 3.15 | 85912232.0 |
| 2006-11-22 10:30:00 | AAPL | Stock | 3.15 | 3.1736 | 3.15 | 3.1686 | 72603412.0 |
| 2006-11-22 11:00:00 | AAPL | Stock | 3.1686 | 3.1768 | 3.1664 | 3.1746 | 41073620.0 |
| 2006-11-22 11:30:00 | AAPL | Stock | 3.1746 | 3.2139 | 3.1732 | 3.1893 | 43699152.0 |
| 2006-11-22 12:00:00 | AAPL | Stock | 3.1893 | 3.2032 | 3.185 | 3.199 | 49377748.0 |
| 2006-11-22 12:30:00 | AAPL | Stock | 3.1989 | 3.2025 | 3.1971 | 3.2011 | 25597460.0 |
| 2006-11-22 13:00:00 | AAPL | Stock | 3.201 | 3.2071 | 3.1893 | 3.1939 | 44374344.0 |
| 2006-11-22 13:30:00 | AAPL | Stock | 3.1939 | 3.2032 | 3.1925 | 3.2004 | 25476864.0 |
| 2006-11-22 14:00:00 | AAPL | Stock | 3.2001 | 3.2107 | 3.1936 | 3.2036 | 42858872.0 |
| 2006-11-22 14:30:00 | AAPL | Stock | 3.2036 | 3.2143 | 3.1982 | 3.2075 | 39200000.0 |
| 2006-11-22 15:00:00 | AAPL | Stock | 3.2079 | 3.2132 | 3.2076 | 3.2125 | 26023956.0 |
| 2006-11-22 15:30:00 | AAPL | Stock | 3.2121 | 3.2411 | 3.2118 | 3.2243 | 76011488.0 |
| 2006-11-22 16:00:00 | AAPL | Stock | 3.2243 | 3.2304 | 3.2207 | 3.2289 | 2235912.0 |
| 2006-11-22 16:30:00 | AAPL | Stock | 3.2321 | 3.2339 | 3.225 | 3.2286 | 701792.0 |
| 2006-11-22 17:00:00 | AAPL | Stock | 3.2286 | 3.2339 | 3.2286 | 3.2296 | 235620.0 |
| 2006-11-22 17:30:00 | AAPL | Stock | 3.2296 | 3.2336 | 3.2296 | 3.2336 | 28420.0 |
| 2006-11-22 18:00:00 | AAPL | Stock | 3.2329 | 3.2339 | 3.2257 | 3.2257 | 209608.0 |
| 2006-11-22 18:30:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2296 | 3.2296 | 45500.0 |
| 2006-11-22 19:00:00 | AAPL | Stock | 3.2336 | 3.2339 | 3.2329 | 3.2339 | 78344.0 |
| 2006-11-22 19:30:00 | AAPL | Stock | 3.2339 | 3.2339 | 3.2329 | 3.2339 | 80808.0 |
| 2006-11-22 07:30:00 | MSFT | Stock | 30.01 | 30.01 | 30.0 | 30.0 | 1310.0 |
| 2006-11-22 08:00:00 | MSFT | Stock | 30.0 | 30.06 | 29.98 | 30.0 | 42182.0 |
| 2006-11-22 08:30:00 | MSFT | Stock | 30.0 | 30.04 | 29.98 | 29.98 | 21476.0 |
| 2006-11-22 09:00:00 | MSFT | Stock | 29.98 | 29.99 | 29.94 | 29.98 | 84700.0 |
| 2006-11-22 09:30:00 | MSFT | Stock | 29.97 | 30.0 | 29.92 | 29.93 | 6636515.0 |
| 2006-11-22 10:00:00 | MSFT | Stock | 29.92 | 29.95 | 29.82 | 29.9 | 5993479.0 |
| 2006-11-22 10:30:00 | MSFT | Stock | 29.91 | 29.93 | 29.87 | 29.921 | 3196027.0 |
| 2006-11-22 11:00:00 | MSFT | Stock | 29.93 | 29.96 | 29.9 | 29.9 | 2878517.0 |
| 2006-11-22 11:30:00 | MSFT | Stock | 29.9 | 29.92 | 29.89 | 29.91 | 1745502.0 |
| 2006-11-22 12:00:00 | MSFT | Stock | 29.91 | 29.93 | 29.86 | 29.9 | 1498623.0 |
| 2006-11-22 12:30:00 | MSFT | Stock | 29.901 | 29.92 | 29.85 | 29.86 | 1906474.0 |
| 2006-11-22 13:00:00 | MSFT | Stock | 29.86 | 29.88 | 29.83 | 29.88 | 2508120.0 |
| 2006-11-22 13:30:00 | MSFT | Stock | 29.88 | 29.9 | 29.86 | 29.86 | 1717797.0 |
| 2006-11-22 14:00:00 | MSFT | Stock | 29.87 | 29.92 | 29.86 | 29.9 | 1699866.0 |
| 2006-11-22 14:30:00 | MSFT | Stock | 29.898 | 29.94 | 29.89 | 29.91 | 2335440.0 |
| 2006-11-22 15:00:00 | MSFT | Stock | 29.91 | 29.93 | 29.89 | 29.9 | 2160656.0 |
| 2006-11-22 15:30:00 | MSFT | Stock | 29.902 | 29.94 | 29.89 | 29.91 | 3512535.0 |
| 2006-11-22 16:00:00 | MSFT | Stock | 29.92 | 29.93 | 29.9 | 29.92 | 570788.0 |
| 2006-11-22 16:30:00 | MSFT | Stock | 29.92 | 29.92 | 29.89 | 29.89 | 9037.0 |
| 2006-11-22 18:00:00 | MSFT | Stock | 29.92 | 29.92 | 29.91 | 29.91 | 227000.0 |
| 2006-11-22 19:00:00 | MSFT | Stock | 29.91 | 29.91 | 29.86 | 29.86 | 2192.0 |
| 2006-11-22 19:30:00 | MSFT | Stock | 29.86 | 29.86 | 29.86 | 29.86 | 1000.0 |
| 2006-11-22 08:00:00 | NVDA | Stock | 0.6057 | 0.6058 | 0.6047 | 0.6047 | 208620.0 |
| 2006-11-22 09:00:00 | NVDA | Stock | 0.6047 | 0.6047 | 0.603 | 0.6045 | 60000.0 |
| 2006-11-22 09:30:00 | NVDA | Stock | 0.6037 | 0.6078 | 0.6005 | 0.601 | 31099680.0 |
> showing 50 of 50,784 rows — these rows as CSV