PREVIEW / stock_1hour / 2006-12-12
file: by_date/stock_1hour/2006/2006-12-12.parquet size: 638 KB rows: 30,330 symbols: 2,462
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-12 07:00:00 | AAPL | Stock | 3.1768 | 3.1768 | 3.1764 | 3.1768 | 33600.0 |
| 2006-12-12 08:00:00 | AAPL | Stock | 3.175 | 3.1829 | 3.1661 | 3.1679 | 1485428.0 |
| 2006-12-12 09:00:00 | AAPL | Stock | 3.1671 | 3.1729 | 3.1518 | 3.16 | 58035096.0 |
| 2006-12-12 10:00:00 | AAPL | Stock | 3.16 | 3.1629 | 3.0825 | 3.1268 | 272947416.0 |
| 2006-12-12 11:00:00 | AAPL | Stock | 3.1271 | 3.1286 | 3.1043 | 3.1061 | 76264440.0 |
| 2006-12-12 12:00:00 | AAPL | Stock | 3.1061 | 3.1104 | 3.0854 | 3.0989 | 119739284.0 |
| 2006-12-12 13:00:00 | AAPL | Stock | 3.0989 | 3.1068 | 3.0936 | 3.0986 | 48704796.0 |
| 2006-12-12 14:00:00 | AAPL | Stock | 3.0982 | 3.1289 | 3.0593 | 3.075 | 223365212.0 |
| 2006-12-12 15:00:00 | AAPL | Stock | 3.0746 | 3.0875 | 3.0546 | 3.0768 | 207796120.0 |
| 2006-12-12 16:00:00 | AAPL | Stock | 3.075 | 3.0964 | 3.07 | 3.0761 | 1818488.0 |
| 2006-12-12 17:00:00 | AAPL | Stock | 3.0761 | 3.0764 | 3.0725 | 3.0725 | 299040.0 |
| 2006-12-12 18:00:00 | AAPL | Stock | 3.0732 | 3.075 | 3.0714 | 3.0725 | 639828.0 |
| 2006-12-12 19:00:00 | AAPL | Stock | 3.0725 | 3.0761 | 3.0714 | 3.0761 | 221900.0 |
| 2006-12-12 07:00:00 | MSFT | Stock | 29.54 | 29.54 | 29.54 | 29.54 | 100.0 |
| 2006-12-12 08:00:00 | MSFT | Stock | 29.54 | 29.57 | 29.5 | 29.5 | 7838.0 |
| 2006-12-12 09:00:00 | MSFT | Stock | 29.54 | 29.63 | 29.41 | 29.44 | 5804826.0 |
| 2006-12-12 10:00:00 | MSFT | Stock | 29.44 | 29.55 | 29.37 | 29.5 | 8833323.0 |
| 2006-12-12 11:00:00 | MSFT | Stock | 29.5 | 29.51 | 29.43 | 29.44 | 6983858.0 |
| 2006-12-12 12:00:00 | MSFT | Stock | 29.44 | 29.45 | 29.22 | 29.32 | 11709032.0 |
| 2006-12-12 13:00:00 | MSFT | Stock | 29.32 | 29.41 | 29.31 | 29.36 | 4620723.0 |
| 2006-12-12 14:00:00 | MSFT | Stock | 29.37 | 29.5 | 29.34 | 29.4 | 8218353.0 |
| 2006-12-12 15:00:00 | MSFT | Stock | 29.4 | 29.46 | 29.24 | 29.43 | 18317704.0 |
| 2006-12-12 16:00:00 | MSFT | Stock | 29.43 | 29.45 | 29.42 | 29.42 | 601491.0 |
| 2006-12-12 17:00:00 | MSFT | Stock | 29.43 | 29.45 | 29.42 | 29.45 | 53204.0 |
| 2006-12-12 18:00:00 | MSFT | Stock | 29.43 | 29.43 | 29.43 | 29.43 | 500.0 |
| 2006-12-12 19:00:00 | MSFT | Stock | 29.45 | 29.45 | 29.43 | 29.43 | 2820.0 |
| 2006-12-12 08:00:00 | NVDA | Stock | 0.6025 | 0.6025 | 0.599 | 0.599 | 314760.0 |
| 2006-12-12 09:00:00 | NVDA | Stock | 0.6 | 0.6003 | 0.5937 | 0.5965 | 43363380.0 |
| 2006-12-12 10:00:00 | NVDA | Stock | 0.5965 | 0.6002 | 0.5917 | 0.5973 | 74998140.0 |
| 2006-12-12 11:00:00 | NVDA | Stock | 0.5975 | 0.5975 | 0.5925 | 0.595 | 41813760.0 |
| 2006-12-12 12:00:00 | NVDA | Stock | 0.5949 | 0.5953 | 0.5885 | 0.5917 | 72520320.0 |
| 2006-12-12 13:00:00 | NVDA | Stock | 0.5915 | 0.5955 | 0.5897 | 0.5944 | 38290020.0 |
| 2006-12-12 14:00:00 | NVDA | Stock | 0.5945 | 0.6 | 0.5942 | 0.5975 | 113263080.0 |
| 2006-12-12 15:00:00 | NVDA | Stock | 0.5973 | 0.6 | 0.5955 | 0.5962 | 109536000.0 |
| 2006-12-12 16:00:00 | NVDA | Stock | 0.5957 | 0.5973 | 0.595 | 0.5965 | 13765380.0 |
| 2006-12-12 17:00:00 | NVDA | Stock | 0.5952 | 0.5952 | 0.5952 | 0.5952 | 6000.0 |
| 2006-12-12 18:00:00 | NVDA | Stock | 0.595 | 0.5962 | 0.595 | 0.595 | 162000.0 |
| 2006-12-12 08:00:00 | AMZN | Stock | 1.9245 | 1.9245 | 1.912 | 1.912 | 59300.0 |
| 2006-12-12 09:00:00 | AMZN | Stock | 1.923 | 1.947 | 1.915 | 1.939 | 8339480.0 |
| 2006-12-12 10:00:00 | AMZN | Stock | 1.9385 | 1.9385 | 1.92 | 1.9265 | 10813060.0 |
| 2006-12-12 11:00:00 | AMZN | Stock | 1.926 | 1.9315 | 1.921 | 1.921 | 9739700.0 |
| 2006-12-12 12:00:00 | AMZN | Stock | 1.921 | 1.924 | 1.9075 | 1.911 | 14207840.0 |
| 2006-12-12 13:00:00 | AMZN | Stock | 1.911 | 1.9225 | 1.911 | 1.92 | 4118940.0 |
| 2006-12-12 14:00:00 | AMZN | Stock | 1.9195 | 1.9365 | 1.914 | 1.9225 | 16113340.0 |
| 2006-12-12 15:00:00 | AMZN | Stock | 1.922 | 1.9265 | 1.9165 | 1.924 | 22312860.0 |
| 2006-12-12 16:00:00 | AMZN | Stock | 1.923 | 1.94 | 1.922 | 1.923 | 304900.0 |
| 2006-12-12 09:00:00 | CL | Stock | 32.99 | 32.995 | 32.84 | 32.89 | 271600.0 |
| 2006-12-12 10:00:00 | CL | Stock | 32.885 | 32.915 | 32.85 | 32.875 | 383000.0 |
| 2006-12-12 11:00:00 | CL | Stock | 32.875 | 32.9 | 32.81 | 32.82 | 376000.0 |
| 2006-12-12 12:00:00 | CL | Stock | 32.815 | 32.88 | 32.76 | 32.77 | 461600.0 |
> showing 50 of 30,330 rows — these rows as CSV