PREVIEW / stock_1hour / 2001-10-02
file: by_date/stock_1hour/2001/2001-10-02.parquet size: 361 KB rows: 17,465 symbols: 1,335
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-02 08:00:00 | AAPL | Stock | 0.2766 | 0.2766 | 0.2766 | 0.2766 | 22400.0 |
| 2001-10-02 09:00:00 | AAPL | Stock | 0.2766 | 0.2813 | 0.2732 | 0.2786 | 20176800.0 |
| 2001-10-02 10:00:00 | AAPL | Stock | 0.2788 | 0.2827 | 0.2768 | 0.2777 | 25328800.0 |
| 2001-10-02 11:00:00 | AAPL | Stock | 0.2777 | 0.2823 | 0.2761 | 0.28 | 31925600.0 |
| 2001-10-02 12:00:00 | AAPL | Stock | 0.2795 | 0.2804 | 0.2759 | 0.2768 | 15192800.0 |
| 2001-10-02 13:00:00 | AAPL | Stock | 0.2761 | 0.2761 | 0.2716 | 0.2739 | 17343200.0 |
| 2001-10-02 14:00:00 | AAPL | Stock | 0.2738 | 0.2766 | 0.2668 | 0.2677 | 37284800.0 |
| 2001-10-02 15:00:00 | AAPL | Stock | 0.2675 | 0.2723 | 0.267 | 0.2688 | 56336000.0 |
| 2001-10-02 16:00:00 | AAPL | Stock | 0.2688 | 0.2696 | 0.2671 | 0.2675 | 15377600.0 |
| 2001-10-02 17:00:00 | AAPL | Stock | 0.2688 | 0.2688 | 0.2688 | 0.2688 | 212800.0 |
| 2001-10-02 18:00:00 | AAPL | Stock | 0.2688 | 0.2688 | 0.2688 | 0.2688 | 11200.0 |
| 2001-10-02 08:00:00 | MSFT | Stock | 25.685 | 25.895 | 25.25 | 25.67 | 387600.0 |
| 2001-10-02 09:00:00 | MSFT | Stock | 25.705 | 26.3005 | 25.675 | 26.215 | 9528600.0 |
| 2001-10-02 10:00:00 | MSFT | Stock | 26.2755 | 26.5 | 26.185 | 26.43 | 9335600.0 |
| 2001-10-02 11:00:00 | MSFT | Stock | 26.43 | 26.775 | 26.395 | 26.705 | 8958400.0 |
| 2001-10-02 12:00:00 | MSFT | Stock | 26.68 | 26.7205 | 26.405 | 26.4345 | 5081200.0 |
| 2001-10-02 13:00:00 | MSFT | Stock | 26.425 | 26.45 | 26.275 | 26.385 | 4621000.0 |
| 2001-10-02 14:00:00 | MSFT | Stock | 26.38 | 26.575 | 26.025 | 26.0905 | 18315200.0 |
| 2001-10-02 15:00:00 | MSFT | Stock | 26.085 | 26.55 | 26.08 | 26.52 | 16591400.0 |
| 2001-10-02 16:00:00 | MSFT | Stock | 26.48 | 26.575 | 26.09 | 26.525 | 2624000.0 |
| 2001-10-02 17:00:00 | MSFT | Stock | 26.485 | 26.525 | 26.45 | 26.45 | 220000.0 |
| 2001-10-02 18:00:00 | MSFT | Stock | 26.455 | 26.455 | 26.44 | 26.44 | 2200.0 |
| 2001-10-02 08:00:00 | NVDA | Stock | 0.2079 | 0.2083 | 0.2042 | 0.2083 | 216000.0 |
| 2001-10-02 09:00:00 | NVDA | Stock | 0.2096 | 0.2175 | 0.2071 | 0.2143 | 131208000.0 |
| 2001-10-02 10:00:00 | NVDA | Stock | 0.2143 | 0.2166 | 0.1888 | 0.2034 | 330240000.0 |
| 2001-10-02 11:00:00 | NVDA | Stock | 0.2034 | 0.21 | 0.2006 | 0.2021 | 139584000.0 |
| 2001-10-02 12:00:00 | NVDA | Stock | 0.2021 | 0.2069 | 0.2014 | 0.2063 | 88884000.0 |
| 2001-10-02 13:00:00 | NVDA | Stock | 0.2064 | 0.2087 | 0.205 | 0.2065 | 66972000.0 |
| 2001-10-02 14:00:00 | NVDA | Stock | 0.2068 | 0.21 | 0.1962 | 0.2 | 160776000.0 |
| 2001-10-02 15:00:00 | NVDA | Stock | 0.2 | 0.2029 | 0.1983 | 0.1989 | 150024000.0 |
| 2001-10-02 16:00:00 | NVDA | Stock | 0.199 | 0.2 | 0.1973 | 0.2 | 11124000.0 |
| 2001-10-02 17:00:00 | NVDA | Stock | 0.199 | 0.2 | 0.1979 | 0.1983 | 228000.0 |
| 2001-10-02 08:00:00 | AMZN | Stock | 0.2951 | 0.305 | 0.2951 | 0.305 | 46000.0 |
| 2001-10-02 09:00:00 | AMZN | Stock | 0.3025 | 0.3085 | 0.2975 | 0.304 | 10156000.0 |
| 2001-10-02 10:00:00 | AMZN | Stock | 0.3035 | 0.305 | 0.3 | 0.303 | 7058000.0 |
| 2001-10-02 11:00:00 | AMZN | Stock | 0.3035 | 0.306 | 0.3005 | 0.3035 | 7888000.0 |
| 2001-10-02 12:00:00 | AMZN | Stock | 0.3025 | 0.307 | 0.3015 | 0.3045 | 9462000.0 |
| 2001-10-02 13:00:00 | AMZN | Stock | 0.304 | 0.308 | 0.3035 | 0.307 | 13048000.0 |
| 2001-10-02 14:00:00 | AMZN | Stock | 0.3065 | 0.307 | 0.299 | 0.3046 | 21220000.0 |
| 2001-10-02 15:00:00 | AMZN | Stock | 0.3045 | 0.307 | 0.3 | 0.303 | 30370000.0 |
| 2001-10-02 16:00:00 | AMZN | Stock | 0.3035 | 0.305 | 0.3 | 0.3035 | 5688000.0 |
| 2001-10-02 17:00:00 | AMZN | Stock | 0.3035 | 0.305 | 0.3035 | 0.305 | 128000.0 |
| 2001-10-02 18:00:00 | AMZN | Stock | 0.3045 | 0.305 | 0.3045 | 0.305 | 46000.0 |
| 2001-10-02 09:00:00 | CL | Stock | 28.5 | 28.625 | 28.45 | 28.515 | 275400.0 |
| 2001-10-02 10:00:00 | CL | Stock | 28.515 | 28.61 | 28.37 | 28.6 | 360800.0 |
| 2001-10-02 11:00:00 | CL | Stock | 28.6 | 28.725 | 28.555 | 28.72 | 192400.0 |
| 2001-10-02 12:00:00 | CL | Stock | 28.725 | 28.725 | 28.49 | 28.505 | 228600.0 |
| 2001-10-02 13:00:00 | CL | Stock | 28.505 | 28.7 | 28.5 | 28.58 | 208400.0 |
| 2001-10-02 14:00:00 | CL | Stock | 28.58 | 28.65 | 28.405 | 28.415 | 352600.0 |
| 2001-10-02 15:00:00 | CL | Stock | 28.415 | 28.75 | 28.4 | 28.725 | 553600.0 |
> showing 50 of 17,465 rows — these rows as CSV