PREVIEW / stock_1hour / 2002-10-29
file: by_date/stock_1hour/2002/2002-10-29.parquet size: 417 KB rows: 20,267 symbols: 1,494
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-10-29 09:00:00 | AAPL | Stock | 0.2734 | 0.2836 | 0.2718 | 0.2796 | 31694432.0 |
| 2002-10-29 10:00:00 | AAPL | Stock | 0.2796 | 0.2804 | 0.2696 | 0.27 | 51145752.0 |
| 2002-10-29 11:00:00 | AAPL | Stock | 0.27 | 0.2732 | 0.2687 | 0.2688 | 44150680.0 |
| 2002-10-29 12:00:00 | AAPL | Stock | 0.2688 | 0.2709 | 0.2671 | 0.2688 | 28140840.0 |
| 2002-10-29 13:00:00 | AAPL | Stock | 0.2688 | 0.272 | 0.2684 | 0.2711 | 19358024.0 |
| 2002-10-29 14:00:00 | AAPL | Stock | 0.2713 | 0.2713 | 0.2688 | 0.2698 | 19784408.0 |
| 2002-10-29 15:00:00 | AAPL | Stock | 0.2702 | 0.2764 | 0.2698 | 0.2754 | 34800752.0 |
| 2002-10-29 16:00:00 | AAPL | Stock | 0.2754 | 0.3393 | 0.2754 | 0.2759 | 6897408.0 |
| 2002-10-29 17:00:00 | AAPL | Stock | 0.2757 | 0.2757 | 0.2757 | 0.2757 | 22400.0 |
| 2002-10-29 18:00:00 | AAPL | Stock | 0.2757 | 0.2757 | 0.2757 | 0.2757 | 78400.0 |
| 2002-10-29 08:00:00 | MSFT | Stock | 25.965 | 25.97 | 25.875 | 25.92 | 63410.0 |
| 2002-10-29 09:00:00 | MSFT | Stock | 25.95 | 26.22 | 25.88 | 26.1635 | 9350176.0 |
| 2002-10-29 10:00:00 | MSFT | Stock | 26.165 | 26.17 | 25.444 | 25.55 | 18995454.0 |
| 2002-10-29 11:00:00 | MSFT | Stock | 25.575 | 25.6805 | 25.425 | 25.615 | 9688148.0 |
| 2002-10-29 12:00:00 | MSFT | Stock | 25.62 | 25.75 | 25.5205 | 25.575 | 7213390.0 |
| 2002-10-29 13:00:00 | MSFT | Stock | 25.575 | 25.73 | 25.525 | 25.715 | 6759830.0 |
| 2002-10-29 14:00:00 | MSFT | Stock | 25.715 | 25.72 | 25.475 | 25.635 | 8487688.0 |
| 2002-10-29 15:00:00 | MSFT | Stock | 25.635 | 26.245 | 25.635 | 26.03 | 17286386.0 |
| 2002-10-29 16:00:00 | MSFT | Stock | 26.025 | 26.18 | 25.45 | 26.075 | 2880538.0 |
| 2002-10-29 17:00:00 | MSFT | Stock | 26.075 | 26.1 | 26.035 | 26.085 | 35800.0 |
| 2002-10-29 18:00:00 | MSFT | Stock | 26.11 | 26.135 | 26.035 | 26.125 | 56800.0 |
| 2002-10-29 08:00:00 | NVDA | Stock | 0.0932 | 0.0933 | 0.0929 | 0.0929 | 600000.0 |
| 2002-10-29 09:00:00 | NVDA | Stock | 0.093 | 0.0938 | 0.0917 | 0.0927 | 68482680.0 |
| 2002-10-29 10:00:00 | NVDA | Stock | 0.0927 | 0.0927 | 0.0842 | 0.086 | 235752000.0 |
| 2002-10-29 11:00:00 | NVDA | Stock | 0.086 | 0.0865 | 0.0854 | 0.0856 | 113632920.0 |
| 2002-10-29 12:00:00 | NVDA | Stock | 0.0856 | 0.0866 | 0.0851 | 0.0859 | 46894800.0 |
| 2002-10-29 13:00:00 | NVDA | Stock | 0.0859 | 0.0863 | 0.0854 | 0.0862 | 35830680.0 |
| 2002-10-29 14:00:00 | NVDA | Stock | 0.0863 | 0.0863 | 0.0846 | 0.0857 | 61907280.0 |
| 2002-10-29 15:00:00 | NVDA | Stock | 0.0857 | 0.0901 | 0.0856 | 0.089 | 113886240.0 |
| 2002-10-29 16:00:00 | NVDA | Stock | 0.0889 | 0.0894 | 0.0885 | 0.0885 | 13167240.0 |
| 2002-10-29 17:00:00 | NVDA | Stock | 0.0875 | 0.0889 | 0.0875 | 0.0889 | 544200.0 |
| 2002-10-29 18:00:00 | NVDA | Stock | 0.0889 | 0.0892 | 0.0882 | 0.0883 | 353880.0 |
| 2002-10-29 08:00:00 | AMZN | Stock | 0.929 | 0.9358 | 0.926 | 0.926 | 362000.0 |
| 2002-10-29 09:00:00 | AMZN | Stock | 0.9265 | 0.946 | 0.9225 | 0.9365 | 19103100.0 |
| 2002-10-29 10:00:00 | AMZN | Stock | 0.937 | 0.9375 | 0.9035 | 0.909 | 29549240.0 |
| 2002-10-29 11:00:00 | AMZN | Stock | 0.909 | 0.926 | 0.9065 | 0.923 | 18597800.0 |
| 2002-10-29 12:00:00 | AMZN | Stock | 0.923 | 0.9295 | 0.9195 | 0.9255 | 12470520.0 |
| 2002-10-29 13:00:00 | AMZN | Stock | 0.9255 | 0.936 | 0.9245 | 0.9335 | 9893320.0 |
| 2002-10-29 14:00:00 | AMZN | Stock | 0.9335 | 0.9345 | 0.9225 | 0.9275 | 15336980.0 |
| 2002-10-29 15:00:00 | AMZN | Stock | 0.9275 | 0.936 | 0.926 | 0.93 | 18723560.0 |
| 2002-10-29 16:00:00 | AMZN | Stock | 0.93 | 0.9345 | 0.928 | 0.93 | 2009000.0 |
| 2002-10-29 17:00:00 | AMZN | Stock | 0.9285 | 0.93 | 0.9285 | 0.9285 | 1638000.0 |
| 2002-10-29 18:00:00 | AMZN | Stock | 0.9285 | 0.93 | 0.9285 | 0.93 | 1624000.0 |
| 2002-10-29 09:00:00 | CL | Stock | 27.605 | 27.855 | 27.565 | 27.845 | 633200.0 |
| 2002-10-29 10:00:00 | CL | Stock | 27.855 | 27.855 | 27.405 | 27.42 | 655200.0 |
| 2002-10-29 11:00:00 | CL | Stock | 27.42 | 27.445 | 27.165 | 27.375 | 525200.0 |
| 2002-10-29 12:00:00 | CL | Stock | 27.37 | 27.525 | 27.245 | 27.42 | 340600.0 |
| 2002-10-29 13:00:00 | CL | Stock | 27.42 | 27.7 | 27.355 | 27.69 | 225600.0 |
| 2002-10-29 14:00:00 | CL | Stock | 27.69 | 27.795 | 27.545 | 27.76 | 307400.0 |
| 2002-10-29 15:00:00 | CL | Stock | 27.76 | 27.905 | 27.74 | 27.845 | 586000.0 |
> showing 50 of 20,267 rows — these rows as CSV