PREVIEW / stock_5min / 2010-12-02
file: by_date/stock_5min/2010/2010-12-02.parquet size: 4.9 MB rows: 333,472 symbols: 3,531
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:35:00 | AAPL | Stock | 11.3536 | 11.3536 | 11.3536 | 11.3536 | 5600.0 |
| 2010-12-02 04:40:00 | AAPL | Stock | 11.3536 | 11.3571 | 11.3536 | 11.3571 | 33320.0 |
| 2010-12-02 04:45:00 | AAPL | Stock | 11.3571 | 11.3571 | 11.3521 | 11.3521 | 14280.0 |
| 2010-12-02 04:50:00 | AAPL | Stock | 11.3521 | 11.3571 | 11.3471 | 11.3471 | 8400.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.3393 | 11.3393 | 8400.0 |
| 2010-12-02 05:05:00 | AAPL | Stock | 11.3214 | 11.3214 | 11.3179 | 11.3179 | 8400.0 |
| 2010-12-02 05:10: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:20: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.3286 | 11.3271 | 11.3286 | 28000.0 |
| 2010-12-02 06:55:00 | AAPL | Stock | 11.3286 | 11.3286 | 11.3286 | 11.3286 | 5600.0 |
| 2010-12-02 07:00:00 | AAPL | Stock | 11.3218 | 11.3357 | 11.3218 | 11.3357 | 16800.0 |
| 2010-12-02 07:05:00 | AAPL | Stock | 11.3304 | 11.3304 | 11.3304 | 11.3304 | 8400.0 |
| 2010-12-02 07:10:00 | AAPL | Stock | 11.3393 | 11.3393 | 11.3357 | 11.3357 | 38668.0 |
| 2010-12-02 07:15:00 | AAPL | Stock | 11.3375 | 11.3375 | 11.3375 | 11.3375 | 2800.0 |
| 2010-12-02 07:20:00 | AAPL | Stock | 11.3357 | 11.3389 | 11.3286 | 11.3286 | 19600.0 |
| 2010-12-02 07:25:00 | AAPL | Stock | 11.3286 | 11.3429 | 11.3271 | 11.3429 | 93520.0 |
| 2010-12-02 07:30:00 | AAPL | Stock | 11.3432 | 11.3639 | 11.3432 | 11.3639 | 150780.0 |
| 2010-12-02 07:35:00 | AAPL | Stock | 11.3629 | 11.3686 | 11.3557 | 11.3557 | 126000.0 |
| 2010-12-02 07:40:00 | AAPL | Stock | 11.3629 | 11.3629 | 11.3564 | 11.3564 | 5600.0 |
| 2010-12-02 07:45:00 | AAPL | Stock | 11.3571 | 11.3657 | 11.3571 | 11.3657 | 8400.0 |
| 2010-12-02 07:50:00 | AAPL | Stock | 11.3661 | 11.3689 | 11.3646 | 11.3689 | 49000.0 |
| 2010-12-02 07:55:00 | AAPL | Stock | 11.3714 | 11.3736 | 11.3607 | 11.3736 | 36400.0 |
| 2010-12-02 08:00:00 | AAPL | Stock | 11.3629 | 11.3711 | 11.3429 | 11.3661 | 677740.0 |
| 2010-12-02 08:05:00 | AAPL | Stock | 11.3675 | 11.3693 | 11.3643 | 11.3682 | 526204.0 |
| 2010-12-02 08:10:00 | AAPL | Stock | 11.3661 | 11.3714 | 11.3643 | 11.3696 | 146300.0 |
| 2010-12-02 08:15:00 | AAPL | Stock | 11.3682 | 11.3707 | 11.3661 | 11.3704 | 207760.0 |
| 2010-12-02 08:20:00 | AAPL | Stock | 11.3707 | 11.3711 | 11.3664 | 11.37 | 282268.0 |
| 2010-12-02 08:25:00 | AAPL | Stock | 11.3704 | 11.375 | 11.3696 | 11.3718 | 386596.0 |
| 2010-12-02 08:30:00 | AAPL | Stock | 11.3693 | 11.3718 | 11.3625 | 11.3643 | 597380.0 |
| 2010-12-02 08:35:00 | AAPL | Stock | 11.3679 | 11.3679 | 11.35 | 11.3546 | 1068256.0 |
| 2010-12-02 08:40:00 | AAPL | Stock | 11.3564 | 11.3682 | 11.3546 | 11.3679 | 421876.0 |
| 2010-12-02 08:45:00 | AAPL | Stock | 11.3679 | 11.3686 | 11.3646 | 11.3679 | 173600.0 |
| 2010-12-02 08:50:00 | AAPL | Stock | 11.3671 | 11.375 | 11.3536 | 11.3568 | 1549716.0 |
| 2010-12-02 08:55:00 | AAPL | Stock | 11.3539 | 11.3589 | 11.3461 | 11.3479 | 463456.0 |
| 2010-12-02 09:00:00 | AAPL | Stock | 11.3446 | 11.3511 | 11.3257 | 11.3357 | 918484.0 |
| 2010-12-02 09:05:00 | AAPL | Stock | 11.3375 | 11.3725 | 11.335 | 11.3686 | 774480.0 |
| 2010-12-02 09:10:00 | AAPL | Stock | 11.3686 | 11.3746 | 11.36 | 11.3746 | 376152.0 |
| 2010-12-02 09:15:00 | AAPL | Stock | 11.3739 | 11.3739 | 11.3625 | 11.3657 | 384608.0 |
| 2010-12-02 09:20:00 | AAPL | Stock | 11.365 | 11.3807 | 11.365 | 11.3661 | 605304.0 |
| 2010-12-02 09:25:00 | AAPL | Stock | 11.3664 | 11.3679 | 11.3429 | 11.3429 | 351652.0 |
| 2010-12-02 09:30:00 | AAPL | Stock | 11.3436 | 11.3864 | 11.3311 | 11.3864 | 19549544.0 |
| 2010-12-02 09:35:00 | AAPL | Stock | 11.3854 | 11.3929 | 11.3654 | 11.3754 | 13837264.0 |
| 2010-12-02 09:40:00 | AAPL | Stock | 11.3739 | 11.3821 | 11.3514 | 11.3589 | 11875668.0 |
> showing 50 of 333,472 rows — these rows as CSV