PREVIEW / stock_1hour / 2002-05-31
file: by_date/stock_1hour/2002/2002-05-31.parquet size: 428 KB rows: 20,395 symbols: 1,428
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 |
|---|---|---|---|---|---|---|---|
| 2002-05-31 08:00:00 | AAPL | Stock | 0.4261 | 0.4261 | 0.4261 | 0.4261 | 5600.0 |
| 2002-05-31 09:00:00 | AAPL | Stock | 0.4311 | 0.4311 | 0.4236 | 0.4284 | 40051200.0 |
| 2002-05-31 10:00:00 | AAPL | Stock | 0.4279 | 0.433 | 0.4239 | 0.4263 | 57551200.0 |
| 2002-05-31 11:00:00 | AAPL | Stock | 0.4261 | 0.4296 | 0.4259 | 0.4286 | 21044800.0 |
| 2002-05-31 12:00:00 | AAPL | Stock | 0.4284 | 0.4321 | 0.4275 | 0.4295 | 46009600.0 |
| 2002-05-31 13:00:00 | AAPL | Stock | 0.4298 | 0.4304 | 0.4245 | 0.4248 | 24959200.0 |
| 2002-05-31 14:00:00 | AAPL | Stock | 0.4252 | 0.4266 | 0.4193 | 0.4205 | 51738400.0 |
| 2002-05-31 15:00:00 | AAPL | Stock | 0.4204 | 0.4243 | 0.4157 | 0.4164 | 91896000.0 |
| 2002-05-31 16:00:00 | AAPL | Stock | 0.4164 | 0.4175 | 0.412 | 0.4157 | 21498400.0 |
| 2002-05-31 17:00:00 | AAPL | Stock | 0.4161 | 0.4161 | 0.4161 | 0.4161 | 5600.0 |
| 2002-05-31 08:00:00 | MSFT | Stock | 26.5 | 26.551 | 26.3175 | 26.5 | 327400.0 |
| 2002-05-31 09:00:00 | MSFT | Stock | 26.5075 | 26.5075 | 26.135 | 26.485 | 9291000.0 |
| 2002-05-31 10:00:00 | MSFT | Stock | 26.484 | 26.71 | 26.435 | 26.47 | 10365000.0 |
| 2002-05-31 11:00:00 | MSFT | Stock | 26.475 | 26.675 | 26.47 | 26.51 | 6228800.0 |
| 2002-05-31 12:00:00 | MSFT | Stock | 26.505 | 26.59 | 26.41 | 26.551 | 4900000.0 |
| 2002-05-31 13:00:00 | MSFT | Stock | 26.555 | 26.575 | 26.285 | 26.325 | 5093400.0 |
| 2002-05-31 14:00:00 | MSFT | Stock | 26.325 | 26.39 | 25.925 | 25.97 | 8397200.0 |
| 2002-05-31 15:00:00 | MSFT | Stock | 25.97 | 26.09 | 25.44 | 25.48 | 11908600.0 |
| 2002-05-31 16:00:00 | MSFT | Stock | 25.455 | 26.336 | 25.385 | 25.43 | 9524200.0 |
| 2002-05-31 17:00:00 | MSFT | Stock | 25.425 | 25.4587 | 25.38 | 25.445 | 204200.0 |
| 2002-05-31 18:00:00 | MSFT | Stock | 25.43 | 25.43 | 25.405 | 25.405 | 5000.0 |
| 2002-05-31 08:00:00 | NVDA | Stock | 0.2875 | 0.2899 | 0.2858 | 0.2883 | 3984000.0 |
| 2002-05-31 09:00:00 | NVDA | Stock | 0.2887 | 0.2896 | 0.2804 | 0.285 | 108048000.0 |
| 2002-05-31 10:00:00 | NVDA | Stock | 0.2852 | 0.2891 | 0.2833 | 0.2846 | 151320000.0 |
| 2002-05-31 11:00:00 | NVDA | Stock | 0.2846 | 0.2867 | 0.2837 | 0.285 | 65172000.0 |
| 2002-05-31 12:00:00 | NVDA | Stock | 0.2849 | 0.2871 | 0.2842 | 0.2866 | 51972000.0 |
| 2002-05-31 13:00:00 | NVDA | Stock | 0.2866 | 0.2866 | 0.2834 | 0.2841 | 63504000.0 |
| 2002-05-31 14:00:00 | NVDA | Stock | 0.2842 | 0.2851 | 0.2797 | 0.2808 | 74148000.0 |
| 2002-05-31 15:00:00 | NVDA | Stock | 0.2806 | 0.2829 | 0.2783 | 0.2788 | 117204000.0 |
| 2002-05-31 16:00:00 | NVDA | Stock | 0.2792 | 0.284 | 0.2775 | 0.2777 | 33948000.0 |
| 2002-05-31 17:00:00 | NVDA | Stock | 0.2777 | 0.2788 | 0.2758 | 0.2758 | 2304000.0 |
| 2002-05-31 18:00:00 | NVDA | Stock | 0.2758 | 0.2765 | 0.275 | 0.2755 | 240000.0 |
| 2002-05-31 08:00:00 | AMZN | Stock | 0.9225 | 0.9305 | 0.9188 | 0.9205 | 72000.0 |
| 2002-05-31 09:00:00 | AMZN | Stock | 0.925 | 0.928 | 0.915 | 0.928 | 9988000.0 |
| 2002-05-31 10:00:00 | AMZN | Stock | 0.928 | 0.939 | 0.924 | 0.936 | 14662000.0 |
| 2002-05-31 11:00:00 | AMZN | Stock | 0.9355 | 0.9415 | 0.934 | 0.939 | 10100000.0 |
| 2002-05-31 12:00:00 | AMZN | Stock | 0.9385 | 0.9445 | 0.937 | 0.941 | 11050000.0 |
| 2002-05-31 13:00:00 | AMZN | Stock | 0.9415 | 0.9415 | 0.935 | 0.936 | 5748000.0 |
| 2002-05-31 14:00:00 | AMZN | Stock | 0.9365 | 0.9375 | 0.917 | 0.9225 | 20080000.0 |
| 2002-05-31 15:00:00 | AMZN | Stock | 0.9225 | 0.931 | 0.91 | 0.9105 | 19076000.0 |
| 2002-05-31 16:00:00 | AMZN | Stock | 0.9105 | 0.916 | 0.9095 | 0.9116 | 7406000.0 |
| 2002-05-31 17:00:00 | AMZN | Stock | 0.9114 | 0.9116 | 0.9114 | 0.9116 | 306000.0 |
| 2002-05-31 18:00:00 | AMZN | Stock | 0.9115 | 0.9115 | 0.9115 | 0.9115 | 48000.0 |
| 2002-05-31 09:00:00 | CL | Stock | 26.1 | 26.37 | 26.08 | 26.37 | 636600.0 |
| 2002-05-31 10:00:00 | CL | Stock | 26.4 | 26.685 | 26.375 | 26.67 | 1219200.0 |
| 2002-05-31 11:00:00 | CL | Stock | 26.675 | 26.75 | 26.635 | 26.74 | 658200.0 |
| 2002-05-31 12:00:00 | CL | Stock | 26.73 | 27.1 | 26.725 | 27.08 | 815800.0 |
| 2002-05-31 13:00:00 | CL | Stock | 27.09 | 27.1 | 26.94 | 27.01 | 821800.0 |
| 2002-05-31 14:00:00 | CL | Stock | 27.05 | 27.135 | 27.0 | 27.125 | 811200.0 |
| 2002-05-31 15:00:00 | CL | Stock | 27.12 | 27.255 | 27.005 | 27.1 | 1722600.0 |
> showing 50 of 20,395 rows — these rows as CSV