PREVIEW / stock_1hour / 2002-05-29
file: by_date/stock_1hour/2002/2002-05-29.parquet size: 403 KB rows: 19,056 symbols: 1,430
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-29 09:00:00 | AAPL | Stock | 0.4277 | 0.4279 | 0.4214 | 0.4268 | 22579200.0 |
| 2002-05-29 10:00:00 | AAPL | Stock | 0.4268 | 0.4302 | 0.4188 | 0.4214 | 30469600.0 |
| 2002-05-29 11:00:00 | AAPL | Stock | 0.4216 | 0.4238 | 0.4205 | 0.4234 | 10612000.0 |
| 2002-05-29 12:00:00 | AAPL | Stock | 0.423 | 0.425 | 0.4214 | 0.4227 | 14912800.0 |
| 2002-05-29 13:00:00 | AAPL | Stock | 0.4225 | 0.428 | 0.4213 | 0.4268 | 23850400.0 |
| 2002-05-29 14:00:00 | AAPL | Stock | 0.4268 | 0.4364 | 0.4266 | 0.4341 | 57013600.0 |
| 2002-05-29 15:00:00 | AAPL | Stock | 0.4341 | 0.4357 | 0.4277 | 0.4295 | 48378400.0 |
| 2002-05-29 16:00:00 | AAPL | Stock | 0.4296 | 0.4304 | 0.4273 | 0.4304 | 3785600.0 |
| 2002-05-29 17:00:00 | AAPL | Stock | 0.4282 | 0.4282 | 0.4282 | 0.4282 | 1461600.0 |
| 2002-05-29 08:00:00 | MSFT | Stock | 26.085 | 26.1625 | 25.785 | 25.825 | 62600.0 |
| 2002-05-29 09:00:00 | MSFT | Stock | 25.785 | 26.13 | 25.775 | 26.005 | 6703600.0 |
| 2002-05-29 10:00:00 | MSFT | Stock | 26.0055 | 26.235 | 25.88 | 25.995 | 8700200.0 |
| 2002-05-29 11:00:00 | MSFT | Stock | 25.98 | 26.2 | 25.975 | 26.185 | 4103600.0 |
| 2002-05-29 12:00:00 | MSFT | Stock | 26.185 | 26.2 | 26.05 | 26.13 | 3595400.0 |
| 2002-05-29 13:00:00 | MSFT | Stock | 26.12 | 26.125 | 25.95 | 26.07 | 4426600.0 |
| 2002-05-29 14:00:00 | MSFT | Stock | 26.065 | 26.36 | 26.049 | 26.265 | 7243600.0 |
| 2002-05-29 15:00:00 | MSFT | Stock | 26.265 | 26.345 | 26.005 | 26.02 | 8309400.0 |
| 2002-05-29 16:00:00 | MSFT | Stock | 26.0055 | 26.1854 | 25.82 | 26.0325 | 1497400.0 |
| 2002-05-29 17:00:00 | MSFT | Stock | 26.025 | 26.05 | 26.025 | 26.05 | 205600.0 |
| 2002-05-29 18:00:00 | MSFT | Stock | 26.04 | 26.06 | 26.04 | 26.04 | 4600.0 |
| 2002-05-29 08:00:00 | NVDA | Stock | 0.2805 | 0.2805 | 0.2762 | 0.2774 | 7596000.0 |
| 2002-05-29 09:00:00 | NVDA | Stock | 0.2765 | 0.2797 | 0.2716 | 0.2777 | 157368000.0 |
| 2002-05-29 10:00:00 | NVDA | Stock | 0.2778 | 0.2787 | 0.2732 | 0.277 | 164916000.0 |
| 2002-05-29 11:00:00 | NVDA | Stock | 0.277 | 0.2827 | 0.2764 | 0.2826 | 111612000.0 |
| 2002-05-29 12:00:00 | NVDA | Stock | 0.2826 | 0.2842 | 0.2804 | 0.2816 | 141432000.0 |
| 2002-05-29 13:00:00 | NVDA | Stock | 0.2816 | 0.2883 | 0.2814 | 0.288 | 131040000.0 |
| 2002-05-29 14:00:00 | NVDA | Stock | 0.2882 | 0.2915 | 0.2859 | 0.2903 | 246864000.0 |
| 2002-05-29 15:00:00 | NVDA | Stock | 0.2903 | 0.2921 | 0.2892 | 0.2911 | 248592000.0 |
| 2002-05-29 16:00:00 | NVDA | Stock | 0.2911 | 0.2929 | 0.2836 | 0.2929 | 80340000.0 |
| 2002-05-29 17:00:00 | NVDA | Stock | 0.2929 | 0.2933 | 0.2909 | 0.2933 | 1680000.0 |
| 2002-05-29 18:00:00 | NVDA | Stock | 0.2929 | 0.2933 | 0.2929 | 0.2933 | 120000.0 |
| 2002-05-29 08:00:00 | AMZN | Stock | 0.953 | 0.9545 | 0.95 | 0.952 | 38000.0 |
| 2002-05-29 09:00:00 | AMZN | Stock | 0.952 | 0.954 | 0.94 | 0.95 | 14634000.0 |
| 2002-05-29 10:00:00 | AMZN | Stock | 0.9505 | 0.955 | 0.943 | 0.95 | 12022000.0 |
| 2002-05-29 11:00:00 | AMZN | Stock | 0.95 | 0.954 | 0.944 | 0.9535 | 9424000.0 |
| 2002-05-29 12:00:00 | AMZN | Stock | 0.9535 | 0.954 | 0.946 | 0.9485 | 6358000.0 |
| 2002-05-29 13:00:00 | AMZN | Stock | 0.9485 | 0.9495 | 0.9425 | 0.9435 | 7828000.0 |
| 2002-05-29 14:00:00 | AMZN | Stock | 0.943 | 0.9495 | 0.942 | 0.9435 | 7440000.0 |
| 2002-05-29 15:00:00 | AMZN | Stock | 0.944 | 0.949 | 0.942 | 0.945 | 11568000.0 |
| 2002-05-29 16:00:00 | AMZN | Stock | 0.9455 | 0.952 | 0.945 | 0.945 | 1762000.0 |
| 2002-05-29 17:00:00 | AMZN | Stock | 0.9455 | 0.9455 | 0.9455 | 0.9455 | 304000.0 |
| 2002-05-29 09:00:00 | CL | Stock | 26.075 | 26.225 | 26.075 | 26.15 | 444800.0 |
| 2002-05-29 10:00:00 | CL | Stock | 26.145 | 26.145 | 25.78 | 25.805 | 971600.0 |
| 2002-05-29 11:00:00 | CL | Stock | 25.805 | 25.875 | 25.725 | 25.82 | 743000.0 |
| 2002-05-29 12:00:00 | CL | Stock | 25.83 | 25.835 | 25.65 | 25.745 | 548000.0 |
| 2002-05-29 13:00:00 | CL | Stock | 25.75 | 25.825 | 25.735 | 25.825 | 744400.0 |
| 2002-05-29 14:00:00 | CL | Stock | 25.85 | 25.915 | 25.785 | 25.85 | 538200.0 |
| 2002-05-29 15:00:00 | CL | Stock | 25.86 | 26.025 | 25.855 | 25.895 | 725400.0 |
| 2002-05-29 16:00:00 | CL | Stock | 25.895 | 25.915 | 25.82 | 25.82 | 192600.0 |
| 2002-05-29 17:00:00 | CL | Stock | 25.875 | 25.875 | 25.875 | 25.875 | 8200.0 |
> showing 50 of 19,056 rows — these rows as CSV