PREVIEW / stock_1hour / 2001-03-26
file: by_date/stock_1hour/2001/2001-03-26.parquet size: 351 KB rows: 16,364 symbols: 1,270
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-03-26 08:00:00 | AAPL | Stock | 0.4141 | 0.4232 | 0.4134 | 0.4139 | 1568000.0 |
| 2001-03-26 09:00:00 | AAPL | Stock | 0.4139 | 0.4241 | 0.4104 | 0.4214 | 138376000.0 |
| 2001-03-26 10:00:00 | AAPL | Stock | 0.4214 | 0.4223 | 0.4159 | 0.4193 | 110213600.0 |
| 2001-03-26 11:00:00 | AAPL | Stock | 0.4195 | 0.4204 | 0.4107 | 0.413 | 104888000.0 |
| 2001-03-26 12:00:00 | AAPL | Stock | 0.4129 | 0.415 | 0.4107 | 0.4116 | 52500000.0 |
| 2001-03-26 13:00:00 | AAPL | Stock | 0.4116 | 0.4125 | 0.3909 | 0.3927 | 86402400.0 |
| 2001-03-26 14:00:00 | AAPL | Stock | 0.393 | 0.3932 | 0.383 | 0.3832 | 85108800.0 |
| 2001-03-26 15:00:00 | AAPL | Stock | 0.383 | 0.3911 | 0.3773 | 0.3891 | 90143200.0 |
| 2001-03-26 16:00:00 | AAPL | Stock | 0.3891 | 0.4048 | 0.3884 | 0.3889 | 25502400.0 |
| 2001-03-26 17:00:00 | AAPL | Stock | 0.39 | 0.39 | 0.3889 | 0.3889 | 1131200.0 |
| 2001-03-26 18:00:00 | AAPL | Stock | 0.39 | 0.39 | 0.39 | 0.39 | 50400.0 |
| 2001-03-26 08:00:00 | MSFT | Stock | 28.3438 | 28.9375 | 28.2188 | 28.6562 | 79800.0 |
| 2001-03-26 09:00:00 | MSFT | Stock | 28.6875 | 28.75 | 28.125 | 28.2188 | 11151800.0 |
| 2001-03-26 10:00:00 | MSFT | Stock | 28.2188 | 28.5 | 28.0625 | 28.3125 | 12344200.0 |
| 2001-03-26 11:00:00 | MSFT | Stock | 28.3125 | 28.4375 | 28.1875 | 28.4062 | 7219600.0 |
| 2001-03-26 12:00:00 | MSFT | Stock | 28.4062 | 28.5 | 28.2812 | 28.3438 | 5332800.0 |
| 2001-03-26 13:00:00 | MSFT | Stock | 28.3438 | 28.4375 | 28.1562 | 28.1875 | 5047000.0 |
| 2001-03-26 14:00:00 | MSFT | Stock | 28.1875 | 28.25 | 27.9062 | 28.0 | 7725600.0 |
| 2001-03-26 15:00:00 | MSFT | Stock | 28.0 | 28.0625 | 27.7812 | 28.0625 | 9757400.0 |
| 2001-03-26 16:00:00 | MSFT | Stock | 28.0625 | 28.4688 | 27.9062 | 28.0 | 1119200.0 |
| 2001-03-26 17:00:00 | MSFT | Stock | 28.0156 | 28.2656 | 28.0 | 28.0625 | 626000.0 |
| 2001-03-26 18:00:00 | MSFT | Stock | 28.1562 | 28.1562 | 28.1562 | 28.1562 | 200.0 |
| 2001-03-26 08:00:00 | NVDA | Stock | 0.2792 | 0.2794 | 0.2776 | 0.2779 | 264000.0 |
| 2001-03-26 09:00:00 | NVDA | Stock | 0.2776 | 0.2917 | 0.2771 | 0.2875 | 230520000.0 |
| 2001-03-26 10:00:00 | NVDA | Stock | 0.2875 | 0.2906 | 0.2854 | 0.287 | 319872000.0 |
| 2001-03-26 11:00:00 | NVDA | Stock | 0.2875 | 0.2885 | 0.2859 | 0.288 | 110544000.0 |
| 2001-03-26 12:00:00 | NVDA | Stock | 0.2883 | 0.2893 | 0.2867 | 0.287 | 92832000.0 |
| 2001-03-26 13:00:00 | NVDA | Stock | 0.2867 | 0.2901 | 0.2867 | 0.2885 | 182280000.0 |
| 2001-03-26 14:00:00 | NVDA | Stock | 0.2888 | 0.2911 | 0.2865 | 0.2893 | 179760000.0 |
| 2001-03-26 15:00:00 | NVDA | Stock | 0.2891 | 0.2958 | 0.2882 | 0.294 | 345096000.0 |
| 2001-03-26 16:00:00 | NVDA | Stock | 0.294 | 0.2958 | 0.2875 | 0.2941 | 28248000.0 |
| 2001-03-26 17:00:00 | NVDA | Stock | 0.2943 | 0.2948 | 0.2927 | 0.2943 | 576000.0 |
| 2001-03-26 08:00:00 | AMZN | Stock | 0.5125 | 0.5245 | 0.5125 | 0.5155 | 224000.0 |
| 2001-03-26 09:00:00 | AMZN | Stock | 0.5215 | 0.543 | 0.5215 | 0.5335 | 12690000.0 |
| 2001-03-26 10:00:00 | AMZN | Stock | 0.5335 | 0.544 | 0.5325 | 0.5415 | 19312000.0 |
| 2001-03-26 11:00:00 | AMZN | Stock | 0.541 | 0.543 | 0.5375 | 0.542 | 13980000.0 |
| 2001-03-26 12:00:00 | AMZN | Stock | 0.5415 | 0.5645 | 0.5415 | 0.561 | 13346000.0 |
| 2001-03-26 13:00:00 | AMZN | Stock | 0.5615 | 0.5635 | 0.545 | 0.5485 | 16786000.0 |
| 2001-03-26 14:00:00 | AMZN | Stock | 0.5475 | 0.5545 | 0.547 | 0.5525 | 20770000.0 |
| 2001-03-26 15:00:00 | AMZN | Stock | 0.552 | 0.5545 | 0.5425 | 0.547 | 29390000.0 |
| 2001-03-26 16:00:00 | AMZN | Stock | 0.5465 | 0.556 | 0.525 | 0.5475 | 1908000.0 |
| 2001-03-26 17:00:00 | AMZN | Stock | 0.55 | 0.55 | 0.55 | 0.55 | 6000.0 |
| 2001-03-26 09:00:00 | CL | Stock | 26.2 | 26.2 | 26.0 | 26.015 | 429000.0 |
| 2001-03-26 10:00:00 | CL | Stock | 26.02 | 26.085 | 25.885 | 26.045 | 542400.0 |
| 2001-03-26 11:00:00 | CL | Stock | 26.025 | 26.14 | 25.975 | 25.975 | 315800.0 |
| 2001-03-26 12:00:00 | CL | Stock | 25.975 | 26.175 | 25.975 | 26.085 | 368400.0 |
| 2001-03-26 13:00:00 | CL | Stock | 26.075 | 26.45 | 26.05 | 26.45 | 712200.0 |
| 2001-03-26 14:00:00 | CL | Stock | 26.45 | 26.48 | 26.285 | 26.395 | 482200.0 |
| 2001-03-26 15:00:00 | CL | Stock | 26.435 | 26.6 | 26.355 | 26.54 | 808400.0 |
| 2001-03-26 16:00:00 | CL | Stock | 26.545 | 26.55 | 26.24 | 26.24 | 102200.0 |
> showing 50 of 16,364 rows — these rows as CSV