PREVIEW / stock_1min / 2013-04-30
file: by_date/stock_1min/2013/2013-04-30.parquet size: 13.5 MB rows: 993,616 symbols: 2,828
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-04-30 04:03:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 11340.0 |
| 2013-04-30 04:04:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 11200.0 |
| 2013-04-30 04:07:00 | AAPL | Stock | 15.3575 | 15.3575 | 15.3575 | 15.3575 | 13916.0 |
| 2013-04-30 04:40:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 11200.0 |
| 2013-04-30 04:46:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 2800.0 |
| 2013-04-30 04:47:00 | AAPL | Stock | 15.4196 | 15.4196 | 15.4196 | 15.4196 | 2800.0 |
| 2013-04-30 05:49:00 | AAPL | Stock | 15.4268 | 15.4268 | 15.4268 | 15.4268 | 2800.0 |
| 2013-04-30 06:10:00 | AAPL | Stock | 15.4496 | 15.4521 | 15.4496 | 15.4521 | 7000.0 |
| 2013-04-30 06:17:00 | AAPL | Stock | 15.4304 | 15.4304 | 15.4304 | 15.4304 | 2800.0 |
| 2013-04-30 06:52:00 | AAPL | Stock | 15.4289 | 15.4289 | 15.4289 | 15.4289 | 2800.0 |
| 2013-04-30 06:55:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4214 | 15.4214 | 2800.0 |
| 2013-04-30 06:57:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4214 | 15.4214 | 2800.0 |
| 2013-04-30 06:59:00 | AAPL | Stock | 15.4186 | 15.4214 | 15.4186 | 15.4214 | 5600.0 |
| 2013-04-30 07:00:00 | AAPL | Stock | 15.4186 | 15.4186 | 15.4096 | 15.4096 | 12880.0 |
| 2013-04-30 07:01:00 | AAPL | Stock | 15.4186 | 15.4186 | 15.4186 | 15.4186 | 2800.0 |
| 2013-04-30 07:03:00 | AAPL | Stock | 15.4186 | 15.4186 | 15.4186 | 15.4186 | 6384.0 |
| 2013-04-30 07:05:00 | AAPL | Stock | 15.4186 | 15.4282 | 15.4025 | 15.4282 | 22092.0 |
| 2013-04-30 07:06:00 | AAPL | Stock | 15.4279 | 15.4286 | 15.4154 | 15.4154 | 11200.0 |
| 2013-04-30 07:07:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4214 | 15.4214 | 2800.0 |
| 2013-04-30 07:08:00 | AAPL | Stock | 15.4121 | 15.4154 | 15.4121 | 15.4154 | 6580.0 |
| 2013-04-30 07:11:00 | AAPL | Stock | 15.4129 | 15.4129 | 15.4025 | 15.4025 | 25200.0 |
| 2013-04-30 07:13:00 | AAPL | Stock | 15.3993 | 15.3993 | 15.3929 | 15.3929 | 14000.0 |
| 2013-04-30 07:16:00 | AAPL | Stock | 15.3971 | 15.4018 | 15.3971 | 15.4018 | 5936.0 |
| 2013-04-30 07:17:00 | AAPL | Stock | 15.4018 | 15.4018 | 15.4018 | 15.4018 | 2800.0 |
| 2013-04-30 07:18:00 | AAPL | Stock | 15.4071 | 15.4214 | 15.4036 | 15.4214 | 39564.0 |
| 2013-04-30 07:19:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.3886 | 15.3886 | 22400.0 |
| 2013-04-30 07:20:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 2800.0 |
| 2013-04-30 07:21:00 | AAPL | Stock | 15.4032 | 15.4032 | 15.4032 | 15.4032 | 2800.0 |
| 2013-04-30 07:22:00 | AAPL | Stock | 15.3932 | 15.3932 | 15.3932 | 15.3932 | 2800.0 |
| 2013-04-30 07:26:00 | AAPL | Stock | 15.4021 | 15.4021 | 15.4021 | 15.4021 | 2800.0 |
| 2013-04-30 07:30:00 | AAPL | Stock | 15.3996 | 15.4018 | 15.3996 | 15.4018 | 25816.0 |
| 2013-04-30 07:33:00 | AAPL | Stock | 15.4032 | 15.4104 | 15.4032 | 15.4104 | 14000.0 |
| 2013-04-30 07:34:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4214 | 15.4214 | 5600.0 |
| 2013-04-30 07:36:00 | AAPL | Stock | 15.4146 | 15.4186 | 15.4146 | 15.4179 | 19600.0 |
| 2013-04-30 07:37:00 | AAPL | Stock | 15.4132 | 15.4132 | 15.4132 | 15.4132 | 2800.0 |
| 2013-04-30 07:40:00 | AAPL | Stock | 15.4114 | 15.4114 | 15.4107 | 15.4107 | 12516.0 |
| 2013-04-30 07:51:00 | AAPL | Stock | 15.4071 | 15.4125 | 15.4071 | 15.4125 | 30828.0 |
| 2013-04-30 07:54:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 2800.0 |
| 2013-04-30 07:55:00 | AAPL | Stock | 15.4039 | 15.4039 | 15.4036 | 15.4036 | 8400.0 |
| 2013-04-30 07:58:00 | AAPL | Stock | 15.4071 | 15.4079 | 15.4071 | 15.4079 | 11200.0 |
| 2013-04-30 07:59:00 | AAPL | Stock | 15.4061 | 15.4061 | 15.405 | 15.405 | 5600.0 |
| 2013-04-30 08:00:00 | AAPL | Stock | 15.3986 | 15.4214 | 15.3929 | 15.4032 | 176288.0 |
| 2013-04-30 08:01:00 | AAPL | Stock | 15.3907 | 15.3971 | 15.3907 | 15.3971 | 16800.0 |
| 2013-04-30 08:02:00 | AAPL | Stock | 15.4018 | 15.405 | 15.3975 | 15.405 | 39144.0 |
| 2013-04-30 08:03:00 | AAPL | Stock | 15.4 | 15.4039 | 15.4 | 15.4025 | 21000.0 |
| 2013-04-30 08:04:00 | AAPL | Stock | 15.4 | 15.4029 | 15.3861 | 15.4025 | 119672.0 |
| 2013-04-30 08:05:00 | AAPL | Stock | 15.3943 | 15.3943 | 15.3943 | 15.3943 | 4200.0 |
| 2013-04-30 08:06:00 | AAPL | Stock | 15.3943 | 15.4011 | 15.3943 | 15.4011 | 22400.0 |
| 2013-04-30 08:07:00 | AAPL | Stock | 15.3986 | 15.3986 | 15.3929 | 15.3929 | 25116.0 |
| 2013-04-30 08:08:00 | AAPL | Stock | 15.3918 | 15.3918 | 15.3918 | 15.3918 | 4200.0 |
> showing 50 of 993,616 rows — these rows as CSV