PREVIEW / stock_5min / 2013-08-02
file: by_date/stock_5min/2013/2013-08-02.parquet size: 5.1 MB rows: 337,547 symbols: 3,516
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-08-02 05:10:00 | AAPL | Stock | 16.3232 | 16.3232 | 16.3232 | 16.3232 | 2800.0 |
| 2013-08-02 05:50:00 | AAPL | Stock | 16.3232 | 16.3232 | 16.3232 | 16.3232 | 2800.0 |
| 2013-08-02 07:20:00 | AAPL | Stock | 16.3179 | 16.3179 | 16.3179 | 16.3179 | 14000.0 |
| 2013-08-02 07:40:00 | AAPL | Stock | 16.3171 | 16.3204 | 16.3171 | 16.3204 | 8400.0 |
| 2013-08-02 07:55:00 | AAPL | Stock | 16.3154 | 16.3218 | 16.3046 | 16.3107 | 80080.0 |
| 2013-08-02 08:00:00 | AAPL | Stock | 16.3079 | 16.3236 | 16.2143 | 16.3236 | 255248.0 |
| 2013-08-02 08:05:00 | AAPL | Stock | 16.3304 | 16.3304 | 16.3296 | 16.3296 | 14000.0 |
| 2013-08-02 08:10:00 | AAPL | Stock | 16.3232 | 16.3296 | 16.3232 | 16.3296 | 44072.0 |
| 2013-08-02 08:15:00 | AAPL | Stock | 16.3261 | 16.3261 | 16.3136 | 16.3214 | 166740.0 |
| 2013-08-02 08:20:00 | AAPL | Stock | 16.3211 | 16.3357 | 16.3211 | 16.3357 | 77224.0 |
| 2013-08-02 08:25:00 | AAPL | Stock | 16.3343 | 16.3643 | 16.3343 | 16.3571 | 121856.0 |
| 2013-08-02 08:30:00 | AAPL | Stock | 16.3571 | 16.3643 | 16.3136 | 16.3214 | 367948.0 |
| 2013-08-02 08:35:00 | AAPL | Stock | 16.3218 | 16.3418 | 16.3218 | 16.3329 | 196252.0 |
| 2013-08-02 08:40:00 | AAPL | Stock | 16.3329 | 16.3443 | 16.3214 | 16.3371 | 134204.0 |
| 2013-08-02 08:45:00 | AAPL | Stock | 16.3429 | 16.3436 | 16.3275 | 16.3282 | 111972.0 |
| 2013-08-02 08:50:00 | AAPL | Stock | 16.3282 | 16.3421 | 16.3271 | 16.3361 | 175000.0 |
| 2013-08-02 08:55:00 | AAPL | Stock | 16.3411 | 16.35 | 16.3411 | 16.35 | 74480.0 |
| 2013-08-02 09:00:00 | AAPL | Stock | 16.3482 | 16.3518 | 16.3446 | 16.3518 | 72800.0 |
| 2013-08-02 09:05:00 | AAPL | Stock | 16.3529 | 16.3554 | 16.345 | 16.3554 | 225820.0 |
| 2013-08-02 09:10:00 | AAPL | Stock | 16.35 | 16.355 | 16.35 | 16.3511 | 65520.0 |
| 2013-08-02 09:15:00 | AAPL | Stock | 16.3536 | 16.3639 | 16.3536 | 16.3618 | 168476.0 |
| 2013-08-02 09:20:00 | AAPL | Stock | 16.3586 | 16.3618 | 16.3575 | 16.3575 | 82824.0 |
| 2013-08-02 09:25:00 | AAPL | Stock | 16.3575 | 16.3629 | 16.3504 | 16.3504 | 156576.0 |
| 2013-08-02 09:30:00 | AAPL | Stock | 16.3525 | 16.3886 | 16.3371 | 16.3768 | 14774088.0 |
| 2013-08-02 09:35:00 | AAPL | Stock | 16.3764 | 16.3964 | 16.3582 | 16.3943 | 7166488.0 |
| 2013-08-02 09:40:00 | AAPL | Stock | 16.3943 | 16.4132 | 16.3593 | 16.3682 | 8390928.0 |
| 2013-08-02 09:45:00 | AAPL | Stock | 16.3682 | 16.3782 | 16.3093 | 16.3154 | 9375492.0 |
| 2013-08-02 09:50:00 | AAPL | Stock | 16.32 | 16.3536 | 16.3154 | 16.3329 | 6379632.0 |
| 2013-08-02 09:55:00 | AAPL | Stock | 16.3329 | 16.3668 | 16.3321 | 16.3621 | 6361684.0 |
| 2013-08-02 10:00:00 | AAPL | Stock | 16.3636 | 16.3814 | 16.3496 | 16.36 | 5965204.0 |
| 2013-08-02 10:05:00 | AAPL | Stock | 16.3607 | 16.3736 | 16.35 | 16.3643 | 2246580.0 |
| 2013-08-02 10:10:00 | AAPL | Stock | 16.3707 | 16.3929 | 16.3625 | 16.3829 | 5818204.0 |
| 2013-08-02 10:15:00 | AAPL | Stock | 16.3821 | 16.3907 | 16.3614 | 16.3807 | 5860120.0 |
| 2013-08-02 10:20:00 | AAPL | Stock | 16.3811 | 16.3811 | 16.3554 | 16.3668 | 2812180.0 |
| 2013-08-02 10:25:00 | AAPL | Stock | 16.3725 | 16.3729 | 16.3554 | 16.3618 | 2806300.0 |
| 2013-08-02 10:30:00 | AAPL | Stock | 16.3611 | 16.3711 | 16.3604 | 16.3704 | 1610644.0 |
| 2013-08-02 10:35:00 | AAPL | Stock | 16.3671 | 16.3775 | 16.3529 | 16.3639 | 3429076.0 |
| 2013-08-02 10:40:00 | AAPL | Stock | 16.3586 | 16.3671 | 16.3547 | 16.3571 | 1112496.0 |
| 2013-08-02 10:45:00 | AAPL | Stock | 16.3571 | 16.3729 | 16.3539 | 16.3654 | 1348816.0 |
| 2013-08-02 10:50:00 | AAPL | Stock | 16.3654 | 16.3686 | 16.3543 | 16.3674 | 1552180.0 |
| 2013-08-02 10:55:00 | AAPL | Stock | 16.3645 | 16.3729 | 16.3368 | 16.3429 | 2296028.0 |
| 2013-08-02 11:00:00 | AAPL | Stock | 16.342 | 16.3536 | 16.3182 | 16.32 | 3787224.0 |
| 2013-08-02 11:05:00 | AAPL | Stock | 16.3214 | 16.3357 | 16.3193 | 16.3296 | 2608760.0 |
| 2013-08-02 11:10:00 | AAPL | Stock | 16.3311 | 16.3479 | 16.3279 | 16.3457 | 1958544.0 |
| 2013-08-02 11:15:00 | AAPL | Stock | 16.3459 | 16.3632 | 16.3418 | 16.3593 | 2706088.0 |
| 2013-08-02 11:20:00 | AAPL | Stock | 16.3593 | 16.3825 | 16.3557 | 16.364 | 3035004.0 |
| 2013-08-02 11:25:00 | AAPL | Stock | 16.3696 | 16.3761 | 16.3611 | 16.3675 | 1891316.0 |
| 2013-08-02 11:30:00 | AAPL | Stock | 16.3692 | 16.3875 | 16.3654 | 16.3814 | 2564044.0 |
| 2013-08-02 11:35:00 | AAPL | Stock | 16.3818 | 16.3825 | 16.3657 | 16.3686 | 1031156.0 |
| 2013-08-02 11:40:00 | AAPL | Stock | 16.369 | 16.3782 | 16.3679 | 16.3732 | 796376.0 |
> showing 50 of 337,547 rows — these rows as CSV