PREVIEW / stock_1min / 2006-01-12
file: by_date/stock_1min/2006/2006-01-12.parquet size: 7.9 MB rows: 637,449 symbols: 1,762
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-01-12 04:27:00 | AAPL | Stock | 3.0143 | 3.0143 | 3.0143 | 3.0143 | 2800.0 |
| 2006-01-12 04:34:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 5600.0 |
| 2006-01-12 05:23:00 | AAPL | Stock | 3.0268 | 3.0268 | 3.0268 | 3.0268 | 14000.0 |
| 2006-01-12 05:25:00 | AAPL | Stock | 3.0279 | 3.0286 | 3.0279 | 3.0286 | 61600.0 |
| 2006-01-12 05:42:00 | AAPL | Stock | 3.0354 | 3.0357 | 3.0354 | 3.0357 | 53900.0 |
| 2006-01-12 05:53:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 2800.0 |
| 2006-01-12 05:56:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 25200.0 |
| 2006-01-12 05:57:00 | AAPL | Stock | 3.0314 | 3.0314 | 3.0314 | 3.0314 | 5600.0 |
| 2006-01-12 05:59:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 4900.0 |
| 2006-01-12 06:20:00 | AAPL | Stock | 3.0375 | 3.0389 | 3.0375 | 3.0389 | 56000.0 |
| 2006-01-12 06:21:00 | AAPL | Stock | 3.0393 | 3.0393 | 3.0393 | 3.0393 | 5600.0 |
| 2006-01-12 06:23:00 | AAPL | Stock | 3.0429 | 3.0429 | 3.0429 | 3.0429 | 30800.0 |
| 2006-01-12 06:25:00 | AAPL | Stock | 3.0625 | 3.0625 | 3.0621 | 3.0621 | 25200.0 |
| 2006-01-12 06:32:00 | AAPL | Stock | 3.0482 | 3.0571 | 3.0482 | 3.0571 | 19600.0 |
| 2006-01-12 06:36:00 | AAPL | Stock | 3.0571 | 3.0571 | 3.0571 | 3.0571 | 2800.0 |
| 2006-01-12 06:38:00 | AAPL | Stock | 3.0525 | 3.0525 | 3.0525 | 3.0525 | 2800.0 |
| 2006-01-12 06:41:00 | AAPL | Stock | 3.0525 | 3.0525 | 3.0525 | 3.0525 | 2800.0 |
| 2006-01-12 06:48:00 | AAPL | Stock | 3.0525 | 3.0525 | 3.0521 | 3.0521 | 8400.0 |
| 2006-01-12 06:49:00 | AAPL | Stock | 3.0461 | 3.0461 | 3.0446 | 3.0446 | 36400.0 |
| 2006-01-12 06:50:00 | AAPL | Stock | 3.0461 | 3.0461 | 3.0461 | 3.0461 | 5600.0 |
| 2006-01-12 06:55:00 | AAPL | Stock | 3.0496 | 3.0496 | 3.0496 | 3.0496 | 8400.0 |
| 2006-01-12 06:57:00 | AAPL | Stock | 3.0461 | 3.0461 | 3.0446 | 3.0446 | 5600.0 |
| 2006-01-12 06:58:00 | AAPL | Stock | 3.0446 | 3.0446 | 3.0446 | 3.0446 | 8400.0 |
| 2006-01-12 07:00:00 | AAPL | Stock | 3.0379 | 3.0379 | 3.0357 | 3.0357 | 212800.0 |
| 2006-01-12 07:01:00 | AAPL | Stock | 3.0357 | 3.0429 | 3.0357 | 3.0361 | 131600.0 |
| 2006-01-12 07:03:00 | AAPL | Stock | 3.0421 | 3.0429 | 3.0421 | 3.0429 | 30800.0 |
| 2006-01-12 07:04:00 | AAPL | Stock | 3.0443 | 3.0446 | 3.0421 | 3.0421 | 72800.0 |
| 2006-01-12 07:10:00 | AAPL | Stock | 3.0425 | 3.0425 | 3.0421 | 3.0421 | 30800.0 |
| 2006-01-12 07:11:00 | AAPL | Stock | 3.0421 | 3.0421 | 3.0375 | 3.0375 | 58800.0 |
| 2006-01-12 07:12:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0314 | 3.0314 | 84000.0 |
| 2006-01-12 07:13:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 5600.0 |
| 2006-01-12 07:18:00 | AAPL | Stock | 3.0321 | 3.0357 | 3.0321 | 3.0357 | 154000.0 |
| 2006-01-12 07:19:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 20216.0 |
| 2006-01-12 07:21:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 2800.0 |
| 2006-01-12 07:25:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0339 | 3.0339 | 2800.0 |
| 2006-01-12 07:26:00 | AAPL | Stock | 3.0339 | 3.0357 | 3.0339 | 3.0357 | 53200.0 |
| 2006-01-12 07:29:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 5600.0 |
| 2006-01-12 07:37:00 | AAPL | Stock | 3.03 | 3.03 | 3.03 | 3.03 | 2800.0 |
| 2006-01-12 07:39:00 | AAPL | Stock | 3.03 | 3.03 | 3.0289 | 3.0289 | 29876.0 |
| 2006-01-12 07:40:00 | AAPL | Stock | 3.0289 | 3.0289 | 3.0289 | 3.0289 | 2800.0 |
| 2006-01-12 07:41:00 | AAPL | Stock | 3.0289 | 3.0289 | 3.0289 | 3.0289 | 22400.0 |
| 2006-01-12 07:43:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 38584.0 |
| 2006-01-12 07:44:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 2800.0 |
| 2006-01-12 07:45:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 14616.0 |
| 2006-01-12 07:46:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0232 | 3.0232 | 56000.0 |
| 2006-01-12 07:47:00 | AAPL | Stock | 3.0286 | 3.0286 | 3.0286 | 3.0286 | 2800.0 |
| 2006-01-12 07:50:00 | AAPL | Stock | 3.025 | 3.025 | 3.025 | 3.025 | 11200.0 |
| 2006-01-12 07:51:00 | AAPL | Stock | 3.0289 | 3.0289 | 3.0289 | 3.0289 | 2800.0 |
| 2006-01-12 07:52:00 | AAPL | Stock | 3.0296 | 3.0304 | 3.0296 | 3.0304 | 13160.0 |
| 2006-01-12 07:54:00 | AAPL | Stock | 3.0325 | 3.0332 | 3.0325 | 3.0329 | 16800.0 |
> showing 50 of 637,449 rows — these rows as CSV