PREVIEW / stock_1hour / 2002-05-10
file: by_date/stock_1hour/2002/2002-05-10.parquet size: 397 KB rows: 18,609 symbols: 1,413
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-10 09:00:00 | AAPL | Stock | 0.4323 | 0.4325 | 0.4214 | 0.4232 | 31320800.0 |
| 2002-05-10 10:00:00 | AAPL | Stock | 0.4232 | 0.4286 | 0.4193 | 0.4266 | 44559200.0 |
| 2002-05-10 11:00:00 | AAPL | Stock | 0.4266 | 0.4273 | 0.4198 | 0.4198 | 18194400.0 |
| 2002-05-10 12:00:00 | AAPL | Stock | 0.4198 | 0.4205 | 0.4104 | 0.4139 | 34972000.0 |
| 2002-05-10 13:00:00 | AAPL | Stock | 0.4139 | 0.4154 | 0.4113 | 0.4141 | 19000800.0 |
| 2002-05-10 14:00:00 | AAPL | Stock | 0.4141 | 0.4188 | 0.4136 | 0.4136 | 33454400.0 |
| 2002-05-10 15:00:00 | AAPL | Stock | 0.4152 | 0.4175 | 0.4121 | 0.4164 | 42694400.0 |
| 2002-05-10 16:00:00 | AAPL | Stock | 0.4166 | 0.417 | 0.4145 | 0.4164 | 7128800.0 |
| 2002-05-10 17:00:00 | AAPL | Stock | 0.4167 | 0.4167 | 0.4167 | 0.4167 | 817600.0 |
| 2002-05-10 08:00:00 | MSFT | Stock | 26.235 | 26.35 | 26.06 | 26.3 | 601000.0 |
| 2002-05-10 09:00:00 | MSFT | Stock | 26.225 | 26.338 | 25.82 | 25.845 | 8819000.0 |
| 2002-05-10 10:00:00 | MSFT | Stock | 25.853 | 26.057 | 25.79 | 25.9345 | 10894600.0 |
| 2002-05-10 11:00:00 | MSFT | Stock | 25.92 | 26.075 | 25.63 | 25.72 | 6759000.0 |
| 2002-05-10 12:00:00 | MSFT | Stock | 25.73 | 25.875 | 25.275 | 25.475 | 8706200.0 |
| 2002-05-10 13:00:00 | MSFT | Stock | 25.475 | 25.51 | 25.155 | 25.3 | 5575200.0 |
| 2002-05-10 14:00:00 | MSFT | Stock | 25.286 | 25.6 | 25.225 | 25.24 | 6721800.0 |
| 2002-05-10 15:00:00 | MSFT | Stock | 25.24 | 25.3 | 24.998 | 25.02 | 11915000.0 |
| 2002-05-10 16:00:00 | MSFT | Stock | 25.02 | 25.6157 | 25.0 | 25.03 | 2117200.0 |
| 2002-05-10 17:00:00 | MSFT | Stock | 25.035 | 25.6164 | 25.01 | 25.03 | 126000.0 |
| 2002-05-10 18:00:00 | MSFT | Stock | 25.075 | 25.085 | 25.04 | 25.04 | 1600.0 |
| 2002-05-10 08:00:00 | NVDA | Stock | 0.2887 | 0.2908 | 0.2872 | 0.2908 | 228000.0 |
| 2002-05-10 09:00:00 | NVDA | Stock | 0.2908 | 0.2928 | 0.2853 | 0.2859 | 148392000.0 |
| 2002-05-10 10:00:00 | NVDA | Stock | 0.2859 | 0.2875 | 0.2792 | 0.2805 | 256380000.0 |
| 2002-05-10 11:00:00 | NVDA | Stock | 0.2805 | 0.2828 | 0.2752 | 0.2755 | 153456000.0 |
| 2002-05-10 12:00:00 | NVDA | Stock | 0.2756 | 0.2768 | 0.2667 | 0.2694 | 232416000.0 |
| 2002-05-10 13:00:00 | NVDA | Stock | 0.2694 | 0.27 | 0.2645 | 0.2668 | 155868000.0 |
| 2002-05-10 14:00:00 | NVDA | Stock | 0.2669 | 0.2708 | 0.2625 | 0.2632 | 176376000.0 |
| 2002-05-10 15:00:00 | NVDA | Stock | 0.2632 | 0.2677 | 0.2632 | 0.2657 | 166116000.0 |
| 2002-05-10 16:00:00 | NVDA | Stock | 0.2663 | 0.2668 | 0.2638 | 0.2644 | 13140000.0 |
| 2002-05-10 17:00:00 | NVDA | Stock | 0.2646 | 0.2658 | 0.2644 | 0.2658 | 828000.0 |
| 2002-05-10 18:00:00 | NVDA | Stock | 0.2646 | 0.2646 | 0.2646 | 0.2646 | 192000.0 |
| 2002-05-10 08:00:00 | AMZN | Stock | 0.892 | 0.892 | 0.8863 | 0.89 | 94000.0 |
| 2002-05-10 09:00:00 | AMZN | Stock | 0.8945 | 0.898 | 0.8755 | 0.8765 | 20526000.0 |
| 2002-05-10 10:00:00 | AMZN | Stock | 0.8755 | 0.876 | 0.862 | 0.865 | 28286000.0 |
| 2002-05-10 11:00:00 | AMZN | Stock | 0.865 | 0.8675 | 0.855 | 0.856 | 22960000.0 |
| 2002-05-10 12:00:00 | AMZN | Stock | 0.856 | 0.8585 | 0.848 | 0.8525 | 18720000.0 |
| 2002-05-10 13:00:00 | AMZN | Stock | 0.852 | 0.855 | 0.84 | 0.8464 | 15764000.0 |
| 2002-05-10 14:00:00 | AMZN | Stock | 0.8455 | 0.85 | 0.843 | 0.843 | 15096000.0 |
| 2002-05-10 15:00:00 | AMZN | Stock | 0.843 | 0.85 | 0.8405 | 0.8475 | 24036000.0 |
| 2002-05-10 16:00:00 | AMZN | Stock | 0.8475 | 0.8591 | 0.845 | 0.8495 | 2294000.0 |
| 2002-05-10 17:00:00 | AMZN | Stock | 0.8495 | 0.8495 | 0.847 | 0.8495 | 176000.0 |
| 2002-05-10 09:00:00 | CL | Stock | 27.455 | 27.575 | 27.39 | 27.51 | 171400.0 |
| 2002-05-10 10:00:00 | CL | Stock | 27.54 | 27.6 | 27.435 | 27.53 | 442600.0 |
| 2002-05-10 11:00:00 | CL | Stock | 27.525 | 27.76 | 27.505 | 27.73 | 415800.0 |
| 2002-05-10 12:00:00 | CL | Stock | 27.725 | 27.75 | 27.57 | 27.63 | 193600.0 |
| 2002-05-10 13:00:00 | CL | Stock | 27.635 | 27.725 | 27.6 | 27.725 | 240800.0 |
| 2002-05-10 14:00:00 | CL | Stock | 27.72 | 27.8 | 27.65 | 27.685 | 504000.0 |
| 2002-05-10 15:00:00 | CL | Stock | 27.695 | 27.8 | 27.61 | 27.765 | 748400.0 |
| 2002-05-10 16:00:00 | CL | Stock | 27.76 | 27.765 | 27.655 | 27.76 | 118600.0 |
> showing 49 of 18,609 rows — these rows as CSV