PREVIEW / stock_1min / 2015-03-12
file: by_date/stock_1min/2015/2015-03-12.parquet size: 14.9 MB rows: 1,080,251 symbols: 2,880
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-12 04:00:00 | AAPL | Stock | 30.7475 | 30.8575 | 30.7475 | 30.8575 | 7200.0 |
| 2015-03-12 04:02:00 | AAPL | Stock | 30.75 | 30.75 | 30.75 | 30.75 | 400.0 |
| 2015-03-12 04:08:00 | AAPL | Stock | 30.7525 | 30.7525 | 30.75 | 30.75 | 2800.0 |
| 2015-03-12 04:15:00 | AAPL | Stock | 30.725 | 30.725 | 30.7125 | 30.715 | 1200.0 |
| 2015-03-12 04:37:00 | AAPL | Stock | 30.69 | 30.69 | 30.69 | 30.69 | 400.0 |
| 2015-03-12 04:59:00 | AAPL | Stock | 30.6975 | 30.6975 | 30.6975 | 30.6975 | 400.0 |
| 2015-03-12 05:01:00 | AAPL | Stock | 30.69 | 30.69 | 30.69 | 30.69 | 2000.0 |
| 2015-03-12 05:04:00 | AAPL | Stock | 30.6925 | 30.6925 | 30.69 | 30.69 | 1600.0 |
| 2015-03-12 05:05:00 | AAPL | Stock | 30.69 | 30.69 | 30.6825 | 30.6825 | 2396.0 |
| 2015-03-12 05:12:00 | AAPL | Stock | 30.68 | 30.68 | 30.68 | 30.68 | 400.0 |
| 2015-03-12 05:16:00 | AAPL | Stock | 30.68 | 30.68 | 30.68 | 30.68 | 800.0 |
| 2015-03-12 05:19:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.6875 | 30.6875 | 800.0 |
| 2015-03-12 05:29:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.665 | 30.665 | 13200.0 |
| 2015-03-12 05:31:00 | AAPL | Stock | 30.665 | 30.6675 | 30.665 | 30.6675 | 800.0 |
| 2015-03-12 05:32:00 | AAPL | Stock | 30.6675 | 30.6675 | 30.6675 | 30.6675 | 800.0 |
| 2015-03-12 05:37:00 | AAPL | Stock | 30.6675 | 30.6675 | 30.6525 | 30.6525 | 1600.0 |
| 2015-03-12 05:40:00 | AAPL | Stock | 30.645 | 30.645 | 30.645 | 30.645 | 1600.0 |
| 2015-03-12 05:41:00 | AAPL | Stock | 30.645 | 30.645 | 30.645 | 30.645 | 6800.0 |
| 2015-03-12 05:45:00 | AAPL | Stock | 30.645 | 30.645 | 30.645 | 30.645 | 3200.0 |
| 2015-03-12 05:46:00 | AAPL | Stock | 30.645 | 30.645 | 30.645 | 30.645 | 4400.0 |
| 2015-03-12 05:47:00 | AAPL | Stock | 30.645 | 30.645 | 30.64 | 30.645 | 4764.0 |
| 2015-03-12 05:52:00 | AAPL | Stock | 30.65 | 30.65 | 30.65 | 30.65 | 2000.0 |
| 2015-03-12 06:00:00 | AAPL | Stock | 30.675 | 30.6875 | 30.675 | 30.6875 | 2604.0 |
| 2015-03-12 06:09:00 | AAPL | Stock | 30.6425 | 30.6425 | 30.6425 | 30.6425 | 400.0 |
| 2015-03-12 06:13:00 | AAPL | Stock | 30.65 | 30.65 | 30.65 | 30.65 | 3200.0 |
| 2015-03-12 06:16:00 | AAPL | Stock | 30.65 | 30.66 | 30.6475 | 30.6475 | 4400.0 |
| 2015-03-12 06:17:00 | AAPL | Stock | 30.63 | 30.63 | 30.63 | 30.63 | 400.0 |
| 2015-03-12 06:19:00 | AAPL | Stock | 30.675 | 30.675 | 30.675 | 30.675 | 4400.0 |
| 2015-03-12 06:20:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.675 | 30.675 | 4400.0 |
| 2015-03-12 06:23:00 | AAPL | Stock | 30.675 | 30.675 | 30.675 | 30.675 | 4000.0 |
| 2015-03-12 06:30:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.6875 | 30.6875 | 400.0 |
| 2015-03-12 06:31:00 | AAPL | Stock | 30.695 | 30.6975 | 30.695 | 30.6975 | 800.0 |
| 2015-03-12 06:32:00 | AAPL | Stock | 30.7 | 30.7 | 30.7 | 30.7 | 4000.0 |
| 2015-03-12 06:36:00 | AAPL | Stock | 30.7 | 30.7 | 30.7 | 30.7 | 1000.0 |
| 2015-03-12 06:38:00 | AAPL | Stock | 30.7 | 30.7 | 30.675 | 30.675 | 2000.0 |
| 2015-03-12 06:39:00 | AAPL | Stock | 30.7 | 30.7 | 30.7 | 30.7 | 400.0 |
| 2015-03-12 06:42:00 | AAPL | Stock | 30.7 | 30.7 | 30.7 | 30.7 | 400.0 |
| 2015-03-12 06:45:00 | AAPL | Stock | 30.715 | 30.715 | 30.7125 | 30.715 | 6800.0 |
| 2015-03-12 06:48:00 | AAPL | Stock | 30.7075 | 30.7075 | 30.7075 | 30.7075 | 400.0 |
| 2015-03-12 06:53:00 | AAPL | Stock | 30.72 | 30.72 | 30.7175 | 30.72 | 5700.0 |
| 2015-03-12 06:54:00 | AAPL | Stock | 30.7175 | 30.72 | 30.7175 | 30.72 | 1200.0 |
| 2015-03-12 07:02:00 | AAPL | Stock | 30.7175 | 30.7175 | 30.7 | 30.7 | 12012.0 |
| 2015-03-12 07:04:00 | AAPL | Stock | 30.6775 | 30.6775 | 30.675 | 30.675 | 5600.0 |
| 2015-03-12 07:05:00 | AAPL | Stock | 30.6875 | 30.6875 | 30.675 | 30.675 | 4348.0 |
| 2015-03-12 07:06:00 | AAPL | Stock | 30.675 | 30.675 | 30.675 | 30.675 | 2000.0 |
| 2015-03-12 07:07:00 | AAPL | Stock | 30.6625 | 30.675 | 30.6625 | 30.6725 | 5252.0 |
| 2015-03-12 07:13:00 | AAPL | Stock | 30.6625 | 30.6725 | 30.6625 | 30.6725 | 2400.0 |
| 2015-03-12 07:16:00 | AAPL | Stock | 30.6525 | 30.67 | 30.6525 | 30.67 | 800.0 |
| 2015-03-12 07:18:00 | AAPL | Stock | 30.7 | 30.7 | 30.665 | 30.665 | 3200.0 |
| 2015-03-12 07:21:00 | AAPL | Stock | 30.6775 | 30.6775 | 30.6775 | 30.6775 | 8000.0 |
> showing 50 of 1,080,251 rows — these rows as CSV