PREVIEW / stock_1hour / 2001-10-01
file: by_date/stock_1hour/2001/2001-10-01.parquet size: 362 KB rows: 17,409 symbols: 1,333
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-01 08:00:00 | AAPL | Stock | 0.2769 | 0.2769 | 0.2769 | 0.2769 | 560000.0 |
| 2001-10-01 09:00:00 | AAPL | Stock | 0.2759 | 0.2846 | 0.2759 | 0.2834 | 42873600.0 |
| 2001-10-01 10:00:00 | AAPL | Stock | 0.283 | 0.2836 | 0.2743 | 0.277 | 46552800.0 |
| 2001-10-01 11:00:00 | AAPL | Stock | 0.2768 | 0.2802 | 0.2768 | 0.2777 | 15752800.0 |
| 2001-10-01 12:00:00 | AAPL | Stock | 0.2777 | 0.2791 | 0.2754 | 0.2791 | 12213600.0 |
| 2001-10-01 13:00:00 | AAPL | Stock | 0.2793 | 0.2795 | 0.2757 | 0.2763 | 10505600.0 |
| 2001-10-01 14:00:00 | AAPL | Stock | 0.2763 | 0.2777 | 0.2757 | 0.277 | 12264000.0 |
| 2001-10-01 15:00:00 | AAPL | Stock | 0.277 | 0.2779 | 0.272 | 0.2773 | 32653600.0 |
| 2001-10-01 16:00:00 | AAPL | Stock | 0.2768 | 0.2786 | 0.2713 | 0.2764 | 10466400.0 |
| 2001-10-01 17:00:00 | AAPL | Stock | 0.2729 | 0.2775 | 0.2729 | 0.2766 | 2368800.0 |
| 2001-10-01 18:00:00 | AAPL | Stock | 0.2768 | 0.2786 | 0.2768 | 0.2786 | 17130400.0 |
| 2001-10-01 08:00:00 | MSFT | Stock | 25.435 | 25.5875 | 25.26 | 25.39 | 32800.0 |
| 2001-10-01 09:00:00 | MSFT | Stock | 25.375 | 25.675 | 25.355 | 25.4805 | 8444200.0 |
| 2001-10-01 10:00:00 | MSFT | Stock | 25.465 | 25.685 | 25.205 | 25.39 | 11516400.0 |
| 2001-10-01 11:00:00 | MSFT | Stock | 25.3895 | 25.53 | 25.3 | 25.455 | 6129800.0 |
| 2001-10-01 12:00:00 | MSFT | Stock | 25.4355 | 25.785 | 25.39 | 25.76 | 5285800.0 |
| 2001-10-01 13:00:00 | MSFT | Stock | 25.745 | 26.25 | 25.7 | 25.92 | 9715000.0 |
| 2001-10-01 14:00:00 | MSFT | Stock | 25.925 | 26.035 | 25.79 | 25.97 | 7513800.0 |
| 2001-10-01 15:00:00 | MSFT | Stock | 25.96 | 25.97 | 25.525 | 25.895 | 12306200.0 |
| 2001-10-01 16:00:00 | MSFT | Stock | 25.9 | 25.925 | 25.55 | 25.8 | 2777800.0 |
| 2001-10-01 17:00:00 | MSFT | Stock | 25.85 | 25.895 | 25.625 | 25.895 | 1062200.0 |
| 2001-10-01 18:00:00 | MSFT | Stock | 25.83 | 25.83 | 25.6456 | 25.6456 | 36200.0 |
| 2001-10-01 08:00:00 | NVDA | Stock | 0.2292 | 0.2293 | 0.2275 | 0.2275 | 3588000.0 |
| 2001-10-01 09:00:00 | NVDA | Stock | 0.2275 | 0.2312 | 0.2217 | 0.2245 | 107688000.0 |
| 2001-10-01 10:00:00 | NVDA | Stock | 0.2238 | 0.2262 | 0.2177 | 0.2186 | 210240000.0 |
| 2001-10-01 11:00:00 | NVDA | Stock | 0.2187 | 0.2212 | 0.215 | 0.2157 | 132912000.0 |
| 2001-10-01 12:00:00 | NVDA | Stock | 0.2152 | 0.2225 | 0.215 | 0.2214 | 81300000.0 |
| 2001-10-01 13:00:00 | NVDA | Stock | 0.2208 | 0.2216 | 0.215 | 0.2181 | 62568000.0 |
| 2001-10-01 14:00:00 | NVDA | Stock | 0.2182 | 0.2193 | 0.213 | 0.2156 | 105288000.0 |
| 2001-10-01 15:00:00 | NVDA | Stock | 0.2153 | 0.2153 | 0.2058 | 0.2095 | 213780000.0 |
| 2001-10-01 16:00:00 | NVDA | Stock | 0.2095 | 0.2097 | 0.2058 | 0.2087 | 7536000.0 |
| 2001-10-01 17:00:00 | NVDA | Stock | 0.2083 | 0.2095 | 0.2062 | 0.2088 | 624000.0 |
| 2001-10-01 18:00:00 | NVDA | Stock | 0.2083 | 0.2083 | 0.2079 | 0.2079 | 156000.0 |
| 2001-10-01 08:00:00 | AMZN | Stock | 0.302 | 0.302 | 0.295 | 0.295 | 68000.0 |
| 2001-10-01 09:00:00 | AMZN | Stock | 0.295 | 0.2985 | 0.289 | 0.289 | 26118000.0 |
| 2001-10-01 10:00:00 | AMZN | Stock | 0.289 | 0.289 | 0.2755 | 0.281 | 22606000.0 |
| 2001-10-01 11:00:00 | AMZN | Stock | 0.281 | 0.2855 | 0.2795 | 0.2845 | 13378000.0 |
| 2001-10-01 12:00:00 | AMZN | Stock | 0.2845 | 0.295 | 0.2825 | 0.2925 | 12160000.0 |
| 2001-10-01 13:00:00 | AMZN | Stock | 0.2925 | 0.2945 | 0.2855 | 0.292 | 16006000.0 |
| 2001-10-01 14:00:00 | AMZN | Stock | 0.292 | 0.3005 | 0.288 | 0.3005 | 17500000.0 |
| 2001-10-01 15:00:00 | AMZN | Stock | 0.3 | 0.305 | 0.296 | 0.3 | 27816000.0 |
| 2001-10-01 16:00:00 | AMZN | Stock | 0.3005 | 0.3025 | 0.2921 | 0.3005 | 11656000.0 |
| 2001-10-01 17:00:00 | AMZN | Stock | 0.3005 | 0.3025 | 0.3 | 0.3025 | 134000.0 |
| 2001-10-01 09:00:00 | CL | Stock | 28.875 | 28.95 | 28.755 | 28.835 | 304600.0 |
| 2001-10-01 10:00:00 | CL | Stock | 28.825 | 28.89 | 28.59 | 28.615 | 518000.0 |
| 2001-10-01 11:00:00 | CL | Stock | 28.61 | 28.66 | 28.455 | 28.52 | 513600.0 |
| 2001-10-01 12:00:00 | CL | Stock | 28.45 | 28.55 | 28.425 | 28.53 | 524200.0 |
| 2001-10-01 13:00:00 | CL | Stock | 28.53 | 28.66 | 28.435 | 28.55 | 924800.0 |
| 2001-10-01 14:00:00 | CL | Stock | 28.55 | 28.57 | 28.35 | 28.46 | 637000.0 |
| 2001-10-01 15:00:00 | CL | Stock | 28.47 | 28.625 | 28.325 | 28.565 | 564000.0 |
> showing 50 of 17,409 rows — these rows as CSV