PREVIEW / stock_1hour / 2002-05-02
file: by_date/stock_1hour/2002/2002-05-02.parquet size: 401 KB rows: 18,813 symbols: 1,405
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-02 08:00:00 | AAPL | Stock | 0.4241 | 0.4273 | 0.4241 | 0.4273 | 257600.0 |
| 2002-05-02 09:00:00 | AAPL | Stock | 0.4282 | 0.4321 | 0.4214 | 0.4296 | 32776800.0 |
| 2002-05-02 10:00:00 | AAPL | Stock | 0.4295 | 0.4334 | 0.4246 | 0.4261 | 29607200.0 |
| 2002-05-02 11:00:00 | AAPL | Stock | 0.4259 | 0.4316 | 0.4245 | 0.4316 | 31108000.0 |
| 2002-05-02 12:00:00 | AAPL | Stock | 0.4314 | 0.4346 | 0.4296 | 0.4304 | 31544800.0 |
| 2002-05-02 13:00:00 | AAPL | Stock | 0.4304 | 0.4321 | 0.4288 | 0.4311 | 17192000.0 |
| 2002-05-02 14:00:00 | AAPL | Stock | 0.4307 | 0.433 | 0.4286 | 0.4291 | 26292000.0 |
| 2002-05-02 15:00:00 | AAPL | Stock | 0.4289 | 0.43 | 0.4227 | 0.4227 | 50288000.0 |
| 2002-05-02 16:00:00 | AAPL | Stock | 0.4225 | 0.4291 | 0.422 | 0.4223 | 19891200.0 |
| 2002-05-02 17:00:00 | AAPL | Stock | 0.4282 | 0.4282 | 0.4282 | 0.4282 | 11200.0 |
| 2002-05-02 18:00:00 | AAPL | Stock | 0.4232 | 0.4232 | 0.4232 | 0.4232 | 5600.0 |
| 2002-05-02 08:00:00 | MSFT | Stock | 26.5 | 26.5 | 26.37 | 26.375 | 42600.0 |
| 2002-05-02 09:00:00 | MSFT | Stock | 26.385 | 26.845 | 26.195 | 26.805 | 9443400.0 |
| 2002-05-02 10:00:00 | MSFT | Stock | 26.805 | 27.035 | 26.434 | 26.63 | 15963800.0 |
| 2002-05-02 11:00:00 | MSFT | Stock | 26.625 | 26.6755 | 26.3 | 26.455 | 8254600.0 |
| 2002-05-02 12:00:00 | MSFT | Stock | 26.44 | 26.465 | 25.754 | 25.7555 | 9707200.0 |
| 2002-05-02 13:00:00 | MSFT | Stock | 25.756 | 26.07 | 25.575 | 25.89 | 10471200.0 |
| 2002-05-02 14:00:00 | MSFT | Stock | 25.885 | 26.0395 | 25.62 | 25.93 | 7759800.0 |
| 2002-05-02 15:00:00 | MSFT | Stock | 25.9 | 25.995 | 25.585 | 25.62 | 12033400.0 |
| 2002-05-02 16:00:00 | MSFT | Stock | 25.655 | 26.2152 | 25.57 | 25.635 | 3511000.0 |
| 2002-05-02 17:00:00 | MSFT | Stock | 25.645 | 25.8768 | 25.63 | 25.65 | 62200.0 |
| 2002-05-02 18:00:00 | MSFT | Stock | 25.635 | 25.65 | 25.63 | 25.64 | 1200.0 |
| 2002-05-02 08:00:00 | NVDA | Stock | 0.2959 | 0.2961 | 0.2935 | 0.2954 | 456000.0 |
| 2002-05-02 09:00:00 | NVDA | Stock | 0.2958 | 0.3041 | 0.2942 | 0.2995 | 201696000.0 |
| 2002-05-02 10:00:00 | NVDA | Stock | 0.3 | 0.3038 | 0.2967 | 0.3003 | 232104000.0 |
| 2002-05-02 11:00:00 | NVDA | Stock | 0.3003 | 0.3003 | 0.2921 | 0.2938 | 150348000.0 |
| 2002-05-02 12:00:00 | NVDA | Stock | 0.2938 | 0.2946 | 0.2879 | 0.2879 | 138876000.0 |
| 2002-05-02 13:00:00 | NVDA | Stock | 0.2879 | 0.2919 | 0.2856 | 0.2901 | 146616000.0 |
| 2002-05-02 14:00:00 | NVDA | Stock | 0.2901 | 0.2916 | 0.2854 | 0.2882 | 86076000.0 |
| 2002-05-02 15:00:00 | NVDA | Stock | 0.2882 | 0.2888 | 0.2833 | 0.2846 | 124272000.0 |
| 2002-05-02 16:00:00 | NVDA | Stock | 0.2834 | 0.2959 | 0.2808 | 0.2833 | 36540000.0 |
| 2002-05-02 17:00:00 | NVDA | Stock | 0.2822 | 0.2829 | 0.2817 | 0.2825 | 840000.0 |
| 2002-05-02 18:00:00 | NVDA | Stock | 0.2829 | 0.2829 | 0.2829 | 0.2829 | 120000.0 |
| 2002-05-02 08:00:00 | AMZN | Stock | 0.826 | 0.832 | 0.8225 | 0.8225 | 116000.0 |
| 2002-05-02 09:00:00 | AMZN | Stock | 0.8205 | 0.8325 | 0.8165 | 0.826 | 12544000.0 |
| 2002-05-02 10:00:00 | AMZN | Stock | 0.827 | 0.829 | 0.819 | 0.8205 | 15198000.0 |
| 2002-05-02 11:00:00 | AMZN | Stock | 0.8205 | 0.821 | 0.813 | 0.816 | 11702000.0 |
| 2002-05-02 12:00:00 | AMZN | Stock | 0.816 | 0.818 | 0.8135 | 0.8135 | 13758000.0 |
| 2002-05-02 13:00:00 | AMZN | Stock | 0.8135 | 0.8225 | 0.8125 | 0.8185 | 11208000.0 |
| 2002-05-02 14:00:00 | AMZN | Stock | 0.819 | 0.821 | 0.814 | 0.8175 | 8322000.0 |
| 2002-05-02 15:00:00 | AMZN | Stock | 0.8175 | 0.8245 | 0.8146 | 0.816 | 20200000.0 |
| 2002-05-02 16:00:00 | AMZN | Stock | 0.815 | 0.825 | 0.814 | 0.818 | 2934000.0 |
| 2002-05-02 17:00:00 | AMZN | Stock | 0.818 | 0.818 | 0.815 | 0.815 | 42000.0 |
| 2002-05-02 18:00:00 | AMZN | Stock | 0.816 | 0.816 | 0.816 | 0.816 | 6000.0 |
| 2002-05-02 09:00:00 | CL | Stock | 26.8 | 26.875 | 26.725 | 26.75 | 465800.0 |
| 2002-05-02 10:00:00 | CL | Stock | 26.73 | 26.9 | 26.7 | 26.88 | 804000.0 |
| 2002-05-02 11:00:00 | CL | Stock | 26.875 | 26.98 | 26.75 | 26.975 | 660600.0 |
| 2002-05-02 12:00:00 | CL | Stock | 27.0 | 27.15 | 27.0 | 27.075 | 427600.0 |
| 2002-05-02 13:00:00 | CL | Stock | 27.08 | 27.16 | 27.05 | 27.155 | 546200.0 |
| 2002-05-02 14:00:00 | CL | Stock | 27.155 | 27.355 | 27.135 | 27.3 | 645400.0 |
> showing 50 of 18,813 rows — these rows as CSV