PREVIEW / stock_1hour / 2002-10-25
file: by_date/stock_1hour/2002/2002-10-25.parquet size: 402 KB rows: 19,102 symbols: 1,493
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-25 08:00:00 | AAPL | Stock | 0.2629 | 0.2643 | 0.2625 | 0.2629 | 1616496.0 |
| 2002-10-25 09:00:00 | AAPL | Stock | 0.2629 | 0.2664 | 0.2616 | 0.2652 | 25566240.0 |
| 2002-10-25 10:00:00 | AAPL | Stock | 0.265 | 0.2664 | 0.2605 | 0.262 | 36350216.0 |
| 2002-10-25 11:00:00 | AAPL | Stock | 0.262 | 0.2677 | 0.2618 | 0.2675 | 23036104.0 |
| 2002-10-25 12:00:00 | AAPL | Stock | 0.2675 | 0.27 | 0.2673 | 0.2695 | 23352840.0 |
| 2002-10-25 13:00:00 | AAPL | Stock | 0.2695 | 0.2714 | 0.2686 | 0.2698 | 29780632.0 |
| 2002-10-25 14:00:00 | AAPL | Stock | 0.2702 | 0.2736 | 0.2696 | 0.2729 | 42975296.0 |
| 2002-10-25 15:00:00 | AAPL | Stock | 0.273 | 0.2759 | 0.2704 | 0.275 | 78334312.0 |
| 2002-10-25 16:00:00 | AAPL | Stock | 0.275 | 0.2757 | 0.2741 | 0.2741 | 9840488.0 |
| 2002-10-25 17:00:00 | AAPL | Stock | 0.2754 | 0.2766 | 0.2754 | 0.2754 | 2368800.0 |
| 2002-10-25 18:00:00 | AAPL | Stock | 0.2725 | 0.2725 | 0.2725 | 0.2725 | 16800.0 |
| 2002-10-25 08:00:00 | MSFT | Stock | 25.7005 | 25.725 | 25.5 | 25.595 | 78366.0 |
| 2002-10-25 09:00:00 | MSFT | Stock | 25.595 | 25.905 | 25.55 | 25.875 | 9329316.0 |
| 2002-10-25 10:00:00 | MSFT | Stock | 25.875 | 26.005 | 25.66 | 25.75 | 15212466.0 |
| 2002-10-25 11:00:00 | MSFT | Stock | 25.75 | 26.045 | 25.73 | 26.04 | 8481470.0 |
| 2002-10-25 12:00:00 | MSFT | Stock | 26.045 | 26.24 | 26.025 | 26.1345 | 9748686.0 |
| 2002-10-25 13:00:00 | MSFT | Stock | 26.1345 | 26.15 | 25.935 | 25.975 | 6859892.0 |
| 2002-10-25 14:00:00 | MSFT | Stock | 25.97 | 26.4 | 25.97 | 26.305 | 10815142.0 |
| 2002-10-25 15:00:00 | MSFT | Stock | 26.31 | 26.4 | 26.19 | 26.365 | 11910082.0 |
| 2002-10-25 16:00:00 | MSFT | Stock | 26.365 | 26.37 | 26.25 | 26.3 | 1191086.0 |
| 2002-10-25 17:00:00 | MSFT | Stock | 26.34 | 26.34 | 26.0256 | 26.265 | 337200.0 |
| 2002-10-25 18:00:00 | MSFT | Stock | 26.26 | 26.26 | 26.255 | 26.255 | 3012.0 |
| 2002-10-25 08:00:00 | NVDA | Stock | 0.0872 | 0.0877 | 0.0872 | 0.0877 | 4848480.0 |
| 2002-10-25 09:00:00 | NVDA | Stock | 0.0877 | 0.0907 | 0.0863 | 0.0901 | 98623920.0 |
| 2002-10-25 10:00:00 | NVDA | Stock | 0.0901 | 0.091 | 0.0876 | 0.0883 | 145034040.0 |
| 2002-10-25 11:00:00 | NVDA | Stock | 0.0883 | 0.0901 | 0.0882 | 0.0897 | 64111560.0 |
| 2002-10-25 12:00:00 | NVDA | Stock | 0.0897 | 0.0904 | 0.0896 | 0.0898 | 36540480.0 |
| 2002-10-25 13:00:00 | NVDA | Stock | 0.0898 | 0.0899 | 0.088 | 0.0883 | 42682800.0 |
| 2002-10-25 14:00:00 | NVDA | Stock | 0.0883 | 0.0921 | 0.0881 | 0.0915 | 188385720.0 |
| 2002-10-25 15:00:00 | NVDA | Stock | 0.0914 | 0.0929 | 0.0911 | 0.0928 | 133272240.0 |
| 2002-10-25 16:00:00 | NVDA | Stock | 0.0925 | 0.0932 | 0.0917 | 0.0932 | 9278400.0 |
| 2002-10-25 17:00:00 | NVDA | Stock | 0.0932 | 0.0936 | 0.0925 | 0.0936 | 2569200.0 |
| 2002-10-25 18:00:00 | NVDA | Stock | 0.0936 | 0.094 | 0.0936 | 0.0938 | 696000.0 |
| 2002-10-25 08:00:00 | AMZN | Stock | 0.93 | 0.994 | 0.9125 | 0.9405 | 9210220.0 |
| 2002-10-25 09:00:00 | AMZN | Stock | 0.94 | 0.993 | 0.925 | 0.96 | 78039320.0 |
| 2002-10-25 10:00:00 | AMZN | Stock | 0.959 | 0.9655 | 0.945 | 0.9455 | 53515220.0 |
| 2002-10-25 11:00:00 | AMZN | Stock | 0.946 | 0.9545 | 0.945 | 0.9545 | 29328100.0 |
| 2002-10-25 12:00:00 | AMZN | Stock | 0.9544 | 0.955 | 0.941 | 0.9415 | 31832560.0 |
| 2002-10-25 13:00:00 | AMZN | Stock | 0.9415 | 0.9435 | 0.9244 | 0.9275 | 25378060.0 |
| 2002-10-25 14:00:00 | AMZN | Stock | 0.9275 | 0.9525 | 0.9275 | 0.949 | 34814960.0 |
| 2002-10-25 15:00:00 | AMZN | Stock | 0.949 | 0.9665 | 0.936 | 0.9655 | 42294460.0 |
| 2002-10-25 16:00:00 | AMZN | Stock | 0.965 | 0.968 | 0.9605 | 0.961 | 3554600.0 |
| 2002-10-25 17:00:00 | AMZN | Stock | 0.9608 | 0.9658 | 0.9606 | 0.964 | 815220.0 |
| 2002-10-25 18:00:00 | AMZN | Stock | 0.96 | 0.9606 | 0.9595 | 0.9595 | 81400.0 |
| 2002-10-25 09:00:00 | CL | Stock | 27.55 | 27.61 | 27.475 | 27.6 | 357200.0 |
| 2002-10-25 10:00:00 | CL | Stock | 27.61 | 27.675 | 27.375 | 27.4 | 466800.0 |
| 2002-10-25 11:00:00 | CL | Stock | 27.385 | 27.575 | 27.385 | 27.575 | 325200.0 |
| 2002-10-25 12:00:00 | CL | Stock | 27.575 | 27.665 | 27.45 | 27.665 | 215000.0 |
| 2002-10-25 13:00:00 | CL | Stock | 27.655 | 27.75 | 27.6 | 27.68 | 228400.0 |
| 2002-10-25 14:00:00 | CL | Stock | 27.675 | 27.9 | 27.65 | 27.885 | 319200.0 |
> showing 50 of 19,102 rows — these rows as CSV