PREVIEW / stock_30min / 2002-08-19
file: by_date/stock_30min/2002/2002-08-19.parquet size: 597 KB rows: 30,982 symbols: 1,456
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-08-19 09:00:00 | AAPL | Stock | 0.2818 | 0.2818 | 0.2818 | 0.2818 | 61600.0 |
| 2002-08-19 09:30:00 | AAPL | Stock | 0.2816 | 0.2857 | 0.2807 | 0.2845 | 20563480.0 |
| 2002-08-19 10:00:00 | AAPL | Stock | 0.2845 | 0.2886 | 0.283 | 0.2848 | 28503328.0 |
| 2002-08-19 10:30:00 | AAPL | Stock | 0.2848 | 0.2886 | 0.2839 | 0.2868 | 14823704.0 |
| 2002-08-19 11:00:00 | AAPL | Stock | 0.2866 | 0.29 | 0.2864 | 0.29 | 15434160.0 |
| 2002-08-19 11:30:00 | AAPL | Stock | 0.29 | 0.2902 | 0.2873 | 0.2882 | 10194184.0 |
| 2002-08-19 12:00:00 | AAPL | Stock | 0.2884 | 0.2891 | 0.2877 | 0.2884 | 7129808.0 |
| 2002-08-19 12:30:00 | AAPL | Stock | 0.2884 | 0.2891 | 0.288 | 0.2886 | 8314152.0 |
| 2002-08-19 13:00:00 | AAPL | Stock | 0.2887 | 0.2893 | 0.2882 | 0.2884 | 11991616.0 |
| 2002-08-19 13:30:00 | AAPL | Stock | 0.2884 | 0.2902 | 0.2882 | 0.2898 | 9324280.0 |
| 2002-08-19 14:00:00 | AAPL | Stock | 0.29 | 0.29 | 0.2871 | 0.2871 | 7146496.0 |
| 2002-08-19 14:30:00 | AAPL | Stock | 0.2871 | 0.2875 | 0.2832 | 0.2848 | 19521376.0 |
| 2002-08-19 15:00:00 | AAPL | Stock | 0.2848 | 0.2864 | 0.2823 | 0.2838 | 14807912.0 |
| 2002-08-19 15:30:00 | AAPL | Stock | 0.2839 | 0.2855 | 0.2825 | 0.2855 | 30584008.0 |
| 2002-08-19 16:00:00 | AAPL | Stock | 0.2854 | 0.2855 | 0.2832 | 0.2832 | 7688800.0 |
| 2002-08-19 18:00:00 | AAPL | Stock | 0.2854 | 0.2854 | 0.2854 | 0.2854 | 22400.0 |
| 2002-08-19 08:00:00 | MSFT | Stock | 24.99 | 25.05 | 24.875 | 25.05 | 126600.0 |
| 2002-08-19 08:30:00 | MSFT | Stock | 25.05 | 25.075 | 25.0 | 25.05 | 59820.0 |
| 2002-08-19 09:00:00 | MSFT | Stock | 25.055 | 25.075 | 25.0 | 25.02 | 121264.0 |
| 2002-08-19 09:30:00 | MSFT | Stock | 25.02 | 25.315 | 24.925 | 25.235 | 8047660.0 |
| 2002-08-19 10:00:00 | MSFT | Stock | 25.24 | 25.665 | 25.225 | 25.52 | 10945728.0 |
| 2002-08-19 10:30:00 | MSFT | Stock | 25.52 | 25.64 | 25.499 | 25.595 | 6431256.0 |
| 2002-08-19 11:00:00 | MSFT | Stock | 25.595 | 25.71 | 25.57 | 25.67 | 5212206.0 |
| 2002-08-19 11:30:00 | MSFT | Stock | 25.665 | 25.8 | 25.65 | 25.7 | 4183736.0 |
| 2002-08-19 12:00:00 | MSFT | Stock | 25.7 | 25.765 | 25.655 | 25.67 | 2782678.0 |
| 2002-08-19 12:30:00 | MSFT | Stock | 25.66 | 25.715 | 25.65 | 25.7005 | 2188652.0 |
| 2002-08-19 13:00:00 | MSFT | Stock | 25.6995 | 25.895 | 25.6995 | 25.88 | 4961432.0 |
| 2002-08-19 13:30:00 | MSFT | Stock | 25.88 | 26.0 | 25.87 | 25.98 | 5372062.0 |
| 2002-08-19 14:00:00 | MSFT | Stock | 25.97 | 26.025 | 25.915 | 25.94 | 7110352.0 |
| 2002-08-19 14:30:00 | MSFT | Stock | 25.945 | 25.9555 | 25.77 | 25.866 | 7234138.0 |
| 2002-08-19 15:00:00 | MSFT | Stock | 25.865 | 25.97 | 25.8 | 25.8945 | 5043454.0 |
| 2002-08-19 15:30:00 | MSFT | Stock | 25.8945 | 26.01 | 25.88 | 25.9945 | 7098906.0 |
| 2002-08-19 16:00:00 | MSFT | Stock | 25.99 | 26.0 | 25.88 | 25.975 | 1036354.0 |
| 2002-08-19 16:30:00 | MSFT | Stock | 25.985 | 26.0 | 25.97 | 25.97 | 23804.0 |
| 2002-08-19 17:00:00 | MSFT | Stock | 25.975 | 25.99 | 25.97 | 25.98 | 6596.0 |
| 2002-08-19 17:30:00 | MSFT | Stock | 25.975 | 25.99 | 25.945 | 25.99 | 4600.0 |
| 2002-08-19 18:00:00 | MSFT | Stock | 26.0 | 26.0 | 25.961 | 26.0 | 9000.0 |
| 2002-08-19 08:00:00 | NVDA | Stock | 0.0903 | 0.0913 | 0.0887 | 0.0908 | 1514400.0 |
| 2002-08-19 08:30:00 | NVDA | Stock | 0.091 | 0.0913 | 0.0907 | 0.0913 | 420000.0 |
| 2002-08-19 09:00:00 | NVDA | Stock | 0.0912 | 0.0958 | 0.0908 | 0.093 | 5479200.0 |
| 2002-08-19 09:30:00 | NVDA | Stock | 0.0929 | 0.0997 | 0.0927 | 0.0977 | 338989440.0 |
| 2002-08-19 10:00:00 | NVDA | Stock | 0.0978 | 0.0992 | 0.0972 | 0.0976 | 178729920.0 |
| 2002-08-19 10:30:00 | NVDA | Stock | 0.0976 | 0.1007 | 0.0972 | 0.0998 | 173482920.0 |
| 2002-08-19 11:00:00 | NVDA | Stock | 0.0999 | 0.1013 | 0.0989 | 0.0995 | 116736960.0 |
| 2002-08-19 11:30:00 | NVDA | Stock | 0.0997 | 0.1007 | 0.0996 | 0.0999 | 92658840.0 |
| 2002-08-19 12:00:00 | NVDA | Stock | 0.0999 | 0.102 | 0.0999 | 0.1018 | 73735680.0 |
| 2002-08-19 12:30:00 | NVDA | Stock | 0.1018 | 0.1022 | 0.1007 | 0.1016 | 65303400.0 |
| 2002-08-19 13:00:00 | NVDA | Stock | 0.1016 | 0.1062 | 0.1014 | 0.1057 | 162345960.0 |
| 2002-08-19 13:30:00 | NVDA | Stock | 0.1058 | 0.1099 | 0.1054 | 0.1098 | 178722360.0 |
| 2002-08-19 14:00:00 | NVDA | Stock | 0.1098 | 0.1121 | 0.1071 | 0.1075 | 270017520.0 |
> showing 50 of 30,982 rows — these rows as CSV