PREVIEW / stock_1min / 2006-12-29
file: by_date/stock_1min/2006/2006-12-29.parquet size: 8.6 MB rows: 699,941 symbols: 2,035
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-29 06:11:00 | AAPL | Stock | 2.8925 | 2.9 | 2.8925 | 2.8996 | 53200.0 |
| 2006-12-29 06:21:00 | AAPL | Stock | 2.9093 | 2.9107 | 2.9093 | 2.9107 | 16800.0 |
| 2006-12-29 06:23:00 | AAPL | Stock | 2.8968 | 2.8968 | 2.8968 | 2.8968 | 11200.0 |
| 2006-12-29 06:24:00 | AAPL | Stock | 2.9189 | 2.9189 | 2.9189 | 2.9189 | 2800.0 |
| 2006-12-29 06:26:00 | AAPL | Stock | 2.9179 | 2.9214 | 2.9179 | 2.9214 | 28000.0 |
| 2006-12-29 06:27:00 | AAPL | Stock | 2.9214 | 2.9214 | 2.9193 | 2.9193 | 22400.0 |
| 2006-12-29 06:28:00 | AAPL | Stock | 2.9257 | 2.9307 | 2.9257 | 2.9307 | 25200.0 |
| 2006-12-29 06:29:00 | AAPL | Stock | 2.9307 | 2.9307 | 2.9307 | 2.9307 | 11200.0 |
| 2006-12-29 06:30:00 | AAPL | Stock | 2.9425 | 2.9425 | 2.9425 | 2.9425 | 14000.0 |
| 2006-12-29 06:32:00 | AAPL | Stock | 2.9639 | 2.9643 | 2.9639 | 2.9639 | 27636.0 |
| 2006-12-29 06:33:00 | AAPL | Stock | 2.9114 | 2.9114 | 2.9114 | 2.9114 | 2800.0 |
| 2006-12-29 06:44:00 | AAPL | Stock | 2.95 | 2.95 | 2.95 | 2.95 | 2800.0 |
| 2006-12-29 06:47:00 | AAPL | Stock | 2.9514 | 2.9514 | 2.9514 | 2.9514 | 8764.0 |
| 2006-12-29 06:51:00 | AAPL | Stock | 2.9704 | 2.9711 | 2.9704 | 2.9711 | 11200.0 |
| 2006-12-29 06:52:00 | AAPL | Stock | 2.9704 | 2.9704 | 2.9704 | 2.9704 | 2800.0 |
| 2006-12-29 06:53:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9679 | 2.9679 | 11200.0 |
| 2006-12-29 06:57:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9714 | 2.9714 | 10808.0 |
| 2006-12-29 07:00:00 | AAPL | Stock | 2.9714 | 2.9714 | 2.9714 | 2.9714 | 3192.0 |
| 2006-12-29 07:02:00 | AAPL | Stock | 2.9814 | 2.9861 | 2.9814 | 2.9861 | 8400.0 |
| 2006-12-29 07:04:00 | AAPL | Stock | 2.9893 | 2.9921 | 2.9821 | 2.9821 | 108836.0 |
| 2006-12-29 07:05:00 | AAPL | Stock | 2.9857 | 2.9857 | 2.9857 | 2.9857 | 235844.0 |
| 2006-12-29 07:06:00 | AAPL | Stock | 2.9893 | 2.9936 | 2.9893 | 2.9936 | 16800.0 |
| 2006-12-29 07:07:00 | AAPL | Stock | 2.9875 | 2.9875 | 2.9875 | 2.9875 | 2800.0 |
| 2006-12-29 07:08:00 | AAPL | Stock | 2.9875 | 2.9875 | 2.9875 | 2.9875 | 9800.0 |
| 2006-12-29 07:10:00 | AAPL | Stock | 2.9821 | 2.9821 | 2.9821 | 2.9821 | 14700.0 |
| 2006-12-29 07:11:00 | AAPL | Stock | 2.9821 | 2.9821 | 2.9668 | 2.9668 | 293300.0 |
| 2006-12-29 07:12:00 | AAPL | Stock | 2.9661 | 2.9661 | 2.9661 | 2.9661 | 2800.0 |
| 2006-12-29 07:13:00 | AAPL | Stock | 2.9679 | 2.9682 | 2.9679 | 2.9682 | 11200.0 |
| 2006-12-29 07:14:00 | AAPL | Stock | 2.975 | 2.975 | 2.975 | 2.975 | 2800.0 |
| 2006-12-29 07:15:00 | AAPL | Stock | 2.9782 | 2.9782 | 2.9782 | 2.9782 | 5600.0 |
| 2006-12-29 07:16:00 | AAPL | Stock | 2.9786 | 2.9786 | 2.9782 | 2.9782 | 145600.0 |
| 2006-12-29 07:17:00 | AAPL | Stock | 2.9814 | 2.9857 | 2.9814 | 2.9821 | 213500.0 |
| 2006-12-29 07:18:00 | AAPL | Stock | 2.9825 | 2.9825 | 2.9825 | 2.9825 | 5600.0 |
| 2006-12-29 07:19:00 | AAPL | Stock | 2.9825 | 2.9825 | 2.9825 | 2.9825 | 8400.0 |
| 2006-12-29 07:20:00 | AAPL | Stock | 2.9825 | 2.9825 | 2.9821 | 2.9821 | 68600.0 |
| 2006-12-29 07:21:00 | AAPL | Stock | 2.9825 | 2.9829 | 2.9825 | 2.9825 | 11200.0 |
| 2006-12-29 07:22:00 | AAPL | Stock | 2.9825 | 2.9825 | 2.9825 | 2.9825 | 11200.0 |
| 2006-12-29 07:23:00 | AAPL | Stock | 2.9825 | 2.9857 | 2.9825 | 2.9846 | 88200.0 |
| 2006-12-29 07:24:00 | AAPL | Stock | 2.9857 | 2.9857 | 2.9825 | 2.9825 | 239680.0 |
| 2006-12-29 07:25:00 | AAPL | Stock | 2.9832 | 2.9832 | 2.9832 | 2.9832 | 2800.0 |
| 2006-12-29 07:27:00 | AAPL | Stock | 2.9829 | 2.9854 | 2.9829 | 2.9854 | 22372.0 |
| 2006-12-29 07:28:00 | AAPL | Stock | 2.9829 | 2.9829 | 2.9829 | 2.9829 | 27972.0 |
| 2006-12-29 07:29:00 | AAPL | Stock | 2.9857 | 2.9857 | 2.9857 | 2.9857 | 113120.0 |
| 2006-12-29 07:30:00 | AAPL | Stock | 2.9875 | 2.9982 | 2.9875 | 2.9914 | 778400.0 |
| 2006-12-29 07:31:00 | AAPL | Stock | 2.9914 | 3.0086 | 2.9914 | 3.0086 | 231700.0 |
| 2006-12-29 07:32:00 | AAPL | Stock | 3.0086 | 3.0196 | 3.0082 | 3.0196 | 583380.0 |
| 2006-12-29 07:33:00 | AAPL | Stock | 3.0214 | 3.0286 | 3.0196 | 3.0286 | 371000.0 |
| 2006-12-29 07:34:00 | AAPL | Stock | 3.0286 | 3.0321 | 3.025 | 3.025 | 507108.0 |
| 2006-12-29 07:35:00 | AAPL | Stock | 3.025 | 3.025 | 3.0143 | 3.0179 | 235200.0 |
| 2006-12-29 07:36:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0118 | 3.0154 | 153524.0 |
> showing 50 of 699,941 rows — these rows as CSV