PREVIEW / stock_1hour / 2001-10-09
file: by_date/stock_1hour/2001/2001-10-09.parquet size: 357 KB rows: 17,066 symbols: 1,341
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-09 08:00:00 | AAPL | Stock | 0.2892 | 0.2893 | 0.2892 | 0.2893 | 173600.0 |
| 2001-10-09 09:00:00 | AAPL | Stock | 0.2909 | 0.2909 | 0.2832 | 0.2846 | 18351200.0 |
| 2001-10-09 10:00:00 | AAPL | Stock | 0.2846 | 0.2891 | 0.2821 | 0.2879 | 17998400.0 |
| 2001-10-09 11:00:00 | AAPL | Stock | 0.2879 | 0.2879 | 0.2814 | 0.2825 | 16615200.0 |
| 2001-10-09 12:00:00 | AAPL | Stock | 0.2825 | 0.2839 | 0.2791 | 0.2798 | 11284000.0 |
| 2001-10-09 13:00:00 | AAPL | Stock | 0.2798 | 0.2839 | 0.2795 | 0.2807 | 14123200.0 |
| 2001-10-09 14:00:00 | AAPL | Stock | 0.2805 | 0.2845 | 0.2791 | 0.2809 | 27143200.0 |
| 2001-10-09 15:00:00 | AAPL | Stock | 0.2807 | 0.288 | 0.2807 | 0.2859 | 55143200.0 |
| 2001-10-09 16:00:00 | AAPL | Stock | 0.2859 | 0.2871 | 0.2848 | 0.2859 | 6893600.0 |
| 2001-10-09 08:00:00 | MSFT | Stock | 29.05 | 29.05 | 28.35 | 28.745 | 593200.0 |
| 2001-10-09 09:00:00 | MSFT | Stock | 28.725 | 28.865 | 28.275 | 28.3445 | 12648000.0 |
| 2001-10-09 10:00:00 | MSFT | Stock | 28.39 | 28.4 | 27.975 | 28.085 | 18082400.0 |
| 2001-10-09 11:00:00 | MSFT | Stock | 28.085 | 28.15 | 27.775 | 27.78 | 7299400.0 |
| 2001-10-09 12:00:00 | MSFT | Stock | 27.78 | 27.875 | 27.66 | 27.74 | 5691200.0 |
| 2001-10-09 13:00:00 | MSFT | Stock | 27.74 | 27.925 | 27.625 | 27.645 | 8418400.0 |
| 2001-10-09 14:00:00 | MSFT | Stock | 27.6455 | 27.76 | 27.39 | 27.52 | 12706200.0 |
| 2001-10-09 15:00:00 | MSFT | Stock | 27.515 | 27.6 | 27.095 | 27.28 | 24933000.0 |
| 2001-10-09 16:00:00 | MSFT | Stock | 27.285 | 27.8037 | 27.195 | 27.28 | 4295000.0 |
| 2001-10-09 17:00:00 | MSFT | Stock | 27.275 | 27.275 | 27.24 | 27.24 | 10000.0 |
| 2001-10-09 18:00:00 | MSFT | Stock | 27.3 | 27.33 | 27.3 | 27.3 | 7400.0 |
| 2001-10-09 08:00:00 | NVDA | Stock | 0.2803 | 0.2833 | 0.2797 | 0.2833 | 144000.0 |
| 2001-10-09 09:00:00 | NVDA | Stock | 0.2807 | 0.2867 | 0.2692 | 0.2745 | 115164000.0 |
| 2001-10-09 10:00:00 | NVDA | Stock | 0.2737 | 0.2771 | 0.2613 | 0.2752 | 251772000.0 |
| 2001-10-09 11:00:00 | NVDA | Stock | 0.2743 | 0.2758 | 0.2637 | 0.2638 | 101100000.0 |
| 2001-10-09 12:00:00 | NVDA | Stock | 0.2642 | 0.2666 | 0.2602 | 0.2653 | 75072000.0 |
| 2001-10-09 13:00:00 | NVDA | Stock | 0.2651 | 0.2733 | 0.2633 | 0.2713 | 93240000.0 |
| 2001-10-09 14:00:00 | NVDA | Stock | 0.271 | 0.2712 | 0.2647 | 0.2687 | 68676000.0 |
| 2001-10-09 15:00:00 | NVDA | Stock | 0.2682 | 0.2719 | 0.2627 | 0.2687 | 160368000.0 |
| 2001-10-09 16:00:00 | NVDA | Stock | 0.2682 | 0.269 | 0.2635 | 0.2667 | 13332000.0 |
| 2001-10-09 17:00:00 | NVDA | Stock | 0.2682 | 0.2682 | 0.2647 | 0.2647 | 84000.0 |
| 2001-10-09 18:00:00 | NVDA | Stock | 0.2647 | 0.2673 | 0.2647 | 0.2673 | 156000.0 |
| 2001-10-09 08:00:00 | AMZN | Stock | 0.3545 | 0.3545 | 0.3545 | 0.3545 | 10000.0 |
| 2001-10-09 09:00:00 | AMZN | Stock | 0.3555 | 0.356 | 0.343 | 0.3485 | 7578000.0 |
| 2001-10-09 10:00:00 | AMZN | Stock | 0.348 | 0.351 | 0.344 | 0.3465 | 7214000.0 |
| 2001-10-09 11:00:00 | AMZN | Stock | 0.3455 | 0.3485 | 0.3335 | 0.339 | 10396000.0 |
| 2001-10-09 12:00:00 | AMZN | Stock | 0.338 | 0.3465 | 0.3375 | 0.346 | 4482000.0 |
| 2001-10-09 13:00:00 | AMZN | Stock | 0.346 | 0.348 | 0.3385 | 0.3395 | 4372000.0 |
| 2001-10-09 14:00:00 | AMZN | Stock | 0.339 | 0.344 | 0.335 | 0.336 | 5604000.0 |
| 2001-10-09 15:00:00 | AMZN | Stock | 0.337 | 0.3475 | 0.335 | 0.346 | 10688000.0 |
| 2001-10-09 16:00:00 | AMZN | Stock | 0.345 | 0.348 | 0.345 | 0.346 | 2842000.0 |
| 2001-10-09 09:00:00 | CL | Stock | 28.55 | 28.6 | 28.35 | 28.37 | 223000.0 |
| 2001-10-09 10:00:00 | CL | Stock | 28.4 | 28.47 | 28.305 | 28.385 | 261200.0 |
| 2001-10-09 11:00:00 | CL | Stock | 28.355 | 28.4 | 28.315 | 28.395 | 222800.0 |
| 2001-10-09 12:00:00 | CL | Stock | 28.395 | 28.5 | 28.25 | 28.255 | 204200.0 |
| 2001-10-09 13:00:00 | CL | Stock | 28.275 | 28.43 | 28.255 | 28.295 | 174000.0 |
| 2001-10-09 14:00:00 | CL | Stock | 28.285 | 28.35 | 28.255 | 28.335 | 158200.0 |
| 2001-10-09 15:00:00 | CL | Stock | 28.34 | 28.75 | 28.275 | 28.63 | 496200.0 |
| 2001-10-09 16:00:00 | CL | Stock | 28.625 | 28.63 | 28.425 | 28.425 | 126200.0 |
> showing 48 of 17,066 rows — these rows as CSV