PREVIEW / stock_30min / 2006-12-27
file: by_date/stock_30min/2006/2006-12-27.parquet size: 953 KB rows: 52,081 symbols: 2,493
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-12-27 06:00:00 | AAPL | Stock | 2.9061 | 2.9107 | 2.8929 | 2.8939 | 103600.0 |
| 2006-12-27 06:30:00 | AAPL | Stock | 2.8914 | 2.8929 | 2.8907 | 2.8929 | 16800.0 |
| 2006-12-27 07:00:00 | AAPL | Stock | 2.9071 | 2.9071 | 2.8786 | 2.8786 | 382480.0 |
| 2006-12-27 07:30:00 | AAPL | Stock | 2.875 | 2.8754 | 2.8571 | 2.8696 | 1253560.0 |
| 2006-12-27 08:00:00 | AAPL | Stock | 2.8711 | 2.8796 | 2.8036 | 2.8043 | 20699532.0 |
| 2006-12-27 08:30:00 | AAPL | Stock | 2.805 | 2.8118 | 2.7807 | 2.7996 | 36196860.0 |
| 2006-12-27 09:00:00 | AAPL | Stock | 2.7979 | 2.8032 | 2.7739 | 2.7907 | 40321064.0 |
| 2006-12-27 09:30:00 | AAPL | Stock | 2.7911 | 2.8068 | 2.7418 | 2.7836 | 452927776.0 |
| 2006-12-27 10:00:00 | AAPL | Stock | 2.7832 | 2.7943 | 2.7736 | 2.7879 | 161326424.0 |
| 2006-12-27 10:30:00 | AAPL | Stock | 2.7875 | 2.7972 | 2.7768 | 2.7921 | 111511064.0 |
| 2006-12-27 11:00:00 | AAPL | Stock | 2.7929 | 2.8204 | 2.7918 | 2.8186 | 139558944.0 |
| 2006-12-27 11:30:00 | AAPL | Stock | 2.8186 | 2.8557 | 2.8143 | 2.8539 | 187169164.0 |
| 2006-12-27 12:00:00 | AAPL | Stock | 2.8543 | 2.8732 | 2.8471 | 2.8679 | 113661352.0 |
| 2006-12-27 12:30:00 | AAPL | Stock | 2.8679 | 2.9107 | 2.8589 | 2.8836 | 146837208.0 |
| 2006-12-27 13:00:00 | AAPL | Stock | 2.8836 | 2.9118 | 2.8832 | 2.91 | 74791836.0 |
| 2006-12-27 13:30:00 | AAPL | Stock | 2.91 | 2.9125 | 2.89 | 2.9029 | 70735868.0 |
| 2006-12-27 14:00:00 | AAPL | Stock | 2.9029 | 2.9068 | 2.8918 | 2.8975 | 57052604.0 |
| 2006-12-27 14:30:00 | AAPL | Stock | 2.8975 | 2.9146 | 2.8964 | 2.9107 | 66760904.0 |
| 2006-12-27 15:00:00 | AAPL | Stock | 2.91 | 2.9286 | 2.9089 | 2.9096 | 118588792.0 |
| 2006-12-27 15:30:00 | AAPL | Stock | 2.9093 | 2.9211 | 2.9018 | 2.9136 | 108256848.0 |
| 2006-12-27 16:00:00 | AAPL | Stock | 2.9136 | 2.9154 | 2.7861 | 2.915 | 4736900.0 |
| 2006-12-27 16:30:00 | AAPL | Stock | 2.9161 | 2.9179 | 2.9143 | 2.9175 | 501844.0 |
| 2006-12-27 17:00:00 | AAPL | Stock | 2.9171 | 2.9179 | 2.9146 | 2.9146 | 254996.0 |
| 2006-12-27 17:30:00 | AAPL | Stock | 2.9154 | 2.9189 | 2.9154 | 2.9189 | 504476.0 |
| 2006-12-27 18:00:00 | AAPL | Stock | 2.9196 | 2.9196 | 2.9114 | 2.9189 | 150668.0 |
| 2006-12-27 18:30:00 | AAPL | Stock | 2.9189 | 2.9204 | 2.9161 | 2.9186 | 127680.0 |
| 2006-12-27 19:00:00 | AAPL | Stock | 2.9186 | 2.9196 | 2.9171 | 2.9193 | 149520.0 |
| 2006-12-27 19:30:00 | AAPL | Stock | 2.9193 | 2.9207 | 2.8214 | 2.8232 | 4474960.0 |
| 2006-12-27 07:00:00 | MSFT | Stock | 29.81 | 29.81 | 29.81 | 29.81 | 800.0 |
| 2006-12-27 07:30:00 | MSFT | Stock | 29.85 | 30.1 | 29.85 | 30.1 | 500.0 |
| 2006-12-27 08:00:00 | MSFT | Stock | 29.95 | 29.95 | 29.92 | 29.92 | 7598.0 |
| 2006-12-27 08:30:00 | MSFT | Stock | 29.95 | 29.99 | 29.93 | 29.99 | 21506.0 |
| 2006-12-27 09:00:00 | MSFT | Stock | 29.99 | 30.01 | 29.91 | 29.99 | 114952.0 |
| 2006-12-27 09:30:00 | MSFT | Stock | 29.99 | 30.13 | 29.91 | 30.098 | 3846771.0 |
| 2006-12-27 10:00:00 | MSFT | Stock | 30.099 | 30.13 | 30.0 | 30.03 | 3437794.0 |
| 2006-12-27 10:30:00 | MSFT | Stock | 30.029 | 30.09 | 29.99 | 30.083 | 1806899.0 |
| 2006-12-27 11:00:00 | MSFT | Stock | 30.08 | 30.082 | 30.01 | 30.02 | 2008308.0 |
| 2006-12-27 11:30:00 | MSFT | Stock | 30.02 | 30.06 | 29.95 | 30.01 | 1838512.0 |
| 2006-12-27 12:00:00 | MSFT | Stock | 30.019 | 30.08 | 30.0 | 30.002 | 1733203.0 |
| 2006-12-27 12:30:00 | MSFT | Stock | 30.0 | 30.04 | 29.99 | 30.009 | 1150049.0 |
| 2006-12-27 13:00:00 | MSFT | Stock | 30.0 | 30.03 | 29.99 | 30.03 | 2090560.0 |
| 2006-12-27 13:30:00 | MSFT | Stock | 30.02 | 30.06 | 30.01 | 30.04 | 2792545.0 |
| 2006-12-27 14:00:00 | MSFT | Stock | 30.04 | 30.09 | 30.04 | 30.08 | 1342547.0 |
| 2006-12-27 14:30:00 | MSFT | Stock | 30.07 | 30.08 | 30.06 | 30.07 | 883321.0 |
| 2006-12-27 15:00:00 | MSFT | Stock | 30.079 | 30.1 | 30.06 | 30.082 | 2112156.0 |
| 2006-12-27 15:30:00 | MSFT | Stock | 30.089 | 30.09 | 30.02 | 30.03 | 3944958.0 |
| 2006-12-27 16:00:00 | MSFT | Stock | 30.02 | 30.03 | 30.0 | 30.02 | 323074.0 |
| 2006-12-27 16:30:00 | MSFT | Stock | 30.02 | 30.04 | 30.02 | 30.04 | 205200.0 |
| 2006-12-27 17:00:00 | MSFT | Stock | 30.02 | 30.02 | 30.02 | 30.02 | 32400.0 |
| 2006-12-27 18:00:00 | MSFT | Stock | 30.02 | 30.02 | 30.02 | 30.02 | 1228.0 |
> showing 50 of 52,081 rows — these rows as CSV