PREVIEW / stock_5min / 2013-10-07
file: by_date/stock_5min/2013/2013-10-07.parquet size: 5.1 MB rows: 342,182 symbols: 3,543
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-07 04:00:00 | AAPL | Stock | 17.33 | 17.33 | 17.3054 | 17.3054 | 212520.0 |
| 2013-10-07 04:05:00 | AAPL | Stock | 17.3214 | 17.3218 | 17.2896 | 17.2911 | 114100.0 |
| 2013-10-07 04:10:00 | AAPL | Stock | 17.2946 | 17.3036 | 17.2946 | 17.3036 | 8400.0 |
| 2013-10-07 04:15:00 | AAPL | Stock | 17.2911 | 17.2911 | 17.2911 | 17.2911 | 5600.0 |
| 2013-10-07 04:20:00 | AAPL | Stock | 17.3057 | 17.3214 | 17.3057 | 17.3214 | 18760.0 |
| 2013-10-07 04:30:00 | AAPL | Stock | 17.3104 | 17.3293 | 17.3104 | 17.3293 | 58800.0 |
| 2013-10-07 04:35:00 | AAPL | Stock | 17.3214 | 17.3332 | 17.3129 | 17.3214 | 181664.0 |
| 2013-10-07 04:40:00 | AAPL | Stock | 17.3143 | 17.3214 | 17.3143 | 17.3214 | 17920.0 |
| 2013-10-07 04:55:00 | AAPL | Stock | 17.3196 | 17.3504 | 17.3196 | 17.3504 | 70336.0 |
| 2013-10-07 05:05:00 | AAPL | Stock | 17.3268 | 17.3268 | 17.325 | 17.325 | 9800.0 |
| 2013-10-07 05:25:00 | AAPL | Stock | 17.3271 | 17.3271 | 17.3271 | 17.3271 | 2800.0 |
| 2013-10-07 05:30:00 | AAPL | Stock | 17.3464 | 17.3464 | 17.3464 | 17.3464 | 61236.0 |
| 2013-10-07 05:35:00 | AAPL | Stock | 17.3296 | 17.3296 | 17.3296 | 17.3296 | 14000.0 |
| 2013-10-07 05:45:00 | AAPL | Stock | 17.3454 | 17.3582 | 17.3454 | 17.3582 | 92820.0 |
| 2013-10-07 05:50:00 | AAPL | Stock | 17.3721 | 17.3929 | 17.3721 | 17.3929 | 77840.0 |
| 2013-10-07 05:55:00 | AAPL | Stock | 17.3929 | 17.3932 | 17.3857 | 17.3886 | 37324.0 |
| 2013-10-07 06:05:00 | AAPL | Stock | 17.3779 | 17.3779 | 17.3779 | 17.3779 | 2800.0 |
| 2013-10-07 06:10:00 | AAPL | Stock | 17.3625 | 17.3775 | 17.3579 | 17.3579 | 34468.0 |
| 2013-10-07 06:15:00 | AAPL | Stock | 17.3579 | 17.3579 | 17.3539 | 17.3539 | 19320.0 |
| 2013-10-07 06:20:00 | AAPL | Stock | 17.3546 | 17.3546 | 17.3546 | 17.3546 | 2800.0 |
| 2013-10-07 06:25:00 | AAPL | Stock | 17.3661 | 17.3661 | 17.3661 | 17.3661 | 2800.0 |
| 2013-10-07 06:30:00 | AAPL | Stock | 17.3607 | 17.3607 | 17.3607 | 17.3607 | 2800.0 |
| 2013-10-07 06:35:00 | AAPL | Stock | 17.3704 | 17.3704 | 17.3704 | 17.3704 | 2800.0 |
| 2013-10-07 06:40:00 | AAPL | Stock | 17.3675 | 17.3675 | 17.3579 | 17.3579 | 16800.0 |
| 2013-10-07 06:45:00 | AAPL | Stock | 17.3571 | 17.3596 | 17.3557 | 17.3596 | 41300.0 |
| 2013-10-07 06:50:00 | AAPL | Stock | 17.3554 | 17.3554 | 17.3539 | 17.3543 | 44800.0 |
| 2013-10-07 06:55:00 | AAPL | Stock | 17.3657 | 17.3789 | 17.3654 | 17.3729 | 77560.0 |
| 2013-10-07 07:00:00 | AAPL | Stock | 17.3696 | 17.3821 | 17.3696 | 17.3821 | 178192.0 |
| 2013-10-07 07:05:00 | AAPL | Stock | 17.3839 | 17.3886 | 17.3768 | 17.3886 | 204064.0 |
| 2013-10-07 07:10:00 | AAPL | Stock | 17.3886 | 17.3886 | 17.3682 | 17.3682 | 82936.0 |
| 2013-10-07 07:15:00 | AAPL | Stock | 17.3618 | 17.3618 | 17.3575 | 17.3575 | 71680.0 |
| 2013-10-07 07:20:00 | AAPL | Stock | 17.3575 | 17.3575 | 17.3418 | 17.3418 | 70000.0 |
| 2013-10-07 07:25:00 | AAPL | Stock | 17.3429 | 17.3479 | 17.3325 | 17.3479 | 109200.0 |
| 2013-10-07 07:30:00 | AAPL | Stock | 17.3479 | 17.3643 | 17.3479 | 17.3643 | 142520.0 |
| 2013-10-07 07:35:00 | AAPL | Stock | 17.3632 | 17.3714 | 17.3521 | 17.3571 | 127092.0 |
| 2013-10-07 07:40:00 | AAPL | Stock | 17.3482 | 17.3607 | 17.3411 | 17.3607 | 51772.0 |
| 2013-10-07 07:45:00 | AAPL | Stock | 17.3525 | 17.3643 | 17.3514 | 17.3621 | 134540.0 |
| 2013-10-07 07:50:00 | AAPL | Stock | 17.3643 | 17.3736 | 17.3571 | 17.3586 | 111580.0 |
| 2013-10-07 07:55:00 | AAPL | Stock | 17.3643 | 17.375 | 17.3643 | 17.3679 | 70784.0 |
| 2013-10-07 08:00:00 | AAPL | Stock | 17.3625 | 17.3886 | 17.2143 | 17.3214 | 1007412.0 |
| 2013-10-07 08:05:00 | AAPL | Stock | 17.3232 | 17.3643 | 17.3214 | 17.3625 | 628908.0 |
| 2013-10-07 08:10:00 | AAPL | Stock | 17.3625 | 17.375 | 17.3496 | 17.3732 | 557648.0 |
| 2013-10-07 08:15:00 | AAPL | Stock | 17.3675 | 17.3775 | 17.3639 | 17.3682 | 573580.0 |
| 2013-10-07 08:20:00 | AAPL | Stock | 17.3679 | 17.3907 | 17.3671 | 17.39 | 582904.0 |
| 2013-10-07 08:25:00 | AAPL | Stock | 17.3843 | 17.3864 | 17.3614 | 17.3629 | 292544.0 |
| 2013-10-07 08:30:00 | AAPL | Stock | 17.3714 | 17.3732 | 17.3668 | 17.3718 | 33600.0 |
| 2013-10-07 08:35:00 | AAPL | Stock | 17.3721 | 17.3886 | 17.3721 | 17.38 | 224392.0 |
| 2013-10-07 08:40:00 | AAPL | Stock | 17.3793 | 17.3857 | 17.3696 | 17.37 | 155680.0 |
| 2013-10-07 08:45:00 | AAPL | Stock | 17.3707 | 17.375 | 17.3604 | 17.3679 | 177072.0 |
| 2013-10-07 08:50:00 | AAPL | Stock | 17.3679 | 17.3818 | 17.3575 | 17.3754 | 312200.0 |
> showing 50 of 342,182 rows — these rows as CSV