PREVIEW / stock_5min / 2010-09-14
file: by_date/stock_5min/2010/2010-09-14.parquet size: 4.7 MB rows: 321,461 symbols: 3,468
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 |
|---|---|---|---|---|---|---|---|
| 2010-09-14 07:00:00 | AAPL | Stock | 9.5021 | 9.5021 | 9.5 | 9.5018 | 16800.0 |
| 2010-09-14 07:05:00 | AAPL | Stock | 9.5193 | 9.5193 | 9.5193 | 9.5193 | 8400.0 |
| 2010-09-14 07:10:00 | AAPL | Stock | 9.5193 | 9.5196 | 9.5193 | 9.5196 | 11200.0 |
| 2010-09-14 07:15:00 | AAPL | Stock | 9.5196 | 9.5196 | 9.5196 | 9.5196 | 8400.0 |
| 2010-09-14 07:20:00 | AAPL | Stock | 9.5104 | 9.5104 | 9.5104 | 9.5104 | 4200.0 |
| 2010-09-14 07:25:00 | AAPL | Stock | 9.5036 | 9.51 | 9.5018 | 9.51 | 39200.0 |
| 2010-09-14 07:30:00 | AAPL | Stock | 9.5007 | 9.5007 | 9.5004 | 9.5004 | 8400.0 |
| 2010-09-14 07:35:00 | AAPL | Stock | 9.4911 | 9.4911 | 9.4911 | 9.4911 | 2800.0 |
| 2010-09-14 07:40:00 | AAPL | Stock | 9.5014 | 9.5036 | 9.5014 | 9.5036 | 20300.0 |
| 2010-09-14 07:50:00 | AAPL | Stock | 9.5057 | 9.5057 | 9.5004 | 9.5004 | 16800.0 |
| 2010-09-14 07:55:00 | AAPL | Stock | 9.5089 | 9.5089 | 9.5089 | 9.5089 | 3696.0 |
| 2010-09-14 08:00:00 | AAPL | Stock | 9.5107 | 9.5304 | 9.5018 | 9.525 | 191240.0 |
| 2010-09-14 08:05:00 | AAPL | Stock | 9.5239 | 9.525 | 9.5232 | 9.5232 | 61600.0 |
| 2010-09-14 08:10:00 | AAPL | Stock | 9.5207 | 9.5321 | 9.5207 | 9.5321 | 51800.0 |
| 2010-09-14 08:15:00 | AAPL | Stock | 9.5279 | 9.53 | 9.5279 | 9.53 | 34720.0 |
| 2010-09-14 08:20:00 | AAPL | Stock | 9.5282 | 9.5318 | 9.5279 | 9.5314 | 54600.0 |
| 2010-09-14 08:25:00 | AAPL | Stock | 9.5318 | 9.5411 | 9.5318 | 9.5411 | 220220.0 |
| 2010-09-14 08:30:00 | AAPL | Stock | 9.5411 | 9.5571 | 9.5339 | 9.5464 | 476392.0 |
| 2010-09-14 08:35:00 | AAPL | Stock | 9.5432 | 9.5471 | 9.5318 | 9.5339 | 176120.0 |
| 2010-09-14 08:40:00 | AAPL | Stock | 9.5332 | 9.5332 | 9.5264 | 9.5268 | 196140.0 |
| 2010-09-14 08:45:00 | AAPL | Stock | 9.5236 | 9.5307 | 9.5218 | 9.53 | 139944.0 |
| 2010-09-14 08:50:00 | AAPL | Stock | 9.5268 | 9.5304 | 9.5232 | 9.525 | 123956.0 |
| 2010-09-14 08:55:00 | AAPL | Stock | 9.5275 | 9.5275 | 9.5175 | 9.5175 | 98000.0 |
| 2010-09-14 09:00:00 | AAPL | Stock | 9.515 | 9.5207 | 9.5093 | 9.5196 | 106400.0 |
| 2010-09-14 09:05:00 | AAPL | Stock | 9.5196 | 9.5211 | 9.5143 | 9.5171 | 178136.0 |
| 2010-09-14 09:10:00 | AAPL | Stock | 9.5139 | 9.5161 | 9.5079 | 9.5107 | 135660.0 |
| 2010-09-14 09:15:00 | AAPL | Stock | 9.5107 | 9.5139 | 9.5096 | 9.5129 | 174300.0 |
| 2010-09-14 09:20:00 | AAPL | Stock | 9.5129 | 9.5154 | 9.5039 | 9.5089 | 107940.0 |
| 2010-09-14 09:25:00 | AAPL | Stock | 9.51 | 9.5125 | 9.5039 | 9.5071 | 139608.0 |
| 2010-09-14 09:30:00 | AAPL | Stock | 9.5068 | 9.5339 | 9.5046 | 9.5057 | 14732172.0 |
| 2010-09-14 09:35:00 | AAPL | Stock | 9.5057 | 9.5243 | 9.4829 | 9.5186 | 13710396.0 |
| 2010-09-14 09:40:00 | AAPL | Stock | 9.5182 | 9.5275 | 9.51 | 9.5164 | 11214924.0 |
| 2010-09-14 09:45:00 | AAPL | Stock | 9.5171 | 9.5446 | 9.5171 | 9.5364 | 14327236.0 |
| 2010-09-14 09:50:00 | AAPL | Stock | 9.5364 | 9.555 | 9.5321 | 9.5475 | 10843924.0 |
| 2010-09-14 09:55:00 | AAPL | Stock | 9.5486 | 9.5596 | 9.5436 | 9.5561 | 6121444.0 |
| 2010-09-14 10:00:00 | AAPL | Stock | 9.5568 | 9.5604 | 9.5357 | 9.5514 | 9637740.0 |
| 2010-09-14 10:05:00 | AAPL | Stock | 9.5518 | 9.5529 | 9.5214 | 9.5275 | 8595300.0 |
| 2010-09-14 10:10:00 | AAPL | Stock | 9.5282 | 9.5321 | 9.5179 | 9.5179 | 5367992.0 |
| 2010-09-14 10:15:00 | AAPL | Stock | 9.5179 | 9.5446 | 9.5179 | 9.5446 | 5099556.0 |
| 2010-09-14 10:20:00 | AAPL | Stock | 9.545 | 9.5468 | 9.5332 | 9.5393 | 4771424.0 |
| 2010-09-14 10:25:00 | AAPL | Stock | 9.5389 | 9.5561 | 9.5379 | 9.5504 | 5781132.0 |
| 2010-09-14 10:30:00 | AAPL | Stock | 9.5482 | 9.5621 | 9.5446 | 9.5511 | 8002400.0 |
| 2010-09-14 10:35:00 | AAPL | Stock | 9.5511 | 9.5557 | 9.54 | 9.5407 | 3660524.0 |
| 2010-09-14 10:40:00 | AAPL | Stock | 9.5414 | 9.5571 | 9.54 | 9.5507 | 2674756.0 |
| 2010-09-14 10:45:00 | AAPL | Stock | 9.5514 | 9.5761 | 9.5484 | 9.5732 | 10341940.0 |
| 2010-09-14 10:50:00 | AAPL | Stock | 9.5732 | 9.5747 | 9.565 | 9.5704 | 5055316.0 |
| 2010-09-14 10:55:00 | AAPL | Stock | 9.5693 | 9.5725 | 9.5657 | 9.5689 | 3295796.0 |
| 2010-09-14 11:00:00 | AAPL | Stock | 9.5696 | 9.5804 | 9.5671 | 9.5718 | 6348720.0 |
| 2010-09-14 11:05:00 | AAPL | Stock | 9.5739 | 9.5864 | 9.5704 | 9.5864 | 5329044.0 |
| 2010-09-14 11:10:00 | AAPL | Stock | 9.5854 | 9.5911 | 9.58 | 9.59 | 6018544.0 |
> showing 50 of 321,461 rows — these rows as CSV