PREVIEW / stock_1hour / 2005-02-10
file: by_date/stock_1hour/2005/2005-02-10.parquet size: 534 KB rows: 25,062 symbols: 1,919
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-02-10 08:00:00 | AAPL | Stock | 1.417 | 1.4186 | 1.3946 | 1.3955 | 2319184.0 |
| 2005-02-10 09:00:00 | AAPL | Stock | 1.3964 | 1.4139 | 1.3846 | 1.4111 | 212386832.0 |
| 2005-02-10 10:00:00 | AAPL | Stock | 1.4114 | 1.4127 | 1.3705 | 1.3782 | 255788848.0 |
| 2005-02-10 11:00:00 | AAPL | Stock | 1.378 | 1.3932 | 1.3689 | 1.3884 | 152649280.0 |
| 2005-02-10 12:00:00 | AAPL | Stock | 1.3888 | 1.3939 | 1.3789 | 1.3866 | 91535192.0 |
| 2005-02-10 13:00:00 | AAPL | Stock | 1.3866 | 1.4145 | 1.3814 | 1.4141 | 141671936.0 |
| 2005-02-10 14:00:00 | AAPL | Stock | 1.4141 | 1.4157 | 1.3929 | 1.4009 | 126975408.0 |
| 2005-02-10 15:00:00 | AAPL | Stock | 1.4005 | 1.4096 | 1.3975 | 1.4009 | 102102896.0 |
| 2005-02-10 16:00:00 | AAPL | Stock | 1.4011 | 1.4036 | 1.3938 | 1.3946 | 3780056.0 |
| 2005-02-10 17:00:00 | AAPL | Stock | 1.3943 | 1.3996 | 1.393 | 1.3996 | 1661016.0 |
| 2005-02-10 18:00:00 | AAPL | Stock | 1.3988 | 1.4 | 1.3988 | 1.4 | 336000.0 |
| 2005-02-10 08:00:00 | MSFT | Stock | 26.11 | 26.11 | 26.07 | 26.11 | 13255.0 |
| 2005-02-10 09:00:00 | MSFT | Stock | 26.11 | 26.13 | 26.01 | 26.06 | 10379064.0 |
| 2005-02-10 10:00:00 | MSFT | Stock | 26.07 | 26.13 | 26.03 | 26.05 | 12240938.0 |
| 2005-02-10 11:00:00 | MSFT | Stock | 26.05 | 26.08 | 26.03 | 26.04 | 7760425.0 |
| 2005-02-10 12:00:00 | MSFT | Stock | 26.05 | 26.13 | 26.03 | 26.04 | 7712271.0 |
| 2005-02-10 13:00:00 | MSFT | Stock | 26.05 | 26.09 | 26.0 | 26.07 | 8221114.0 |
| 2005-02-10 14:00:00 | MSFT | Stock | 26.08 | 26.12 | 26.04 | 26.07 | 8825814.0 |
| 2005-02-10 15:00:00 | MSFT | Stock | 26.07 | 26.13 | 26.05 | 26.06 | 14656798.0 |
| 2005-02-10 16:00:00 | MSFT | Stock | 26.06 | 26.09 | 25.87 | 26.05 | 660334.0 |
| 2005-02-10 17:00:00 | MSFT | Stock | 26.0 | 26.078 | 26.0 | 26.02 | 688590.0 |
| 2005-02-10 18:00:00 | MSFT | Stock | 26.01 | 26.01 | 26.0 | 26.01 | 3100.0 |
| 2005-02-10 08:00:00 | NVDA | Stock | 0.2075 | 0.2077 | 0.2075 | 0.2077 | 126120.0 |
| 2005-02-10 09:00:00 | NVDA | Stock | 0.2076 | 0.2109 | 0.2074 | 0.2104 | 58608960.0 |
| 2005-02-10 10:00:00 | NVDA | Stock | 0.2103 | 0.2123 | 0.2072 | 0.2089 | 114366840.0 |
| 2005-02-10 11:00:00 | NVDA | Stock | 0.2089 | 0.2102 | 0.2072 | 0.2095 | 81294960.0 |
| 2005-02-10 12:00:00 | NVDA | Stock | 0.2095 | 0.2122 | 0.209 | 0.2116 | 68655120.0 |
| 2005-02-10 13:00:00 | NVDA | Stock | 0.2116 | 0.2127 | 0.2107 | 0.2126 | 78211440.0 |
| 2005-02-10 14:00:00 | NVDA | Stock | 0.2126 | 0.2128 | 0.2099 | 0.2107 | 65464200.0 |
| 2005-02-10 15:00:00 | NVDA | Stock | 0.2107 | 0.2127 | 0.2102 | 0.2117 | 106760400.0 |
| 2005-02-10 16:00:00 | NVDA | Stock | 0.2117 | 0.2117 | 0.21 | 0.21 | 5566680.0 |
| 2005-02-10 17:00:00 | NVDA | Stock | 0.2102 | 0.2119 | 0.21 | 0.21 | 20958000.0 |
| 2005-02-10 08:00:00 | AMZN | Stock | 1.7975 | 1.8 | 1.7975 | 1.8 | 92200.0 |
| 2005-02-10 09:00:00 | AMZN | Stock | 1.8005 | 1.8055 | 1.7805 | 1.785 | 16982960.0 |
| 2005-02-10 10:00:00 | AMZN | Stock | 1.785 | 1.803 | 1.7765 | 1.782 | 36467080.0 |
| 2005-02-10 11:00:00 | AMZN | Stock | 1.7815 | 1.7925 | 1.7775 | 1.7835 | 22335480.0 |
| 2005-02-10 12:00:00 | AMZN | Stock | 1.784 | 1.802 | 1.782 | 1.799 | 21133700.0 |
| 2005-02-10 13:00:00 | AMZN | Stock | 1.7995 | 1.8025 | 1.7925 | 1.8025 | 10908860.0 |
| 2005-02-10 14:00:00 | AMZN | Stock | 1.802 | 1.8025 | 1.786 | 1.789 | 26937620.0 |
| 2005-02-10 15:00:00 | AMZN | Stock | 1.789 | 1.8035 | 1.785 | 1.7865 | 20275640.0 |
| 2005-02-10 16:00:00 | AMZN | Stock | 1.786 | 1.7892 | 1.7815 | 1.7892 | 840900.0 |
| 2005-02-10 17:00:00 | AMZN | Stock | 1.785 | 1.7855 | 1.785 | 1.785 | 12000.0 |
| 2005-02-10 09:00:00 | CL | Stock | 27.26 | 27.29 | 27.17 | 27.22 | 253200.0 |
| 2005-02-10 10:00:00 | CL | Stock | 27.22 | 27.24 | 27.08 | 27.12 | 461400.0 |
| 2005-02-10 11:00:00 | CL | Stock | 27.115 | 27.13 | 26.875 | 26.905 | 774000.0 |
| 2005-02-10 12:00:00 | CL | Stock | 26.905 | 26.995 | 26.855 | 26.9 | 1128600.0 |
| 2005-02-10 13:00:00 | CL | Stock | 26.9 | 27.05 | 26.865 | 27.03 | 778400.0 |
| 2005-02-10 14:00:00 | CL | Stock | 27.01 | 27.06 | 26.92 | 26.97 | 568400.0 |
| 2005-02-10 15:00:00 | CL | Stock | 26.965 | 27.065 | 26.94 | 27.0 | 921600.0 |
| 2005-02-10 16:00:00 | CL | Stock | 26.99 | 26.99 | 26.99 | 26.99 | 1000.0 |
> showing 50 of 25,062 rows — these rows as CSV