PREVIEW / stock_5min / 2014-05-28
file: by_date/stock_5min/2014/2014-05-28.parquet size: 5.4 MB rows: 359,933 symbols: 3,566
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-28 04:10:00 | AAPL | Stock | 22.3596 | 22.3596 | 22.3596 | 22.3596 | 5600.0 |
| 2014-05-28 05:20:00 | AAPL | Stock | 22.4607 | 22.4607 | 22.4104 | 22.4104 | 5600.0 |
| 2014-05-28 05:25:00 | AAPL | Stock | 22.4361 | 22.4893 | 22.4361 | 22.4893 | 13552.0 |
| 2014-05-28 05:35:00 | AAPL | Stock | 22.4893 | 22.4907 | 22.4893 | 22.4907 | 8848.0 |
| 2014-05-28 06:05:00 | AAPL | Stock | 22.4711 | 22.4711 | 22.4468 | 22.4468 | 19600.0 |
| 2014-05-28 06:10:00 | AAPL | Stock | 22.4504 | 22.4504 | 22.4418 | 22.4418 | 5600.0 |
| 2014-05-28 06:15:00 | AAPL | Stock | 22.4286 | 22.4286 | 22.4286 | 22.4286 | 2800.0 |
| 2014-05-28 06:20:00 | AAPL | Stock | 22.4286 | 22.4286 | 22.4286 | 22.4286 | 14000.0 |
| 2014-05-28 06:30:00 | AAPL | Stock | 22.4125 | 22.4286 | 22.3929 | 22.4286 | 37716.0 |
| 2014-05-28 06:35:00 | AAPL | Stock | 22.4225 | 22.4225 | 22.4225 | 22.4225 | 2800.0 |
| 2014-05-28 06:45:00 | AAPL | Stock | 22.4214 | 22.4214 | 22.4214 | 22.4214 | 2800.0 |
| 2014-05-28 06:50:00 | AAPL | Stock | 22.4175 | 22.4175 | 22.4175 | 22.4175 | 2800.0 |
| 2014-05-28 06:55:00 | AAPL | Stock | 22.4221 | 22.4225 | 22.4107 | 22.4107 | 39200.0 |
| 2014-05-28 07:00:00 | AAPL | Stock | 22.4143 | 22.4143 | 22.4143 | 22.4143 | 28000.0 |
| 2014-05-28 07:05:00 | AAPL | Stock | 22.4129 | 22.4143 | 22.4125 | 22.4143 | 9800.0 |
| 2014-05-28 07:10:00 | AAPL | Stock | 22.4107 | 22.4107 | 22.4107 | 22.4107 | 8400.0 |
| 2014-05-28 07:15:00 | AAPL | Stock | 22.4107 | 22.4107 | 22.4107 | 22.4107 | 2800.0 |
| 2014-05-28 07:25:00 | AAPL | Stock | 22.4054 | 22.4107 | 22.4018 | 22.4018 | 21896.0 |
| 2014-05-28 07:30:00 | AAPL | Stock | 22.3946 | 22.4 | 22.3932 | 22.3982 | 11200.0 |
| 2014-05-28 07:35:00 | AAPL | Stock | 22.3946 | 22.3946 | 22.3929 | 22.3929 | 72800.0 |
| 2014-05-28 07:40:00 | AAPL | Stock | 22.3929 | 22.3929 | 22.3929 | 22.3929 | 2800.0 |
| 2014-05-28 07:45:00 | AAPL | Stock | 22.3929 | 22.3964 | 22.3839 | 22.3964 | 16016.0 |
| 2014-05-28 07:50:00 | AAPL | Stock | 22.3929 | 22.3929 | 22.3768 | 22.3825 | 39872.0 |
| 2014-05-28 07:55:00 | AAPL | Stock | 22.3782 | 22.3782 | 22.3571 | 22.3571 | 99092.0 |
| 2014-05-28 08:00:00 | AAPL | Stock | 22.3839 | 22.4286 | 22.3439 | 22.3996 | 643748.0 |
| 2014-05-28 08:05:00 | AAPL | Stock | 22.3907 | 22.3929 | 22.3804 | 22.3875 | 120036.0 |
| 2014-05-28 08:10:00 | AAPL | Stock | 22.3911 | 22.3929 | 22.3732 | 22.3907 | 183428.0 |
| 2014-05-28 08:15:00 | AAPL | Stock | 22.3907 | 22.3932 | 22.3907 | 22.3932 | 103600.0 |
| 2014-05-28 08:20:00 | AAPL | Stock | 22.3957 | 22.3964 | 22.395 | 22.3964 | 52052.0 |
| 2014-05-28 08:25:00 | AAPL | Stock | 22.4 | 22.4071 | 22.3993 | 22.4068 | 135520.0 |
| 2014-05-28 08:30:00 | AAPL | Stock | 22.4011 | 22.4036 | 22.3882 | 22.3964 | 155848.0 |
| 2014-05-28 08:35:00 | AAPL | Stock | 22.3964 | 22.4032 | 22.3839 | 22.3846 | 145096.0 |
| 2014-05-28 08:40:00 | AAPL | Stock | 22.3843 | 22.3929 | 22.3682 | 22.3682 | 180572.0 |
| 2014-05-28 08:45:00 | AAPL | Stock | 22.3793 | 22.3793 | 22.3589 | 22.3643 | 206192.0 |
| 2014-05-28 08:50:00 | AAPL | Stock | 22.3611 | 22.3704 | 22.3314 | 22.3314 | 333480.0 |
| 2014-05-28 08:55:00 | AAPL | Stock | 22.3321 | 22.3339 | 22.3207 | 22.3207 | 172704.0 |
| 2014-05-28 09:00:00 | AAPL | Stock | 22.3104 | 22.3275 | 22.3104 | 22.3275 | 112560.0 |
| 2014-05-28 09:05:00 | AAPL | Stock | 22.33 | 22.33 | 22.3193 | 22.325 | 22288.0 |
| 2014-05-28 09:10:00 | AAPL | Stock | 22.3268 | 22.3314 | 22.3268 | 22.3268 | 16800.0 |
| 2014-05-28 09:15:00 | AAPL | Stock | 22.3318 | 22.3393 | 22.3304 | 22.3375 | 26152.0 |
| 2014-05-28 09:20:00 | AAPL | Stock | 22.3429 | 22.3439 | 22.3364 | 22.3393 | 78792.0 |
| 2014-05-28 09:25:00 | AAPL | Stock | 22.3411 | 22.3643 | 22.3286 | 22.3571 | 925456.0 |
| 2014-05-28 09:30:00 | AAPL | Stock | 22.3579 | 22.4036 | 22.3293 | 22.3345 | 17352300.0 |
| 2014-05-28 09:35:00 | AAPL | Stock | 22.3329 | 22.3721 | 22.3236 | 22.3373 | 7089068.0 |
| 2014-05-28 09:40:00 | AAPL | Stock | 22.3386 | 22.3975 | 22.3143 | 22.3875 | 6455820.0 |
| 2014-05-28 09:45:00 | AAPL | Stock | 22.3896 | 22.4286 | 22.3836 | 22.4282 | 10234252.0 |
| 2014-05-28 09:50:00 | AAPL | Stock | 22.4261 | 22.4829 | 22.4261 | 22.4557 | 11834004.0 |
| 2014-05-28 09:55:00 | AAPL | Stock | 22.4554 | 22.46 | 22.4075 | 22.46 | 7765044.0 |
| 2014-05-28 10:00:00 | AAPL | Stock | 22.4607 | 22.4679 | 22.4171 | 22.4414 | 4720828.0 |
| 2014-05-28 10:05:00 | AAPL | Stock | 22.4379 | 22.4925 | 22.4379 | 22.4921 | 4909408.0 |
> showing 50 of 359,933 rows — these rows as CSV