PREVIEW / stock_1hour / 2004-04-16
file: by_date/stock_1hour/2004/2004-04-16.parquet size: 501 KB rows: 23,384 symbols: 1,756
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 |
|---|---|---|---|---|---|---|---|
| 2004-04-16 08:00:00 | AAPL | Stock | 0.5231 | 0.5231 | 0.5179 | 0.5196 | 597800.0 |
| 2004-04-16 09:00:00 | AAPL | Stock | 0.5198 | 0.5229 | 0.5145 | 0.5163 | 44525992.0 |
| 2004-04-16 10:00:00 | AAPL | Stock | 0.5164 | 0.5168 | 0.5089 | 0.5141 | 67929064.0 |
| 2004-04-16 11:00:00 | AAPL | Stock | 0.5141 | 0.5189 | 0.5132 | 0.5188 | 37280040.0 |
| 2004-04-16 12:00:00 | AAPL | Stock | 0.5188 | 0.523 | 0.5175 | 0.5225 | 28737016.0 |
| 2004-04-16 13:00:00 | AAPL | Stock | 0.5223 | 0.5225 | 0.5177 | 0.5191 | 30867368.0 |
| 2004-04-16 14:00:00 | AAPL | Stock | 0.5189 | 0.5214 | 0.5184 | 0.5205 | 23639336.0 |
| 2004-04-16 15:00:00 | AAPL | Stock | 0.5204 | 0.5234 | 0.518 | 0.5211 | 55029352.0 |
| 2004-04-16 16:00:00 | AAPL | Stock | 0.5211 | 0.5234 | 0.5201 | 0.5211 | 6377448.0 |
| 2004-04-16 18:00:00 | AAPL | Stock | 0.5229 | 0.5232 | 0.5229 | 0.5232 | 11200.0 |
| 2004-04-16 08:00:00 | MSFT | Stock | 25.15 | 25.2 | 25.14 | 25.19 | 71589.0 |
| 2004-04-16 09:00:00 | MSFT | Stock | 25.19 | 25.35 | 25.11 | 25.15 | 5655698.0 |
| 2004-04-16 10:00:00 | MSFT | Stock | 25.16 | 25.3 | 25.11 | 25.23 | 6634050.0 |
| 2004-04-16 11:00:00 | MSFT | Stock | 25.23 | 25.4 | 25.19 | 25.24 | 7386988.0 |
| 2004-04-16 12:00:00 | MSFT | Stock | 25.24 | 25.34 | 25.19 | 25.3 | 3198262.0 |
| 2004-04-16 13:00:00 | MSFT | Stock | 25.3 | 25.32 | 25.191 | 25.2394 | 3979314.0 |
| 2004-04-16 14:00:00 | MSFT | Stock | 25.23 | 25.28 | 25.2 | 25.23 | 4101611.0 |
| 2004-04-16 15:00:00 | MSFT | Stock | 25.22 | 25.27 | 25.16 | 25.18 | 8179703.0 |
| 2004-04-16 16:00:00 | MSFT | Stock | 25.17 | 25.21 | 25.0 | 25.12 | 595964.0 |
| 2004-04-16 17:00:00 | MSFT | Stock | 25.13 | 25.14 | 25.12 | 25.14 | 8850.0 |
| 2004-04-16 18:00:00 | MSFT | Stock | 25.14 | 25.16 | 25.14 | 25.16 | 4950.0 |
| 2004-04-16 08:00:00 | NVDA | Stock | 0.2032 | 0.2033 | 0.2032 | 0.2033 | 534000.0 |
| 2004-04-16 09:00:00 | NVDA | Stock | 0.2033 | 0.2033 | 0.1963 | 0.1975 | 79976760.0 |
| 2004-04-16 10:00:00 | NVDA | Stock | 0.1974 | 0.1992 | 0.1967 | 0.1987 | 78256080.0 |
| 2004-04-16 11:00:00 | NVDA | Stock | 0.1987 | 0.2025 | 0.1987 | 0.1996 | 63859680.0 |
| 2004-04-16 12:00:00 | NVDA | Stock | 0.1996 | 0.2004 | 0.198 | 0.1988 | 85014480.0 |
| 2004-04-16 13:00:00 | NVDA | Stock | 0.1988 | 0.1988 | 0.197 | 0.1971 | 53436600.0 |
| 2004-04-16 14:00:00 | NVDA | Stock | 0.1972 | 0.1987 | 0.1971 | 0.1983 | 59250720.0 |
| 2004-04-16 15:00:00 | NVDA | Stock | 0.1983 | 0.1983 | 0.1966 | 0.1968 | 94249920.0 |
| 2004-04-16 16:00:00 | NVDA | Stock | 0.1965 | 0.1972 | 0.1963 | 0.1964 | 4055640.0 |
| 2004-04-16 17:00:00 | NVDA | Stock | 0.1965 | 0.1965 | 0.1965 | 0.1965 | 72000.0 |
| 2004-04-16 08:00:00 | AMZN | Stock | 2.347 | 2.35 | 2.335 | 2.335 | 78000.0 |
| 2004-04-16 09:00:00 | AMZN | Stock | 2.3435 | 2.3545 | 2.2915 | 2.3055 | 16525880.0 |
| 2004-04-16 10:00:00 | AMZN | Stock | 2.304 | 2.3125 | 2.2985 | 2.31 | 23630020.0 |
| 2004-04-16 11:00:00 | AMZN | Stock | 2.3095 | 2.349 | 2.3095 | 2.347 | 16551240.0 |
| 2004-04-16 12:00:00 | AMZN | Stock | 2.3475 | 2.3475 | 2.333 | 2.342 | 10558420.0 |
| 2004-04-16 13:00:00 | AMZN | Stock | 2.341 | 2.3475 | 2.3255 | 2.327 | 7249160.0 |
| 2004-04-16 14:00:00 | AMZN | Stock | 2.3265 | 2.3295 | 2.2985 | 2.301 | 10292200.0 |
| 2004-04-16 15:00:00 | AMZN | Stock | 2.301 | 2.301 | 2.2725 | 2.2775 | 39111560.0 |
| 2004-04-16 16:00:00 | AMZN | Stock | 2.277 | 2.278 | 2.266 | 2.271 | 2560700.0 |
| 2004-04-16 17:00:00 | AMZN | Stock | 2.2675 | 2.2715 | 2.2675 | 2.2675 | 384080.0 |
| 2004-04-16 18:00:00 | AMZN | Stock | 2.268 | 2.2715 | 2.268 | 2.2705 | 27000.0 |
| 2004-04-16 09:00:00 | CL | Stock | 27.9 | 27.95 | 27.805 | 27.885 | 430200.0 |
| 2004-04-16 10:00:00 | CL | Stock | 27.88 | 27.935 | 27.805 | 27.86 | 372400.0 |
| 2004-04-16 11:00:00 | CL | Stock | 27.86 | 27.9 | 27.81 | 27.865 | 212800.0 |
| 2004-04-16 12:00:00 | CL | Stock | 27.87 | 27.96 | 27.855 | 27.935 | 200400.0 |
| 2004-04-16 13:00:00 | CL | Stock | 27.935 | 27.975 | 27.925 | 27.945 | 245400.0 |
| 2004-04-16 14:00:00 | CL | Stock | 27.94 | 27.945 | 27.83 | 27.845 | 394000.0 |
| 2004-04-16 15:00:00 | CL | Stock | 27.85 | 27.9 | 27.77 | 27.835 | 714200.0 |
| 2004-04-16 16:00:00 | CL | Stock | 27.8755 | 27.8755 | 27.875 | 27.875 | 7400.0 |
> showing 50 of 23,384 rows — these rows as CSV