PREVIEW / stock_5min / 2010-12-09
file: by_date/stock_5min/2010/2010-12-09.parquet size: 4.8 MB rows: 330,423 symbols: 3,519
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-12-09 04:00:00 | AAPL | Stock | 11.4821 | 11.4821 | 11.4821 | 11.4821 | 2800.0 |
| 2010-12-09 04:15:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 2800.0 |
| 2010-12-09 04:40:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 30800.0 |
| 2010-12-09 04:45:00 | AAPL | Stock | 11.4493 | 11.4493 | 11.4493 | 11.4493 | 2800.0 |
| 2010-12-09 05:15:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 5600.0 |
| 2010-12-09 05:25:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 8400.0 |
| 2010-12-09 05:30:00 | AAPL | Stock | 11.4589 | 11.46 | 11.4589 | 11.46 | 9184.0 |
| 2010-12-09 05:35:00 | AAPL | Stock | 11.4632 | 11.4632 | 11.4632 | 11.4632 | 5600.0 |
| 2010-12-09 05:40:00 | AAPL | Stock | 11.4632 | 11.4632 | 11.4632 | 11.4632 | 11200.0 |
| 2010-12-09 05:45:00 | AAPL | Stock | 11.4607 | 11.4607 | 11.4607 | 11.4607 | 5600.0 |
| 2010-12-09 05:55:00 | AAPL | Stock | 11.4539 | 11.4607 | 11.4539 | 11.4607 | 18060.0 |
| 2010-12-09 06:00:00 | AAPL | Stock | 11.4679 | 11.4679 | 11.4679 | 11.4679 | 56000.0 |
| 2010-12-09 06:05:00 | AAPL | Stock | 11.475 | 11.475 | 11.475 | 11.475 | 2800.0 |
| 2010-12-09 06:10:00 | AAPL | Stock | 11.475 | 11.475 | 11.4679 | 11.4679 | 14000.0 |
| 2010-12-09 06:20:00 | AAPL | Stock | 11.4486 | 11.4604 | 11.4486 | 11.4554 | 56000.0 |
| 2010-12-09 06:30:00 | AAPL | Stock | 11.4675 | 11.4675 | 11.4675 | 11.4675 | 5600.0 |
| 2010-12-09 06:50:00 | AAPL | Stock | 11.4732 | 11.4732 | 11.4732 | 11.4732 | 2800.0 |
| 2010-12-09 06:55:00 | AAPL | Stock | 11.4743 | 11.4743 | 11.4743 | 11.4743 | 2800.0 |
| 2010-12-09 07:00:00 | AAPL | Stock | 11.4821 | 11.4821 | 11.4818 | 11.4818 | 8400.0 |
| 2010-12-09 07:05:00 | AAPL | Stock | 11.4889 | 11.4889 | 11.4889 | 11.4889 | 2800.0 |
| 2010-12-09 07:10:00 | AAPL | Stock | 11.4893 | 11.4975 | 11.4893 | 11.4975 | 39200.0 |
| 2010-12-09 07:15:00 | AAPL | Stock | 11.5 | 11.5 | 11.4932 | 11.4932 | 22092.0 |
| 2010-12-09 07:20:00 | AAPL | Stock | 11.5057 | 11.5179 | 11.5057 | 11.5179 | 35840.0 |
| 2010-12-09 07:25:00 | AAPL | Stock | 11.5179 | 11.53 | 11.5125 | 11.5125 | 100800.0 |
| 2010-12-09 07:35:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5036 | 11.5036 | 113120.0 |
| 2010-12-09 07:40:00 | AAPL | Stock | 11.5089 | 11.5171 | 11.5089 | 11.515 | 19600.0 |
| 2010-12-09 07:45:00 | AAPL | Stock | 11.5089 | 11.5089 | 11.5089 | 11.5089 | 2800.0 |
| 2010-12-09 07:50:00 | AAPL | Stock | 11.5143 | 11.5161 | 11.5043 | 11.5161 | 44800.0 |
| 2010-12-09 07:55:00 | AAPL | Stock | 11.5107 | 11.5107 | 11.5104 | 11.5107 | 39200.0 |
| 2010-12-09 08:00:00 | AAPL | Stock | 11.5054 | 11.5125 | 11.4964 | 11.5 | 271684.0 |
| 2010-12-09 08:05:00 | AAPL | Stock | 11.5 | 11.5086 | 11.4996 | 11.5054 | 75068.0 |
| 2010-12-09 08:10:00 | AAPL | Stock | 11.5039 | 11.5132 | 11.5036 | 11.5111 | 413224.0 |
| 2010-12-09 08:15:00 | AAPL | Stock | 11.5111 | 11.5111 | 11.5032 | 11.5089 | 115808.0 |
| 2010-12-09 08:20:00 | AAPL | Stock | 11.5075 | 11.5089 | 11.5025 | 11.5032 | 550340.0 |
| 2010-12-09 08:25:00 | AAPL | Stock | 11.5032 | 11.5071 | 11.4996 | 11.5043 | 352912.0 |
| 2010-12-09 08:30:00 | AAPL | Stock | 11.5071 | 11.5236 | 11.5043 | 11.5214 | 614012.0 |
| 2010-12-09 08:35:00 | AAPL | Stock | 11.5211 | 11.5282 | 11.5196 | 11.5282 | 791728.0 |
| 2010-12-09 08:40:00 | AAPL | Stock | 11.5279 | 11.5293 | 11.5207 | 11.525 | 666008.0 |
| 2010-12-09 08:45:00 | AAPL | Stock | 11.5229 | 11.5257 | 11.5229 | 11.5243 | 55580.0 |
| 2010-12-09 08:50:00 | AAPL | Stock | 11.5211 | 11.5239 | 11.5207 | 11.5211 | 44800.0 |
| 2010-12-09 08:55:00 | AAPL | Stock | 11.5236 | 11.5268 | 11.52 | 11.5268 | 213780.0 |
| 2010-12-09 09:00:00 | AAPL | Stock | 11.5268 | 11.5286 | 11.5232 | 11.5282 | 299040.0 |
| 2010-12-09 09:05:00 | AAPL | Stock | 11.5282 | 11.5314 | 11.5264 | 11.5286 | 566384.0 |
| 2010-12-09 09:10:00 | AAPL | Stock | 11.5282 | 11.5321 | 11.5204 | 11.5261 | 280224.0 |
| 2010-12-09 09:15:00 | AAPL | Stock | 11.5232 | 11.5286 | 11.5218 | 11.5218 | 267008.0 |
| 2010-12-09 09:20:00 | AAPL | Stock | 11.525 | 11.5254 | 11.5179 | 11.5229 | 164360.0 |
| 2010-12-09 09:25:00 | AAPL | Stock | 11.5204 | 11.5254 | 11.5039 | 11.5046 | 277788.0 |
| 2010-12-09 09:30:00 | AAPL | Stock | 11.5061 | 11.5179 | 11.4618 | 11.4646 | 14486164.0 |
| 2010-12-09 09:35:00 | AAPL | Stock | 11.465 | 11.465 | 11.4396 | 11.44 | 11285820.0 |
| 2010-12-09 09:40:00 | AAPL | Stock | 11.4429 | 11.4686 | 11.4364 | 11.4564 | 8431752.0 |
> showing 50 of 330,423 rows — these rows as CSV