PREVIEW / stock_5min / 2005-03-16
file: by_date/stock_5min/2005/2005-03-16.parquet size: 2.7 MB rows: 194,102 symbols: 1,946
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-16 08:00:00 | AAPL | Stock | 1.4711 | 1.4711 | 1.4675 | 1.4675 | 313572.0 |
| 2005-03-16 08:05:00 | AAPL | Stock | 1.4675 | 1.4682 | 1.4668 | 1.4668 | 68600.0 |
| 2005-03-16 08:10:00 | AAPL | Stock | 1.4668 | 1.4679 | 1.4668 | 1.4679 | 50400.0 |
| 2005-03-16 08:15:00 | AAPL | Stock | 1.4679 | 1.4682 | 1.4675 | 1.4679 | 103880.0 |
| 2005-03-16 08:20:00 | AAPL | Stock | 1.4675 | 1.4679 | 1.4639 | 1.4639 | 232484.0 |
| 2005-03-16 08:25:00 | AAPL | Stock | 1.4639 | 1.4639 | 1.4629 | 1.4629 | 63112.0 |
| 2005-03-16 08:30:00 | AAPL | Stock | 1.4625 | 1.4639 | 1.4625 | 1.4636 | 18200.0 |
| 2005-03-16 08:35:00 | AAPL | Stock | 1.4629 | 1.4629 | 1.4604 | 1.4607 | 33600.0 |
| 2005-03-16 08:40:00 | AAPL | Stock | 1.4607 | 1.4629 | 1.4607 | 1.4629 | 96600.0 |
| 2005-03-16 08:50:00 | AAPL | Stock | 1.46 | 1.4625 | 1.4571 | 1.4625 | 104188.0 |
| 2005-03-16 08:55:00 | AAPL | Stock | 1.4625 | 1.4625 | 1.4582 | 1.4596 | 29820.0 |
| 2005-03-16 09:00:00 | AAPL | Stock | 1.4579 | 1.4579 | 1.4554 | 1.4554 | 67200.0 |
| 2005-03-16 09:05:00 | AAPL | Stock | 1.4554 | 1.4571 | 1.4536 | 1.4536 | 380548.0 |
| 2005-03-16 09:10:00 | AAPL | Stock | 1.4536 | 1.4564 | 1.4536 | 1.4564 | 162120.0 |
| 2005-03-16 09:15:00 | AAPL | Stock | 1.4629 | 1.4629 | 1.4543 | 1.4571 | 167608.0 |
| 2005-03-16 09:20:00 | AAPL | Stock | 1.4564 | 1.4586 | 1.4564 | 1.4586 | 375144.0 |
| 2005-03-16 09:25:00 | AAPL | Stock | 1.4575 | 1.4718 | 1.4439 | 1.4693 | 3213196.0 |
| 2005-03-16 09:30:00 | AAPL | Stock | 1.4718 | 1.4718 | 1.4611 | 1.4679 | 25411764.0 |
| 2005-03-16 09:35:00 | AAPL | Stock | 1.4682 | 1.4682 | 1.4629 | 1.4679 | 9699676.0 |
| 2005-03-16 09:40:00 | AAPL | Stock | 1.4679 | 1.4718 | 1.4661 | 1.4679 | 11900224.0 |
| 2005-03-16 09:45:00 | AAPL | Stock | 1.4679 | 1.4768 | 1.4671 | 1.4739 | 18228560.0 |
| 2005-03-16 09:50:00 | AAPL | Stock | 1.4732 | 1.4814 | 1.4729 | 1.4768 | 17804192.0 |
| 2005-03-16 09:55:00 | AAPL | Stock | 1.4771 | 1.4821 | 1.4768 | 1.4786 | 11925200.0 |
| 2005-03-16 10:00:00 | AAPL | Stock | 1.4786 | 1.4875 | 1.4782 | 1.4857 | 16020508.0 |
| 2005-03-16 10:05:00 | AAPL | Stock | 1.4857 | 1.4975 | 1.4854 | 1.4961 | 21456932.0 |
| 2005-03-16 10:10:00 | AAPL | Stock | 1.4936 | 1.5043 | 1.4929 | 1.5025 | 31271576.0 |
| 2005-03-16 10:15:00 | AAPL | Stock | 1.5021 | 1.5111 | 1.4996 | 1.5021 | 29908620.0 |
| 2005-03-16 10:20:00 | AAPL | Stock | 1.5018 | 1.5032 | 1.4918 | 1.4961 | 18925928.0 |
| 2005-03-16 10:25:00 | AAPL | Stock | 1.4964 | 1.4964 | 1.4875 | 1.4911 | 16840936.0 |
| 2005-03-16 10:30:00 | AAPL | Stock | 1.4911 | 1.4929 | 1.4829 | 1.4893 | 18652340.0 |
| 2005-03-16 10:35:00 | AAPL | Stock | 1.4893 | 1.4907 | 1.4821 | 1.4825 | 11874996.0 |
| 2005-03-16 10:40:00 | AAPL | Stock | 1.4825 | 1.4846 | 1.4771 | 1.4775 | 15481872.0 |
| 2005-03-16 10:45:00 | AAPL | Stock | 1.4775 | 1.4832 | 1.4768 | 1.4825 | 13159300.0 |
| 2005-03-16 10:50:00 | AAPL | Stock | 1.4821 | 1.4882 | 1.4821 | 1.4836 | 12306140.0 |
| 2005-03-16 10:55:00 | AAPL | Stock | 1.4839 | 1.4871 | 1.4782 | 1.48 | 8150464.0 |
| 2005-03-16 11:00:00 | AAPL | Stock | 1.48 | 1.48 | 1.4686 | 1.4754 | 14685048.0 |
| 2005-03-16 11:05:00 | AAPL | Stock | 1.475 | 1.4782 | 1.4739 | 1.4754 | 6147624.0 |
| 2005-03-16 11:10:00 | AAPL | Stock | 1.4757 | 1.4786 | 1.4739 | 1.4782 | 6252932.0 |
| 2005-03-16 11:15:00 | AAPL | Stock | 1.4786 | 1.4875 | 1.47 | 1.4725 | 7852852.0 |
| 2005-03-16 11:20:00 | AAPL | Stock | 1.4729 | 1.4732 | 1.4679 | 1.4704 | 6173748.0 |
| 2005-03-16 11:25:00 | AAPL | Stock | 1.4707 | 1.4796 | 1.4689 | 1.4782 | 6742372.0 |
| 2005-03-16 11:30:00 | AAPL | Stock | 1.4782 | 1.4868 | 1.4782 | 1.4846 | 11814264.0 |
| 2005-03-16 11:35:00 | AAPL | Stock | 1.4846 | 1.485 | 1.48 | 1.4821 | 6591256.0 |
| 2005-03-16 11:40:00 | AAPL | Stock | 1.4821 | 1.4832 | 1.4768 | 1.4771 | 4379732.0 |
| 2005-03-16 11:45:00 | AAPL | Stock | 1.4771 | 1.4782 | 1.4732 | 1.4761 | 7388948.0 |
| 2005-03-16 11:50:00 | AAPL | Stock | 1.4761 | 1.48 | 1.4757 | 1.4782 | 4263196.0 |
| 2005-03-16 11:55:00 | AAPL | Stock | 1.4782 | 1.48 | 1.4768 | 1.4786 | 3536316.0 |
| 2005-03-16 12:00:00 | AAPL | Stock | 1.4786 | 1.4793 | 1.4768 | 1.4782 | 2196432.0 |
| 2005-03-16 12:05:00 | AAPL | Stock | 1.4775 | 1.4796 | 1.4771 | 1.4771 | 3160892.0 |
| 2005-03-16 12:10:00 | AAPL | Stock | 1.4771 | 1.4821 | 1.4768 | 1.4821 | 3175956.0 |
> showing 50 of 194,102 rows — these rows as CSV