PREVIEW / stock_30min / 2002-07-31
file: by_date/stock_30min/2002/2002-07-31.parquet size: 619 KB rows: 31,753 symbols: 1,459
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-07-31 08:00:00 | AAPL | Stock | 0.2759 | 0.2759 | 0.2682 | 0.2732 | 1450400.0 |
| 2002-07-31 08:30:00 | AAPL | Stock | 0.2732 | 0.2732 | 0.2732 | 0.2732 | 11200.0 |
| 2002-07-31 09:30:00 | AAPL | Stock | 0.275 | 0.2752 | 0.2675 | 0.2688 | 31761296.0 |
| 2002-07-31 10:00:00 | AAPL | Stock | 0.2688 | 0.2695 | 0.267 | 0.2671 | 24871784.0 |
| 2002-07-31 10:30:00 | AAPL | Stock | 0.2671 | 0.2688 | 0.2666 | 0.2677 | 14900312.0 |
| 2002-07-31 11:00:00 | AAPL | Stock | 0.2679 | 0.2689 | 0.2666 | 0.2689 | 15114512.0 |
| 2002-07-31 11:30:00 | AAPL | Stock | 0.2689 | 0.2698 | 0.2661 | 0.2675 | 27786528.0 |
| 2002-07-31 12:00:00 | AAPL | Stock | 0.2675 | 0.2679 | 0.267 | 0.2677 | 14002856.0 |
| 2002-07-31 12:30:00 | AAPL | Stock | 0.2675 | 0.2689 | 0.2671 | 0.2689 | 12393640.0 |
| 2002-07-31 13:00:00 | AAPL | Stock | 0.2689 | 0.2704 | 0.268 | 0.2688 | 17916696.0 |
| 2002-07-31 13:30:00 | AAPL | Stock | 0.2691 | 0.272 | 0.2682 | 0.2704 | 16550352.0 |
| 2002-07-31 14:00:00 | AAPL | Stock | 0.2704 | 0.2713 | 0.2688 | 0.2693 | 27563536.0 |
| 2002-07-31 14:30:00 | AAPL | Stock | 0.2693 | 0.2713 | 0.2688 | 0.2688 | 13224624.0 |
| 2002-07-31 15:00:00 | AAPL | Stock | 0.2688 | 0.2704 | 0.2671 | 0.2684 | 21348040.0 |
| 2002-07-31 15:30:00 | AAPL | Stock | 0.2686 | 0.275 | 0.268 | 0.2725 | 39965520.0 |
| 2002-07-31 16:00:00 | AAPL | Stock | 0.2723 | 0.2732 | 0.2716 | 0.2718 | 6684720.0 |
| 2002-07-31 16:30:00 | AAPL | Stock | 0.2714 | 0.2725 | 0.2702 | 0.2725 | 7224000.0 |
| 2002-07-31 17:00:00 | AAPL | Stock | 0.2725 | 0.2725 | 0.2725 | 0.2725 | 711200.0 |
| 2002-07-31 17:30:00 | AAPL | Stock | 0.268 | 0.2725 | 0.2679 | 0.2725 | 2000488.0 |
| 2002-07-31 08:00:00 | MSFT | Stock | 24.05 | 24.28 | 23.775 | 24.05 | 56754.0 |
| 2002-07-31 08:30:00 | MSFT | Stock | 24.015 | 24.035 | 23.695 | 24.02 | 212238.0 |
| 2002-07-31 09:00:00 | MSFT | Stock | 23.785 | 24.02 | 23.53 | 23.81 | 803340.0 |
| 2002-07-31 09:30:00 | MSFT | Stock | 23.805 | 23.94 | 23.7 | 23.7645 | 8805090.0 |
| 2002-07-31 10:00:00 | MSFT | Stock | 23.77 | 23.77 | 23.34 | 23.4 | 10598730.0 |
| 2002-07-31 10:30:00 | MSFT | Stock | 23.41 | 23.5 | 23.275 | 23.455 | 6128424.0 |
| 2002-07-31 11:00:00 | MSFT | Stock | 23.45 | 23.6 | 23.39 | 23.595 | 3930536.0 |
| 2002-07-31 11:30:00 | MSFT | Stock | 23.6 | 23.68 | 23.5 | 23.665 | 4321412.0 |
| 2002-07-31 12:00:00 | MSFT | Stock | 23.665 | 23.78 | 23.625 | 23.63 | 4114302.0 |
| 2002-07-31 12:30:00 | MSFT | Stock | 23.645 | 23.645 | 23.375 | 23.48 | 4935156.0 |
| 2002-07-31 13:00:00 | MSFT | Stock | 23.48 | 23.5 | 23.34 | 23.405 | 3877836.0 |
| 2002-07-31 13:30:00 | MSFT | Stock | 23.405 | 23.475 | 23.26 | 23.2955 | 3732016.0 |
| 2002-07-31 14:00:00 | MSFT | Stock | 23.295 | 23.39 | 23.18 | 23.1995 | 5685508.0 |
| 2002-07-31 14:30:00 | MSFT | Stock | 23.2085 | 23.49 | 23.1945 | 23.34 | 7231654.0 |
| 2002-07-31 15:00:00 | MSFT | Stock | 23.33 | 23.625 | 23.255 | 23.47 | 6926078.0 |
| 2002-07-31 15:30:00 | MSFT | Stock | 23.475 | 23.965 | 23.445 | 23.955 | 13166996.0 |
| 2002-07-31 16:00:00 | MSFT | Stock | 23.96 | 24.015 | 23.475 | 23.9 | 7669810.0 |
| 2002-07-31 16:30:00 | MSFT | Stock | 23.885 | 23.99 | 23.825 | 23.99 | 2369850.0 |
| 2002-07-31 17:00:00 | MSFT | Stock | 23.86 | 23.99 | 23.83 | 23.99 | 9800.0 |
| 2002-07-31 17:30:00 | MSFT | Stock | 23.85 | 23.875 | 23.825 | 23.87 | 12800.0 |
| 2002-07-31 18:00:00 | MSFT | Stock | 23.845 | 23.865 | 23.835 | 23.85 | 9400.0 |
| 2002-07-31 08:00:00 | NVDA | Stock | 0.1062 | 0.1329 | 0.1025 | 0.1048 | 87218520.0 |
| 2002-07-31 08:30:00 | NVDA | Stock | 0.1047 | 0.1084 | 0.1 | 0.1002 | 94294560.0 |
| 2002-07-31 09:00:00 | NVDA | Stock | 0.1004 | 0.1084 | 0.0982 | 0.0982 | 133019760.0 |
| 2002-07-31 09:30:00 | NVDA | Stock | 0.0985 | 0.1005 | 0.0937 | 0.0947 | 1014623520.0 |
| 2002-07-31 10:00:00 | NVDA | Stock | 0.0946 | 0.095 | 0.0912 | 0.0924 | 712792080.0 |
| 2002-07-31 10:30:00 | NVDA | Stock | 0.0924 | 0.0948 | 0.0924 | 0.0939 | 277276800.0 |
| 2002-07-31 11:00:00 | NVDA | Stock | 0.0938 | 0.0947 | 0.0925 | 0.0933 | 220890240.0 |
| 2002-07-31 11:30:00 | NVDA | Stock | 0.0933 | 0.0939 | 0.0926 | 0.093 | 151388040.0 |
| 2002-07-31 12:00:00 | NVDA | Stock | 0.0931 | 0.0943 | 0.0927 | 0.0937 | 170188320.0 |
| 2002-07-31 12:30:00 | NVDA | Stock | 0.0937 | 0.0954 | 0.0936 | 0.0939 | 253434120.0 |
> showing 50 of 31,753 rows — these rows as CSV