PREVIEW / stock_1min / 2013-01-04
file: by_date/stock_1min/2013/2013-01-04.parquet size: 12.8 MB rows: 950,920 symbols: 2,803
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-01-04 04:00:00 | AAPL | Stock | 19.3361 | 19.3361 | 19.3361 | 19.3361 | 5600.0 |
| 2013-01-04 04:04:00 | AAPL | Stock | 19.3714 | 19.3714 | 19.3714 | 19.3714 | 2800.0 |
| 2013-01-04 04:41:00 | AAPL | Stock | 19.3714 | 19.3714 | 19.3714 | 19.3714 | 2800.0 |
| 2013-01-04 05:25:00 | AAPL | Stock | 19.3821 | 19.3821 | 19.3821 | 19.3821 | 2800.0 |
| 2013-01-04 06:12:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3929 | 19.3929 | 5600.0 |
| 2013-01-04 07:00:00 | AAPL | Stock | 19.3875 | 19.3875 | 19.3875 | 19.3875 | 2800.0 |
| 2013-01-04 07:06:00 | AAPL | Stock | 19.4107 | 19.4296 | 19.4107 | 19.4296 | 18928.0 |
| 2013-01-04 07:07:00 | AAPL | Stock | 19.4286 | 19.4286 | 19.4286 | 19.4286 | 2800.0 |
| 2013-01-04 07:20:00 | AAPL | Stock | 19.4279 | 19.4279 | 19.4279 | 19.4279 | 2800.0 |
| 2013-01-04 07:23:00 | AAPL | Stock | 19.4168 | 19.4168 | 19.4168 | 19.4168 | 2800.0 |
| 2013-01-04 07:26:00 | AAPL | Stock | 19.4179 | 19.4179 | 19.4157 | 19.4157 | 11200.0 |
| 2013-01-04 07:27:00 | AAPL | Stock | 19.4164 | 19.4164 | 19.4164 | 19.4164 | 2800.0 |
| 2013-01-04 07:31:00 | AAPL | Stock | 19.4107 | 19.4107 | 19.4107 | 19.4107 | 21952.0 |
| 2013-01-04 07:34:00 | AAPL | Stock | 19.4143 | 19.4143 | 19.4143 | 19.4143 | 25200.0 |
| 2013-01-04 07:40:00 | AAPL | Stock | 19.4139 | 19.4139 | 19.4139 | 19.4139 | 2800.0 |
| 2013-01-04 07:42:00 | AAPL | Stock | 19.4179 | 19.4286 | 19.4171 | 19.4196 | 30800.0 |
| 2013-01-04 07:44:00 | AAPL | Stock | 19.4296 | 19.4296 | 19.4296 | 19.4296 | 2800.0 |
| 2013-01-04 07:45:00 | AAPL | Stock | 19.4182 | 19.4286 | 19.4182 | 19.4279 | 22400.0 |
| 2013-01-04 07:46:00 | AAPL | Stock | 19.4279 | 19.4364 | 19.4279 | 19.4364 | 26600.0 |
| 2013-01-04 07:47:00 | AAPL | Stock | 19.4371 | 19.4371 | 19.435 | 19.435 | 11200.0 |
| 2013-01-04 07:49:00 | AAPL | Stock | 19.4289 | 19.4289 | 19.4286 | 19.4286 | 5600.0 |
| 2013-01-04 07:51:00 | AAPL | Stock | 19.43 | 19.43 | 19.43 | 19.43 | 2800.0 |
| 2013-01-04 07:52:00 | AAPL | Stock | 19.4314 | 19.4314 | 19.4314 | 19.4314 | 2800.0 |
| 2013-01-04 07:54:00 | AAPL | Stock | 19.4321 | 19.4321 | 19.4286 | 19.4286 | 23660.0 |
| 2013-01-04 07:55:00 | AAPL | Stock | 19.4161 | 19.4314 | 19.4107 | 19.4107 | 26600.0 |
| 2013-01-04 07:56:00 | AAPL | Stock | 19.4261 | 19.4261 | 19.4232 | 19.4232 | 5600.0 |
| 2013-01-04 07:57:00 | AAPL | Stock | 19.4071 | 19.4071 | 19.4071 | 19.4071 | 5600.0 |
| 2013-01-04 08:00:00 | AAPL | Stock | 19.4071 | 19.4375 | 19.3768 | 19.3929 | 155652.0 |
| 2013-01-04 08:01:00 | AAPL | Stock | 19.3843 | 19.3843 | 19.3843 | 19.3843 | 2800.0 |
| 2013-01-04 08:02:00 | AAPL | Stock | 19.3929 | 19.3929 | 19.3921 | 19.3921 | 5600.0 |
| 2013-01-04 08:03:00 | AAPL | Stock | 19.4 | 19.4089 | 19.4 | 19.4089 | 17780.0 |
| 2013-01-04 08:04:00 | AAPL | Stock | 19.4086 | 19.4161 | 19.4086 | 19.4161 | 16800.0 |
| 2013-01-04 08:05:00 | AAPL | Stock | 19.4161 | 19.4214 | 19.4161 | 19.42 | 36372.0 |
| 2013-01-04 08:06:00 | AAPL | Stock | 19.4107 | 19.4107 | 19.4107 | 19.4107 | 2800.0 |
| 2013-01-04 08:07:00 | AAPL | Stock | 19.4157 | 19.4196 | 19.4143 | 19.4179 | 98000.0 |
| 2013-01-04 08:08:00 | AAPL | Stock | 19.4107 | 19.4196 | 19.4107 | 19.4196 | 11200.0 |
| 2013-01-04 08:09:00 | AAPL | Stock | 19.4189 | 19.4189 | 19.4161 | 19.4161 | 16856.0 |
| 2013-01-04 08:10:00 | AAPL | Stock | 19.4211 | 19.4336 | 19.4211 | 19.4321 | 31500.0 |
| 2013-01-04 08:11:00 | AAPL | Stock | 19.4332 | 19.4339 | 19.4214 | 19.4214 | 36400.0 |
| 2013-01-04 08:12:00 | AAPL | Stock | 19.4336 | 19.4336 | 19.4107 | 19.4107 | 86240.0 |
| 2013-01-04 08:13:00 | AAPL | Stock | 19.4093 | 19.4093 | 19.4093 | 19.4093 | 2800.0 |
| 2013-01-04 08:14:00 | AAPL | Stock | 19.4104 | 19.4104 | 19.4104 | 19.4104 | 2800.0 |
| 2013-01-04 08:15:00 | AAPL | Stock | 19.405 | 19.4054 | 19.4004 | 19.4004 | 22400.0 |
| 2013-01-04 08:16:00 | AAPL | Stock | 19.4054 | 19.4121 | 19.4054 | 19.4121 | 21000.0 |
| 2013-01-04 08:17:00 | AAPL | Stock | 19.4079 | 19.4121 | 19.4018 | 19.4121 | 71400.0 |
| 2013-01-04 08:20:00 | AAPL | Stock | 19.4143 | 19.4279 | 19.4139 | 19.4146 | 19600.0 |
| 2013-01-04 08:21:00 | AAPL | Stock | 19.4243 | 19.425 | 19.4243 | 19.4243 | 29960.0 |
| 2013-01-04 08:22:00 | AAPL | Stock | 19.4243 | 19.4254 | 19.4214 | 19.4214 | 47600.0 |
| 2013-01-04 08:23:00 | AAPL | Stock | 19.4214 | 19.4243 | 19.4214 | 19.4243 | 13440.0 |
| 2013-01-04 08:24:00 | AAPL | Stock | 19.4207 | 19.4257 | 19.4207 | 19.4257 | 30800.0 |
> showing 50 of 950,920 rows — these rows as CSV