PREVIEW / stock_5min / 2013-10-11
file: by_date/stock_5min/2013/2013-10-11.parquet size: 5.1 MB rows: 339,197 symbols: 3,538
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-11 04:00:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 2800.0 |
| 2013-10-11 04:30:00 | AAPL | Stock | 17.4589 | 17.4643 | 17.4589 | 17.4643 | 22400.0 |
| 2013-10-11 05:30:00 | AAPL | Stock | 17.4625 | 17.4625 | 17.4625 | 17.4625 | 2800.0 |
| 2013-10-11 05:35:00 | AAPL | Stock | 17.4214 | 17.4214 | 17.4214 | 17.4214 | 2800.0 |
| 2013-10-11 05:40:00 | AAPL | Stock | 17.4443 | 17.4443 | 17.4443 | 17.4443 | 2800.0 |
| 2013-10-11 06:40:00 | AAPL | Stock | 17.4196 | 17.4289 | 17.4196 | 17.4196 | 18284.0 |
| 2013-10-11 06:45:00 | AAPL | Stock | 17.3714 | 17.4096 | 17.3714 | 17.4096 | 5600.0 |
| 2013-10-11 07:00:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 5040.0 |
| 2013-10-11 07:05:00 | AAPL | Stock | 17.4164 | 17.4164 | 17.3929 | 17.3929 | 56000.0 |
| 2013-10-11 07:10:00 | AAPL | Stock | 17.4025 | 17.4025 | 17.4025 | 17.4025 | 2800.0 |
| 2013-10-11 07:15:00 | AAPL | Stock | 17.4089 | 17.4125 | 17.4089 | 17.4125 | 14000.0 |
| 2013-10-11 07:20:00 | AAPL | Stock | 17.4196 | 17.4196 | 17.4196 | 17.4196 | 25984.0 |
| 2013-10-11 07:25:00 | AAPL | Stock | 17.4196 | 17.4214 | 17.4121 | 17.4121 | 18116.0 |
| 2013-10-11 07:35:00 | AAPL | Stock | 17.4129 | 17.4129 | 17.4129 | 17.4129 | 2800.0 |
| 2013-10-11 07:40:00 | AAPL | Stock | 17.4279 | 17.4279 | 17.4107 | 17.4129 | 49504.0 |
| 2013-10-11 07:45:00 | AAPL | Stock | 17.3996 | 17.4107 | 17.3996 | 17.4107 | 28000.0 |
| 2013-10-11 07:50:00 | AAPL | Stock | 17.4118 | 17.4236 | 17.4118 | 17.4236 | 16800.0 |
| 2013-10-11 07:55:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.3996 | 17.3996 | 51660.0 |
| 2013-10-11 08:00:00 | AAPL | Stock | 17.4068 | 17.4371 | 17.3929 | 17.4 | 332724.0 |
| 2013-10-11 08:05:00 | AAPL | Stock | 17.3993 | 17.3993 | 17.3643 | 17.3786 | 392532.0 |
| 2013-10-11 08:10:00 | AAPL | Stock | 17.3646 | 17.375 | 17.35 | 17.3607 | 477876.0 |
| 2013-10-11 08:15:00 | AAPL | Stock | 17.3607 | 17.375 | 17.3571 | 17.3714 | 211764.0 |
| 2013-10-11 08:20:00 | AAPL | Stock | 17.3714 | 17.3714 | 17.3607 | 17.3661 | 134400.0 |
| 2013-10-11 08:25:00 | AAPL | Stock | 17.3643 | 17.375 | 17.3643 | 17.375 | 248360.0 |
| 2013-10-11 08:30:00 | AAPL | Stock | 17.3732 | 17.3764 | 17.37 | 17.3764 | 82656.0 |
| 2013-10-11 08:35:00 | AAPL | Stock | 17.375 | 17.3929 | 17.3739 | 17.3929 | 132076.0 |
| 2013-10-11 08:40:00 | AAPL | Stock | 17.3929 | 17.4146 | 17.3929 | 17.4143 | 111440.0 |
| 2013-10-11 08:45:00 | AAPL | Stock | 17.4146 | 17.4871 | 17.4082 | 17.4111 | 316204.0 |
| 2013-10-11 08:50:00 | AAPL | Stock | 17.4043 | 17.4043 | 17.3929 | 17.3929 | 22400.0 |
| 2013-10-11 08:55:00 | AAPL | Stock | 17.4039 | 17.4039 | 17.3936 | 17.3936 | 16800.0 |
| 2013-10-11 09:00:00 | AAPL | Stock | 17.3996 | 17.4043 | 17.3986 | 17.4004 | 33236.0 |
| 2013-10-11 09:05:00 | AAPL | Stock | 17.3989 | 17.4039 | 17.3989 | 17.4039 | 9352.0 |
| 2013-10-11 09:10:00 | AAPL | Stock | 17.4 | 17.4054 | 17.3929 | 17.4054 | 72352.0 |
| 2013-10-11 09:15:00 | AAPL | Stock | 17.4071 | 17.4186 | 17.4071 | 17.415 | 30800.0 |
| 2013-10-11 09:20:00 | AAPL | Stock | 17.4093 | 17.4096 | 17.4043 | 17.4093 | 33600.0 |
| 2013-10-11 09:25:00 | AAPL | Stock | 17.4143 | 17.425 | 17.3736 | 17.3939 | 226156.0 |
| 2013-10-11 09:30:00 | AAPL | Stock | 17.3929 | 17.4089 | 17.3271 | 17.3468 | 13990508.0 |
| 2013-10-11 09:35:00 | AAPL | Stock | 17.3475 | 17.3889 | 17.3393 | 17.3814 | 7305452.0 |
| 2013-10-11 09:40:00 | AAPL | Stock | 17.3804 | 17.4018 | 17.3625 | 17.3757 | 6937252.0 |
| 2013-10-11 09:45:00 | AAPL | Stock | 17.3818 | 17.4 | 17.3571 | 17.3744 | 5687556.0 |
| 2013-10-11 09:50:00 | AAPL | Stock | 17.3743 | 17.3986 | 17.3607 | 17.3929 | 3096408.0 |
| 2013-10-11 09:55:00 | AAPL | Stock | 17.3964 | 17.4464 | 17.3816 | 17.4414 | 7248444.0 |
| 2013-10-11 10:00:00 | AAPL | Stock | 17.4414 | 17.4532 | 17.4168 | 17.4429 | 4633020.0 |
| 2013-10-11 10:05:00 | AAPL | Stock | 17.4464 | 17.4521 | 17.42 | 17.4264 | 3466092.0 |
| 2013-10-11 10:10:00 | AAPL | Stock | 17.425 | 17.4286 | 17.4039 | 17.4175 | 3100776.0 |
| 2013-10-11 10:15:00 | AAPL | Stock | 17.4171 | 17.4246 | 17.3936 | 17.3992 | 2840936.0 |
| 2013-10-11 10:20:00 | AAPL | Stock | 17.3982 | 17.4032 | 17.3625 | 17.3739 | 4704420.0 |
| 2013-10-11 10:25:00 | AAPL | Stock | 17.3742 | 17.4016 | 17.3736 | 17.3957 | 2208444.0 |
| 2013-10-11 10:30:00 | AAPL | Stock | 17.3932 | 17.3982 | 17.3818 | 17.3914 | 1236368.0 |
| 2013-10-11 10:35:00 | AAPL | Stock | 17.3914 | 17.4004 | 17.3818 | 17.3875 | 1238188.0 |
> showing 50 of 339,197 rows — these rows as CSV