PREVIEW / stock_1min / 2008-11-10
file: by_date/stock_1min/2008/2008-11-10.parquet size: 11.9 MB rows: 955,139 symbols: 2,695
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-10 07:02:00 | AAPL | Stock | 3.5839 | 3.5839 | 3.5839 | 3.5839 | 3920.0 |
| 2008-11-10 07:15:00 | AAPL | Stock | 3.5882 | 3.5882 | 3.5882 | 3.5882 | 12600.0 |
| 2008-11-10 07:18:00 | AAPL | Stock | 3.6204 | 3.6429 | 3.6204 | 3.6429 | 59808.0 |
| 2008-11-10 07:19:00 | AAPL | Stock | 3.6161 | 3.6161 | 3.6161 | 3.6161 | 5600.0 |
| 2008-11-10 07:20:00 | AAPL | Stock | 3.6161 | 3.6161 | 3.6161 | 3.6161 | 22400.0 |
| 2008-11-10 07:26:00 | AAPL | Stock | 3.6157 | 3.6161 | 3.6157 | 3.6161 | 8400.0 |
| 2008-11-10 07:27:00 | AAPL | Stock | 3.6071 | 3.6071 | 3.6071 | 3.6071 | 2800.0 |
| 2008-11-10 07:28:00 | AAPL | Stock | 3.6068 | 3.6071 | 3.6068 | 3.6071 | 14000.0 |
| 2008-11-10 07:39:00 | AAPL | Stock | 3.6036 | 3.6036 | 3.6036 | 3.6036 | 10892.0 |
| 2008-11-10 07:46:00 | AAPL | Stock | 3.6 | 3.6 | 3.6 | 3.6 | 4004.0 |
| 2008-11-10 07:47:00 | AAPL | Stock | 3.6 | 3.6 | 3.6 | 3.6 | 9996.0 |
| 2008-11-10 07:51:00 | AAPL | Stock | 3.6018 | 3.6018 | 3.6018 | 3.6018 | 29400.0 |
| 2008-11-10 07:55:00 | AAPL | Stock | 3.6 | 3.6014 | 3.6 | 3.6014 | 30800.0 |
| 2008-11-10 07:56:00 | AAPL | Stock | 3.6014 | 3.6014 | 3.6 | 3.6 | 12404.0 |
| 2008-11-10 07:57:00 | AAPL | Stock | 3.6 | 3.6 | 3.6 | 3.6 | 5600.0 |
| 2008-11-10 07:58:00 | AAPL | Stock | 3.6 | 3.6 | 3.6 | 3.6 | 11200.0 |
| 2008-11-10 07:59:00 | AAPL | Stock | 3.6014 | 3.6014 | 3.6014 | 3.6014 | 5600.0 |
| 2008-11-10 08:00:00 | AAPL | Stock | 3.6014 | 3.6018 | 3.5929 | 3.5946 | 128072.0 |
| 2008-11-10 08:01:00 | AAPL | Stock | 3.5946 | 3.6175 | 3.5946 | 3.6175 | 309792.0 |
| 2008-11-10 08:02:00 | AAPL | Stock | 3.6164 | 3.6214 | 3.6111 | 3.6214 | 213808.0 |
| 2008-11-10 08:03:00 | AAPL | Stock | 3.6114 | 3.6161 | 3.6114 | 3.6161 | 18200.0 |
| 2008-11-10 08:04:00 | AAPL | Stock | 3.6214 | 3.6214 | 3.6111 | 3.6143 | 73640.0 |
| 2008-11-10 08:05:00 | AAPL | Stock | 3.6143 | 3.6143 | 3.6143 | 3.6143 | 21000.0 |
| 2008-11-10 08:06:00 | AAPL | Stock | 3.6136 | 3.6136 | 3.6114 | 3.6118 | 11200.0 |
| 2008-11-10 08:07:00 | AAPL | Stock | 3.6118 | 3.6118 | 3.6075 | 3.6118 | 11200.0 |
| 2008-11-10 08:08:00 | AAPL | Stock | 3.6089 | 3.6089 | 3.6089 | 3.6089 | 13580.0 |
| 2008-11-10 08:09:00 | AAPL | Stock | 3.6071 | 3.6075 | 3.6039 | 3.6039 | 62132.0 |
| 2008-11-10 08:10:00 | AAPL | Stock | 3.6068 | 3.6071 | 3.6068 | 3.6071 | 8400.0 |
| 2008-11-10 08:11:00 | AAPL | Stock | 3.6068 | 3.6068 | 3.6036 | 3.6036 | 76132.0 |
| 2008-11-10 08:12:00 | AAPL | Stock | 3.6036 | 3.6036 | 3.5911 | 3.5911 | 85876.0 |
| 2008-11-10 08:14:00 | AAPL | Stock | 3.6007 | 3.6007 | 3.6007 | 3.6007 | 2800.0 |
| 2008-11-10 08:15:00 | AAPL | Stock | 3.6007 | 3.6071 | 3.6007 | 3.6071 | 41020.0 |
| 2008-11-10 08:16:00 | AAPL | Stock | 3.6036 | 3.6036 | 3.6 | 3.6 | 64120.0 |
| 2008-11-10 08:17:00 | AAPL | Stock | 3.6014 | 3.6032 | 3.5921 | 3.5932 | 51100.0 |
| 2008-11-10 08:18:00 | AAPL | Stock | 3.5989 | 3.5989 | 3.5929 | 3.5929 | 100268.0 |
| 2008-11-10 08:19:00 | AAPL | Stock | 3.5921 | 3.5921 | 3.5857 | 3.5911 | 64988.0 |
| 2008-11-10 08:20:00 | AAPL | Stock | 3.5889 | 3.5893 | 3.5889 | 3.5893 | 42280.0 |
| 2008-11-10 08:21:00 | AAPL | Stock | 3.5929 | 3.5929 | 3.5929 | 3.5929 | 12320.0 |
| 2008-11-10 08:22:00 | AAPL | Stock | 3.5893 | 3.5893 | 3.5857 | 3.5893 | 82572.0 |
| 2008-11-10 08:23:00 | AAPL | Stock | 3.5904 | 3.5904 | 3.5896 | 3.59 | 11200.0 |
| 2008-11-10 08:24:00 | AAPL | Stock | 3.5893 | 3.5896 | 3.5893 | 3.5893 | 78400.0 |
| 2008-11-10 08:25:00 | AAPL | Stock | 3.5893 | 3.5893 | 3.5893 | 3.5893 | 5600.0 |
| 2008-11-10 08:26:00 | AAPL | Stock | 3.5893 | 3.5896 | 3.5875 | 3.5875 | 22680.0 |
| 2008-11-10 08:27:00 | AAPL | Stock | 3.5857 | 3.5875 | 3.5857 | 3.5857 | 57400.0 |
| 2008-11-10 08:28:00 | AAPL | Stock | 3.5857 | 3.5875 | 3.5857 | 3.5875 | 9800.0 |
| 2008-11-10 08:29:00 | AAPL | Stock | 3.5893 | 3.5893 | 3.5893 | 3.5893 | 20160.0 |
| 2008-11-10 08:30:00 | AAPL | Stock | 3.5889 | 3.5889 | 3.5875 | 3.5875 | 8260.0 |
| 2008-11-10 08:31:00 | AAPL | Stock | 3.5864 | 3.5889 | 3.5864 | 3.5889 | 11200.0 |
| 2008-11-10 08:32:00 | AAPL | Stock | 3.5893 | 3.5893 | 3.5889 | 3.5889 | 5600.0 |
| 2008-11-10 08:34:00 | AAPL | Stock | 3.5875 | 3.5875 | 3.5875 | 3.5875 | 2800.0 |
> showing 50 of 955,139 rows — these rows as CSV