PREVIEW / stock_5min / 2012-02-22
file: by_date/stock_5min/2012/2012-02-22.parquet size: 4.9 MB rows: 327,344 symbols: 3,532
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-22 04:00:00 | AAPL | Stock | 18.4239 | 18.4239 | 18.4239 | 18.4239 | 5600.0 |
| 2012-02-22 04:15:00 | AAPL | Stock | 18.3782 | 18.3782 | 18.3782 | 18.3782 | 5600.0 |
| 2012-02-22 04:20:00 | AAPL | Stock | 18.3825 | 18.3825 | 18.3786 | 18.3786 | 14000.0 |
| 2012-02-22 04:50:00 | AAPL | Stock | 18.3982 | 18.3982 | 18.3982 | 18.3982 | 16800.0 |
| 2012-02-22 05:25:00 | AAPL | Stock | 18.3964 | 18.3964 | 18.3964 | 18.3964 | 2800.0 |
| 2012-02-22 05:35:00 | AAPL | Stock | 18.3982 | 18.3982 | 18.3982 | 18.3982 | 2800.0 |
| 2012-02-22 05:40:00 | AAPL | Stock | 18.3982 | 18.3982 | 18.3982 | 18.3982 | 6020.0 |
| 2012-02-22 06:00:00 | AAPL | Stock | 18.3875 | 18.3875 | 18.3875 | 18.3875 | 5600.0 |
| 2012-02-22 06:15:00 | AAPL | Stock | 18.3518 | 18.3561 | 18.3518 | 18.3561 | 25200.0 |
| 2012-02-22 06:20:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 2800.0 |
| 2012-02-22 06:25:00 | AAPL | Stock | 18.3714 | 18.3714 | 18.3661 | 18.3661 | 14252.0 |
| 2012-02-22 06:40:00 | AAPL | Stock | 18.3693 | 18.3693 | 18.3693 | 18.3693 | 5600.0 |
| 2012-02-22 06:45:00 | AAPL | Stock | 18.3693 | 18.3693 | 18.3693 | 18.3693 | 5544.0 |
| 2012-02-22 06:55:00 | AAPL | Stock | 18.3536 | 18.3536 | 18.3493 | 18.3493 | 25200.0 |
| 2012-02-22 07:00:00 | AAPL | Stock | 18.3571 | 18.3661 | 18.3564 | 18.3661 | 56868.0 |
| 2012-02-22 07:05:00 | AAPL | Stock | 18.3661 | 18.375 | 18.3575 | 18.3575 | 42224.0 |
| 2012-02-22 07:10:00 | AAPL | Stock | 18.3571 | 18.3643 | 18.345 | 18.3639 | 72800.0 |
| 2012-02-22 07:15:00 | AAPL | Stock | 18.3625 | 18.3839 | 18.3625 | 18.3839 | 40404.0 |
| 2012-02-22 07:20:00 | AAPL | Stock | 18.3675 | 18.3839 | 18.3668 | 18.3786 | 25200.0 |
| 2012-02-22 07:25:00 | AAPL | Stock | 18.3846 | 18.3846 | 18.3714 | 18.3714 | 123816.0 |
| 2012-02-22 07:30:00 | AAPL | Stock | 18.375 | 18.3846 | 18.375 | 18.3846 | 83860.0 |
| 2012-02-22 07:35:00 | AAPL | Stock | 18.3846 | 18.385 | 18.3668 | 18.3714 | 216524.0 |
| 2012-02-22 07:40:00 | AAPL | Stock | 18.3786 | 18.3804 | 18.3654 | 18.3714 | 33880.0 |
| 2012-02-22 07:45:00 | AAPL | Stock | 18.375 | 18.3807 | 18.3725 | 18.3725 | 107968.0 |
| 2012-02-22 07:50:00 | AAPL | Stock | 18.3661 | 18.3661 | 18.3607 | 18.3661 | 14000.0 |
| 2012-02-22 07:55:00 | AAPL | Stock | 18.3668 | 18.3668 | 18.3575 | 18.3639 | 17500.0 |
| 2012-02-22 08:00:00 | AAPL | Stock | 18.3607 | 18.3786 | 18.2736 | 18.2907 | 776468.0 |
| 2012-02-22 08:05:00 | AAPL | Stock | 18.3021 | 18.33 | 18.2982 | 18.32 | 459480.0 |
| 2012-02-22 08:10:00 | AAPL | Stock | 18.3204 | 18.3289 | 18.3161 | 18.3161 | 348460.0 |
| 2012-02-22 08:15:00 | AAPL | Stock | 18.3143 | 18.3161 | 18.2779 | 18.2929 | 446712.0 |
| 2012-02-22 08:20:00 | AAPL | Stock | 18.2854 | 18.2864 | 18.2739 | 18.2821 | 561904.0 |
| 2012-02-22 08:25:00 | AAPL | Stock | 18.2793 | 18.3018 | 18.2775 | 18.2921 | 512316.0 |
| 2012-02-22 08:30:00 | AAPL | Stock | 18.2932 | 18.2982 | 18.2768 | 18.2857 | 212968.0 |
| 2012-02-22 08:35:00 | AAPL | Stock | 18.2875 | 18.2932 | 18.2811 | 18.2821 | 356300.0 |
| 2012-02-22 08:40:00 | AAPL | Stock | 18.2821 | 18.2896 | 18.2689 | 18.2886 | 370944.0 |
| 2012-02-22 08:45:00 | AAPL | Stock | 18.2861 | 18.2911 | 18.2821 | 18.2904 | 337288.0 |
| 2012-02-22 08:50:00 | AAPL | Stock | 18.2911 | 18.3114 | 18.2854 | 18.3039 | 427952.0 |
| 2012-02-22 08:55:00 | AAPL | Stock | 18.3104 | 18.3232 | 18.3018 | 18.3232 | 346864.0 |
| 2012-02-22 09:00:00 | AAPL | Stock | 18.3239 | 18.3304 | 18.3125 | 18.3157 | 618128.0 |
| 2012-02-22 09:05:00 | AAPL | Stock | 18.3136 | 18.3214 | 18.3093 | 18.3161 | 428736.0 |
| 2012-02-22 09:10:00 | AAPL | Stock | 18.3143 | 18.3196 | 18.2893 | 18.2907 | 423528.0 |
| 2012-02-22 09:15:00 | AAPL | Stock | 18.2896 | 18.2925 | 18.2768 | 18.2857 | 194796.0 |
| 2012-02-22 09:20:00 | AAPL | Stock | 18.2907 | 18.2911 | 18.2786 | 18.2857 | 312340.0 |
| 2012-02-22 09:25:00 | AAPL | Stock | 18.2868 | 18.325 | 18.2821 | 18.3214 | 579544.0 |
| 2012-02-22 09:30:00 | AAPL | Stock | 18.3243 | 18.3536 | 18.1811 | 18.2461 | 23815288.0 |
| 2012-02-22 09:35:00 | AAPL | Stock | 18.2457 | 18.2604 | 18.2055 | 18.2429 | 12868436.0 |
| 2012-02-22 09:40:00 | AAPL | Stock | 18.2433 | 18.3257 | 18.21 | 18.3129 | 16775136.0 |
| 2012-02-22 09:45:00 | AAPL | Stock | 18.3121 | 18.3375 | 18.2754 | 18.2968 | 9245684.0 |
| 2012-02-22 09:50:00 | AAPL | Stock | 18.2904 | 18.3171 | 18.2539 | 18.2714 | 7428260.0 |
| 2012-02-22 09:55:00 | AAPL | Stock | 18.2682 | 18.2936 | 18.2482 | 18.2789 | 6947668.0 |
> showing 50 of 327,344 rows — these rows as CSV