PREVIEW / stock_30min / 2005-01-27
file: by_date/stock_30min/2005/2005-01-27.parquet size: 793 KB rows: 42,452 symbols: 1,908
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-27 08:00:00 | AAPL | Stock | 1.29 | 1.29 | 1.2875 | 1.2884 | 1019312.0 |
| 2005-01-27 08:30:00 | AAPL | Stock | 1.2886 | 1.2886 | 1.2861 | 1.2875 | 122080.0 |
| 2005-01-27 09:00:00 | AAPL | Stock | 1.2886 | 1.2918 | 1.2875 | 1.2882 | 482552.0 |
| 2005-01-27 09:30:00 | AAPL | Stock | 1.2886 | 1.2929 | 1.2777 | 1.2863 | 64602216.0 |
| 2005-01-27 10:00:00 | AAPL | Stock | 1.2866 | 1.2914 | 1.2821 | 1.283 | 49511392.0 |
| 2005-01-27 10:30:00 | AAPL | Stock | 1.2829 | 1.2902 | 1.2813 | 1.2888 | 46441360.0 |
| 2005-01-27 11:00:00 | AAPL | Stock | 1.2889 | 1.2923 | 1.2871 | 1.2891 | 39174016.0 |
| 2005-01-27 11:30:00 | AAPL | Stock | 1.2893 | 1.3021 | 1.2884 | 1.2979 | 59708936.0 |
| 2005-01-27 12:00:00 | AAPL | Stock | 1.2979 | 1.3018 | 1.2932 | 1.2936 | 28803432.0 |
| 2005-01-27 12:30:00 | AAPL | Stock | 1.2938 | 1.2955 | 1.2918 | 1.2936 | 21964824.0 |
| 2005-01-27 13:00:00 | AAPL | Stock | 1.2936 | 1.2945 | 1.29 | 1.2911 | 29505504.0 |
| 2005-01-27 13:30:00 | AAPL | Stock | 1.2911 | 1.2927 | 1.2884 | 1.2891 | 31112368.0 |
| 2005-01-27 14:00:00 | AAPL | Stock | 1.2891 | 1.2911 | 1.2875 | 1.2902 | 16659048.0 |
| 2005-01-27 14:30:00 | AAPL | Stock | 1.2902 | 1.2923 | 1.2886 | 1.2895 | 16459072.0 |
| 2005-01-27 15:00:00 | AAPL | Stock | 1.2893 | 1.2948 | 1.2873 | 1.2943 | 32501392.0 |
| 2005-01-27 15:30:00 | AAPL | Stock | 1.2946 | 1.2971 | 1.2927 | 1.2963 | 42781704.0 |
| 2005-01-27 16:00:00 | AAPL | Stock | 1.2966 | 1.2982 | 1.2929 | 1.2961 | 5258568.0 |
| 2005-01-27 16:30:00 | AAPL | Stock | 1.2964 | 1.2982 | 1.2946 | 1.2972 | 1397704.0 |
| 2005-01-27 17:00:00 | AAPL | Stock | 1.2973 | 1.2973 | 1.2973 | 1.2973 | 106400.0 |
| 2005-01-27 17:30:00 | AAPL | Stock | 1.2955 | 1.2973 | 1.2955 | 1.2973 | 201600.0 |
| 2005-01-27 18:00:00 | AAPL | Stock | 1.2973 | 1.2973 | 1.2948 | 1.2955 | 166320.0 |
| 2005-01-27 08:00:00 | MSFT | Stock | 26.07 | 26.08 | 25.9 | 26.0 | 3019911.0 |
| 2005-01-27 08:30:00 | MSFT | Stock | 25.97 | 26.0 | 25.97 | 26.0 | 42050.0 |
| 2005-01-27 09:00:00 | MSFT | Stock | 26.0 | 26.05 | 25.95 | 25.96 | 250887.0 |
| 2005-01-27 09:30:00 | MSFT | Stock | 25.95 | 25.97 | 25.85 | 25.942 | 8552885.0 |
| 2005-01-27 10:00:00 | MSFT | Stock | 25.95 | 25.96 | 25.89 | 25.93 | 6046739.0 |
| 2005-01-27 10:30:00 | MSFT | Stock | 25.93 | 26.03 | 25.91 | 26.0 | 4852412.0 |
| 2005-01-27 11:00:00 | MSFT | Stock | 25.99 | 26.02 | 25.93 | 25.962 | 3596917.0 |
| 2005-01-27 11:30:00 | MSFT | Stock | 25.96 | 26.03 | 25.96 | 26.0 | 3079332.0 |
| 2005-01-27 12:00:00 | MSFT | Stock | 26.0 | 26.01 | 25.95 | 25.99 | 3213991.0 |
| 2005-01-27 12:30:00 | MSFT | Stock | 25.99 | 26.02 | 25.96 | 26.0 | 3196924.0 |
| 2005-01-27 13:00:00 | MSFT | Stock | 26.0 | 26.02 | 25.94 | 25.94 | 3820449.0 |
| 2005-01-27 13:30:00 | MSFT | Stock | 25.94 | 25.95 | 25.87 | 25.911 | 4604035.0 |
| 2005-01-27 14:00:00 | MSFT | Stock | 25.91 | 25.93 | 25.86 | 25.88 | 5334129.0 |
| 2005-01-27 14:30:00 | MSFT | Stock | 25.88 | 25.91 | 25.86 | 25.88 | 4139824.0 |
| 2005-01-27 15:00:00 | MSFT | Stock | 25.88 | 26.045 | 25.86 | 26.02 | 7241645.0 |
| 2005-01-27 15:30:00 | MSFT | Stock | 26.02 | 26.16 | 26.0 | 26.1 | 14361107.0 |
| 2005-01-27 16:00:00 | MSFT | Stock | 26.11 | 26.5 | 25.45 | 26.11 | 12460306.0 |
| 2005-01-27 16:30:00 | MSFT | Stock | 26.11 | 26.6 | 26.07 | 26.43 | 3211445.0 |
| 2005-01-27 17:00:00 | MSFT | Stock | 26.43 | 26.55 | 26.198 | 26.54 | 784632.0 |
| 2005-01-27 17:30:00 | MSFT | Stock | 26.53 | 26.61 | 25.969 | 26.58 | 424638.0 |
| 2005-01-27 18:00:00 | MSFT | Stock | 26.58 | 26.58 | 26.52 | 26.57 | 170811.0 |
| 2005-01-27 09:00:00 | NVDA | Stock | 0.1769 | 0.1771 | 0.1762 | 0.1762 | 298200.0 |
| 2005-01-27 09:30:00 | NVDA | Stock | 0.1771 | 0.1804 | 0.176 | 0.18 | 81814080.0 |
| 2005-01-27 10:00:00 | NVDA | Stock | 0.18 | 0.185 | 0.1799 | 0.1837 | 198552960.0 |
| 2005-01-27 10:30:00 | NVDA | Stock | 0.1837 | 0.1875 | 0.1831 | 0.1866 | 115131480.0 |
| 2005-01-27 11:00:00 | NVDA | Stock | 0.1866 | 0.1875 | 0.1854 | 0.1858 | 54429240.0 |
| 2005-01-27 11:30:00 | NVDA | Stock | 0.1858 | 0.187 | 0.1857 | 0.1867 | 21450120.0 |
| 2005-01-27 12:00:00 | NVDA | Stock | 0.1866 | 0.187 | 0.185 | 0.185 | 29311560.0 |
| 2005-01-27 12:30:00 | NVDA | Stock | 0.1852 | 0.1867 | 0.1846 | 0.1865 | 29287200.0 |
> showing 50 of 42,452 rows — these rows as CSV