PREVIEW / stock_1min / 2007-12-13
file: by_date/stock_1min/2007/2007-12-13.parquet size: 12.2 MB rows: 991,574 symbols: 2,630
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-13 05:07:00 | AAPL | Stock | 6.7746 | 6.7746 | 6.7746 | 6.7746 | 2800.0 |
| 2007-12-13 05:29:00 | AAPL | Stock | 6.7561 | 6.7561 | 6.75 | 6.75 | 6160.0 |
| 2007-12-13 07:14:00 | AAPL | Stock | 6.7589 | 6.7589 | 6.7589 | 6.7589 | 5600.0 |
| 2007-12-13 07:16:00 | AAPL | Stock | 6.7557 | 6.7557 | 6.7557 | 6.7557 | 2800.0 |
| 2007-12-13 07:18:00 | AAPL | Stock | 6.7511 | 6.7511 | 6.75 | 6.7507 | 13440.0 |
| 2007-12-13 07:22:00 | AAPL | Stock | 6.7364 | 6.7364 | 6.7364 | 6.7364 | 19600.0 |
| 2007-12-13 07:23:00 | AAPL | Stock | 6.7179 | 6.7179 | 6.7179 | 6.7179 | 2800.0 |
| 2007-12-13 07:26:00 | AAPL | Stock | 6.7214 | 6.7214 | 6.7214 | 6.7214 | 2800.0 |
| 2007-12-13 07:27:00 | AAPL | Stock | 6.7286 | 6.7286 | 6.7286 | 6.7286 | 19600.0 |
| 2007-12-13 07:29:00 | AAPL | Stock | 6.7293 | 6.7293 | 6.7286 | 6.7286 | 5600.0 |
| 2007-12-13 07:31:00 | AAPL | Stock | 6.7286 | 6.7286 | 6.7286 | 6.7286 | 2800.0 |
| 2007-12-13 07:32:00 | AAPL | Stock | 6.7286 | 6.7286 | 6.7286 | 6.7286 | 7560.0 |
| 2007-12-13 07:35:00 | AAPL | Stock | 6.7286 | 6.7296 | 6.7232 | 6.725 | 33320.0 |
| 2007-12-13 07:36:00 | AAPL | Stock | 6.7321 | 6.7321 | 6.7321 | 6.7321 | 2800.0 |
| 2007-12-13 07:38:00 | AAPL | Stock | 6.7321 | 6.7321 | 6.7321 | 6.7321 | 14280.0 |
| 2007-12-13 07:39:00 | AAPL | Stock | 6.7321 | 6.7464 | 6.7321 | 6.7464 | 20020.0 |
| 2007-12-13 07:40:00 | AAPL | Stock | 6.7357 | 6.7357 | 6.7357 | 6.7357 | 11200.0 |
| 2007-12-13 07:41:00 | AAPL | Stock | 6.7357 | 6.7357 | 6.7357 | 6.7357 | 25200.0 |
| 2007-12-13 07:43:00 | AAPL | Stock | 6.7357 | 6.7361 | 6.7357 | 6.7361 | 50400.0 |
| 2007-12-13 07:45:00 | AAPL | Stock | 6.7332 | 6.7332 | 6.7332 | 6.7332 | 2800.0 |
| 2007-12-13 07:46:00 | AAPL | Stock | 6.7743 | 6.7743 | 6.7743 | 6.7743 | 25200.0 |
| 2007-12-13 07:51:00 | AAPL | Stock | 6.7321 | 6.7321 | 6.7321 | 6.7321 | 25200.0 |
| 2007-12-13 07:56:00 | AAPL | Stock | 6.7464 | 6.7464 | 6.7464 | 6.7464 | 14000.0 |
| 2007-12-13 07:58:00 | AAPL | Stock | 6.7429 | 6.7429 | 6.7429 | 6.7429 | 14000.0 |
| 2007-12-13 07:59:00 | AAPL | Stock | 6.75 | 6.75 | 6.7464 | 6.75 | 30800.0 |
| 2007-12-13 08:00:00 | AAPL | Stock | 6.75 | 6.7661 | 6.7304 | 6.7475 | 541856.0 |
| 2007-12-13 08:01:00 | AAPL | Stock | 6.7475 | 6.75 | 6.7421 | 6.75 | 98000.0 |
| 2007-12-13 08:02:00 | AAPL | Stock | 6.75 | 6.7536 | 6.75 | 6.75 | 24080.0 |
| 2007-12-13 08:03:00 | AAPL | Stock | 6.7536 | 6.7589 | 6.7536 | 6.7561 | 25480.0 |
| 2007-12-13 08:04:00 | AAPL | Stock | 6.7554 | 6.7625 | 6.7554 | 6.7621 | 84700.0 |
| 2007-12-13 08:05:00 | AAPL | Stock | 6.7625 | 6.7625 | 6.75 | 6.75 | 157640.0 |
| 2007-12-13 08:06:00 | AAPL | Stock | 6.75 | 6.75 | 6.745 | 6.745 | 58800.0 |
| 2007-12-13 08:07:00 | AAPL | Stock | 6.75 | 6.75 | 6.745 | 6.75 | 62020.0 |
| 2007-12-13 08:08:00 | AAPL | Stock | 6.7504 | 6.7536 | 6.75 | 6.75 | 67984.0 |
| 2007-12-13 08:09:00 | AAPL | Stock | 6.7482 | 6.7536 | 6.7482 | 6.7536 | 39200.0 |
| 2007-12-13 08:10:00 | AAPL | Stock | 6.7579 | 6.7579 | 6.7536 | 6.7571 | 50400.0 |
| 2007-12-13 08:11:00 | AAPL | Stock | 6.7571 | 6.7571 | 6.7511 | 6.7518 | 34076.0 |
| 2007-12-13 08:12:00 | AAPL | Stock | 6.7564 | 6.7564 | 6.7564 | 6.7564 | 27104.0 |
| 2007-12-13 08:13:00 | AAPL | Stock | 6.7568 | 6.7579 | 6.7539 | 6.7539 | 41020.0 |
| 2007-12-13 08:14:00 | AAPL | Stock | 6.7539 | 6.7571 | 6.7539 | 6.7539 | 78008.0 |
| 2007-12-13 08:15:00 | AAPL | Stock | 6.7539 | 6.7539 | 6.7486 | 6.7493 | 184044.0 |
| 2007-12-13 08:16:00 | AAPL | Stock | 6.7482 | 6.7529 | 6.7482 | 6.75 | 91728.0 |
| 2007-12-13 08:17:00 | AAPL | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 21000.0 |
| 2007-12-13 08:18:00 | AAPL | Stock | 6.75 | 6.7529 | 6.75 | 6.7529 | 86352.0 |
| 2007-12-13 08:19:00 | AAPL | Stock | 6.7529 | 6.7529 | 6.7504 | 6.7504 | 30800.0 |
| 2007-12-13 08:20:00 | AAPL | Stock | 6.7507 | 6.7579 | 6.75 | 6.7579 | 90132.0 |
| 2007-12-13 08:21:00 | AAPL | Stock | 6.7586 | 6.7589 | 6.7554 | 6.7554 | 14000.0 |
| 2007-12-13 08:22:00 | AAPL | Stock | 6.7529 | 6.7589 | 6.7518 | 6.7571 | 81200.0 |
| 2007-12-13 08:23:00 | AAPL | Stock | 6.7536 | 6.7589 | 6.7536 | 6.7589 | 28000.0 |
| 2007-12-13 08:24:00 | AAPL | Stock | 6.7571 | 6.7571 | 6.7536 | 6.7536 | 11200.0 |
> showing 50 of 991,574 rows — these rows as CSV