PREVIEW / stock_5min / 2011-12-27
file: by_date/stock_5min/2011/2011-12-27.parquet size: 4.5 MB rows: 310,014 symbols: 3,559
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-12-27 07:00:00 | AAPL | Stock | 14.4143 | 14.4143 | 14.4143 | 14.4143 | 5600.0 |
| 2011-12-27 07:05:00 | AAPL | Stock | 14.4196 | 14.4214 | 14.4196 | 14.4214 | 6300.0 |
| 2011-12-27 07:10:00 | AAPL | Stock | 14.4018 | 14.4018 | 14.4018 | 14.4018 | 2800.0 |
| 2011-12-27 07:15:00 | AAPL | Stock | 14.4036 | 14.4036 | 14.3929 | 14.3929 | 27440.0 |
| 2011-12-27 07:20:00 | AAPL | Stock | 14.4032 | 14.4179 | 14.4032 | 14.4121 | 42000.0 |
| 2011-12-27 07:35:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4043 | 14.4043 | 5600.0 |
| 2011-12-27 07:45:00 | AAPL | Stock | 14.4089 | 14.4111 | 14.4089 | 14.4111 | 24416.0 |
| 2011-12-27 07:50:00 | AAPL | Stock | 14.4046 | 14.4046 | 14.4046 | 14.4046 | 11340.0 |
| 2011-12-27 07:55:00 | AAPL | Stock | 14.395 | 14.395 | 14.3946 | 14.3946 | 5600.0 |
| 2011-12-27 08:00:00 | AAPL | Stock | 14.3936 | 14.4061 | 14.3936 | 14.4061 | 107016.0 |
| 2011-12-27 08:05:00 | AAPL | Stock | 14.4082 | 14.4393 | 14.4082 | 14.4393 | 108640.0 |
| 2011-12-27 08:10:00 | AAPL | Stock | 14.44 | 14.4611 | 14.425 | 14.4611 | 86800.0 |
| 2011-12-27 08:15:00 | AAPL | Stock | 14.46 | 14.4786 | 14.4554 | 14.4554 | 224560.0 |
| 2011-12-27 08:20:00 | AAPL | Stock | 14.4554 | 14.4554 | 14.4386 | 14.4386 | 53200.0 |
| 2011-12-27 08:25:00 | AAPL | Stock | 14.4336 | 14.44 | 14.4304 | 14.4307 | 77980.0 |
| 2011-12-27 08:30:00 | AAPL | Stock | 14.4329 | 14.4393 | 14.4325 | 14.4325 | 28000.0 |
| 2011-12-27 08:35:00 | AAPL | Stock | 14.4361 | 14.4361 | 14.4286 | 14.4286 | 112700.0 |
| 2011-12-27 08:40:00 | AAPL | Stock | 14.4246 | 14.4246 | 14.4036 | 14.4179 | 134820.0 |
| 2011-12-27 08:45:00 | AAPL | Stock | 14.4261 | 14.4261 | 14.4071 | 14.4129 | 103880.0 |
| 2011-12-27 08:50:00 | AAPL | Stock | 14.4107 | 14.4268 | 14.4107 | 14.4232 | 98504.0 |
| 2011-12-27 08:55:00 | AAPL | Stock | 14.4257 | 14.4286 | 14.4214 | 14.4268 | 107912.0 |
| 2011-12-27 09:00:00 | AAPL | Stock | 14.4232 | 14.4382 | 14.4218 | 14.4357 | 135576.0 |
| 2011-12-27 09:05:00 | AAPL | Stock | 14.4357 | 14.4357 | 14.4214 | 14.4214 | 18200.0 |
| 2011-12-27 09:10:00 | AAPL | Stock | 14.4143 | 14.4286 | 14.4143 | 14.4286 | 59752.0 |
| 2011-12-27 09:15:00 | AAPL | Stock | 14.42 | 14.42 | 14.4196 | 14.42 | 9128.0 |
| 2011-12-27 09:20:00 | AAPL | Stock | 14.42 | 14.42 | 14.4132 | 14.4143 | 39732.0 |
| 2011-12-27 09:25:00 | AAPL | Stock | 14.4186 | 14.42 | 14.4011 | 14.4011 | 279048.0 |
| 2011-12-27 09:30:00 | AAPL | Stock | 14.3964 | 14.4482 | 14.3936 | 14.4436 | 8646736.0 |
| 2011-12-27 09:35:00 | AAPL | Stock | 14.4439 | 14.4929 | 14.4429 | 14.4882 | 10893008.0 |
| 2011-12-27 09:40:00 | AAPL | Stock | 14.4882 | 14.5668 | 14.4871 | 14.5629 | 14000448.0 |
| 2011-12-27 09:45:00 | AAPL | Stock | 14.5629 | 14.6104 | 14.5304 | 14.6025 | 16675316.0 |
| 2011-12-27 09:50:00 | AAPL | Stock | 14.6004 | 14.6061 | 14.5643 | 14.5893 | 12540080.0 |
| 2011-12-27 09:55:00 | AAPL | Stock | 14.5889 | 14.5929 | 14.5646 | 14.5764 | 5356764.0 |
| 2011-12-27 10:00:00 | AAPL | Stock | 14.5746 | 14.5957 | 14.5607 | 14.5703 | 7187964.0 |
| 2011-12-27 10:05:00 | AAPL | Stock | 14.5668 | 14.5729 | 14.5575 | 14.5714 | 3702552.0 |
| 2011-12-27 10:10:00 | AAPL | Stock | 14.5675 | 14.5743 | 14.562 | 14.5704 | 2852388.0 |
| 2011-12-27 10:15:00 | AAPL | Stock | 14.5714 | 14.5732 | 14.5607 | 14.5611 | 2702672.0 |
| 2011-12-27 10:20:00 | AAPL | Stock | 14.5614 | 14.5668 | 14.5464 | 14.5561 | 3393684.0 |
| 2011-12-27 10:25:00 | AAPL | Stock | 14.5539 | 14.5561 | 14.5429 | 14.5475 | 3472364.0 |
| 2011-12-27 10:30:00 | AAPL | Stock | 14.5471 | 14.5503 | 14.5407 | 14.5421 | 2707096.0 |
| 2011-12-27 10:35:00 | AAPL | Stock | 14.5407 | 14.5589 | 14.5382 | 14.5529 | 3979780.0 |
| 2011-12-27 10:40:00 | AAPL | Stock | 14.5521 | 14.5586 | 14.5432 | 14.5432 | 2724344.0 |
| 2011-12-27 10:45:00 | AAPL | Stock | 14.5446 | 14.545 | 14.5071 | 14.5193 | 5824476.0 |
| 2011-12-27 10:50:00 | AAPL | Stock | 14.5196 | 14.5196 | 14.4846 | 14.4882 | 5267948.0 |
| 2011-12-27 10:55:00 | AAPL | Stock | 14.4882 | 14.5018 | 14.4864 | 14.5018 | 3415888.0 |
| 2011-12-27 11:00:00 | AAPL | Stock | 14.4996 | 14.5232 | 14.4993 | 14.5193 | 2611224.0 |
| 2011-12-27 11:05:00 | AAPL | Stock | 14.5214 | 14.5214 | 14.4929 | 14.4954 | 2067968.0 |
| 2011-12-27 11:10:00 | AAPL | Stock | 14.495 | 14.5146 | 14.4932 | 14.5114 | 2105236.0 |
| 2011-12-27 11:15:00 | AAPL | Stock | 14.5121 | 14.5139 | 14.505 | 14.5132 | 1396304.0 |
| 2011-12-27 11:20:00 | AAPL | Stock | 14.5125 | 14.5214 | 14.5107 | 14.5129 | 1241380.0 |
> showing 50 of 310,014 rows — these rows as CSV