PREVIEW / stock_1hour / 2002-06-06
file: by_date/stock_1hour/2002/2002-06-06.parquet size: 405 KB rows: 19,397 symbols: 1,434
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-06-06 08:00:00 | AAPL | Stock | 0.4057 | 0.4057 | 0.393 | 0.4057 | 140000.0 |
| 2002-06-06 09:00:00 | AAPL | Stock | 0.4063 | 0.4148 | 0.4045 | 0.4088 | 52063200.0 |
| 2002-06-06 10:00:00 | AAPL | Stock | 0.4088 | 0.4098 | 0.4017 | 0.4038 | 38040800.0 |
| 2002-06-06 11:00:00 | AAPL | Stock | 0.4034 | 0.4041 | 0.3971 | 0.4011 | 19712000.0 |
| 2002-06-06 12:00:00 | AAPL | Stock | 0.4009 | 0.402 | 0.3973 | 0.4002 | 19964000.0 |
| 2002-06-06 13:00:00 | AAPL | Stock | 0.4002 | 0.4004 | 0.3982 | 0.3982 | 14380800.0 |
| 2002-06-06 14:00:00 | AAPL | Stock | 0.3982 | 0.4004 | 0.3936 | 0.3954 | 43394400.0 |
| 2002-06-06 15:00:00 | AAPL | Stock | 0.3952 | 0.3991 | 0.3943 | 0.395 | 28812000.0 |
| 2002-06-06 16:00:00 | AAPL | Stock | 0.3945 | 0.4116 | 0.3839 | 0.395 | 19947200.0 |
| 2002-06-06 17:00:00 | AAPL | Stock | 0.395 | 0.3957 | 0.3857 | 0.3857 | 2458400.0 |
| 2002-06-06 18:00:00 | AAPL | Stock | 0.3875 | 0.3875 | 0.3857 | 0.3857 | 33600.0 |
| 2002-06-06 08:00:00 | MSFT | Stock | 25.89 | 25.945 | 25.65 | 25.825 | 293200.0 |
| 2002-06-06 09:00:00 | MSFT | Stock | 25.825 | 25.85 | 25.505 | 25.59 | 10912400.0 |
| 2002-06-06 10:00:00 | MSFT | Stock | 25.59 | 25.83 | 25.4 | 25.75 | 12145400.0 |
| 2002-06-06 11:00:00 | MSFT | Stock | 25.75 | 25.775 | 25.5 | 25.685 | 10143000.0 |
| 2002-06-06 12:00:00 | MSFT | Stock | 25.675 | 25.8655 | 25.55 | 25.755 | 5567200.0 |
| 2002-06-06 13:00:00 | MSFT | Stock | 25.755 | 25.93 | 25.675 | 25.8355 | 5626000.0 |
| 2002-06-06 14:00:00 | MSFT | Stock | 25.835 | 25.972 | 25.53 | 25.75 | 9488600.0 |
| 2002-06-06 15:00:00 | MSFT | Stock | 25.75 | 26.07 | 25.615 | 25.95 | 12482000.0 |
| 2002-06-06 16:00:00 | MSFT | Stock | 25.975 | 26.07 | 24.71 | 25.5 | 6767800.0 |
| 2002-06-06 17:00:00 | MSFT | Stock | 25.5 | 25.95 | 24.7 | 25.0 | 899800.0 |
| 2002-06-06 18:00:00 | MSFT | Stock | 25.05 | 25.05 | 24.97 | 25.025 | 6000.0 |
| 2002-06-06 08:00:00 | NVDA | Stock | 0.2716 | 0.2725 | 0.2675 | 0.2694 | 1776000.0 |
| 2002-06-06 09:00:00 | NVDA | Stock | 0.2694 | 0.2742 | 0.2686 | 0.2708 | 103584000.0 |
| 2002-06-06 10:00:00 | NVDA | Stock | 0.2709 | 0.2754 | 0.2688 | 0.2744 | 136224000.0 |
| 2002-06-06 11:00:00 | NVDA | Stock | 0.2747 | 0.2748 | 0.2692 | 0.2726 | 120960000.0 |
| 2002-06-06 12:00:00 | NVDA | Stock | 0.2725 | 0.2742 | 0.271 | 0.2735 | 61800000.0 |
| 2002-06-06 13:00:00 | NVDA | Stock | 0.2737 | 0.2749 | 0.2727 | 0.2733 | 71460000.0 |
| 2002-06-06 14:00:00 | NVDA | Stock | 0.2732 | 0.2741 | 0.2689 | 0.2715 | 57672000.0 |
| 2002-06-06 15:00:00 | NVDA | Stock | 0.2714 | 0.2732 | 0.2706 | 0.2719 | 95868000.0 |
| 2002-06-06 16:00:00 | NVDA | Stock | 0.2718 | 0.2724 | 0.2563 | 0.2712 | 32916000.0 |
| 2002-06-06 17:00:00 | NVDA | Stock | 0.271 | 0.2717 | 0.255 | 0.2554 | 8772000.0 |
| 2002-06-06 18:00:00 | NVDA | Stock | 0.2552 | 0.2596 | 0.255 | 0.2566 | 1104000.0 |
| 2002-06-06 08:00:00 | AMZN | Stock | 0.9 | 0.9 | 0.9 | 0.9 | 2000.0 |
| 2002-06-06 09:00:00 | AMZN | Stock | 0.8995 | 0.9045 | 0.8885 | 0.89 | 10788000.0 |
| 2002-06-06 10:00:00 | AMZN | Stock | 0.8915 | 0.899 | 0.888 | 0.894 | 9804000.0 |
| 2002-06-06 11:00:00 | AMZN | Stock | 0.894 | 0.9 | 0.888 | 0.8995 | 14208000.0 |
| 2002-06-06 12:00:00 | AMZN | Stock | 0.8995 | 0.9165 | 0.8975 | 0.911 | 16018000.0 |
| 2002-06-06 13:00:00 | AMZN | Stock | 0.9105 | 0.9145 | 0.9035 | 0.9085 | 9514000.0 |
| 2002-06-06 14:00:00 | AMZN | Stock | 0.9085 | 0.914 | 0.9 | 0.9065 | 12694000.0 |
| 2002-06-06 15:00:00 | AMZN | Stock | 0.9065 | 0.9205 | 0.903 | 0.9115 | 23386000.0 |
| 2002-06-06 16:00:00 | AMZN | Stock | 0.91 | 0.921 | 0.8965 | 0.911 | 3238000.0 |
| 2002-06-06 17:00:00 | AMZN | Stock | 0.911 | 0.911 | 0.88 | 0.9085 | 842000.0 |
| 2002-06-06 18:00:00 | AMZN | Stock | 0.8835 | 0.885 | 0.883 | 0.885 | 36000.0 |
| 2002-06-06 09:00:00 | CL | Stock | 27.8 | 27.95 | 27.76 | 27.89 | 774600.0 |
| 2002-06-06 10:00:00 | CL | Stock | 27.9 | 27.95 | 27.82 | 27.82 | 559600.0 |
| 2002-06-06 11:00:00 | CL | Stock | 27.825 | 27.875 | 27.615 | 27.81 | 772000.0 |
| 2002-06-06 12:00:00 | CL | Stock | 27.85 | 27.85 | 27.75 | 27.835 | 400200.0 |
| 2002-06-06 13:00:00 | CL | Stock | 27.815 | 27.85 | 27.625 | 27.63 | 555800.0 |
| 2002-06-06 14:00:00 | CL | Stock | 27.63 | 27.9 | 27.62 | 27.715 | 767400.0 |
> showing 50 of 19,397 rows — these rows as CSV