PREVIEW / stock_30min / 2006-02-01
file: by_date/stock_30min/2006/2006-02-01.parquet size: 906 KB rows: 48,826 symbols: 2,188
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-01 07:00:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6639 | 2.6639 | 24752.0 |
| 2006-02-01 07:30:00 | AAPL | Stock | 2.6679 | 2.675 | 2.6643 | 2.6743 | 178808.0 |
| 2006-02-01 08:00:00 | AAPL | Stock | 2.675 | 2.6821 | 2.6704 | 2.6821 | 1297492.0 |
| 2006-02-01 08:30:00 | AAPL | Stock | 2.6814 | 2.6864 | 2.6782 | 2.6821 | 792428.0 |
| 2006-02-01 09:00:00 | AAPL | Stock | 2.6839 | 2.6886 | 2.6768 | 2.6768 | 1561140.0 |
| 2006-02-01 09:30:00 | AAPL | Stock | 2.6768 | 2.6961 | 2.6657 | 2.6821 | 71165136.0 |
| 2006-02-01 10:00:00 | AAPL | Stock | 2.6818 | 2.7307 | 2.6761 | 2.7171 | 79839984.0 |
| 2006-02-01 10:30:00 | AAPL | Stock | 2.7179 | 2.7271 | 2.6982 | 2.7079 | 53763248.0 |
| 2006-02-01 11:00:00 | AAPL | Stock | 2.7082 | 2.7211 | 2.6893 | 2.7039 | 45816232.0 |
| 2006-02-01 11:30:00 | AAPL | Stock | 2.7043 | 2.7118 | 2.693 | 2.7021 | 30008776.0 |
| 2006-02-01 12:00:00 | AAPL | Stock | 2.7025 | 2.7054 | 2.6964 | 2.7032 | 24064796.0 |
| 2006-02-01 12:30:00 | AAPL | Stock | 2.7029 | 2.7054 | 2.6921 | 2.6947 | 19972484.0 |
| 2006-02-01 13:00:00 | AAPL | Stock | 2.6946 | 2.6971 | 2.6814 | 2.6896 | 27065500.0 |
| 2006-02-01 13:30:00 | AAPL | Stock | 2.6893 | 2.6939 | 2.6818 | 2.6904 | 28755608.0 |
| 2006-02-01 14:00:00 | AAPL | Stock | 2.6904 | 2.7018 | 2.69 | 2.6979 | 24245172.0 |
| 2006-02-01 14:30:00 | AAPL | Stock | 2.6982 | 2.7089 | 2.695 | 2.6982 | 32886728.0 |
| 2006-02-01 15:00:00 | AAPL | Stock | 2.6986 | 2.7057 | 2.6925 | 2.6932 | 27343876.0 |
| 2006-02-01 15:30:00 | AAPL | Stock | 2.6932 | 2.7036 | 2.6875 | 2.6929 | 39529812.0 |
| 2006-02-01 16:00:00 | AAPL | Stock | 2.6943 | 2.6964 | 2.6875 | 2.69 | 982100.0 |
| 2006-02-01 16:30:00 | AAPL | Stock | 2.6889 | 2.6936 | 2.6868 | 2.6875 | 924588.0 |
| 2006-02-01 17:00:00 | AAPL | Stock | 2.6886 | 2.6893 | 2.6886 | 2.6886 | 70000.0 |
| 2006-02-01 17:30:00 | AAPL | Stock | 2.6886 | 2.6927 | 2.6879 | 2.6927 | 44436.0 |
| 2006-02-01 18:00:00 | AAPL | Stock | 2.69 | 2.6932 | 2.69 | 2.6932 | 156576.0 |
| 2006-02-01 06:00:00 | MSFT | Stock | 27.78 | 27.78 | 27.78 | 27.78 | 100.0 |
| 2006-02-01 06:30:00 | MSFT | Stock | 27.81 | 27.81 | 27.81 | 27.81 | 120.0 |
| 2006-02-01 07:30:00 | MSFT | Stock | 27.92 | 27.92 | 27.92 | 27.92 | 290.0 |
| 2006-02-01 08:00:00 | MSFT | Stock | 27.95 | 27.99 | 27.92 | 27.97 | 9455.0 |
| 2006-02-01 08:30:00 | MSFT | Stock | 27.97 | 28.15 | 27.97 | 28.05 | 93355.0 |
| 2006-02-01 09:00:00 | MSFT | Stock | 28.09 | 28.15 | 27.96 | 27.97 | 251444.0 |
| 2006-02-01 09:30:00 | MSFT | Stock | 27.96 | 28.05 | 27.9 | 28.0 | 6708395.0 |
| 2006-02-01 10:00:00 | MSFT | Stock | 28.001 | 28.07 | 27.95 | 28.02 | 4645849.0 |
| 2006-02-01 10:30:00 | MSFT | Stock | 28.02 | 28.07 | 27.95 | 27.98 | 3986709.0 |
| 2006-02-01 11:00:00 | MSFT | Stock | 27.98 | 28.0 | 27.86 | 27.89 | 6669195.0 |
| 2006-02-01 11:30:00 | MSFT | Stock | 27.89 | 27.91 | 27.82 | 27.84 | 5002056.0 |
| 2006-02-01 12:00:00 | MSFT | Stock | 27.83 | 27.91 | 27.82 | 27.91 | 3816313.0 |
| 2006-02-01 12:30:00 | MSFT | Stock | 27.91 | 27.96 | 27.87 | 27.9 | 4045304.0 |
| 2006-02-01 13:00:00 | MSFT | Stock | 27.9 | 27.93 | 27.86 | 27.872 | 5212364.0 |
| 2006-02-01 13:30:00 | MSFT | Stock | 27.87 | 27.88 | 27.819 | 27.85 | 3315398.0 |
| 2006-02-01 14:00:00 | MSFT | Stock | 27.85 | 27.9 | 27.76 | 27.76 | 3741951.0 |
| 2006-02-01 14:30:00 | MSFT | Stock | 27.77 | 27.82 | 27.76 | 27.8 | 4435149.0 |
| 2006-02-01 15:00:00 | MSFT | Stock | 27.8 | 27.95 | 27.77 | 27.92 | 6352932.0 |
| 2006-02-01 15:30:00 | MSFT | Stock | 27.91 | 28.04 | 27.91 | 28.04 | 7852784.0 |
| 2006-02-01 16:00:00 | MSFT | Stock | 28.03 | 28.05 | 27.8 | 28.04 | 319263.0 |
| 2006-02-01 16:30:00 | MSFT | Stock | 28.04 | 28.05 | 28.02 | 28.04 | 110973.0 |
| 2006-02-01 17:00:00 | MSFT | Stock | 28.04 | 28.05 | 28.04 | 28.05 | 1300.0 |
| 2006-02-01 17:30:00 | MSFT | Stock | 28.02 | 28.02 | 28.016 | 28.016 | 9705.0 |
| 2006-02-01 18:00:00 | MSFT | Stock | 28.04 | 28.04 | 28.04 | 28.04 | 1400.0 |
| 2006-02-01 07:30:00 | NVDA | Stock | 0.3684 | 0.3684 | 0.3684 | 0.3684 | 120000.0 |
| 2006-02-01 08:00:00 | NVDA | Stock | 0.3678 | 0.3687 | 0.3646 | 0.3683 | 768240.0 |
| 2006-02-01 08:30:00 | NVDA | Stock | 0.3687 | 0.3687 | 0.3683 | 0.3683 | 108960.0 |
> showing 50 of 48,826 rows — these rows as CSV