PREVIEW / stock_1min / 2007-12-05
file: by_date/stock_1min/2007/2007-12-05.parquet size: 12.0 MB rows: 980,060 symbols: 2,618
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-12-05 04:48:00 | AAPL | Stock | 6.4636 | 6.4636 | 6.4636 | 6.4636 | 33600.0 |
| 2007-12-05 05:11:00 | AAPL | Stock | 6.4718 | 6.4718 | 6.4718 | 6.4718 | 2800.0 |
| 2007-12-05 06:23:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4811 | 6.4811 | 22400.0 |
| 2007-12-05 06:26:00 | AAPL | Stock | 6.4811 | 6.4811 | 6.4811 | 6.4811 | 2800.0 |
| 2007-12-05 06:52:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4821 | 6.4821 | 8400.0 |
| 2007-12-05 07:00:00 | AAPL | Stock | 6.5 | 6.5 | 6.5 | 6.5 | 2800.0 |
| 2007-12-05 07:02:00 | AAPL | Stock | 6.4957 | 6.4957 | 6.4957 | 6.4957 | 8400.0 |
| 2007-12-05 07:03:00 | AAPL | Stock | 6.4957 | 6.4957 | 6.4929 | 6.4929 | 14000.0 |
| 2007-12-05 07:04:00 | AAPL | Stock | 6.4929 | 6.4929 | 6.4929 | 6.4929 | 22400.0 |
| 2007-12-05 07:08:00 | AAPL | Stock | 6.4929 | 6.4929 | 6.4929 | 6.4929 | 3920.0 |
| 2007-12-05 07:10:00 | AAPL | Stock | 6.5 | 6.5 | 6.5 | 6.5 | 8400.0 |
| 2007-12-05 07:12:00 | AAPL | Stock | 6.4918 | 6.4918 | 6.4918 | 6.4918 | 2800.0 |
| 2007-12-05 07:14:00 | AAPL | Stock | 6.4929 | 6.4929 | 6.4821 | 6.4821 | 10724.0 |
| 2007-12-05 07:21:00 | AAPL | Stock | 6.5004 | 6.5004 | 6.5004 | 6.5004 | 14280.0 |
| 2007-12-05 07:25:00 | AAPL | Stock | 6.5004 | 6.5004 | 6.5004 | 6.5004 | 13720.0 |
| 2007-12-05 07:40:00 | AAPL | Stock | 6.4861 | 6.4861 | 6.4861 | 6.4861 | 11200.0 |
| 2007-12-05 07:43:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4821 | 6.4821 | 5600.0 |
| 2007-12-05 07:45:00 | AAPL | Stock | 6.4814 | 6.4814 | 6.4814 | 6.4814 | 7140.0 |
| 2007-12-05 07:46:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4821 | 6.4821 | 20860.0 |
| 2007-12-05 07:47:00 | AAPL | Stock | 6.4818 | 6.4818 | 6.4814 | 6.4814 | 60060.0 |
| 2007-12-05 07:48:00 | AAPL | Stock | 6.4814 | 6.4814 | 6.4814 | 6.4814 | 21140.0 |
| 2007-12-05 07:49:00 | AAPL | Stock | 6.4821 | 6.4821 | 6.4821 | 6.4821 | 2800.0 |
| 2007-12-05 07:50:00 | AAPL | Stock | 6.4854 | 6.4854 | 6.4854 | 6.4854 | 2800.0 |
| 2007-12-05 07:54:00 | AAPL | Stock | 6.4911 | 6.4911 | 6.4911 | 6.4911 | 11200.0 |
| 2007-12-05 08:00:00 | AAPL | Stock | 6.4893 | 6.4929 | 6.4218 | 6.4929 | 518448.0 |
| 2007-12-05 08:01:00 | AAPL | Stock | 6.4932 | 6.4932 | 6.4732 | 6.4829 | 33600.0 |
| 2007-12-05 08:02:00 | AAPL | Stock | 6.4839 | 6.4889 | 6.4839 | 6.4857 | 57400.0 |
| 2007-12-05 08:03:00 | AAPL | Stock | 6.4857 | 6.4857 | 6.4857 | 6.4857 | 5600.0 |
| 2007-12-05 08:04:00 | AAPL | Stock | 6.4857 | 6.4857 | 6.4786 | 6.4793 | 232820.0 |
| 2007-12-05 08:05:00 | AAPL | Stock | 6.4836 | 6.4929 | 6.4836 | 6.4904 | 89600.0 |
| 2007-12-05 08:06:00 | AAPL | Stock | 6.4857 | 6.4857 | 6.4829 | 6.4829 | 70000.0 |
| 2007-12-05 08:07:00 | AAPL | Stock | 6.4857 | 6.4857 | 6.4829 | 6.4857 | 33600.0 |
| 2007-12-05 08:08:00 | AAPL | Stock | 6.4825 | 6.4857 | 6.4825 | 6.4857 | 8400.0 |
| 2007-12-05 08:09:00 | AAPL | Stock | 6.4825 | 6.4857 | 6.4804 | 6.4857 | 60200.0 |
| 2007-12-05 08:10:00 | AAPL | Stock | 6.4839 | 6.4839 | 6.4839 | 6.4839 | 12600.0 |
| 2007-12-05 08:11:00 | AAPL | Stock | 6.4825 | 6.4832 | 6.475 | 6.4786 | 443268.0 |
| 2007-12-05 08:12:00 | AAPL | Stock | 6.4757 | 6.4786 | 6.4736 | 6.4743 | 145600.0 |
| 2007-12-05 08:13:00 | AAPL | Stock | 6.4743 | 6.4764 | 6.4736 | 6.4764 | 95200.0 |
| 2007-12-05 08:14:00 | AAPL | Stock | 6.4768 | 6.4768 | 6.4764 | 6.4768 | 25200.0 |
| 2007-12-05 08:15:00 | AAPL | Stock | 6.48 | 6.4839 | 6.48 | 6.4821 | 143584.0 |
| 2007-12-05 08:16:00 | AAPL | Stock | 6.4839 | 6.4868 | 6.4839 | 6.4868 | 19600.0 |
| 2007-12-05 08:17:00 | AAPL | Stock | 6.4868 | 6.4893 | 6.4821 | 6.4825 | 88956.0 |
| 2007-12-05 08:18:00 | AAPL | Stock | 6.4871 | 6.4964 | 6.4871 | 6.4932 | 160860.0 |
| 2007-12-05 08:19:00 | AAPL | Stock | 6.4932 | 6.5 | 6.4932 | 6.4996 | 139160.0 |
| 2007-12-05 08:20:00 | AAPL | Stock | 6.4996 | 6.4996 | 6.4929 | 6.4929 | 162540.0 |
| 2007-12-05 08:21:00 | AAPL | Stock | 6.4946 | 6.4946 | 6.4911 | 6.4925 | 209860.0 |
| 2007-12-05 08:22:00 | AAPL | Stock | 6.4914 | 6.4929 | 6.4914 | 6.4929 | 19600.0 |
| 2007-12-05 08:23:00 | AAPL | Stock | 6.4929 | 6.495 | 6.4911 | 6.4911 | 43736.0 |
| 2007-12-05 08:25:00 | AAPL | Stock | 6.4946 | 6.495 | 6.4946 | 6.495 | 14000.0 |
| 2007-12-05 08:26:00 | AAPL | Stock | 6.4946 | 6.4946 | 6.4932 | 6.4932 | 11200.0 |
> showing 50 of 980,060 rows — these rows as CSV