PREVIEW / stock_1hour / 2002-11-11
file: by_date/stock_1hour/2002/2002-11-11.parquet size: 388 KB rows: 18,537 symbols: 1,488
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-11-11 09:00:00 | AAPL | Stock | 0.2803 | 0.2838 | 0.2771 | 0.2784 | 12853232.0 |
| 2002-11-11 10:00:00 | AAPL | Stock | 0.2784 | 0.2788 | 0.2739 | 0.2748 | 30526552.0 |
| 2002-11-11 11:00:00 | AAPL | Stock | 0.2746 | 0.2773 | 0.2739 | 0.2754 | 20110888.0 |
| 2002-11-11 12:00:00 | AAPL | Stock | 0.2752 | 0.2754 | 0.2721 | 0.2739 | 18094608.0 |
| 2002-11-11 13:00:00 | AAPL | Stock | 0.2739 | 0.275 | 0.2723 | 0.2732 | 7873600.0 |
| 2002-11-11 14:00:00 | AAPL | Stock | 0.2732 | 0.2741 | 0.2716 | 0.2734 | 13161232.0 |
| 2002-11-11 15:00:00 | AAPL | Stock | 0.2732 | 0.2741 | 0.27 | 0.2702 | 36235248.0 |
| 2002-11-11 16:00:00 | AAPL | Stock | 0.2711 | 0.2723 | 0.2702 | 0.2709 | 3729600.0 |
| 2002-11-11 17:00:00 | AAPL | Stock | 0.2689 | 0.2689 | 0.2689 | 0.2689 | 56000.0 |
| 2002-11-11 08:00:00 | MSFT | Stock | 27.48 | 27.675 | 27.265 | 27.55 | 45120.0 |
| 2002-11-11 09:00:00 | MSFT | Stock | 27.575 | 27.625 | 27.11 | 27.175 | 9547358.0 |
| 2002-11-11 10:00:00 | MSFT | Stock | 27.177 | 27.26 | 27.015 | 27.15 | 11687854.0 |
| 2002-11-11 11:00:00 | MSFT | Stock | 27.145 | 27.245 | 27.035 | 27.115 | 6736120.0 |
| 2002-11-11 12:00:00 | MSFT | Stock | 27.121 | 27.275 | 27.085 | 27.275 | 5162922.0 |
| 2002-11-11 13:00:00 | MSFT | Stock | 27.28 | 27.28 | 27.16 | 27.205 | 4737802.0 |
| 2002-11-11 14:00:00 | MSFT | Stock | 27.205 | 27.24 | 27.13 | 27.16 | 3630016.0 |
| 2002-11-11 15:00:00 | MSFT | Stock | 27.16 | 27.195 | 26.91 | 26.935 | 11729866.0 |
| 2002-11-11 16:00:00 | MSFT | Stock | 26.93 | 27.12 | 26.92 | 26.925 | 1470058.0 |
| 2002-11-11 17:00:00 | MSFT | Stock | 26.925 | 27.0 | 26.9 | 26.925 | 67904.0 |
| 2002-11-11 18:00:00 | MSFT | Stock | 26.925 | 26.935 | 26.9 | 26.9 | 4300.0 |
| 2002-11-11 08:00:00 | NVDA | Stock | 0.0933 | 0.0946 | 0.0908 | 0.0917 | 4968000.0 |
| 2002-11-11 09:00:00 | NVDA | Stock | 0.0912 | 0.0946 | 0.0852 | 0.0864 | 340193520.0 |
| 2002-11-11 10:00:00 | NVDA | Stock | 0.0863 | 0.0897 | 0.0857 | 0.0887 | 265475640.0 |
| 2002-11-11 11:00:00 | NVDA | Stock | 0.0889 | 0.0911 | 0.0883 | 0.089 | 183510600.0 |
| 2002-11-11 12:00:00 | NVDA | Stock | 0.089 | 0.0894 | 0.0866 | 0.0885 | 124680480.0 |
| 2002-11-11 13:00:00 | NVDA | Stock | 0.0885 | 0.0898 | 0.0872 | 0.0886 | 86313240.0 |
| 2002-11-11 14:00:00 | NVDA | Stock | 0.0887 | 0.0896 | 0.0878 | 0.0889 | 81312960.0 |
| 2002-11-11 15:00:00 | NVDA | Stock | 0.0889 | 0.0889 | 0.0867 | 0.0874 | 199865400.0 |
| 2002-11-11 16:00:00 | NVDA | Stock | 0.0873 | 0.0881 | 0.0867 | 0.0873 | 18948000.0 |
| 2002-11-11 17:00:00 | NVDA | Stock | 0.0878 | 0.088 | 0.0876 | 0.0879 | 1644840.0 |
| 2002-11-11 18:00:00 | NVDA | Stock | 0.0875 | 0.088 | 0.0875 | 0.0878 | 816000.0 |
| 2002-11-11 08:00:00 | AMZN | Stock | 0.9725 | 0.9725 | 0.9725 | 0.9725 | 46000.0 |
| 2002-11-11 09:00:00 | AMZN | Stock | 0.9725 | 0.9775 | 0.9575 | 0.9605 | 13500480.0 |
| 2002-11-11 10:00:00 | AMZN | Stock | 0.9605 | 0.965 | 0.955 | 0.956 | 16195180.0 |
| 2002-11-11 11:00:00 | AMZN | Stock | 0.956 | 0.96 | 0.9525 | 0.9545 | 16084680.0 |
| 2002-11-11 12:00:00 | AMZN | Stock | 0.954 | 0.9575 | 0.95 | 0.954 | 15226540.0 |
| 2002-11-11 13:00:00 | AMZN | Stock | 0.954 | 0.96 | 0.952 | 0.9555 | 11036720.0 |
| 2002-11-11 14:00:00 | AMZN | Stock | 0.9555 | 0.9555 | 0.94 | 0.95 | 9215100.0 |
| 2002-11-11 15:00:00 | AMZN | Stock | 0.95 | 0.9575 | 0.943 | 0.95 | 19310060.0 |
| 2002-11-11 16:00:00 | AMZN | Stock | 0.9505 | 0.955 | 0.95 | 0.9505 | 2581240.0 |
| 2002-11-11 17:00:00 | AMZN | Stock | 0.95 | 0.95 | 0.95 | 0.95 | 1538600.0 |
| 2002-11-11 09:00:00 | CL | Stock | 27.25 | 27.4 | 27.21 | 27.245 | 469400.0 |
| 2002-11-11 10:00:00 | CL | Stock | 27.25 | 27.345 | 26.975 | 27.025 | 451200.0 |
| 2002-11-11 11:00:00 | CL | Stock | 27.025 | 27.1 | 26.735 | 26.75 | 393600.0 |
| 2002-11-11 12:00:00 | CL | Stock | 26.775 | 27.07 | 26.695 | 27.06 | 274000.0 |
| 2002-11-11 13:00:00 | CL | Stock | 27.06 | 27.205 | 27.005 | 27.165 | 346000.0 |
| 2002-11-11 14:00:00 | CL | Stock | 27.165 | 27.225 | 27.075 | 27.135 | 416400.0 |
| 2002-11-11 15:00:00 | CL | Stock | 27.13 | 27.155 | 26.885 | 26.985 | 650400.0 |
| 2002-11-11 16:00:00 | CL | Stock | 26.975 | 26.975 | 26.975 | 26.975 | 39200.0 |
> showing 49 of 18,537 rows — these rows as CSV