PREVIEW / stock_1min / 2010-12-20
file: by_date/stock_1min/2010/2010-12-20.parquet size: 13.6 MB rows: 1,016,385 symbols: 2,886
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-20 04:09:00 | AAPL | Stock | 11.4686 | 11.4686 | 11.4686 | 11.4686 | 2800.0 |
| 2010-12-20 04:14:00 | AAPL | Stock | 11.4771 | 11.4771 | 11.4771 | 11.4771 | 2800.0 |
| 2010-12-20 04:31:00 | AAPL | Stock | 11.47 | 11.47 | 11.47 | 11.47 | 2800.0 |
| 2010-12-20 04:33:00 | AAPL | Stock | 11.4879 | 11.4879 | 11.4879 | 11.4879 | 2800.0 |
| 2010-12-20 04:34:00 | AAPL | Stock | 11.4961 | 11.5 | 11.4961 | 11.4961 | 8400.0 |
| 2010-12-20 04:35:00 | AAPL | Stock | 11.4879 | 11.4879 | 11.4879 | 11.4879 | 2800.0 |
| 2010-12-20 04:37:00 | AAPL | Stock | 11.4857 | 11.4857 | 11.4857 | 11.4857 | 2800.0 |
| 2010-12-20 04:58:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 2800.0 |
| 2010-12-20 06:26:00 | AAPL | Stock | 11.4746 | 11.4746 | 11.4746 | 11.4746 | 2800.0 |
| 2010-12-20 06:27:00 | AAPL | Stock | 11.475 | 11.475 | 11.475 | 11.475 | 14000.0 |
| 2010-12-20 06:31:00 | AAPL | Stock | 11.475 | 11.475 | 11.475 | 11.475 | 5600.0 |
| 2010-12-20 06:32:00 | AAPL | Stock | 11.4729 | 11.4729 | 11.4729 | 11.4729 | 2800.0 |
| 2010-12-20 06:45:00 | AAPL | Stock | 11.475 | 11.475 | 11.475 | 11.475 | 2800.0 |
| 2010-12-20 06:52:00 | AAPL | Stock | 11.475 | 11.475 | 11.475 | 11.475 | 2800.0 |
| 2010-12-20 06:56:00 | AAPL | Stock | 11.475 | 11.475 | 11.475 | 11.475 | 2800.0 |
| 2010-12-20 06:57:00 | AAPL | Stock | 11.4654 | 11.4654 | 11.4654 | 11.4654 | 2800.0 |
| 2010-12-20 07:00:00 | AAPL | Stock | 11.4768 | 11.4768 | 11.4768 | 11.4768 | 5600.0 |
| 2010-12-20 07:02:00 | AAPL | Stock | 11.4757 | 11.4829 | 11.4757 | 11.4829 | 22400.0 |
| 2010-12-20 07:04:00 | AAPL | Stock | 11.4821 | 11.4821 | 11.4821 | 11.4821 | 5320.0 |
| 2010-12-20 07:06:00 | AAPL | Stock | 11.4714 | 11.4714 | 11.4714 | 11.4714 | 5600.0 |
| 2010-12-20 07:07:00 | AAPL | Stock | 11.4821 | 11.4821 | 11.4821 | 11.4821 | 4200.0 |
| 2010-12-20 07:12:00 | AAPL | Stock | 11.4818 | 11.4818 | 11.4818 | 11.4818 | 11200.0 |
| 2010-12-20 07:14:00 | AAPL | Stock | 11.4732 | 11.4732 | 11.4732 | 11.4732 | 2800.0 |
| 2010-12-20 07:19:00 | AAPL | Stock | 11.4732 | 11.4732 | 11.4714 | 11.4714 | 5600.0 |
| 2010-12-20 07:20:00 | AAPL | Stock | 11.4757 | 11.4757 | 11.4757 | 11.4757 | 2800.0 |
| 2010-12-20 07:21:00 | AAPL | Stock | 11.4679 | 11.4679 | 11.4657 | 11.4679 | 14000.0 |
| 2010-12-20 07:22:00 | AAPL | Stock | 11.4679 | 11.4857 | 11.4679 | 11.4829 | 109760.0 |
| 2010-12-20 07:26:00 | AAPL | Stock | 11.4904 | 11.4904 | 11.4904 | 11.4904 | 2800.0 |
| 2010-12-20 07:39:00 | AAPL | Stock | 11.4861 | 11.4886 | 11.4861 | 11.4886 | 30800.0 |
| 2010-12-20 07:42:00 | AAPL | Stock | 11.4825 | 11.4825 | 11.4825 | 11.4825 | 2800.0 |
| 2010-12-20 07:43:00 | AAPL | Stock | 11.4829 | 11.4829 | 11.4829 | 11.4829 | 5600.0 |
| 2010-12-20 07:44:00 | AAPL | Stock | 11.4825 | 11.4825 | 11.4825 | 11.4825 | 5600.0 |
| 2010-12-20 07:45:00 | AAPL | Stock | 11.4825 | 11.4825 | 11.4825 | 11.4825 | 2800.0 |
| 2010-12-20 07:49:00 | AAPL | Stock | 11.4825 | 11.4825 | 11.4825 | 11.4825 | 2800.0 |
| 2010-12-20 07:52:00 | AAPL | Stock | 11.4821 | 11.4821 | 11.4821 | 11.4821 | 5600.0 |
| 2010-12-20 07:55:00 | AAPL | Stock | 11.475 | 11.475 | 11.475 | 11.475 | 2800.0 |
| 2010-12-20 07:56:00 | AAPL | Stock | 11.4821 | 11.4821 | 11.4821 | 11.4821 | 7000.0 |
| 2010-12-20 07:57:00 | AAPL | Stock | 11.4761 | 11.4761 | 11.4761 | 11.4761 | 2800.0 |
| 2010-12-20 07:58:00 | AAPL | Stock | 11.4757 | 11.4757 | 11.4757 | 11.4757 | 2800.0 |
| 2010-12-20 08:00:00 | AAPL | Stock | 11.4786 | 11.4821 | 11.4729 | 11.4757 | 51912.0 |
| 2010-12-20 08:01:00 | AAPL | Stock | 11.4761 | 11.4761 | 11.4754 | 11.4754 | 43764.0 |
| 2010-12-20 08:02:00 | AAPL | Stock | 11.4754 | 11.4789 | 11.4754 | 11.4757 | 17024.0 |
| 2010-12-20 08:03:00 | AAPL | Stock | 11.4768 | 11.4768 | 11.4757 | 11.4757 | 28000.0 |
| 2010-12-20 08:04:00 | AAPL | Stock | 11.4793 | 11.4793 | 11.4793 | 11.4793 | 13440.0 |
| 2010-12-20 08:05:00 | AAPL | Stock | 11.48 | 11.4814 | 11.48 | 11.4804 | 28000.0 |
| 2010-12-20 08:06:00 | AAPL | Stock | 11.4821 | 11.485 | 11.4821 | 11.485 | 52948.0 |
| 2010-12-20 08:07:00 | AAPL | Stock | 11.485 | 11.4857 | 11.4836 | 11.485 | 34608.0 |
| 2010-12-20 08:08:00 | AAPL | Stock | 11.4825 | 11.4825 | 11.48 | 11.48 | 102648.0 |
| 2010-12-20 08:09:00 | AAPL | Stock | 11.48 | 11.4804 | 11.4796 | 11.4804 | 50400.0 |
| 2010-12-20 08:10:00 | AAPL | Stock | 11.4804 | 11.4804 | 11.48 | 11.48 | 8400.0 |
> showing 50 of 1,016,385 rows — these rows as CSV