PREVIEW / stock_5min / 2007-01-16
file: by_date/stock_5min/2007/2007-01-16.parquet size: 3.4 MB rows: 246,274 symbols: 2,509
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-16 04:15:00 | AAPL | Stock | 3.4114 | 3.4114 | 3.4114 | 3.4114 | 11200.0 |
| 2007-01-16 05:35:00 | AAPL | Stock | 3.4175 | 3.4257 | 3.4175 | 3.4257 | 5600.0 |
| 2007-01-16 05:40:00 | AAPL | Stock | 3.4214 | 3.4214 | 3.4214 | 3.4214 | 2800.0 |
| 2007-01-16 05:55:00 | AAPL | Stock | 3.4046 | 3.4046 | 3.4018 | 3.4018 | 14000.0 |
| 2007-01-16 06:05:00 | AAPL | Stock | 3.4229 | 3.4229 | 3.4229 | 3.4229 | 2800.0 |
| 2007-01-16 06:25:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4143 | 3.4143 | 5600.0 |
| 2007-01-16 06:50:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 8400.0 |
| 2007-01-16 06:55:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 8400.0 |
| 2007-01-16 07:00:00 | AAPL | Stock | 3.4179 | 3.4179 | 3.4071 | 3.4089 | 53200.0 |
| 2007-01-16 07:05:00 | AAPL | Stock | 3.4089 | 3.4089 | 3.4071 | 3.4071 | 44800.0 |
| 2007-01-16 07:15:00 | AAPL | Stock | 3.4089 | 3.4089 | 3.4089 | 3.4089 | 14000.0 |
| 2007-01-16 07:20:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4107 | 3.4107 | 11200.0 |
| 2007-01-16 07:25:00 | AAPL | Stock | 3.4143 | 3.4171 | 3.4143 | 3.4171 | 84000.0 |
| 2007-01-16 07:30:00 | AAPL | Stock | 3.4143 | 3.4143 | 3.4143 | 3.4143 | 14000.0 |
| 2007-01-16 07:35:00 | AAPL | Stock | 3.4179 | 3.4232 | 3.4179 | 3.4225 | 610400.0 |
| 2007-01-16 07:40:00 | AAPL | Stock | 3.4214 | 3.4214 | 3.4143 | 3.4196 | 246400.0 |
| 2007-01-16 07:45:00 | AAPL | Stock | 3.4154 | 3.4154 | 3.4143 | 3.4143 | 42000.0 |
| 2007-01-16 07:50:00 | AAPL | Stock | 3.4146 | 3.4146 | 3.4143 | 3.4143 | 144480.0 |
| 2007-01-16 07:55:00 | AAPL | Stock | 3.4129 | 3.4129 | 3.4071 | 3.4071 | 254772.0 |
| 2007-01-16 08:00:00 | AAPL | Stock | 3.4157 | 3.4193 | 3.4075 | 3.4114 | 1248072.0 |
| 2007-01-16 08:05:00 | AAPL | Stock | 3.4132 | 3.4175 | 3.4107 | 3.4175 | 817376.0 |
| 2007-01-16 08:10:00 | AAPL | Stock | 3.4161 | 3.4196 | 3.4125 | 3.4171 | 1027684.0 |
| 2007-01-16 08:15:00 | AAPL | Stock | 3.4171 | 3.4214 | 3.4161 | 3.4196 | 1279124.0 |
| 2007-01-16 08:20:00 | AAPL | Stock | 3.4196 | 3.4214 | 3.4196 | 3.42 | 762524.0 |
| 2007-01-16 08:25:00 | AAPL | Stock | 3.4214 | 3.4236 | 3.4204 | 3.4204 | 619668.0 |
| 2007-01-16 08:30:00 | AAPL | Stock | 3.4207 | 3.4214 | 3.4161 | 3.4161 | 808640.0 |
| 2007-01-16 08:35:00 | AAPL | Stock | 3.4164 | 3.4179 | 3.4146 | 3.4175 | 245560.0 |
| 2007-01-16 08:40:00 | AAPL | Stock | 3.4179 | 3.4204 | 3.4164 | 3.4164 | 536228.0 |
| 2007-01-16 08:45:00 | AAPL | Stock | 3.4161 | 3.4179 | 3.4143 | 3.4175 | 220976.0 |
| 2007-01-16 08:50:00 | AAPL | Stock | 3.4161 | 3.4161 | 3.4125 | 3.4125 | 646044.0 |
| 2007-01-16 08:55:00 | AAPL | Stock | 3.4125 | 3.4157 | 3.4107 | 3.4125 | 617708.0 |
| 2007-01-16 09:00:00 | AAPL | Stock | 3.4114 | 3.4154 | 3.4086 | 3.41 | 586684.0 |
| 2007-01-16 09:05:00 | AAPL | Stock | 3.41 | 3.41 | 3.4046 | 3.4057 | 895608.0 |
| 2007-01-16 09:10:00 | AAPL | Stock | 3.4064 | 3.4096 | 3.4057 | 3.4096 | 605304.0 |
| 2007-01-16 09:15:00 | AAPL | Stock | 3.4104 | 3.4104 | 3.4064 | 3.4071 | 585592.0 |
| 2007-01-16 09:20:00 | AAPL | Stock | 3.4071 | 3.4093 | 3.4061 | 3.4086 | 953932.0 |
| 2007-01-16 09:25:00 | AAPL | Stock | 3.4086 | 3.4193 | 3.4068 | 3.4175 | 9177700.0 |
| 2007-01-16 09:30:00 | AAPL | Stock | 3.4171 | 3.4325 | 3.4089 | 3.4279 | 61474336.0 |
| 2007-01-16 09:35:00 | AAPL | Stock | 3.4275 | 3.4304 | 3.4154 | 3.4164 | 30479540.0 |
| 2007-01-16 09:40:00 | AAPL | Stock | 3.4161 | 3.435 | 3.4107 | 3.4321 | 38802596.0 |
| 2007-01-16 09:45:00 | AAPL | Stock | 3.4321 | 3.4379 | 3.425 | 3.4304 | 30226168.0 |
| 2007-01-16 09:50:00 | AAPL | Stock | 3.4304 | 3.4418 | 3.4268 | 3.4382 | 27495916.0 |
| 2007-01-16 09:55:00 | AAPL | Stock | 3.4382 | 3.4482 | 3.4379 | 3.4389 | 36484056.0 |
| 2007-01-16 10:00:00 | AAPL | Stock | 3.4382 | 3.44 | 3.4257 | 3.4268 | 36542772.0 |
| 2007-01-16 10:05:00 | AAPL | Stock | 3.4261 | 3.4296 | 3.4214 | 3.4268 | 26732944.0 |
| 2007-01-16 10:10:00 | AAPL | Stock | 3.4271 | 3.4286 | 3.4225 | 3.4282 | 22906044.0 |
| 2007-01-16 10:15:00 | AAPL | Stock | 3.4285 | 3.4332 | 3.4196 | 3.4282 | 38510780.0 |
| 2007-01-16 10:20:00 | AAPL | Stock | 3.4282 | 3.4304 | 3.4171 | 3.4279 | 17381028.0 |
| 2007-01-16 10:25:00 | AAPL | Stock | 3.4282 | 3.4375 | 3.4243 | 3.4339 | 21009968.0 |
| 2007-01-16 10:30:00 | AAPL | Stock | 3.4339 | 3.4411 | 3.4332 | 3.4368 | 18994136.0 |
> showing 50 of 246,274 rows — these rows as CSV