PREVIEW / stock_5min / 2011-05-05
file: by_date/stock_5min/2011/2011-05-05.parquet size: 5.1 MB rows: 340,742 symbols: 3,556
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-05 04:35:00 | AAPL | Stock | 12.5139 | 12.5139 | 12.5139 | 12.5139 | 2800.0 |
| 2011-05-05 06:40:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 2800.0 |
| 2011-05-05 07:00:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 14000.0 |
| 2011-05-05 07:15:00 | AAPL | Stock | 12.4729 | 12.4729 | 12.4729 | 12.4729 | 2800.0 |
| 2011-05-05 07:35:00 | AAPL | Stock | 12.4721 | 12.4721 | 12.4721 | 12.4721 | 2800.0 |
| 2011-05-05 07:40:00 | AAPL | Stock | 12.4493 | 12.4493 | 12.4493 | 12.4493 | 2800.0 |
| 2011-05-05 08:00:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4393 | 12.44 | 157360.0 |
| 2011-05-05 08:05:00 | AAPL | Stock | 12.4404 | 12.4479 | 12.4404 | 12.4464 | 116480.0 |
| 2011-05-05 08:10:00 | AAPL | Stock | 12.4489 | 12.45 | 12.4486 | 12.45 | 29960.0 |
| 2011-05-05 08:15:00 | AAPL | Stock | 12.4525 | 12.4607 | 12.4525 | 12.4607 | 55440.0 |
| 2011-05-05 08:20:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.4554 | 12.4554 | 7000.0 |
| 2011-05-05 08:25:00 | AAPL | Stock | 12.4532 | 12.4532 | 12.4446 | 12.45 | 22176.0 |
| 2011-05-05 08:30:00 | AAPL | Stock | 12.4446 | 12.4446 | 12.405 | 12.4332 | 615104.0 |
| 2011-05-05 08:35:00 | AAPL | Stock | 12.4196 | 12.4332 | 12.4196 | 12.4282 | 123312.0 |
| 2011-05-05 08:40:00 | AAPL | Stock | 12.425 | 12.4282 | 12.4214 | 12.4218 | 112644.0 |
| 2011-05-05 08:45:00 | AAPL | Stock | 12.4268 | 12.4336 | 12.4236 | 12.4239 | 106260.0 |
| 2011-05-05 08:50:00 | AAPL | Stock | 12.4218 | 12.4436 | 12.4214 | 12.4436 | 120400.0 |
| 2011-05-05 08:55:00 | AAPL | Stock | 12.4436 | 12.4436 | 12.4261 | 12.4393 | 62720.0 |
| 2011-05-05 09:00:00 | AAPL | Stock | 12.4321 | 12.4375 | 12.4286 | 12.4286 | 157388.0 |
| 2011-05-05 09:05:00 | AAPL | Stock | 12.4275 | 12.4414 | 12.4271 | 12.435 | 199080.0 |
| 2011-05-05 09:10:00 | AAPL | Stock | 12.4304 | 12.4375 | 12.4304 | 12.4375 | 25760.0 |
| 2011-05-05 09:15:00 | AAPL | Stock | 12.4393 | 12.4479 | 12.4379 | 12.4464 | 99568.0 |
| 2011-05-05 09:20:00 | AAPL | Stock | 12.4429 | 12.4429 | 12.4289 | 12.4321 | 88480.0 |
| 2011-05-05 09:25:00 | AAPL | Stock | 12.4354 | 12.4436 | 12.4336 | 12.4429 | 180404.0 |
| 2011-05-05 09:30:00 | AAPL | Stock | 12.4436 | 12.5161 | 12.4386 | 12.5132 | 16989000.0 |
| 2011-05-05 09:35:00 | AAPL | Stock | 12.5111 | 12.5339 | 12.4807 | 12.5 | 13507788.0 |
| 2011-05-05 09:40:00 | AAPL | Stock | 12.5 | 12.5179 | 12.4929 | 12.5018 | 7894320.0 |
| 2011-05-05 09:45:00 | AAPL | Stock | 12.5016 | 12.5032 | 12.4557 | 12.4789 | 11865252.0 |
| 2011-05-05 09:50:00 | AAPL | Stock | 12.4821 | 12.4857 | 12.4618 | 12.4793 | 4326896.0 |
| 2011-05-05 09:55:00 | AAPL | Stock | 12.4775 | 12.4818 | 12.4593 | 12.4771 | 5092808.0 |
| 2011-05-05 10:00:00 | AAPL | Stock | 12.4767 | 12.5086 | 12.4729 | 12.5021 | 6920396.0 |
| 2011-05-05 10:05:00 | AAPL | Stock | 12.5003 | 12.5125 | 12.4829 | 12.4829 | 5626320.0 |
| 2011-05-05 10:10:00 | AAPL | Stock | 12.4829 | 12.4907 | 12.4661 | 12.4671 | 4807124.0 |
| 2011-05-05 10:15:00 | AAPL | Stock | 12.4661 | 12.4714 | 12.4554 | 12.4693 | 5511380.0 |
| 2011-05-05 10:20:00 | AAPL | Stock | 12.4657 | 12.4768 | 12.4554 | 12.4636 | 5620692.0 |
| 2011-05-05 10:25:00 | AAPL | Stock | 12.4639 | 12.4743 | 12.4589 | 12.4664 | 2675932.0 |
| 2011-05-05 10:30:00 | AAPL | Stock | 12.4693 | 12.4821 | 12.4536 | 12.4818 | 3435992.0 |
| 2011-05-05 10:35:00 | AAPL | Stock | 12.4821 | 12.4996 | 12.4777 | 12.4857 | 4493132.0 |
| 2011-05-05 10:40:00 | AAPL | Stock | 12.4861 | 12.4961 | 12.4732 | 12.4732 | 3236016.0 |
| 2011-05-05 10:45:00 | AAPL | Stock | 12.4727 | 12.4904 | 12.4725 | 12.48 | 1565172.0 |
| 2011-05-05 10:50:00 | AAPL | Stock | 12.4782 | 12.4782 | 12.4571 | 12.4632 | 3536680.0 |
| 2011-05-05 10:55:00 | AAPL | Stock | 12.464 | 12.475 | 12.455 | 12.4593 | 3161816.0 |
| 2011-05-05 11:00:00 | AAPL | Stock | 12.4571 | 12.4811 | 12.4561 | 12.4775 | 4723992.0 |
| 2011-05-05 11:05:00 | AAPL | Stock | 12.4754 | 12.4764 | 12.45 | 12.4536 | 4822300.0 |
| 2011-05-05 11:10:00 | AAPL | Stock | 12.4536 | 12.4893 | 12.4196 | 12.4332 | 8954540.0 |
| 2011-05-05 11:15:00 | AAPL | Stock | 12.4332 | 12.4475 | 12.4236 | 12.4432 | 4179756.0 |
| 2011-05-05 11:20:00 | AAPL | Stock | 12.4429 | 12.4521 | 12.4411 | 12.4496 | 1946392.0 |
| 2011-05-05 11:25:00 | AAPL | Stock | 12.4496 | 12.4589 | 12.4468 | 12.4586 | 1429540.0 |
| 2011-05-05 11:30:00 | AAPL | Stock | 12.4589 | 12.4639 | 12.4443 | 12.4625 | 2816044.0 |
| 2011-05-05 11:35:00 | AAPL | Stock | 12.4629 | 12.4768 | 12.4599 | 12.4689 | 4582564.0 |
> showing 50 of 340,742 rows — these rows as CSV