PREVIEW / stock_1min / 2010-01-15
file: by_date/stock_1min/2010/2010-01-15.parquet size: 12.8 MB rows: 967,382 symbols: 2,797
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-01-15 06:34:00 | AAPL | Stock | 7.5086 | 7.5232 | 7.5086 | 7.5232 | 8400.0 |
| 2010-01-15 07:04:00 | AAPL | Stock | 7.4918 | 7.4918 | 7.4918 | 7.4918 | 2800.0 |
| 2010-01-15 07:05:00 | AAPL | Stock | 7.4879 | 7.4879 | 7.4879 | 7.4879 | 4200.0 |
| 2010-01-15 07:08:00 | AAPL | Stock | 7.4914 | 7.4914 | 7.4839 | 7.4839 | 16604.0 |
| 2010-01-15 07:11:00 | AAPL | Stock | 7.4718 | 7.4718 | 7.4718 | 7.4718 | 2800.0 |
| 2010-01-15 07:12:00 | AAPL | Stock | 7.4704 | 7.4704 | 7.4643 | 7.4643 | 50400.0 |
| 2010-01-15 07:14:00 | AAPL | Stock | 7.4643 | 7.4643 | 7.4643 | 7.4643 | 8400.0 |
| 2010-01-15 07:24:00 | AAPL | Stock | 7.4643 | 7.4643 | 7.4643 | 7.4643 | 11200.0 |
| 2010-01-15 07:27:00 | AAPL | Stock | 7.4639 | 7.4643 | 7.4639 | 7.4643 | 73220.0 |
| 2010-01-15 07:28:00 | AAPL | Stock | 7.4643 | 7.4643 | 7.4643 | 7.4643 | 5600.0 |
| 2010-01-15 07:53:00 | AAPL | Stock | 7.4732 | 7.4732 | 7.4732 | 7.4732 | 2800.0 |
| 2010-01-15 07:55:00 | AAPL | Stock | 7.4682 | 7.4682 | 7.4682 | 7.4682 | 2800.0 |
| 2010-01-15 07:59:00 | AAPL | Stock | 7.4657 | 7.4657 | 7.4657 | 7.4657 | 8400.0 |
| 2010-01-15 08:00:00 | AAPL | Stock | 7.4761 | 7.4768 | 7.475 | 7.4768 | 16800.0 |
| 2010-01-15 08:01:00 | AAPL | Stock | 7.4786 | 7.4786 | 7.4768 | 7.4782 | 107520.0 |
| 2010-01-15 08:02:00 | AAPL | Stock | 7.4732 | 7.4732 | 7.4721 | 7.4721 | 16800.0 |
| 2010-01-15 08:03:00 | AAPL | Stock | 7.4732 | 7.4732 | 7.4729 | 7.4732 | 61600.0 |
| 2010-01-15 08:04:00 | AAPL | Stock | 7.4782 | 7.4821 | 7.4782 | 7.4821 | 40712.0 |
| 2010-01-15 08:05:00 | AAPL | Stock | 7.5 | 7.5 | 7.5 | 7.5 | 2800.0 |
| 2010-01-15 08:07:00 | AAPL | Stock | 7.4821 | 7.4854 | 7.4793 | 7.4852 | 13720.0 |
| 2010-01-15 08:08:00 | AAPL | Stock | 7.4854 | 7.4941 | 7.485 | 7.4941 | 50400.0 |
| 2010-01-15 08:09:00 | AAPL | Stock | 7.4925 | 7.4982 | 7.4921 | 7.4946 | 167076.0 |
| 2010-01-15 08:10:00 | AAPL | Stock | 7.4971 | 7.4971 | 7.4971 | 7.4971 | 14000.0 |
| 2010-01-15 08:11:00 | AAPL | Stock | 7.4898 | 7.4898 | 7.4898 | 7.4898 | 8400.0 |
| 2010-01-15 08:13:00 | AAPL | Stock | 7.4925 | 7.4925 | 7.4889 | 7.4893 | 32424.0 |
| 2010-01-15 08:15:00 | AAPL | Stock | 7.4896 | 7.4896 | 7.4893 | 7.4893 | 11200.0 |
| 2010-01-15 08:16:00 | AAPL | Stock | 7.4893 | 7.4893 | 7.4893 | 7.4893 | 5600.0 |
| 2010-01-15 08:18:00 | AAPL | Stock | 7.4925 | 7.4925 | 7.4925 | 7.4925 | 2800.0 |
| 2010-01-15 08:19:00 | AAPL | Stock | 7.485 | 7.485 | 7.4825 | 7.4825 | 21196.0 |
| 2010-01-15 08:29:00 | AAPL | Stock | 7.4921 | 7.4925 | 7.4921 | 7.4925 | 5600.0 |
| 2010-01-15 08:32:00 | AAPL | Stock | 7.4857 | 7.4857 | 7.4839 | 7.4839 | 8400.0 |
| 2010-01-15 08:33:00 | AAPL | Stock | 7.4909 | 7.4911 | 7.4909 | 7.4911 | 9800.0 |
| 2010-01-15 08:34:00 | AAPL | Stock | 7.4911 | 7.4911 | 7.4911 | 7.4911 | 2800.0 |
| 2010-01-15 08:35:00 | AAPL | Stock | 7.4911 | 7.4911 | 7.4911 | 7.4911 | 5040.0 |
| 2010-01-15 08:37:00 | AAPL | Stock | 7.4875 | 7.4875 | 7.4875 | 7.4875 | 5600.0 |
| 2010-01-15 08:42:00 | AAPL | Stock | 7.4893 | 7.4893 | 7.4893 | 7.4893 | 11200.0 |
| 2010-01-15 08:43:00 | AAPL | Stock | 7.4893 | 7.4893 | 7.4893 | 7.4893 | 3220.0 |
| 2010-01-15 08:44:00 | AAPL | Stock | 7.4904 | 7.4904 | 7.4904 | 7.4904 | 9800.0 |
| 2010-01-15 08:45:00 | AAPL | Stock | 7.4861 | 7.4861 | 7.4861 | 7.4861 | 5600.0 |
| 2010-01-15 08:46:00 | AAPL | Stock | 7.4875 | 7.4875 | 7.4875 | 7.4875 | 14000.0 |
| 2010-01-15 08:47:00 | AAPL | Stock | 7.4857 | 7.4857 | 7.4857 | 7.4857 | 5600.0 |
| 2010-01-15 08:48:00 | AAPL | Stock | 7.4886 | 7.4893 | 7.4821 | 7.4821 | 109200.0 |
| 2010-01-15 08:50:00 | AAPL | Stock | 7.4821 | 7.4821 | 7.4804 | 7.4804 | 22400.0 |
| 2010-01-15 08:51:00 | AAPL | Stock | 7.4804 | 7.4804 | 7.4804 | 7.4804 | 2800.0 |
| 2010-01-15 08:52:00 | AAPL | Stock | 7.4775 | 7.4779 | 7.4771 | 7.4771 | 16800.0 |
| 2010-01-15 08:53:00 | AAPL | Stock | 7.4761 | 7.4764 | 7.4757 | 7.4757 | 11900.0 |
| 2010-01-15 08:54:00 | AAPL | Stock | 7.4775 | 7.4857 | 7.4775 | 7.4857 | 34440.0 |
| 2010-01-15 08:58:00 | AAPL | Stock | 7.4821 | 7.4821 | 7.4821 | 7.4821 | 2800.0 |
| 2010-01-15 08:59:00 | AAPL | Stock | 7.4854 | 7.4854 | 7.4854 | 7.4854 | 8400.0 |
| 2010-01-15 09:00:00 | AAPL | Stock | 7.4861 | 7.4861 | 7.4861 | 7.4861 | 5600.0 |
> showing 50 of 967,382 rows — these rows as CSV