PREVIEW / stock_1hour / 2006-12-14
file: by_date/stock_1hour/2006/2006-12-14.parquet size: 637 KB rows: 30,426 symbols: 2,479
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-12-14 07:00:00 | AAPL | Stock | 3.1786 | 3.1893 | 3.1786 | 3.1811 | 352800.0 |
| 2006-12-14 08:00:00 | AAPL | Stock | 3.1857 | 3.1893 | 3.1736 | 3.175 | 3896900.0 |
| 2006-12-14 09:00:00 | AAPL | Stock | 3.1746 | 3.1964 | 3.1521 | 3.1664 | 136515344.0 |
| 2006-12-14 10:00:00 | AAPL | Stock | 3.1664 | 3.2143 | 3.1654 | 3.2043 | 221829188.0 |
| 2006-12-14 11:00:00 | AAPL | Stock | 3.2043 | 3.2068 | 3.1918 | 3.1957 | 80204208.0 |
| 2006-12-14 12:00:00 | AAPL | Stock | 3.1957 | 3.1996 | 3.1832 | 3.1925 | 75445552.0 |
| 2006-12-14 13:00:00 | AAPL | Stock | 3.1929 | 3.1989 | 3.1768 | 3.1911 | 88811184.0 |
| 2006-12-14 14:00:00 | AAPL | Stock | 3.1907 | 3.2043 | 3.1875 | 3.1968 | 65465232.0 |
| 2006-12-14 15:00:00 | AAPL | Stock | 3.1968 | 3.1982 | 3.1582 | 3.1614 | 139623680.0 |
| 2006-12-14 16:00:00 | AAPL | Stock | 3.1621 | 3.175 | 3.1575 | 3.1671 | 3422412.0 |
| 2006-12-14 17:00:00 | AAPL | Stock | 3.1661 | 3.1686 | 3.1661 | 3.1679 | 283080.0 |
| 2006-12-14 18:00:00 | AAPL | Stock | 3.1664 | 3.1696 | 3.1643 | 3.1643 | 163044.0 |
| 2006-12-14 19:00:00 | AAPL | Stock | 3.1643 | 3.1693 | 3.1625 | 3.1689 | 198380.0 |
| 2006-12-14 07:00:00 | MSFT | Stock | 29.53 | 29.53 | 29.53 | 29.53 | 500.0 |
| 2006-12-14 08:00:00 | MSFT | Stock | 29.55 | 29.57 | 29.53 | 29.56 | 9585.0 |
| 2006-12-14 09:00:00 | MSFT | Stock | 29.58 | 29.85 | 29.51 | 29.82 | 7348804.0 |
| 2006-12-14 10:00:00 | MSFT | Stock | 29.82 | 29.94 | 29.72 | 29.88 | 13736808.0 |
| 2006-12-14 11:00:00 | MSFT | Stock | 29.88 | 29.95 | 29.72 | 29.93 | 12215952.0 |
| 2006-12-14 12:00:00 | MSFT | Stock | 29.94 | 30.0 | 29.72 | 29.98 | 9282746.0 |
| 2006-12-14 13:00:00 | MSFT | Stock | 29.98 | 30.03 | 29.8 | 29.96 | 14123628.0 |
| 2006-12-14 14:00:00 | MSFT | Stock | 29.96 | 30.05 | 29.92 | 30.0 | 9588587.0 |
| 2006-12-14 15:00:00 | MSFT | Stock | 30.01 | 30.08 | 29.96 | 30.07 | 12184710.0 |
| 2006-12-14 16:00:00 | MSFT | Stock | 30.06 | 30.08 | 30.04 | 30.05 | 373474.0 |
| 2006-12-14 17:00:00 | MSFT | Stock | 30.04 | 30.07 | 30.03 | 30.03 | 1683835.0 |
| 2006-12-14 18:00:00 | MSFT | Stock | 30.04 | 30.05 | 30.03 | 30.05 | 5950.0 |
| 2006-12-14 19:00:00 | MSFT | Stock | 30.06 | 30.09 | 30.03 | 30.09 | 3500.0 |
| 2006-12-14 08:00:00 | NVDA | Stock | 0.605 | 0.6062 | 0.605 | 0.6062 | 30000.0 |
| 2006-12-14 09:00:00 | NVDA | Stock | 0.6067 | 0.6173 | 0.6067 | 0.6153 | 104495400.0 |
| 2006-12-14 10:00:00 | NVDA | Stock | 0.6155 | 0.6208 | 0.6148 | 0.6203 | 119251740.0 |
| 2006-12-14 11:00:00 | NVDA | Stock | 0.6203 | 0.6218 | 0.6177 | 0.62 | 72629040.0 |
| 2006-12-14 12:00:00 | NVDA | Stock | 0.62 | 0.6208 | 0.6153 | 0.6167 | 84130860.0 |
| 2006-12-14 13:00:00 | NVDA | Stock | 0.6165 | 0.618 | 0.6155 | 0.616 | 53568960.0 |
| 2006-12-14 14:00:00 | NVDA | Stock | 0.616 | 0.6182 | 0.616 | 0.6172 | 54131520.0 |
| 2006-12-14 15:00:00 | NVDA | Stock | 0.6172 | 0.618 | 0.614 | 0.6142 | 108066780.0 |
| 2006-12-14 16:00:00 | NVDA | Stock | 0.6142 | 0.6147 | 0.6137 | 0.6145 | 1027320.0 |
| 2006-12-14 17:00:00 | NVDA | Stock | 0.6165 | 0.6165 | 0.6165 | 0.6165 | 6000.0 |
| 2006-12-14 18:00:00 | NVDA | Stock | 0.6165 | 0.6173 | 0.6165 | 0.6173 | 59220.0 |
| 2006-12-14 09:00:00 | AMZN | Stock | 1.926 | 1.9625 | 1.926 | 1.959 | 15925520.0 |
| 2006-12-14 10:00:00 | AMZN | Stock | 1.959 | 1.975 | 1.957 | 1.972 | 28575620.0 |
| 2006-12-14 11:00:00 | AMZN | Stock | 1.9715 | 1.977 | 1.9675 | 1.97 | 17799620.0 |
| 2006-12-14 12:00:00 | AMZN | Stock | 1.97 | 1.9705 | 1.9555 | 1.9605 | 13974180.0 |
| 2006-12-14 13:00:00 | AMZN | Stock | 1.9605 | 1.9665 | 1.957 | 1.959 | 9918820.0 |
| 2006-12-14 14:00:00 | AMZN | Stock | 1.9595 | 1.9675 | 1.9555 | 1.9635 | 9989040.0 |
| 2006-12-14 15:00:00 | AMZN | Stock | 1.963 | 1.965 | 1.9495 | 1.9505 | 25493100.0 |
| 2006-12-14 16:00:00 | AMZN | Stock | 1.9505 | 1.9515 | 1.949 | 1.9495 | 149620.0 |
| 2006-12-14 19:00:00 | AMZN | Stock | 1.955 | 1.955 | 1.9525 | 1.9525 | 5000.0 |
| 2006-12-14 09:00:00 | CL | Stock | 32.89 | 32.99 | 32.745 | 32.985 | 238000.0 |
| 2006-12-14 10:00:00 | CL | Stock | 32.97 | 33.01 | 32.89 | 32.915 | 598200.0 |
| 2006-12-14 11:00:00 | CL | Stock | 32.915 | 32.995 | 32.86 | 32.885 | 362200.0 |
| 2006-12-14 12:00:00 | CL | Stock | 32.89 | 32.915 | 32.845 | 32.885 | 226200.0 |
> showing 50 of 30,426 rows — these rows as CSV