PREVIEW / stock_1min / 2007-06-11
file: by_date/stock_1min/2007/2007-06-11.parquet size: 10.8 MB rows: 888,430 symbols: 2,472
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-06-11 09:30:00 | AAPL | Stock | 4.5 | 4.5032 | 4.4875 | 4.5029 | 17492468.0 |
| 2007-06-11 09:31:00 | AAPL | Stock | 4.5032 | 4.5054 | 4.4832 | 4.4861 | 6997172.0 |
| 2007-06-11 09:32:00 | AAPL | Stock | 4.4854 | 4.4964 | 4.4751 | 4.481 | 7368452.0 |
| 2007-06-11 09:33:00 | AAPL | Stock | 4.4811 | 4.49 | 4.4771 | 4.485 | 6417152.0 |
| 2007-06-11 09:34:00 | AAPL | Stock | 4.4854 | 4.4964 | 4.4854 | 4.4929 | 6242012.0 |
| 2007-06-11 09:35:00 | AAPL | Stock | 4.4932 | 4.4946 | 4.4732 | 4.4736 | 7638064.0 |
| 2007-06-11 09:36:00 | AAPL | Stock | 4.4739 | 4.4821 | 4.4661 | 4.47 | 7641872.0 |
| 2007-06-11 09:37:00 | AAPL | Stock | 4.47 | 4.4704 | 4.4593 | 4.4596 | 9478952.0 |
| 2007-06-11 09:38:00 | AAPL | Stock | 4.4596 | 4.4711 | 4.4586 | 4.4696 | 5694892.0 |
| 2007-06-11 09:39:00 | AAPL | Stock | 4.4696 | 4.4736 | 4.4664 | 4.4686 | 6131552.0 |
| 2007-06-11 09:40:00 | AAPL | Stock | 4.4686 | 4.4729 | 4.4679 | 4.4679 | 5313196.0 |
| 2007-06-11 09:41:00 | AAPL | Stock | 4.4679 | 4.4679 | 4.4607 | 4.4611 | 6145048.0 |
| 2007-06-11 09:42:00 | AAPL | Stock | 4.4611 | 4.4797 | 4.4554 | 4.4629 | 7716268.0 |
| 2007-06-11 09:43:00 | AAPL | Stock | 4.4625 | 4.4768 | 4.4604 | 4.4754 | 6068216.0 |
| 2007-06-11 09:44:00 | AAPL | Stock | 4.4754 | 4.4764 | 4.465 | 4.4729 | 6336036.0 |
| 2007-06-11 09:45:00 | AAPL | Stock | 4.4732 | 4.475 | 4.4693 | 4.4739 | 4324936.0 |
| 2007-06-11 09:46:00 | AAPL | Stock | 4.4732 | 4.4768 | 4.4707 | 4.4736 | 4551204.0 |
| 2007-06-11 09:47:00 | AAPL | Stock | 4.4736 | 4.4804 | 4.4736 | 4.4764 | 4468912.0 |
| 2007-06-11 09:48:00 | AAPL | Stock | 4.4761 | 4.4789 | 4.4668 | 4.4686 | 6669544.0 |
| 2007-06-11 09:49:00 | AAPL | Stock | 4.4686 | 4.4754 | 4.465 | 4.4668 | 5122992.0 |
| 2007-06-11 09:50:00 | AAPL | Stock | 4.4668 | 4.4714 | 4.4664 | 4.4714 | 2462292.0 |
| 2007-06-11 09:51:00 | AAPL | Stock | 4.4711 | 4.475 | 4.4679 | 4.4682 | 3441452.0 |
| 2007-06-11 09:52:00 | AAPL | Stock | 4.4679 | 4.4725 | 4.4679 | 4.4725 | 1490860.0 |
| 2007-06-11 09:53:00 | AAPL | Stock | 4.4725 | 4.4839 | 4.47 | 4.4796 | 5456696.0 |
| 2007-06-11 09:54:00 | AAPL | Stock | 4.4796 | 4.4821 | 4.4768 | 4.4775 | 2844660.0 |
| 2007-06-11 09:55:00 | AAPL | Stock | 4.4768 | 4.4771 | 4.4661 | 4.4682 | 3820124.0 |
| 2007-06-11 09:56:00 | AAPL | Stock | 4.4667 | 4.47 | 4.4639 | 4.4689 | 4524772.0 |
| 2007-06-11 09:57:00 | AAPL | Stock | 4.4693 | 4.4711 | 4.4654 | 4.4686 | 2278696.0 |
| 2007-06-11 09:58:00 | AAPL | Stock | 4.4697 | 4.4707 | 4.4661 | 4.4686 | 2056656.0 |
| 2007-06-11 09:59:00 | AAPL | Stock | 4.4686 | 4.4707 | 4.4646 | 4.4661 | 4535608.0 |
| 2007-06-11 10:00:00 | AAPL | Stock | 4.4668 | 4.4668 | 4.4596 | 4.4614 | 6191220.0 |
| 2007-06-11 10:01:00 | AAPL | Stock | 4.4614 | 4.4654 | 4.4586 | 4.4625 | 4472972.0 |
| 2007-06-11 10:02:00 | AAPL | Stock | 4.4618 | 4.4625 | 4.4561 | 4.4611 | 4375448.0 |
| 2007-06-11 10:03:00 | AAPL | Stock | 4.4611 | 4.4621 | 4.4571 | 4.4582 | 2986144.0 |
| 2007-06-11 10:04:00 | AAPL | Stock | 4.4579 | 4.4596 | 4.45 | 4.4529 | 7900088.0 |
| 2007-06-11 10:05:00 | AAPL | Stock | 4.4529 | 4.4593 | 4.4527 | 4.455 | 9008048.0 |
| 2007-06-11 10:06:00 | AAPL | Stock | 4.4536 | 4.4604 | 4.4529 | 4.4561 | 4601800.0 |
| 2007-06-11 10:07:00 | AAPL | Stock | 4.4554 | 4.4561 | 4.4486 | 4.4521 | 5194896.0 |
| 2007-06-11 10:08:00 | AAPL | Stock | 4.4518 | 4.4529 | 4.4464 | 4.4521 | 6581064.0 |
| 2007-06-11 10:09:00 | AAPL | Stock | 4.4514 | 4.4546 | 4.4418 | 4.4432 | 6216980.0 |
| 2007-06-11 10:10:00 | AAPL | Stock | 4.4436 | 4.4475 | 4.4421 | 4.4446 | 12581380.0 |
| 2007-06-11 10:11:00 | AAPL | Stock | 4.4443 | 4.4461 | 4.4404 | 4.4418 | 4743676.0 |
| 2007-06-11 10:12:00 | AAPL | Stock | 4.4411 | 4.4482 | 4.4404 | 4.4421 | 5581184.0 |
| 2007-06-11 10:13:00 | AAPL | Stock | 4.4418 | 4.4461 | 4.4411 | 4.4443 | 3133872.0 |
| 2007-06-11 10:14:00 | AAPL | Stock | 4.4446 | 4.4457 | 4.4386 | 4.4393 | 4610228.0 |
| 2007-06-11 10:15:00 | AAPL | Stock | 4.4393 | 4.4393 | 4.4321 | 4.4357 | 5103532.0 |
| 2007-06-11 10:16:00 | AAPL | Stock | 4.4357 | 4.4364 | 4.4286 | 4.4304 | 6735120.0 |
| 2007-06-11 10:17:00 | AAPL | Stock | 4.4304 | 4.435 | 4.4275 | 4.4282 | 5551812.0 |
| 2007-06-11 10:18:00 | AAPL | Stock | 4.4279 | 4.4318 | 4.4232 | 4.4311 | 7513184.0 |
| 2007-06-11 10:19:00 | AAPL | Stock | 4.4304 | 4.4329 | 4.4286 | 4.4318 | 3915996.0 |
> showing 50 of 888,430 rows — these rows as CSV