PREVIEW / stock_1hour / 2001-10-08
file: by_date/stock_1hour/2001/2001-10-08.parquet size: 343 KB rows: 16,441 symbols: 1,323
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-08 08:00:00 | AAPL | Stock | 0.2834 | 0.2834 | 0.2834 | 0.2834 | 33600.0 |
| 2001-10-08 09:00:00 | AAPL | Stock | 0.2821 | 0.287 | 0.2768 | 0.2859 | 36702400.0 |
| 2001-10-08 10:00:00 | AAPL | Stock | 0.2857 | 0.2909 | 0.2821 | 0.2886 | 43769600.0 |
| 2001-10-08 11:00:00 | AAPL | Stock | 0.2877 | 0.2905 | 0.2868 | 0.2891 | 17516800.0 |
| 2001-10-08 12:00:00 | AAPL | Stock | 0.2891 | 0.2896 | 0.2839 | 0.2861 | 11743200.0 |
| 2001-10-08 13:00:00 | AAPL | Stock | 0.2859 | 0.2913 | 0.2846 | 0.2905 | 19846400.0 |
| 2001-10-08 14:00:00 | AAPL | Stock | 0.2907 | 0.2916 | 0.2861 | 0.2886 | 25659200.0 |
| 2001-10-08 15:00:00 | AAPL | Stock | 0.2884 | 0.2904 | 0.2857 | 0.2896 | 23100000.0 |
| 2001-10-08 16:00:00 | AAPL | Stock | 0.2893 | 0.2895 | 0.2866 | 0.2893 | 20025600.0 |
| 2001-10-08 17:00:00 | AAPL | Stock | 0.2866 | 0.2866 | 0.2866 | 0.2866 | 5600.0 |
| 2001-10-08 18:00:00 | AAPL | Stock | 0.2866 | 0.2866 | 0.2866 | 0.2866 | 5600.0 |
| 2001-10-08 08:00:00 | MSFT | Stock | 28.25 | 28.8625 | 28.12 | 28.5 | 79800.0 |
| 2001-10-08 09:00:00 | MSFT | Stock | 28.595 | 29.075 | 28.37 | 29.035 | 10255200.0 |
| 2001-10-08 10:00:00 | MSFT | Stock | 29.045 | 29.16 | 28.625 | 28.965 | 10622800.0 |
| 2001-10-08 11:00:00 | MSFT | Stock | 28.96 | 29.325 | 28.95 | 29.055 | 7662000.0 |
| 2001-10-08 12:00:00 | MSFT | Stock | 29.06 | 29.1355 | 28.775 | 28.815 | 4835400.0 |
| 2001-10-08 13:00:00 | MSFT | Stock | 28.825 | 29.1 | 28.7195 | 29.0 | 5461000.0 |
| 2001-10-08 14:00:00 | MSFT | Stock | 29.0005 | 29.07 | 28.505 | 28.505 | 7933200.0 |
| 2001-10-08 15:00:00 | MSFT | Stock | 28.515 | 29.07 | 28.45 | 29.02 | 9652600.0 |
| 2001-10-08 16:00:00 | MSFT | Stock | 29.02 | 29.075 | 28.8134 | 29.075 | 2017400.0 |
| 2001-10-08 17:00:00 | MSFT | Stock | 29.105 | 29.105 | 29.005 | 29.015 | 8600.0 |
| 2001-10-08 18:00:00 | MSFT | Stock | 29.015 | 29.075 | 29.015 | 29.075 | 1600.0 |
| 2001-10-08 08:00:00 | NVDA | Stock | 0.2667 | 0.27 | 0.2584 | 0.2642 | 2172000.0 |
| 2001-10-08 09:00:00 | NVDA | Stock | 0.2642 | 0.2825 | 0.2633 | 0.2824 | 109200000.0 |
| 2001-10-08 10:00:00 | NVDA | Stock | 0.2823 | 0.2896 | 0.2765 | 0.2877 | 183876000.0 |
| 2001-10-08 11:00:00 | NVDA | Stock | 0.2877 | 0.2908 | 0.2807 | 0.2826 | 88464000.0 |
| 2001-10-08 12:00:00 | NVDA | Stock | 0.2827 | 0.2867 | 0.2808 | 0.2825 | 57120000.0 |
| 2001-10-08 13:00:00 | NVDA | Stock | 0.2824 | 0.285 | 0.2785 | 0.28 | 80604000.0 |
| 2001-10-08 14:00:00 | NVDA | Stock | 0.28 | 0.2807 | 0.2713 | 0.2721 | 90792000.0 |
| 2001-10-08 15:00:00 | NVDA | Stock | 0.2721 | 0.2832 | 0.2693 | 0.2802 | 116004000.0 |
| 2001-10-08 16:00:00 | NVDA | Stock | 0.2802 | 0.2807 | 0.2634 | 0.2783 | 7536000.0 |
| 2001-10-08 17:00:00 | NVDA | Stock | 0.278 | 0.2786 | 0.278 | 0.2783 | 156000.0 |
| 2001-10-08 18:00:00 | NVDA | Stock | 0.2793 | 0.2803 | 0.2793 | 0.2803 | 384000.0 |
| 2001-10-08 08:00:00 | AMZN | Stock | 0.3525 | 0.355 | 0.3525 | 0.355 | 20000.0 |
| 2001-10-08 09:00:00 | AMZN | Stock | 0.354 | 0.365 | 0.3455 | 0.3595 | 14996000.0 |
| 2001-10-08 10:00:00 | AMZN | Stock | 0.364 | 0.365 | 0.352 | 0.3605 | 21082000.0 |
| 2001-10-08 11:00:00 | AMZN | Stock | 0.3606 | 0.364 | 0.355 | 0.357 | 9336000.0 |
| 2001-10-08 12:00:00 | AMZN | Stock | 0.3565 | 0.3585 | 0.355 | 0.3585 | 4398000.0 |
| 2001-10-08 13:00:00 | AMZN | Stock | 0.356 | 0.3605 | 0.356 | 0.356 | 4502000.0 |
| 2001-10-08 14:00:00 | AMZN | Stock | 0.357 | 0.3595 | 0.349 | 0.3505 | 7962000.0 |
| 2001-10-08 15:00:00 | AMZN | Stock | 0.351 | 0.359 | 0.3465 | 0.356 | 6622000.0 |
| 2001-10-08 16:00:00 | AMZN | Stock | 0.355 | 0.3595 | 0.355 | 0.356 | 6380000.0 |
| 2001-10-08 18:00:00 | AMZN | Stock | 0.355 | 0.355 | 0.355 | 0.355 | 2000.0 |
| 2001-10-08 09:00:00 | CL | Stock | 28.75 | 28.755 | 28.505 | 28.525 | 247200.0 |
| 2001-10-08 10:00:00 | CL | Stock | 28.525 | 28.565 | 28.3 | 28.48 | 247000.0 |
| 2001-10-08 11:00:00 | CL | Stock | 28.5 | 28.59 | 28.34 | 28.48 | 166400.0 |
| 2001-10-08 12:00:00 | CL | Stock | 28.48 | 28.485 | 28.3 | 28.44 | 226800.0 |
| 2001-10-08 13:00:00 | CL | Stock | 28.44 | 28.51 | 28.415 | 28.455 | 205600.0 |
| 2001-10-08 14:00:00 | CL | Stock | 28.46 | 28.475 | 28.265 | 28.275 | 345600.0 |
| 2001-10-08 15:00:00 | CL | Stock | 28.275 | 28.525 | 28.265 | 28.485 | 332800.0 |
> showing 50 of 16,441 rows — these rows as CSV