PREVIEW / stock_1min / 2014-07-10
file: by_date/stock_1min/2014/2014-07-10.parquet size: 14.3 MB rows: 1,060,924 symbols: 2,907
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-10 04:00:00 | AAPL | Stock | 23.845 | 23.845 | 23.845 | 23.845 | 400.0 |
| 2014-07-10 04:02:00 | AAPL | Stock | 23.82 | 23.82 | 23.82 | 23.82 | 800.0 |
| 2014-07-10 04:22:00 | AAPL | Stock | 23.795 | 23.795 | 23.795 | 23.795 | 800.0 |
| 2014-07-10 04:37:00 | AAPL | Stock | 23.7925 | 23.7925 | 23.7925 | 23.7925 | 400.0 |
| 2014-07-10 04:44:00 | AAPL | Stock | 23.78 | 23.78 | 23.78 | 23.78 | 3496.0 |
| 2014-07-10 04:45:00 | AAPL | Stock | 23.78 | 23.78 | 23.78 | 23.78 | 1096.0 |
| 2014-07-10 04:52:00 | AAPL | Stock | 23.76 | 23.76 | 23.76 | 23.76 | 800.0 |
| 2014-07-10 04:55:00 | AAPL | Stock | 23.7575 | 23.7575 | 23.7575 | 23.7575 | 2000.0 |
| 2014-07-10 04:56:00 | AAPL | Stock | 23.75 | 23.75 | 23.725 | 23.725 | 4400.0 |
| 2014-07-10 04:57:00 | AAPL | Stock | 23.725 | 23.725 | 23.725 | 23.725 | 400.0 |
| 2014-07-10 04:58:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 800.0 |
| 2014-07-10 05:02:00 | AAPL | Stock | 23.715 | 23.715 | 23.715 | 23.715 | 1656.0 |
| 2014-07-10 05:04:00 | AAPL | Stock | 23.715 | 23.715 | 23.715 | 23.715 | 2000.0 |
| 2014-07-10 05:11:00 | AAPL | Stock | 23.7225 | 23.7225 | 23.7225 | 23.7225 | 400.0 |
| 2014-07-10 05:14:00 | AAPL | Stock | 23.7 | 23.7 | 23.7 | 23.7 | 2800.0 |
| 2014-07-10 05:15:00 | AAPL | Stock | 23.68 | 23.68 | 23.68 | 23.68 | 1400.0 |
| 2014-07-10 05:36:00 | AAPL | Stock | 23.69 | 23.6925 | 23.69 | 23.6925 | 3508.0 |
| 2014-07-10 05:40:00 | AAPL | Stock | 23.695 | 23.695 | 23.695 | 23.695 | 3140.0 |
| 2014-07-10 05:41:00 | AAPL | Stock | 23.695 | 23.695 | 23.695 | 23.695 | 6400.0 |
| 2014-07-10 05:43:00 | AAPL | Stock | 23.6775 | 23.6775 | 23.6775 | 23.6775 | 400.0 |
| 2014-07-10 05:44:00 | AAPL | Stock | 23.6775 | 23.6775 | 23.6775 | 23.6775 | 1160.0 |
| 2014-07-10 05:45:00 | AAPL | Stock | 23.6775 | 23.68 | 23.6775 | 23.68 | 2400.0 |
| 2014-07-10 05:49:00 | AAPL | Stock | 23.66 | 23.66 | 23.66 | 23.66 | 600.0 |
| 2014-07-10 05:51:00 | AAPL | Stock | 23.66 | 23.66 | 23.66 | 23.66 | 2480.0 |
| 2014-07-10 05:52:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.6375 | 23.6375 | 2000.0 |
| 2014-07-10 05:53:00 | AAPL | Stock | 23.6375 | 23.6375 | 23.63 | 23.63 | 4800.0 |
| 2014-07-10 05:54:00 | AAPL | Stock | 23.6275 | 23.6275 | 23.62 | 23.6225 | 23520.0 |
| 2014-07-10 05:55:00 | AAPL | Stock | 23.61 | 23.61 | 23.6075 | 23.6075 | 2400.0 |
| 2014-07-10 05:58:00 | AAPL | Stock | 23.6075 | 23.62 | 23.6075 | 23.6175 | 6800.0 |
| 2014-07-10 06:00:00 | AAPL | Stock | 23.5825 | 23.59 | 23.5825 | 23.59 | 2400.0 |
| 2014-07-10 06:01:00 | AAPL | Stock | 23.59 | 23.59 | 23.59 | 23.59 | 2000.0 |
| 2014-07-10 06:04:00 | AAPL | Stock | 23.58 | 23.58 | 23.58 | 23.58 | 1000.0 |
| 2014-07-10 06:05:00 | AAPL | Stock | 23.6 | 23.6 | 23.6 | 23.6 | 400.0 |
| 2014-07-10 06:07:00 | AAPL | Stock | 23.58 | 23.58 | 23.5775 | 23.5775 | 3608.0 |
| 2014-07-10 06:09:00 | AAPL | Stock | 23.58 | 23.58 | 23.5775 | 23.5775 | 4000.0 |
| 2014-07-10 06:11:00 | AAPL | Stock | 23.565 | 23.565 | 23.5425 | 23.565 | 10800.0 |
| 2014-07-10 06:12:00 | AAPL | Stock | 23.525 | 23.5625 | 23.515 | 23.5625 | 18040.0 |
| 2014-07-10 06:13:00 | AAPL | Stock | 23.5625 | 23.5625 | 23.5625 | 23.5625 | 4888.0 |
| 2014-07-10 06:16:00 | AAPL | Stock | 23.525 | 23.525 | 23.525 | 23.525 | 4000.0 |
| 2014-07-10 06:17:00 | AAPL | Stock | 23.525 | 23.525 | 23.525 | 23.525 | 1872.0 |
| 2014-07-10 06:19:00 | AAPL | Stock | 23.5125 | 23.5125 | 23.4375 | 23.4375 | 5072.0 |
| 2014-07-10 06:23:00 | AAPL | Stock | 23.4575 | 23.4575 | 23.4575 | 23.4575 | 4000.0 |
| 2014-07-10 06:24:00 | AAPL | Stock | 23.48 | 23.485 | 23.455 | 23.485 | 8800.0 |
| 2014-07-10 06:25:00 | AAPL | Stock | 23.485 | 23.485 | 23.485 | 23.485 | 3600.0 |
| 2014-07-10 06:27:00 | AAPL | Stock | 23.4825 | 23.4825 | 23.4825 | 23.4825 | 800.0 |
| 2014-07-10 06:28:00 | AAPL | Stock | 23.5025 | 23.5025 | 23.5025 | 23.5025 | 8300.0 |
| 2014-07-10 06:30:00 | AAPL | Stock | 23.515 | 23.515 | 23.515 | 23.515 | 800.0 |
| 2014-07-10 06:31:00 | AAPL | Stock | 23.5 | 23.5375 | 23.5 | 23.5375 | 6400.0 |
| 2014-07-10 06:32:00 | AAPL | Stock | 23.5375 | 23.5375 | 23.5125 | 23.5125 | 1600.0 |
| 2014-07-10 06:33:00 | AAPL | Stock | 23.5125 | 23.5125 | 23.5125 | 23.5125 | 400.0 |
> showing 50 of 1,060,924 rows — these rows as CSV