PREVIEW / stock_1min / 2012-11-12
file: by_date/stock_1min/2012/2012-11-12.parquet size: 11.9 MB rows: 893,520 symbols: 2,788
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-12 04:00:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.8214 | 19.8214 | 4200.0 |
| 2012-11-12 04:01:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 28000.0 |
| 2012-11-12 04:26:00 | AAPL | Stock | 19.6604 | 19.6604 | 19.6604 | 19.6604 | 2800.0 |
| 2012-11-12 04:30:00 | AAPL | Stock | 19.6607 | 19.6607 | 19.6607 | 19.6607 | 10640.0 |
| 2012-11-12 04:45:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 14000.0 |
| 2012-11-12 04:46:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 5600.0 |
| 2012-11-12 05:02:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 2800.0 |
| 2012-11-12 05:06:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 16800.0 |
| 2012-11-12 05:53:00 | AAPL | Stock | 19.6464 | 19.6464 | 19.6464 | 19.6464 | 2800.0 |
| 2012-11-12 06:07:00 | AAPL | Stock | 19.6679 | 19.6679 | 19.6679 | 19.6679 | 16800.0 |
| 2012-11-12 06:14:00 | AAPL | Stock | 19.6711 | 19.675 | 19.6711 | 19.675 | 18760.0 |
| 2012-11-12 06:15:00 | AAPL | Stock | 19.6746 | 19.675 | 19.6746 | 19.675 | 5684.0 |
| 2012-11-12 06:23:00 | AAPL | Stock | 19.6964 | 19.7071 | 19.6964 | 19.7071 | 5600.0 |
| 2012-11-12 06:32:00 | AAPL | Stock | 19.7054 | 19.7054 | 19.7054 | 19.7054 | 28000.0 |
| 2012-11-12 06:39:00 | AAPL | Stock | 19.7107 | 19.7107 | 19.7107 | 19.7107 | 3080.0 |
| 2012-11-12 07:00:00 | AAPL | Stock | 19.7054 | 19.7054 | 19.7054 | 19.7054 | 2800.0 |
| 2012-11-12 07:01:00 | AAPL | Stock | 19.7054 | 19.7232 | 19.7054 | 19.7232 | 5600.0 |
| 2012-11-12 07:03:00 | AAPL | Stock | 19.7439 | 19.7439 | 19.7439 | 19.7439 | 4200.0 |
| 2012-11-12 07:04:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.7321 | 19.7321 | 5600.0 |
| 2012-11-12 07:05:00 | AAPL | Stock | 19.7289 | 19.7289 | 19.7289 | 19.7289 | 2800.0 |
| 2012-11-12 07:06:00 | AAPL | Stock | 19.7493 | 19.7496 | 19.7493 | 19.7493 | 13944.0 |
| 2012-11-12 07:08:00 | AAPL | Stock | 19.7536 | 19.7536 | 19.75 | 19.75 | 5600.0 |
| 2012-11-12 07:09:00 | AAPL | Stock | 19.75 | 19.75 | 19.75 | 19.75 | 5600.0 |
| 2012-11-12 07:10:00 | AAPL | Stock | 19.7339 | 19.7411 | 19.7321 | 19.7321 | 74620.0 |
| 2012-11-12 07:11:00 | AAPL | Stock | 19.7232 | 19.7232 | 19.7232 | 19.7232 | 2800.0 |
| 2012-11-12 07:12:00 | AAPL | Stock | 19.7318 | 19.7382 | 19.7318 | 19.7379 | 28476.0 |
| 2012-11-12 07:13:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.7321 | 19.7321 | 2800.0 |
| 2012-11-12 07:14:00 | AAPL | Stock | 19.7164 | 19.7368 | 19.7164 | 19.7218 | 16800.0 |
| 2012-11-12 07:15:00 | AAPL | Stock | 19.7261 | 19.73 | 19.7243 | 19.73 | 8400.0 |
| 2012-11-12 07:16:00 | AAPL | Stock | 19.7204 | 19.7286 | 19.7204 | 19.7286 | 7000.0 |
| 2012-11-12 07:19:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.7282 | 19.7282 | 12880.0 |
| 2012-11-12 07:20:00 | AAPL | Stock | 19.7179 | 19.7179 | 19.7179 | 19.7179 | 2800.0 |
| 2012-11-12 07:21:00 | AAPL | Stock | 19.7286 | 19.7318 | 19.7286 | 19.7286 | 18200.0 |
| 2012-11-12 07:23:00 | AAPL | Stock | 19.7179 | 19.7179 | 19.7054 | 19.7054 | 47936.0 |
| 2012-11-12 07:25:00 | AAPL | Stock | 19.7136 | 19.7143 | 19.7136 | 19.7143 | 12012.0 |
| 2012-11-12 07:26:00 | AAPL | Stock | 19.6971 | 19.6971 | 19.6971 | 19.6971 | 2800.0 |
| 2012-11-12 07:27:00 | AAPL | Stock | 19.7132 | 19.7132 | 19.7054 | 19.7054 | 15988.0 |
| 2012-11-12 07:29:00 | AAPL | Stock | 19.6964 | 19.7143 | 19.6964 | 19.7143 | 14000.0 |
| 2012-11-12 07:32:00 | AAPL | Stock | 19.6964 | 19.6964 | 19.6964 | 19.6964 | 4228.0 |
| 2012-11-12 07:34:00 | AAPL | Stock | 19.7 | 19.7 | 19.7 | 19.7 | 2800.0 |
| 2012-11-12 07:35:00 | AAPL | Stock | 19.7057 | 19.7057 | 19.7054 | 19.7054 | 5600.0 |
| 2012-11-12 07:38:00 | AAPL | Stock | 19.7118 | 19.7118 | 19.7118 | 19.7118 | 5600.0 |
| 2012-11-12 07:39:00 | AAPL | Stock | 19.7121 | 19.7143 | 19.7121 | 19.7143 | 35700.0 |
| 2012-11-12 07:40:00 | AAPL | Stock | 19.7143 | 19.7143 | 19.7143 | 19.7143 | 19600.0 |
| 2012-11-12 07:43:00 | AAPL | Stock | 19.7164 | 19.7321 | 19.7143 | 19.7143 | 22960.0 |
| 2012-11-12 07:44:00 | AAPL | Stock | 19.7304 | 19.7304 | 19.7282 | 19.7282 | 12600.0 |
| 2012-11-12 07:45:00 | AAPL | Stock | 19.7286 | 19.7286 | 19.7286 | 19.7286 | 5600.0 |
| 2012-11-12 07:46:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.7321 | 19.7321 | 2800.0 |
| 2012-11-12 07:49:00 | AAPL | Stock | 19.7179 | 19.7179 | 19.7179 | 19.7179 | 3248.0 |
| 2012-11-12 07:50:00 | AAPL | Stock | 19.7146 | 19.7146 | 19.7143 | 19.7143 | 8400.0 |
> showing 50 of 893,520 rows — these rows as CSV