PREVIEW / stock_1hour / 2002-05-24
file: by_date/stock_1hour/2002/2002-05-24.parquet size: 408 KB rows: 18,950 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-24 08:00:00 | AAPL | Stock | 0.4464 | 0.4495 | 0.4454 | 0.4464 | 319200.0 |
| 2002-05-24 09:00:00 | AAPL | Stock | 0.4475 | 0.4475 | 0.4386 | 0.4413 | 28257600.0 |
| 2002-05-24 10:00:00 | AAPL | Stock | 0.4411 | 0.442 | 0.433 | 0.4361 | 36108800.0 |
| 2002-05-24 11:00:00 | AAPL | Stock | 0.4364 | 0.438 | 0.4316 | 0.4329 | 23122400.0 |
| 2002-05-24 12:00:00 | AAPL | Stock | 0.433 | 0.4332 | 0.43 | 0.4314 | 10976000.0 |
| 2002-05-24 13:00:00 | AAPL | Stock | 0.4314 | 0.4336 | 0.4291 | 0.4291 | 16968000.0 |
| 2002-05-24 14:00:00 | AAPL | Stock | 0.4291 | 0.4311 | 0.4279 | 0.4286 | 16172800.0 |
| 2002-05-24 15:00:00 | AAPL | Stock | 0.4286 | 0.435 | 0.4286 | 0.4309 | 25569600.0 |
| 2002-05-24 16:00:00 | AAPL | Stock | 0.4305 | 0.4351 | 0.4305 | 0.433 | 4782400.0 |
| 2002-05-24 17:00:00 | AAPL | Stock | 0.4286 | 0.4313 | 0.4286 | 0.4313 | 2856000.0 |
| 2002-05-24 18:00:00 | AAPL | Stock | 0.4313 | 0.4313 | 0.4313 | 0.4313 | 235200.0 |
| 2002-05-24 08:00:00 | MSFT | Stock | 27.125 | 27.42 | 26.955 | 27.0 | 122800.0 |
| 2002-05-24 09:00:00 | MSFT | Stock | 27.0 | 27.26 | 26.88 | 27.05 | 5182400.0 |
| 2002-05-24 10:00:00 | MSFT | Stock | 27.034 | 27.12 | 26.67 | 26.7455 | 7597800.0 |
| 2002-05-24 11:00:00 | MSFT | Stock | 26.7545 | 26.875 | 26.64 | 26.69 | 3365600.0 |
| 2002-05-24 12:00:00 | MSFT | Stock | 26.7 | 26.84 | 26.62 | 26.765 | 3664400.0 |
| 2002-05-24 13:00:00 | MSFT | Stock | 26.765 | 26.905 | 26.582 | 26.595 | 3587000.0 |
| 2002-05-24 14:00:00 | MSFT | Stock | 26.59 | 26.735 | 26.52 | 26.55 | 3461000.0 |
| 2002-05-24 15:00:00 | MSFT | Stock | 26.545 | 26.905 | 26.535 | 26.63 | 6720200.0 |
| 2002-05-24 16:00:00 | MSFT | Stock | 26.64 | 26.8014 | 26.625 | 26.625 | 1490200.0 |
| 2002-05-24 17:00:00 | MSFT | Stock | 26.63 | 26.675 | 26.63 | 26.63 | 390000.0 |
| 2002-05-24 18:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.63 | 26.63 | 33600.0 |
| 2002-05-24 08:00:00 | NVDA | Stock | 0.2924 | 0.2977 | 0.2896 | 0.293 | 2616000.0 |
| 2002-05-24 09:00:00 | NVDA | Stock | 0.2912 | 0.2937 | 0.289 | 0.2908 | 135036000.0 |
| 2002-05-24 10:00:00 | NVDA | Stock | 0.2911 | 0.2925 | 0.2892 | 0.2902 | 121512000.0 |
| 2002-05-24 11:00:00 | NVDA | Stock | 0.2903 | 0.2921 | 0.2879 | 0.2907 | 81516000.0 |
| 2002-05-24 12:00:00 | NVDA | Stock | 0.291 | 0.2922 | 0.2893 | 0.2904 | 57984000.0 |
| 2002-05-24 13:00:00 | NVDA | Stock | 0.2904 | 0.2918 | 0.289 | 0.2892 | 55416000.0 |
| 2002-05-24 14:00:00 | NVDA | Stock | 0.2892 | 0.29 | 0.2852 | 0.2857 | 60288000.0 |
| 2002-05-24 15:00:00 | NVDA | Stock | 0.2858 | 0.2927 | 0.2852 | 0.2917 | 140592000.0 |
| 2002-05-24 16:00:00 | NVDA | Stock | 0.2918 | 0.2937 | 0.2901 | 0.2925 | 74712000.0 |
| 2002-05-24 17:00:00 | NVDA | Stock | 0.2929 | 0.293 | 0.2919 | 0.2919 | 2244000.0 |
| 2002-05-24 18:00:00 | NVDA | Stock | 0.2919 | 0.2919 | 0.2919 | 0.2919 | 156000.0 |
| 2002-05-24 08:00:00 | AMZN | Stock | 0.977 | 0.977 | 0.9325 | 0.95 | 58000.0 |
| 2002-05-24 09:00:00 | AMZN | Stock | 0.954 | 0.972 | 0.953 | 0.9645 | 9824000.0 |
| 2002-05-24 10:00:00 | AMZN | Stock | 0.9645 | 0.9775 | 0.9575 | 0.9665 | 17936000.0 |
| 2002-05-24 11:00:00 | AMZN | Stock | 0.9675 | 0.973 | 0.9645 | 0.97 | 9760000.0 |
| 2002-05-24 12:00:00 | AMZN | Stock | 0.9695 | 0.9735 | 0.9645 | 0.9715 | 6380000.0 |
| 2002-05-24 13:00:00 | AMZN | Stock | 0.971 | 0.9835 | 0.969 | 0.976 | 14002000.0 |
| 2002-05-24 14:00:00 | AMZN | Stock | 0.9756 | 0.981 | 0.975 | 0.9775 | 8174000.0 |
| 2002-05-24 15:00:00 | AMZN | Stock | 0.9775 | 0.9845 | 0.97 | 0.9735 | 13204000.0 |
| 2002-05-24 16:00:00 | AMZN | Stock | 0.974 | 0.98 | 0.9695 | 0.9785 | 1476000.0 |
| 2002-05-24 17:00:00 | AMZN | Stock | 0.9735 | 0.975 | 0.9735 | 0.975 | 522000.0 |
| 2002-05-24 18:00:00 | AMZN | Stock | 0.9735 | 0.9735 | 0.9735 | 0.9735 | 42000.0 |
| 2002-05-24 09:00:00 | CL | Stock | 26.975 | 27.0 | 26.85 | 26.86 | 529400.0 |
| 2002-05-24 10:00:00 | CL | Stock | 26.865 | 27.025 | 26.8 | 26.9 | 768800.0 |
| 2002-05-24 11:00:00 | CL | Stock | 26.905 | 26.925 | 26.86 | 26.915 | 169200.0 |
| 2002-05-24 12:00:00 | CL | Stock | 26.91 | 26.915 | 26.855 | 26.875 | 338200.0 |
| 2002-05-24 13:00:00 | CL | Stock | 26.86 | 26.9 | 26.845 | 26.845 | 324000.0 |
| 2002-05-24 14:00:00 | CL | Stock | 26.84 | 26.84 | 26.655 | 26.66 | 345200.0 |
> showing 50 of 18,950 rows — these rows as CSV