PREVIEW / stock_1hour / 2008-12-17
file: by_date/stock_1hour/2008/2008-12-17.parquet size: 869 KB rows: 45,007 symbols: 3,363
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-17 04:00:00 | AAPL | Stock | 3.3193 | 3.3193 | 3.3193 | 3.3193 | 2800.0 |
| 2008-12-17 05:00:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3482 | 3.3482 | 2800.0 |
| 2008-12-17 06:00:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.2857 | 3.2861 | 383740.0 |
| 2008-12-17 07:00:00 | AAPL | Stock | 3.2982 | 3.3054 | 3.2571 | 3.2786 | 1307992.0 |
| 2008-12-17 08:00:00 | AAPL | Stock | 3.2836 | 3.2857 | 3.2214 | 3.2782 | 10786748.0 |
| 2008-12-17 09:00:00 | AAPL | Stock | 3.2793 | 3.2814 | 3.1911 | 3.214 | 240107308.0 |
| 2008-12-17 10:00:00 | AAPL | Stock | 3.2139 | 3.2175 | 3.1436 | 3.1786 | 261147124.0 |
| 2008-12-17 11:00:00 | AAPL | Stock | 3.1786 | 3.1921 | 3.1475 | 3.1729 | 148154916.0 |
| 2008-12-17 12:00:00 | AAPL | Stock | 3.1729 | 3.1936 | 3.1614 | 3.185 | 126834344.0 |
| 2008-12-17 13:00:00 | AAPL | Stock | 3.185 | 3.225 | 3.175 | 3.1986 | 151797548.0 |
| 2008-12-17 14:00:00 | AAPL | Stock | 3.1982 | 3.2161 | 3.1614 | 3.185 | 123538016.0 |
| 2008-12-17 15:00:00 | AAPL | Stock | 3.185 | 3.2089 | 3.1643 | 3.1839 | 181425104.0 |
| 2008-12-17 16:00:00 | AAPL | Stock | 3.1821 | 3.1922 | 3.1768 | 3.1818 | 20740468.0 |
| 2008-12-17 17:00:00 | AAPL | Stock | 3.1807 | 3.1843 | 3.1754 | 3.1786 | 3028648.0 |
| 2008-12-17 18:00:00 | AAPL | Stock | 3.1779 | 3.1843 | 3.175 | 3.1779 | 5325768.0 |
| 2008-12-17 19:00:00 | AAPL | Stock | 3.1757 | 3.1821 | 3.1721 | 3.1754 | 501480.0 |
| 2008-12-17 20:00:00 | AAPL | Stock | 3.1843 | 3.1843 | 3.1843 | 3.1843 | 131600.0 |
| 2008-12-17 07:00:00 | MSFT | Stock | 19.85 | 19.85 | 19.72 | 19.83 | 1697.0 |
| 2008-12-17 08:00:00 | MSFT | Stock | 19.85 | 19.9 | 19.8 | 19.9 | 14957.0 |
| 2008-12-17 09:00:00 | MSFT | Stock | 19.9 | 20.02 | 19.76 | 19.8 | 8748758.0 |
| 2008-12-17 10:00:00 | MSFT | Stock | 19.81 | 19.82 | 19.5 | 19.68 | 12234280.0 |
| 2008-12-17 11:00:00 | MSFT | Stock | 19.68 | 19.868 | 19.5 | 19.84 | 7106954.0 |
| 2008-12-17 12:00:00 | MSFT | Stock | 19.84 | 20.05 | 19.8 | 19.94 | 6829297.0 |
| 2008-12-17 13:00:00 | MSFT | Stock | 19.94 | 20.01 | 19.86 | 19.94 | 7703412.0 |
| 2008-12-17 14:00:00 | MSFT | Stock | 19.94 | 20.01 | 19.62 | 19.79 | 12600455.0 |
| 2008-12-17 15:00:00 | MSFT | Stock | 19.79 | 20.0 | 19.63 | 19.64 | 17202763.0 |
| 2008-12-17 16:00:00 | MSFT | Stock | 19.64 | 19.86 | 19.62 | 19.86 | 3017881.0 |
| 2008-12-17 17:00:00 | MSFT | Stock | 19.67 | 20.11 | 19.65 | 20.11 | 799672.0 |
| 2008-12-17 18:00:00 | MSFT | Stock | 19.65 | 19.68 | 19.64 | 19.68 | 23385.0 |
| 2008-12-17 19:00:00 | MSFT | Stock | 19.66 | 19.69 | 19.66 | 19.66 | 1297.0 |
| 2008-12-17 20:00:00 | MSFT | Stock | 19.66 | 19.66 | 19.66 | 19.66 | 5900.0 |
| 2008-12-17 08:00:00 | NVDA | Stock | 0.2175 | 0.2188 | 0.214 | 0.2188 | 78440.0 |
| 2008-12-17 09:00:00 | NVDA | Stock | 0.218 | 0.2238 | 0.215 | 0.2212 | 56150800.0 |
| 2008-12-17 10:00:00 | NVDA | Stock | 0.2212 | 0.2228 | 0.215 | 0.2228 | 92873320.0 |
| 2008-12-17 11:00:00 | NVDA | Stock | 0.2228 | 0.2272 | 0.2228 | 0.227 | 65436160.0 |
| 2008-12-17 12:00:00 | NVDA | Stock | 0.2268 | 0.2335 | 0.2268 | 0.2322 | 82142360.0 |
| 2008-12-17 13:00:00 | NVDA | Stock | 0.2322 | 0.2355 | 0.2298 | 0.2335 | 91796160.0 |
| 2008-12-17 14:00:00 | NVDA | Stock | 0.2335 | 0.235 | 0.229 | 0.2332 | 106661960.0 |
| 2008-12-17 15:00:00 | NVDA | Stock | 0.2332 | 0.2362 | 0.2328 | 0.233 | 163842560.0 |
| 2008-12-17 16:00:00 | NVDA | Stock | 0.233 | 0.2337 | 0.2303 | 0.2337 | 176600.0 |
| 2008-12-17 18:00:00 | NVDA | Stock | 0.2308 | 0.2358 | 0.2308 | 0.2358 | 154400.0 |
| 2008-12-17 19:00:00 | NVDA | Stock | 0.2358 | 0.2358 | 0.233 | 0.233 | 92000.0 |
| 2008-12-17 08:00:00 | AMZN | Stock | 2.5925 | 2.5925 | 2.5925 | 2.5925 | 6000.0 |
| 2008-12-17 09:00:00 | AMZN | Stock | 2.6025 | 2.635 | 2.5765 | 2.6051 | 18107100.0 |
| 2008-12-17 10:00:00 | AMZN | Stock | 2.607 | 2.613 | 2.577 | 2.605 | 23509600.0 |
| 2008-12-17 11:00:00 | AMZN | Stock | 2.605 | 2.6445 | 2.5995 | 2.6385 | 14635440.0 |
| 2008-12-17 12:00:00 | AMZN | Stock | 2.6375 | 2.675 | 2.63 | 2.6525 | 23416480.0 |
| 2008-12-17 13:00:00 | AMZN | Stock | 2.653 | 2.682 | 2.6425 | 2.678 | 16627120.0 |
| 2008-12-17 14:00:00 | AMZN | Stock | 2.6775 | 2.6915 | 2.6565 | 2.686 | 25722140.0 |
| 2008-12-17 15:00:00 | AMZN | Stock | 2.687 | 2.7385 | 2.653 | 2.6595 | 56634240.0 |
> showing 50 of 45,007 rows — these rows as CSV