PREVIEW / stock_1min / 2011-02-10
file: by_date/stock_1min/2011/2011-02-10.parquet size: 13.0 MB rows: 979,311 symbols: 2,872
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-02-10 04:13:00 | AAPL | Stock | 12.7089 | 12.7089 | 12.7089 | 12.7089 | 2800.0 |
| 2011-02-10 04:18:00 | AAPL | Stock | 12.7011 | 12.7011 | 12.7011 | 12.7011 | 2800.0 |
| 2011-02-10 04:19:00 | AAPL | Stock | 12.6996 | 12.6996 | 12.6786 | 12.6786 | 5600.0 |
| 2011-02-10 04:35:00 | AAPL | Stock | 12.68 | 12.68 | 12.6764 | 12.6764 | 8400.0 |
| 2011-02-10 04:37:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 2800.0 |
| 2011-02-10 04:40:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 14000.0 |
| 2011-02-10 04:41:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 22400.0 |
| 2011-02-10 04:48:00 | AAPL | Stock | 12.6879 | 12.6879 | 12.6879 | 12.6879 | 5600.0 |
| 2011-02-10 04:53:00 | AAPL | Stock | 12.6929 | 12.6929 | 12.6929 | 12.6929 | 14000.0 |
| 2011-02-10 05:02:00 | AAPL | Stock | 12.7046 | 12.7057 | 12.7046 | 12.7057 | 5600.0 |
| 2011-02-10 05:03:00 | AAPL | Stock | 12.7111 | 12.7125 | 12.7111 | 12.7125 | 16800.0 |
| 2011-02-10 05:04:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7143 | 12.7143 | 2800.0 |
| 2011-02-10 05:05:00 | AAPL | Stock | 12.7243 | 12.725 | 12.7243 | 12.725 | 14000.0 |
| 2011-02-10 05:08:00 | AAPL | Stock | 12.7136 | 12.7136 | 12.7136 | 12.7136 | 2800.0 |
| 2011-02-10 05:12:00 | AAPL | Stock | 12.7189 | 12.7189 | 12.7179 | 12.7179 | 5600.0 |
| 2011-02-10 05:14:00 | AAPL | Stock | 12.7189 | 12.7189 | 12.7164 | 12.7164 | 5600.0 |
| 2011-02-10 05:16:00 | AAPL | Stock | 12.7157 | 12.7157 | 12.7157 | 12.7157 | 2800.0 |
| 2011-02-10 05:18:00 | AAPL | Stock | 12.7204 | 12.7204 | 12.7204 | 12.7204 | 2800.0 |
| 2011-02-10 05:30:00 | AAPL | Stock | 12.7179 | 12.7179 | 12.7179 | 12.7179 | 2800.0 |
| 2011-02-10 05:31:00 | AAPL | Stock | 12.7164 | 12.7164 | 12.7164 | 12.7164 | 2800.0 |
| 2011-02-10 05:42:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7143 | 12.7143 | 7000.0 |
| 2011-02-10 06:16:00 | AAPL | Stock | 12.6893 | 12.6893 | 12.6893 | 12.6893 | 2800.0 |
| 2011-02-10 06:28:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6964 | 12.6964 | 2800.0 |
| 2011-02-10 06:29:00 | AAPL | Stock | 12.6964 | 12.6982 | 12.6964 | 12.6982 | 5600.0 |
| 2011-02-10 06:33:00 | AAPL | Stock | 12.6968 | 12.6968 | 12.6968 | 12.6968 | 5600.0 |
| 2011-02-10 06:36:00 | AAPL | Stock | 12.7196 | 12.7196 | 12.7196 | 12.7196 | 11200.0 |
| 2011-02-10 06:37:00 | AAPL | Stock | 12.7196 | 12.7196 | 12.7196 | 12.7196 | 8400.0 |
| 2011-02-10 06:38:00 | AAPL | Stock | 12.7196 | 12.7196 | 12.7196 | 12.7196 | 2800.0 |
| 2011-02-10 06:42:00 | AAPL | Stock | 12.7411 | 12.7411 | 12.7411 | 12.7411 | 5600.0 |
| 2011-02-10 06:44:00 | AAPL | Stock | 12.7411 | 12.7411 | 12.7411 | 12.7411 | 8400.0 |
| 2011-02-10 07:00:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7143 | 12.7143 | 8400.0 |
| 2011-02-10 07:01:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7143 | 12.7143 | 16800.0 |
| 2011-02-10 07:05:00 | AAPL | Stock | 12.7036 | 12.7036 | 12.7036 | 12.7036 | 5600.0 |
| 2011-02-10 07:08:00 | AAPL | Stock | 12.7054 | 12.7054 | 12.7054 | 12.7054 | 2800.0 |
| 2011-02-10 07:12:00 | AAPL | Stock | 12.7079 | 12.7164 | 12.7075 | 12.7164 | 11200.0 |
| 2011-02-10 07:13:00 | AAPL | Stock | 12.7175 | 12.7175 | 12.7175 | 12.7175 | 3080.0 |
| 2011-02-10 07:14:00 | AAPL | Stock | 12.7175 | 12.7175 | 12.7175 | 12.7175 | 11200.0 |
| 2011-02-10 07:15:00 | AAPL | Stock | 12.7175 | 12.7175 | 12.7175 | 12.7175 | 11200.0 |
| 2011-02-10 07:16:00 | AAPL | Stock | 12.7175 | 12.7175 | 12.7175 | 12.7175 | 18620.0 |
| 2011-02-10 07:17:00 | AAPL | Stock | 12.7175 | 12.7175 | 12.7107 | 12.7107 | 49000.0 |
| 2011-02-10 07:18:00 | AAPL | Stock | 12.7139 | 12.7139 | 12.7139 | 12.7139 | 29960.0 |
| 2011-02-10 07:19:00 | AAPL | Stock | 12.7139 | 12.7139 | 12.7139 | 12.7139 | 8400.0 |
| 2011-02-10 07:20:00 | AAPL | Stock | 12.7139 | 12.7139 | 12.7139 | 12.7139 | 11200.0 |
| 2011-02-10 07:22:00 | AAPL | Stock | 12.7075 | 12.7075 | 12.7075 | 12.7075 | 8400.0 |
| 2011-02-10 07:23:00 | AAPL | Stock | 12.71 | 12.7125 | 12.71 | 12.7125 | 8400.0 |
| 2011-02-10 07:24:00 | AAPL | Stock | 12.7071 | 12.7071 | 12.7071 | 12.7071 | 2800.0 |
| 2011-02-10 07:25:00 | AAPL | Stock | 12.7071 | 12.7071 | 12.7071 | 12.7071 | 11200.0 |
| 2011-02-10 07:27:00 | AAPL | Stock | 12.7125 | 12.7139 | 12.7125 | 12.7139 | 30800.0 |
| 2011-02-10 07:28:00 | AAPL | Stock | 12.7139 | 12.7139 | 12.7139 | 12.7139 | 5600.0 |
| 2011-02-10 07:29:00 | AAPL | Stock | 12.7139 | 12.7139 | 12.7075 | 12.7139 | 25200.0 |
> showing 50 of 979,311 rows — these rows as CSV