PREVIEW / stock_1min / 2013-04-03
file: by_date/stock_1min/2013/2013-04-03.parquet size: 13.9 MB rows: 1,020,996 symbols: 2,827
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-03 04:00:00 | AAPL | Stock | 15.4 | 15.4 | 15.4 | 15.4 | 5488.0 |
| 2013-04-03 04:21:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 5600.0 |
| 2013-04-03 06:52:00 | AAPL | Stock | 15.4 | 15.4 | 15.4 | 15.4 | 8344.0 |
| 2013-04-03 06:57:00 | AAPL | Stock | 15.3964 | 15.3993 | 15.3964 | 15.3993 | 5600.0 |
| 2013-04-03 06:58:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 2800.0 |
| 2013-04-03 07:02:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 2800.0 |
| 2013-04-03 07:11:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 2800.0 |
| 2013-04-03 07:12:00 | AAPL | Stock | 15.3929 | 15.3932 | 15.3929 | 15.3932 | 5600.0 |
| 2013-04-03 07:13:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.3929 | 15.3929 | 2800.0 |
| 2013-04-03 07:15:00 | AAPL | Stock | 15.4018 | 15.4018 | 15.4018 | 15.4018 | 2800.0 |
| 2013-04-03 07:27:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4036 | 15.4036 | 2800.0 |
| 2013-04-03 07:33:00 | AAPL | Stock | 15.4211 | 15.4214 | 15.4211 | 15.4214 | 5600.0 |
| 2013-04-03 07:35:00 | AAPL | Stock | 15.4189 | 15.4214 | 15.4189 | 15.4214 | 5600.0 |
| 2013-04-03 07:37:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4018 | 15.4018 | 19600.0 |
| 2013-04-03 07:38:00 | AAPL | Stock | 15.4036 | 15.4036 | 15.4036 | 15.4036 | 8400.0 |
| 2013-04-03 07:43:00 | AAPL | Stock | 15.4054 | 15.4054 | 15.4054 | 15.4054 | 6720.0 |
| 2013-04-03 07:50:00 | AAPL | Stock | 15.41 | 15.4196 | 15.41 | 15.4186 | 47600.0 |
| 2013-04-03 07:51:00 | AAPL | Stock | 15.4189 | 15.4196 | 15.4189 | 15.4196 | 13300.0 |
| 2013-04-03 07:52:00 | AAPL | Stock | 15.4207 | 15.4321 | 15.4207 | 15.4321 | 36400.0 |
| 2013-04-03 07:53:00 | AAPL | Stock | 15.4321 | 15.4386 | 15.4321 | 15.4386 | 8400.0 |
| 2013-04-03 07:54:00 | AAPL | Stock | 15.4304 | 15.4386 | 15.4304 | 15.4386 | 8400.0 |
| 2013-04-03 07:55:00 | AAPL | Stock | 15.4357 | 15.4357 | 15.4357 | 15.4357 | 16800.0 |
| 2013-04-03 07:56:00 | AAPL | Stock | 15.4375 | 15.4389 | 15.4375 | 15.4375 | 33600.0 |
| 2013-04-03 07:57:00 | AAPL | Stock | 15.4425 | 15.4425 | 15.4421 | 15.4425 | 23016.0 |
| 2013-04-03 07:58:00 | AAPL | Stock | 15.4389 | 15.4389 | 15.4389 | 15.4389 | 4200.0 |
| 2013-04-03 08:00:00 | AAPL | Stock | 15.4321 | 15.4425 | 15.3982 | 15.4304 | 145348.0 |
| 2013-04-03 08:01:00 | AAPL | Stock | 15.4266 | 15.4318 | 15.4266 | 15.4318 | 8400.0 |
| 2013-04-03 08:02:00 | AAPL | Stock | 15.4314 | 15.4314 | 15.4314 | 15.4314 | 4480.0 |
| 2013-04-03 08:03:00 | AAPL | Stock | 15.4286 | 15.4318 | 15.4286 | 15.4318 | 33740.0 |
| 2013-04-03 08:04:00 | AAPL | Stock | 15.4425 | 15.4425 | 15.4421 | 15.4421 | 11200.0 |
| 2013-04-03 08:05:00 | AAPL | Stock | 15.25 | 15.4418 | 15.25 | 15.4418 | 28000.0 |
| 2013-04-03 08:06:00 | AAPL | Stock | 15.4343 | 15.4361 | 15.4214 | 15.4321 | 137620.0 |
| 2013-04-03 08:07:00 | AAPL | Stock | 15.4214 | 15.4214 | 15.4039 | 15.4039 | 42084.0 |
| 2013-04-03 08:08:00 | AAPL | Stock | 15.4107 | 15.4107 | 15.4107 | 15.4107 | 2800.0 |
| 2013-04-03 08:09:00 | AAPL | Stock | 15.4121 | 15.4121 | 15.4121 | 15.4121 | 2800.0 |
| 2013-04-03 08:10:00 | AAPL | Stock | 15.4129 | 15.4154 | 15.4121 | 15.4121 | 19404.0 |
| 2013-04-03 08:11:00 | AAPL | Stock | 15.4204 | 15.4204 | 15.4204 | 15.4204 | 2800.0 |
| 2013-04-03 08:12:00 | AAPL | Stock | 15.4186 | 15.4186 | 15.4071 | 15.4093 | 110600.0 |
| 2013-04-03 08:13:00 | AAPL | Stock | 15.4025 | 15.4118 | 15.4025 | 15.4118 | 16800.0 |
| 2013-04-03 08:14:00 | AAPL | Stock | 15.4107 | 15.4121 | 15.4107 | 15.4118 | 16128.0 |
| 2013-04-03 08:15:00 | AAPL | Stock | 15.4107 | 15.4121 | 15.3875 | 15.4036 | 106120.0 |
| 2013-04-03 08:16:00 | AAPL | Stock | 15.3971 | 15.3979 | 15.3497 | 15.3843 | 72744.0 |
| 2013-04-03 08:17:00 | AAPL | Stock | 15.3854 | 15.3854 | 15.3796 | 15.3796 | 40684.0 |
| 2013-04-03 08:18:00 | AAPL | Stock | 15.3911 | 15.3911 | 15.3825 | 15.3825 | 30800.0 |
| 2013-04-03 08:19:00 | AAPL | Stock | 15.3807 | 15.3957 | 15.3807 | 15.3957 | 25200.0 |
| 2013-04-03 08:20:00 | AAPL | Stock | 15.3936 | 15.3964 | 15.3929 | 15.3929 | 75180.0 |
| 2013-04-03 08:22:00 | AAPL | Stock | 15.4029 | 15.4118 | 15.4029 | 15.4118 | 34860.0 |
| 2013-04-03 08:23:00 | AAPL | Stock | 15.4161 | 15.4161 | 15.4157 | 15.4161 | 27328.0 |
| 2013-04-03 08:24:00 | AAPL | Stock | 15.4175 | 15.4286 | 15.4164 | 15.4164 | 21868.0 |
| 2013-04-03 08:25:00 | AAPL | Stock | 15.4018 | 15.4136 | 15.3982 | 15.4107 | 56000.0 |
> showing 50 of 1,020,996 rows — these rows as CSV