PREVIEW / stock_1hour / 2002-10-30
file: by_date/stock_1hour/2002/2002-10-30.parquet size: 401 KB rows: 19,392 symbols: 1,490
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-30 08:00:00 | AAPL | Stock | 0.2775 | 0.2775 | 0.2771 | 0.2771 | 16800.0 |
| 2002-10-30 09:00:00 | AAPL | Stock | 0.2766 | 0.2814 | 0.2764 | 0.279 | 23518712.0 |
| 2002-10-30 10:00:00 | AAPL | Stock | 0.2793 | 0.2848 | 0.2789 | 0.2841 | 41191416.0 |
| 2002-10-30 11:00:00 | AAPL | Stock | 0.2841 | 0.2879 | 0.2834 | 0.2866 | 50557808.0 |
| 2002-10-30 12:00:00 | AAPL | Stock | 0.2866 | 0.2896 | 0.2866 | 0.2896 | 25596536.0 |
| 2002-10-30 13:00:00 | AAPL | Stock | 0.2898 | 0.2923 | 0.2852 | 0.2863 | 25561536.0 |
| 2002-10-30 14:00:00 | AAPL | Stock | 0.2862 | 0.2903 | 0.2854 | 0.2889 | 25040960.0 |
| 2002-10-30 15:00:00 | AAPL | Stock | 0.2888 | 0.292 | 0.285 | 0.285 | 43218224.0 |
| 2002-10-30 16:00:00 | AAPL | Stock | 0.2854 | 0.2874 | 0.2821 | 0.2854 | 13400800.0 |
| 2002-10-30 18:00:00 | AAPL | Stock | 0.285 | 0.285 | 0.285 | 0.285 | 56000.0 |
| 2002-10-30 08:00:00 | MSFT | Stock | 26.1 | 26.255 | 26.1 | 26.15 | 109760.0 |
| 2002-10-30 09:00:00 | MSFT | Stock | 26.1455 | 26.225 | 25.815 | 25.93 | 9391386.0 |
| 2002-10-30 10:00:00 | MSFT | Stock | 25.93 | 26.49 | 25.91 | 26.38 | 16517102.0 |
| 2002-10-30 11:00:00 | MSFT | Stock | 26.3845 | 26.58 | 26.35 | 26.43 | 14076972.0 |
| 2002-10-30 12:00:00 | MSFT | Stock | 26.425 | 26.64 | 26.405 | 26.625 | 9570536.0 |
| 2002-10-30 13:00:00 | MSFT | Stock | 26.635 | 26.645 | 26.385 | 26.405 | 9461452.0 |
| 2002-10-30 14:00:00 | MSFT | Stock | 26.41 | 26.6 | 26.325 | 26.555 | 9322670.0 |
| 2002-10-30 15:00:00 | MSFT | Stock | 26.54 | 26.695 | 26.35 | 26.565 | 17347934.0 |
| 2002-10-30 16:00:00 | MSFT | Stock | 26.565 | 26.575 | 26.41 | 26.54 | 1142526.0 |
| 2002-10-30 17:00:00 | MSFT | Stock | 26.525 | 26.5395 | 26.475 | 26.505 | 21042.0 |
| 2002-10-30 18:00:00 | MSFT | Stock | 26.5 | 26.5 | 26.475 | 26.5 | 4600.0 |
| 2002-10-30 08:00:00 | NVDA | Stock | 0.089 | 0.0907 | 0.089 | 0.0907 | 2265000.0 |
| 2002-10-30 09:00:00 | NVDA | Stock | 0.0907 | 0.0937 | 0.0905 | 0.0923 | 193167240.0 |
| 2002-10-30 10:00:00 | NVDA | Stock | 0.0923 | 0.0958 | 0.0919 | 0.0945 | 179663160.0 |
| 2002-10-30 11:00:00 | NVDA | Stock | 0.0943 | 0.0967 | 0.0934 | 0.0937 | 153291600.0 |
| 2002-10-30 12:00:00 | NVDA | Stock | 0.0937 | 0.095 | 0.0937 | 0.0942 | 75160680.0 |
| 2002-10-30 13:00:00 | NVDA | Stock | 0.0942 | 0.0949 | 0.0925 | 0.0925 | 81132600.0 |
| 2002-10-30 14:00:00 | NVDA | Stock | 0.0925 | 0.094 | 0.0917 | 0.0937 | 151486080.0 |
| 2002-10-30 15:00:00 | NVDA | Stock | 0.0937 | 0.0946 | 0.0932 | 0.0937 | 168328680.0 |
| 2002-10-30 16:00:00 | NVDA | Stock | 0.0936 | 0.0942 | 0.0933 | 0.0933 | 54839640.0 |
| 2002-10-30 17:00:00 | NVDA | Stock | 0.0929 | 0.0936 | 0.0929 | 0.0935 | 240000.0 |
| 2002-10-30 18:00:00 | NVDA | Stock | 0.0935 | 0.0935 | 0.0933 | 0.0933 | 396000.0 |
| 2002-10-30 08:00:00 | AMZN | Stock | 0.94 | 0.9475 | 0.94 | 0.9465 | 224000.0 |
| 2002-10-30 09:00:00 | AMZN | Stock | 0.9465 | 0.9504 | 0.9235 | 0.927 | 19095940.0 |
| 2002-10-30 10:00:00 | AMZN | Stock | 0.927 | 0.955 | 0.927 | 0.948 | 29495280.0 |
| 2002-10-30 11:00:00 | AMZN | Stock | 0.9485 | 0.9565 | 0.942 | 0.9475 | 19376820.0 |
| 2002-10-30 12:00:00 | AMZN | Stock | 0.9475 | 0.961 | 0.9473 | 0.9595 | 15592200.0 |
| 2002-10-30 13:00:00 | AMZN | Stock | 0.9595 | 0.961 | 0.9445 | 0.949 | 12134360.0 |
| 2002-10-30 14:00:00 | AMZN | Stock | 0.949 | 0.9505 | 0.9384 | 0.948 | 9446540.0 |
| 2002-10-30 15:00:00 | AMZN | Stock | 0.9485 | 0.9582 | 0.9445 | 0.9536 | 19312300.0 |
| 2002-10-30 16:00:00 | AMZN | Stock | 0.954 | 0.957 | 0.95 | 0.952 | 3438160.0 |
| 2002-10-30 17:00:00 | AMZN | Stock | 0.954 | 0.954 | 0.954 | 0.954 | 30000.0 |
| 2002-10-30 18:00:00 | AMZN | Stock | 0.952 | 0.955 | 0.952 | 0.955 | 106000.0 |
| 2002-10-30 09:00:00 | CL | Stock | 28.025 | 28.05 | 27.8 | 27.87 | 470200.0 |
| 2002-10-30 10:00:00 | CL | Stock | 27.875 | 28.05 | 27.83 | 27.905 | 537400.0 |
| 2002-10-30 11:00:00 | CL | Stock | 27.915 | 28.04 | 27.84 | 27.99 | 267600.0 |
| 2002-10-30 12:00:00 | CL | Stock | 27.935 | 28.05 | 27.87 | 28.025 | 232400.0 |
| 2002-10-30 13:00:00 | CL | Stock | 28.015 | 28.1 | 27.92 | 27.975 | 185400.0 |
| 2002-10-30 14:00:00 | CL | Stock | 27.955 | 28.025 | 27.895 | 28.015 | 304800.0 |
| 2002-10-30 15:00:00 | CL | Stock | 28.015 | 28.14 | 27.935 | 27.98 | 578600.0 |
> showing 50 of 19,392 rows — these rows as CSV