PREVIEW / stock_5min / 2011-05-09
file: by_date/stock_5min/2011/2011-05-09.parquet size: 4.8 MB rows: 328,290 symbols: 3,561
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-09 04:00:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 2800.0 |
| 2011-05-09 04:15:00 | AAPL | Stock | 12.4575 | 12.4575 | 12.4575 | 12.4575 | 7000.0 |
| 2011-05-09 05:45:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 2800.0 |
| 2011-05-09 06:05:00 | AAPL | Stock | 12.455 | 12.455 | 12.455 | 12.455 | 2800.0 |
| 2011-05-09 06:25:00 | AAPL | Stock | 12.4218 | 12.4218 | 12.4214 | 12.4214 | 5600.0 |
| 2011-05-09 06:30:00 | AAPL | Stock | 12.4214 | 12.4214 | 12.4214 | 12.4214 | 2800.0 |
| 2011-05-09 06:40:00 | AAPL | Stock | 12.4036 | 12.4036 | 12.4036 | 12.4036 | 11200.0 |
| 2011-05-09 06:45:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 10500.0 |
| 2011-05-09 06:50:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 5600.0 |
| 2011-05-09 06:55:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 2800.0 |
| 2011-05-09 07:00:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 5600.0 |
| 2011-05-09 07:05:00 | AAPL | Stock | 12.4007 | 12.4036 | 12.4007 | 12.4036 | 11200.0 |
| 2011-05-09 07:10:00 | AAPL | Stock | 12.4039 | 12.4107 | 12.4018 | 12.4036 | 30800.0 |
| 2011-05-09 07:15:00 | AAPL | Stock | 12.4071 | 12.4179 | 12.4071 | 12.4179 | 9380.0 |
| 2011-05-09 07:20:00 | AAPL | Stock | 12.4211 | 12.4214 | 12.4164 | 12.4164 | 15400.0 |
| 2011-05-09 07:30:00 | AAPL | Stock | 12.4286 | 12.4357 | 12.4286 | 12.4357 | 27440.0 |
| 2011-05-09 07:35:00 | AAPL | Stock | 12.4357 | 12.4393 | 12.4179 | 12.4221 | 120176.0 |
| 2011-05-09 07:40:00 | AAPL | Stock | 12.4221 | 12.4329 | 12.4221 | 12.4329 | 45220.0 |
| 2011-05-09 07:45:00 | AAPL | Stock | 12.4336 | 12.4389 | 12.4336 | 12.4389 | 39200.0 |
| 2011-05-09 07:50:00 | AAPL | Stock | 12.4343 | 12.4343 | 12.4343 | 12.4343 | 5600.0 |
| 2011-05-09 07:55:00 | AAPL | Stock | 12.4343 | 12.4368 | 12.4304 | 12.4304 | 33600.0 |
| 2011-05-09 08:00:00 | AAPL | Stock | 12.4368 | 12.4375 | 12.4236 | 12.4236 | 183988.0 |
| 2011-05-09 08:05:00 | AAPL | Stock | 12.4282 | 12.4339 | 12.4282 | 12.4339 | 113960.0 |
| 2011-05-09 08:10:00 | AAPL | Stock | 12.4339 | 12.4454 | 12.4339 | 12.4411 | 109284.0 |
| 2011-05-09 08:15:00 | AAPL | Stock | 12.4393 | 12.4429 | 12.4361 | 12.4375 | 63392.0 |
| 2011-05-09 08:20:00 | AAPL | Stock | 12.4361 | 12.4361 | 12.4268 | 12.4304 | 91980.0 |
| 2011-05-09 08:25:00 | AAPL | Stock | 12.425 | 12.425 | 12.4104 | 12.4229 | 140756.0 |
| 2011-05-09 08:30:00 | AAPL | Stock | 12.4143 | 12.4143 | 12.4143 | 12.4143 | 2800.0 |
| 2011-05-09 08:35:00 | AAPL | Stock | 12.4182 | 12.4186 | 12.4143 | 12.4186 | 31500.0 |
| 2011-05-09 08:40:00 | AAPL | Stock | 12.4132 | 12.4146 | 12.4132 | 12.4143 | 55580.0 |
| 2011-05-09 08:45:00 | AAPL | Stock | 12.4175 | 12.4175 | 12.4143 | 12.4143 | 15400.0 |
| 2011-05-09 08:50:00 | AAPL | Stock | 12.4079 | 12.4079 | 12.3968 | 12.4064 | 116760.0 |
| 2011-05-09 08:55:00 | AAPL | Stock | 12.395 | 12.4046 | 12.395 | 12.3982 | 63028.0 |
| 2011-05-09 09:00:00 | AAPL | Stock | 12.4032 | 12.4164 | 12.3964 | 12.4086 | 100408.0 |
| 2011-05-09 09:05:00 | AAPL | Stock | 12.4089 | 12.4182 | 12.3975 | 12.4182 | 75796.0 |
| 2011-05-09 09:10:00 | AAPL | Stock | 12.4182 | 12.4182 | 12.4107 | 12.4107 | 86660.0 |
| 2011-05-09 09:15:00 | AAPL | Stock | 12.4107 | 12.4125 | 12.4089 | 12.4125 | 71400.0 |
| 2011-05-09 09:20:00 | AAPL | Stock | 12.4161 | 12.4171 | 12.4161 | 12.4161 | 34580.0 |
| 2011-05-09 09:25:00 | AAPL | Stock | 12.4193 | 12.4275 | 12.4143 | 12.4236 | 443660.0 |
| 2011-05-09 09:30:00 | AAPL | Stock | 12.4221 | 12.4682 | 12.4089 | 12.4668 | 11333476.0 |
| 2011-05-09 09:35:00 | AAPL | Stock | 12.4679 | 12.4714 | 12.4315 | 12.433 | 9721824.0 |
| 2011-05-09 09:40:00 | AAPL | Stock | 12.435 | 12.4371 | 12.4214 | 12.4329 | 5022612.0 |
| 2011-05-09 09:45:00 | AAPL | Stock | 12.4332 | 12.4386 | 12.4018 | 12.41 | 6475252.0 |
| 2011-05-09 09:50:00 | AAPL | Stock | 12.4101 | 12.4243 | 12.4039 | 12.4136 | 4312812.0 |
| 2011-05-09 09:55:00 | AAPL | Stock | 12.415 | 12.4268 | 12.3964 | 12.4114 | 3271632.0 |
| 2011-05-09 10:00:00 | AAPL | Stock | 12.4114 | 12.4351 | 12.4057 | 12.4277 | 4384800.0 |
| 2011-05-09 10:05:00 | AAPL | Stock | 12.4279 | 12.4339 | 12.42 | 12.4286 | 2612512.0 |
| 2011-05-09 10:10:00 | AAPL | Stock | 12.4275 | 12.4357 | 12.4232 | 12.4277 | 3223948.0 |
| 2011-05-09 10:15:00 | AAPL | Stock | 12.4279 | 12.4375 | 12.4057 | 12.4118 | 3715544.0 |
| 2011-05-09 10:20:00 | AAPL | Stock | 12.4079 | 12.4132 | 12.376 | 12.4021 | 6333824.0 |
> showing 50 of 328,290 rows — these rows as CSV