PREVIEW / stock_1min / 2010-12-02
file: by_date/stock_1min/2010/2010-12-02.parquet size: 13.3 MB rows: 993,703 symbols: 2,875
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-02 04:20:00 | AAPL | Stock | 11.3539 | 11.3539 | 11.3539 | 11.3539 | 2800.0 |
| 2010-12-02 04:39:00 | AAPL | Stock | 11.3536 | 11.3536 | 11.3536 | 11.3536 | 5600.0 |
| 2010-12-02 04:41:00 | AAPL | Stock | 11.3536 | 11.3536 | 11.3536 | 11.3536 | 2800.0 |
| 2010-12-02 04:44:00 | AAPL | Stock | 11.3539 | 11.3571 | 11.3539 | 11.3571 | 30520.0 |
| 2010-12-02 04:45:00 | AAPL | Stock | 11.3571 | 11.3571 | 11.3521 | 11.3521 | 14280.0 |
| 2010-12-02 04:51:00 | AAPL | Stock | 11.3521 | 11.3521 | 11.3521 | 11.3521 | 2800.0 |
| 2010-12-02 04:53:00 | AAPL | Stock | 11.3571 | 11.3571 | 11.3571 | 11.3571 | 2800.0 |
| 2010-12-02 04:54:00 | AAPL | Stock | 11.3471 | 11.3471 | 11.3471 | 11.3471 | 2800.0 |
| 2010-12-02 04:55:00 | AAPL | Stock | 11.3464 | 11.3464 | 11.3464 | 11.3464 | 5600.0 |
| 2010-12-02 05:00:00 | AAPL | Stock | 11.3571 | 11.3571 | 11.3571 | 11.3571 | 2800.0 |
| 2010-12-02 05:04:00 | AAPL | Stock | 11.3418 | 11.3418 | 11.3393 | 11.3393 | 5600.0 |
| 2010-12-02 05:09:00 | AAPL | Stock | 11.3214 | 11.3214 | 11.3179 | 11.3179 | 8400.0 |
| 2010-12-02 05:12:00 | AAPL | Stock | 11.3179 | 11.3179 | 11.3179 | 11.3179 | 2800.0 |
| 2010-12-02 05:20:00 | AAPL | Stock | 11.3143 | 11.3143 | 11.3143 | 11.3143 | 9100.0 |
| 2010-12-02 05:30:00 | AAPL | Stock | 11.3143 | 11.3143 | 11.3143 | 11.3143 | 7700.0 |
| 2010-12-02 06:05:00 | AAPL | Stock | 11.3261 | 11.3261 | 11.3261 | 11.3261 | 2800.0 |
| 2010-12-02 06:23:00 | AAPL | Stock | 11.3214 | 11.3214 | 11.3214 | 11.3214 | 6048.0 |
| 2010-12-02 06:25:00 | AAPL | Stock | 11.3286 | 11.3286 | 11.3286 | 11.3286 | 2800.0 |
| 2010-12-02 06:45:00 | AAPL | Stock | 11.3243 | 11.3243 | 11.3243 | 11.3243 | 2800.0 |
| 2010-12-02 06:50:00 | AAPL | Stock | 11.3271 | 11.3271 | 11.3271 | 11.3271 | 5600.0 |
| 2010-12-02 06:51:00 | AAPL | Stock | 11.3286 | 11.3286 | 11.3286 | 11.3286 | 22400.0 |
| 2010-12-02 06:56:00 | AAPL | Stock | 11.3286 | 11.3286 | 11.3286 | 11.3286 | 5600.0 |
| 2010-12-02 07:00:00 | AAPL | Stock | 11.3218 | 11.3218 | 11.3218 | 11.3218 | 2800.0 |
| 2010-12-02 07:01:00 | AAPL | Stock | 11.3271 | 11.3271 | 11.3271 | 11.3271 | 2800.0 |
| 2010-12-02 07:02:00 | AAPL | Stock | 11.3271 | 11.3271 | 11.3271 | 11.3271 | 8400.0 |
| 2010-12-02 07:03:00 | AAPL | Stock | 11.3357 | 11.3357 | 11.3357 | 11.3357 | 2800.0 |
| 2010-12-02 07:06:00 | AAPL | Stock | 11.3304 | 11.3304 | 11.3304 | 11.3304 | 8400.0 |
| 2010-12-02 07:12:00 | AAPL | Stock | 11.3393 | 11.3393 | 11.3393 | 11.3393 | 5068.0 |
| 2010-12-02 07:13:00 | AAPL | Stock | 11.3393 | 11.3393 | 11.3357 | 11.3357 | 33600.0 |
| 2010-12-02 07:19:00 | AAPL | Stock | 11.3375 | 11.3375 | 11.3375 | 11.3375 | 2800.0 |
| 2010-12-02 07:20:00 | AAPL | Stock | 11.3357 | 11.3357 | 11.3357 | 11.3357 | 7000.0 |
| 2010-12-02 07:21:00 | AAPL | Stock | 11.3389 | 11.3389 | 11.3389 | 11.3389 | 2800.0 |
| 2010-12-02 07:22:00 | AAPL | Stock | 11.3307 | 11.3357 | 11.3307 | 11.3357 | 7000.0 |
| 2010-12-02 07:24:00 | AAPL | Stock | 11.3286 | 11.3286 | 11.3286 | 11.3286 | 2800.0 |
| 2010-12-02 07:25:00 | AAPL | Stock | 11.3286 | 11.3286 | 11.3286 | 11.3286 | 2800.0 |
| 2010-12-02 07:26:00 | AAPL | Stock | 11.3286 | 11.3286 | 11.3271 | 11.3271 | 5600.0 |
| 2010-12-02 07:27:00 | AAPL | Stock | 11.3311 | 11.3389 | 11.3311 | 11.3389 | 41160.0 |
| 2010-12-02 07:28:00 | AAPL | Stock | 11.3368 | 11.3389 | 11.3368 | 11.3389 | 41160.0 |
| 2010-12-02 07:29:00 | AAPL | Stock | 11.3429 | 11.3429 | 11.3429 | 11.3429 | 2800.0 |
| 2010-12-02 07:30:00 | AAPL | Stock | 11.3432 | 11.3432 | 11.3432 | 11.3432 | 2800.0 |
| 2010-12-02 07:31:00 | AAPL | Stock | 11.3482 | 11.3496 | 11.3482 | 11.3496 | 22400.0 |
| 2010-12-02 07:32:00 | AAPL | Stock | 11.3464 | 11.3482 | 11.3464 | 11.3482 | 19600.0 |
| 2010-12-02 07:33:00 | AAPL | Stock | 11.3496 | 11.3532 | 11.3496 | 11.3532 | 57400.0 |
| 2010-12-02 07:34:00 | AAPL | Stock | 11.3546 | 11.3639 | 11.3546 | 11.3639 | 48580.0 |
| 2010-12-02 07:35:00 | AAPL | Stock | 11.3629 | 11.3639 | 11.3629 | 11.3639 | 28000.0 |
| 2010-12-02 07:36:00 | AAPL | Stock | 11.3639 | 11.3686 | 11.3639 | 11.3686 | 92400.0 |
| 2010-12-02 07:39:00 | AAPL | Stock | 11.3575 | 11.3575 | 11.3557 | 11.3557 | 5600.0 |
| 2010-12-02 07:41:00 | AAPL | Stock | 11.3629 | 11.3629 | 11.3629 | 11.3629 | 2800.0 |
| 2010-12-02 07:42:00 | AAPL | Stock | 11.3564 | 11.3564 | 11.3564 | 11.3564 | 2800.0 |
| 2010-12-02 07:49:00 | AAPL | Stock | 11.3571 | 11.3657 | 11.3571 | 11.3657 | 8400.0 |
> showing 50 of 993,703 rows — these rows as CSV