PREVIEW / stock_1min / 2013-10-11
file: by_date/stock_1min/2013/2013-10-11.parquet size: 13.4 MB rows: 977,115 symbols: 2,867
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:36: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:43:00 | AAPL | Stock | 17.4196 | 17.4289 | 17.4196 | 17.4196 | 18284.0 |
| 2013-10-11 06:45:00 | AAPL | Stock | 17.3714 | 17.3714 | 17.3714 | 17.3714 | 2800.0 |
| 2013-10-11 06:49:00 | AAPL | Stock | 17.4096 | 17.4096 | 17.4096 | 17.4096 | 2800.0 |
| 2013-10-11 07:03:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 5040.0 |
| 2013-10-11 07:06:00 | AAPL | Stock | 17.4164 | 17.4164 | 17.4071 | 17.4093 | 25200.0 |
| 2013-10-11 07:07:00 | AAPL | Stock | 17.4093 | 17.4093 | 17.3929 | 17.3929 | 30800.0 |
| 2013-10-11 07:11:00 | AAPL | Stock | 17.4025 | 17.4025 | 17.4025 | 17.4025 | 2800.0 |
| 2013-10-11 07:18:00 | AAPL | Stock | 17.4089 | 17.4107 | 17.4089 | 17.4107 | 8400.0 |
| 2013-10-11 07:19:00 | AAPL | Stock | 17.4125 | 17.4125 | 17.4125 | 17.4125 | 5600.0 |
| 2013-10-11 07:20:00 | AAPL | Stock | 17.4196 | 17.4196 | 17.4196 | 17.4196 | 3584.0 |
| 2013-10-11 07:21:00 | AAPL | Stock | 17.4196 | 17.4196 | 17.4196 | 17.4196 | 8400.0 |
| 2013-10-11 07:22:00 | AAPL | Stock | 17.4196 | 17.4196 | 17.4196 | 17.4196 | 14000.0 |
| 2013-10-11 07:25:00 | AAPL | Stock | 17.4196 | 17.4196 | 17.4196 | 17.4196 | 5600.0 |
| 2013-10-11 07:28:00 | AAPL | Stock | 17.4214 | 17.4214 | 17.4214 | 17.4214 | 5600.0 |
| 2013-10-11 07:29:00 | AAPL | Stock | 17.415 | 17.415 | 17.4121 | 17.4121 | 6916.0 |
| 2013-10-11 07:37:00 | AAPL | Stock | 17.4129 | 17.4129 | 17.4129 | 17.4129 | 2800.0 |
| 2013-10-11 07:43:00 | AAPL | Stock | 17.4279 | 17.4279 | 17.4279 | 17.4279 | 2800.0 |
| 2013-10-11 07:44:00 | AAPL | Stock | 17.4146 | 17.4146 | 17.4107 | 17.4129 | 46704.0 |
| 2013-10-11 07:45:00 | AAPL | Stock | 17.3996 | 17.4089 | 17.3996 | 17.4089 | 5600.0 |
| 2013-10-11 07:47:00 | AAPL | Stock | 17.4096 | 17.4107 | 17.4096 | 17.4107 | 8400.0 |
| 2013-10-11 07:48:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 2800.0 |
| 2013-10-11 07:49:00 | AAPL | Stock | 17.4104 | 17.4107 | 17.4104 | 17.4107 | 11200.0 |
| 2013-10-11 07:50:00 | AAPL | Stock | 17.4118 | 17.42 | 17.4118 | 17.42 | 5600.0 |
| 2013-10-11 07:52:00 | AAPL | Stock | 17.4221 | 17.4221 | 17.4125 | 17.4125 | 8400.0 |
| 2013-10-11 07:53:00 | AAPL | Stock | 17.4236 | 17.4236 | 17.4236 | 17.4236 | 2800.0 |
| 2013-10-11 07:57:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4071 | 17.4071 | 48860.0 |
| 2013-10-11 07:58:00 | AAPL | Stock | 17.3996 | 17.3996 | 17.3996 | 17.3996 | 2800.0 |
| 2013-10-11 08:00:00 | AAPL | Stock | 17.4068 | 17.4371 | 17.3929 | 17.4275 | 239736.0 |
| 2013-10-11 08:01:00 | AAPL | Stock | 17.4129 | 17.4286 | 17.4129 | 17.4286 | 19600.0 |
| 2013-10-11 08:02:00 | AAPL | Stock | 17.4121 | 17.4136 | 17.4071 | 17.4125 | 52220.0 |
| 2013-10-11 08:03:00 | AAPL | Stock | 17.4036 | 17.4036 | 17.4036 | 17.4036 | 11396.0 |
| 2013-10-11 08:04:00 | AAPL | Stock | 17.4018 | 17.4018 | 17.4 | 17.4 | 9772.0 |
| 2013-10-11 08:05:00 | AAPL | Stock | 17.3993 | 17.3993 | 17.3786 | 17.3786 | 191576.0 |
| 2013-10-11 08:06:00 | AAPL | Stock | 17.3768 | 17.3775 | 17.3732 | 17.3775 | 38080.0 |
| 2013-10-11 08:07:00 | AAPL | Stock | 17.375 | 17.3829 | 17.3732 | 17.3786 | 53620.0 |
| 2013-10-11 08:08:00 | AAPL | Stock | 17.3811 | 17.3836 | 17.3754 | 17.3757 | 39956.0 |
| 2013-10-11 08:09:00 | AAPL | Stock | 17.3664 | 17.3832 | 17.3643 | 17.3786 | 69300.0 |
| 2013-10-11 08:10:00 | AAPL | Stock | 17.3646 | 17.375 | 17.3625 | 17.375 | 112700.0 |
| 2013-10-11 08:11:00 | AAPL | Stock | 17.3614 | 17.3661 | 17.35 | 17.3661 | 139216.0 |
| 2013-10-11 08:12:00 | AAPL | Stock | 17.365 | 17.3682 | 17.365 | 17.3682 | 5600.0 |
| 2013-10-11 08:13:00 | AAPL | Stock | 17.3679 | 17.3743 | 17.3629 | 17.3743 | 107660.0 |
| 2013-10-11 08:14:00 | AAPL | Stock | 17.3621 | 17.3679 | 17.3571 | 17.3607 | 112700.0 |
| 2013-10-11 08:15:00 | AAPL | Stock | 17.3607 | 17.3696 | 17.3571 | 17.3575 | 99204.0 |
| 2013-10-11 08:16:00 | AAPL | Stock | 17.3729 | 17.375 | 17.3711 | 17.375 | 53200.0 |
| 2013-10-11 08:17:00 | AAPL | Stock | 17.3736 | 17.3743 | 17.3736 | 17.3743 | 11200.0 |
> showing 50 of 977,115 rows — these rows as CSV