PREVIEW / stock_1min / 2011-03-10
file: by_date/stock_1min/2011/2011-03-10.parquet size: 14.2 MB rows: 1,064,234 symbols: 2,850
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-10 04:03:00 | AAPL | Stock | 12.5354 | 12.5354 | 12.5354 | 12.5354 | 7000.0 |
| 2011-03-10 04:37:00 | AAPL | Stock | 12.5118 | 12.5154 | 12.5118 | 12.5154 | 11200.0 |
| 2011-03-10 04:40:00 | AAPL | Stock | 12.5154 | 12.5204 | 12.5154 | 12.5204 | 8400.0 |
| 2011-03-10 04:42:00 | AAPL | Stock | 12.5204 | 12.5204 | 12.5204 | 12.5204 | 11200.0 |
| 2011-03-10 05:50:00 | AAPL | Stock | 12.4839 | 12.4839 | 12.4839 | 12.4839 | 5600.0 |
| 2011-03-10 05:58:00 | AAPL | Stock | 12.4839 | 12.4839 | 12.4839 | 12.4839 | 3192.0 |
| 2011-03-10 06:08:00 | AAPL | Stock | 12.515 | 12.515 | 12.515 | 12.515 | 2800.0 |
| 2011-03-10 06:13:00 | AAPL | Stock | 12.5154 | 12.5154 | 12.5154 | 12.5154 | 5600.0 |
| 2011-03-10 06:25:00 | AAPL | Stock | 12.5136 | 12.5136 | 12.5136 | 12.5136 | 2800.0 |
| 2011-03-10 06:26:00 | AAPL | Stock | 12.4936 | 12.4936 | 12.4936 | 12.4936 | 14000.0 |
| 2011-03-10 06:27:00 | AAPL | Stock | 12.4907 | 12.4907 | 12.4907 | 12.4907 | 10920.0 |
| 2011-03-10 07:01:00 | AAPL | Stock | 12.49 | 12.49 | 12.49 | 12.49 | 6216.0 |
| 2011-03-10 07:02:00 | AAPL | Stock | 12.4839 | 12.4839 | 12.4832 | 12.4832 | 10220.0 |
| 2011-03-10 07:03:00 | AAPL | Stock | 12.4832 | 12.4832 | 12.4832 | 12.4832 | 5600.0 |
| 2011-03-10 07:04:00 | AAPL | Stock | 12.475 | 12.475 | 12.475 | 12.475 | 5600.0 |
| 2011-03-10 07:05:00 | AAPL | Stock | 12.475 | 12.475 | 12.475 | 12.475 | 8400.0 |
| 2011-03-10 07:06:00 | AAPL | Stock | 12.475 | 12.475 | 12.475 | 12.475 | 25200.0 |
| 2011-03-10 07:08:00 | AAPL | Stock | 12.4714 | 12.4857 | 12.4714 | 12.4857 | 5600.0 |
| 2011-03-10 07:09:00 | AAPL | Stock | 12.4982 | 12.4982 | 12.4982 | 12.4982 | 16800.0 |
| 2011-03-10 07:11:00 | AAPL | Stock | 12.5089 | 12.5089 | 12.5089 | 12.5089 | 37800.0 |
| 2011-03-10 07:14:00 | AAPL | Stock | 12.5071 | 12.5071 | 12.5071 | 12.5071 | 2800.0 |
| 2011-03-10 07:15:00 | AAPL | Stock | 12.5071 | 12.5071 | 12.5071 | 12.5071 | 11200.0 |
| 2011-03-10 07:16:00 | AAPL | Stock | 12.5071 | 12.5071 | 12.5071 | 12.5071 | 11200.0 |
| 2011-03-10 07:20:00 | AAPL | Stock | 12.5146 | 12.5146 | 12.5146 | 12.5146 | 4704.0 |
| 2011-03-10 07:21:00 | AAPL | Stock | 12.5193 | 12.5193 | 12.5193 | 12.5193 | 2800.0 |
| 2011-03-10 07:23:00 | AAPL | Stock | 12.5107 | 12.5107 | 12.5107 | 12.5107 | 2800.0 |
| 2011-03-10 07:29:00 | AAPL | Stock | 12.5071 | 12.5071 | 12.5071 | 12.5071 | 5936.0 |
| 2011-03-10 07:31:00 | AAPL | Stock | 12.5089 | 12.5089 | 12.5089 | 12.5089 | 5600.0 |
| 2011-03-10 07:35:00 | AAPL | Stock | 12.5071 | 12.5071 | 12.5036 | 12.5036 | 19264.0 |
| 2011-03-10 07:37:00 | AAPL | Stock | 12.5 | 12.5 | 12.5 | 12.5 | 2800.0 |
| 2011-03-10 07:40:00 | AAPL | Stock | 12.5 | 12.5 | 12.5 | 12.5 | 2800.0 |
| 2011-03-10 07:41:00 | AAPL | Stock | 12.5 | 12.5 | 12.5 | 12.5 | 21560.0 |
| 2011-03-10 07:42:00 | AAPL | Stock | 12.4889 | 12.4911 | 12.4889 | 12.4911 | 14000.0 |
| 2011-03-10 07:43:00 | AAPL | Stock | 12.4918 | 12.4929 | 12.4918 | 12.4929 | 33600.0 |
| 2011-03-10 07:44:00 | AAPL | Stock | 12.4911 | 12.4911 | 12.4911 | 12.4911 | 39200.0 |
| 2011-03-10 07:45:00 | AAPL | Stock | 12.5 | 12.5 | 12.5 | 12.5 | 78400.0 |
| 2011-03-10 07:48:00 | AAPL | Stock | 12.5018 | 12.5018 | 12.5018 | 12.5018 | 2800.0 |
| 2011-03-10 07:50:00 | AAPL | Stock | 12.5029 | 12.5029 | 12.5 | 12.5 | 11200.0 |
| 2011-03-10 07:51:00 | AAPL | Stock | 12.4929 | 12.4929 | 12.4929 | 12.4929 | 6720.0 |
| 2011-03-10 07:53:00 | AAPL | Stock | 12.4996 | 12.4996 | 12.4996 | 12.4996 | 2800.0 |
| 2011-03-10 07:55:00 | AAPL | Stock | 12.4982 | 12.4982 | 12.4982 | 12.4982 | 5600.0 |
| 2011-03-10 07:56:00 | AAPL | Stock | 12.4982 | 12.4986 | 12.4982 | 12.4986 | 5600.0 |
| 2011-03-10 07:58:00 | AAPL | Stock | 12.4964 | 12.4964 | 12.4964 | 12.4964 | 5600.0 |
| 2011-03-10 07:59:00 | AAPL | Stock | 12.4964 | 12.4964 | 12.4964 | 12.4964 | 8400.0 |
| 2011-03-10 08:00:00 | AAPL | Stock | 12.5 | 12.5186 | 12.5 | 12.5139 | 530432.0 |
| 2011-03-10 08:01:00 | AAPL | Stock | 12.5011 | 12.5104 | 12.5011 | 12.5057 | 52192.0 |
| 2011-03-10 08:02:00 | AAPL | Stock | 12.5054 | 12.5071 | 12.5054 | 12.5054 | 42560.0 |
| 2011-03-10 08:04:00 | AAPL | Stock | 12.5129 | 12.5154 | 12.5125 | 12.5125 | 11200.0 |
| 2011-03-10 08:05:00 | AAPL | Stock | 12.5114 | 12.5207 | 12.5114 | 12.5207 | 5600.0 |
| 2011-03-10 08:06:00 | AAPL | Stock | 12.5214 | 12.5286 | 12.5214 | 12.5286 | 14000.0 |
> showing 50 of 1,064,234 rows — these rows as CSV