PREVIEW / stock_1min / 2006-12-19
file: by_date/stock_1min/2006/2006-12-19.parquet size: 9.2 MB rows: 746,456 symbols: 2,026
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-19 07:35:00 | AAPL | Stock | 3.035 | 3.035 | 3.035 | 3.035 | 2800.0 |
| 2006-12-19 07:36:00 | AAPL | Stock | 3.035 | 3.035 | 3.035 | 3.035 | 28000.0 |
| 2006-12-19 07:38:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 11200.0 |
| 2006-12-19 07:40:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0446 | 3.0446 | 28000.0 |
| 2006-12-19 07:45:00 | AAPL | Stock | 3.0368 | 3.0368 | 3.0364 | 3.0364 | 42000.0 |
| 2006-12-19 07:56:00 | AAPL | Stock | 3.0379 | 3.0379 | 3.0379 | 3.0379 | 8400.0 |
| 2006-12-19 08:00:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0325 | 3.0325 | 54460.0 |
| 2006-12-19 08:01:00 | AAPL | Stock | 3.0354 | 3.0354 | 3.0354 | 3.0354 | 5516.0 |
| 2006-12-19 08:02:00 | AAPL | Stock | 3.0354 | 3.0354 | 3.0304 | 3.0339 | 223160.0 |
| 2006-12-19 08:03:00 | AAPL | Stock | 3.0354 | 3.0357 | 3.0321 | 3.0354 | 335776.0 |
| 2006-12-19 08:04:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0325 | 3.0325 | 223580.0 |
| 2006-12-19 08:05:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 140000.0 |
| 2006-12-19 08:06:00 | AAPL | Stock | 3.0325 | 3.0339 | 3.0325 | 3.0325 | 105000.0 |
| 2006-12-19 08:07:00 | AAPL | Stock | 3.0314 | 3.0314 | 3.0314 | 3.0314 | 2800.0 |
| 2006-12-19 08:08:00 | AAPL | Stock | 3.0304 | 3.0314 | 3.0304 | 3.0304 | 51660.0 |
| 2006-12-19 08:09:00 | AAPL | Stock | 3.0304 | 3.0321 | 3.0268 | 3.03 | 171640.0 |
| 2006-12-19 08:10:00 | AAPL | Stock | 3.0268 | 3.0304 | 3.0268 | 3.0304 | 95340.0 |
| 2006-12-19 08:11:00 | AAPL | Stock | 3.0321 | 3.0336 | 3.03 | 3.03 | 26600.0 |
| 2006-12-19 08:12:00 | AAPL | Stock | 3.0332 | 3.0332 | 3.0332 | 3.0332 | 14000.0 |
| 2006-12-19 08:13:00 | AAPL | Stock | 3.0311 | 3.0332 | 3.0311 | 3.0311 | 12600.0 |
| 2006-12-19 08:16:00 | AAPL | Stock | 3.0321 | 3.0329 | 3.0307 | 3.0307 | 44800.0 |
| 2006-12-19 08:17:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0289 | 3.0289 | 72800.0 |
| 2006-12-19 08:18:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 2800.0 |
| 2006-12-19 08:19:00 | AAPL | Stock | 3.0275 | 3.0286 | 3.0275 | 3.0286 | 65800.0 |
| 2006-12-19 08:20:00 | AAPL | Stock | 3.0286 | 3.0329 | 3.0286 | 3.0329 | 28000.0 |
| 2006-12-19 08:21:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0304 | 3.0304 | 14000.0 |
| 2006-12-19 08:22:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0289 | 3.0304 | 65800.0 |
| 2006-12-19 08:23:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0304 | 3.0304 | 72800.0 |
| 2006-12-19 08:24:00 | AAPL | Stock | 3.0304 | 3.0321 | 3.0304 | 3.0321 | 26600.0 |
| 2006-12-19 08:25:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 14980.0 |
| 2006-12-19 08:26:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 70000.0 |
| 2006-12-19 08:27:00 | AAPL | Stock | 3.0329 | 3.0336 | 3.0329 | 3.0336 | 54600.0 |
| 2006-12-19 08:28:00 | AAPL | Stock | 3.035 | 3.0357 | 3.0339 | 3.0357 | 168280.0 |
| 2006-12-19 08:29:00 | AAPL | Stock | 3.0357 | 3.0364 | 3.0357 | 3.0357 | 53200.0 |
| 2006-12-19 08:30:00 | AAPL | Stock | 3.0329 | 3.0329 | 3.0304 | 3.0304 | 131600.0 |
| 2006-12-19 08:31:00 | AAPL | Stock | 3.0321 | 3.0325 | 3.0286 | 3.0325 | 96936.0 |
| 2006-12-19 08:32:00 | AAPL | Stock | 3.0311 | 3.0321 | 3.0307 | 3.0321 | 47600.0 |
| 2006-12-19 08:33:00 | AAPL | Stock | 3.0314 | 3.0314 | 3.03 | 3.03 | 18900.0 |
| 2006-12-19 08:34:00 | AAPL | Stock | 3.0311 | 3.0321 | 3.0311 | 3.0321 | 126000.0 |
| 2006-12-19 08:35:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0261 | 3.0261 | 150864.0 |
| 2006-12-19 08:36:00 | AAPL | Stock | 3.0268 | 3.0271 | 3.0261 | 3.0261 | 63700.0 |
| 2006-12-19 08:37:00 | AAPL | Stock | 3.0271 | 3.0271 | 3.0254 | 3.0271 | 49616.0 |
| 2006-12-19 08:38:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0243 | 3.0243 | 21000.0 |
| 2006-12-19 08:39:00 | AAPL | Stock | 3.0239 | 3.0239 | 3.0214 | 3.0214 | 135100.0 |
| 2006-12-19 08:40:00 | AAPL | Stock | 3.0214 | 3.0232 | 3.0211 | 3.0211 | 212800.0 |
| 2006-12-19 08:41:00 | AAPL | Stock | 3.0214 | 3.0214 | 3.0186 | 3.0214 | 122920.0 |
| 2006-12-19 08:42:00 | AAPL | Stock | 3.0204 | 3.0211 | 3.0196 | 3.0196 | 24976.0 |
| 2006-12-19 08:43:00 | AAPL | Stock | 3.0196 | 3.0236 | 3.0193 | 3.0193 | 140700.0 |
| 2006-12-19 08:44:00 | AAPL | Stock | 3.0204 | 3.0207 | 3.0196 | 3.02 | 37100.0 |
| 2006-12-19 08:45:00 | AAPL | Stock | 3.0211 | 3.0211 | 3.0182 | 3.0182 | 230664.0 |
> showing 50 of 746,456 rows — these rows as CSV