PREVIEW / stock_1min / 2014-12-09
file: by_date/stock_1min/2014/2014-12-09.parquet size: 15.9 MB rows: 1,136,014 symbols: 2,896
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-12-09 04:00:00 | AAPL | Stock | 28.0875 | 28.0875 | 27.7425 | 27.81 | 23084.0 |
| 2014-12-09 04:01:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 3000.0 |
| 2014-12-09 04:02:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 800.0 |
| 2014-12-09 04:03:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 400.0 |
| 2014-12-09 04:04:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 1200.0 |
| 2014-12-09 04:05:00 | AAPL | Stock | 27.775 | 27.775 | 27.775 | 27.775 | 400.0 |
| 2014-12-09 04:06:00 | AAPL | Stock | 27.7725 | 27.7725 | 27.7725 | 27.7725 | 1600.0 |
| 2014-12-09 04:07:00 | AAPL | Stock | 27.775 | 27.775 | 27.7725 | 27.7725 | 1600.0 |
| 2014-12-09 04:08:00 | AAPL | Stock | 27.785 | 27.785 | 27.785 | 27.785 | 400.0 |
| 2014-12-09 04:10:00 | AAPL | Stock | 27.7925 | 27.7975 | 27.7625 | 27.7625 | 2800.0 |
| 2014-12-09 04:13:00 | AAPL | Stock | 27.7675 | 27.7675 | 27.7675 | 27.7675 | 400.0 |
| 2014-12-09 04:17:00 | AAPL | Stock | 27.7625 | 27.7625 | 27.7575 | 27.7575 | 800.0 |
| 2014-12-09 04:18:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 2600.0 |
| 2014-12-09 04:22:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.7125 | 27.7125 | 800.0 |
| 2014-12-09 04:23:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.7125 | 27.7125 | 1200.0 |
| 2014-12-09 04:25:00 | AAPL | Stock | 27.7825 | 27.7825 | 27.7825 | 27.7825 | 2000.0 |
| 2014-12-09 04:26:00 | AAPL | Stock | 27.765 | 27.765 | 27.765 | 27.765 | 2000.0 |
| 2014-12-09 04:27:00 | AAPL | Stock | 27.765 | 27.765 | 27.765 | 27.765 | 400.0 |
| 2014-12-09 04:28:00 | AAPL | Stock | 27.765 | 27.765 | 27.7575 | 27.7575 | 4000.0 |
| 2014-12-09 04:29:00 | AAPL | Stock | 27.7575 | 27.7575 | 27.7575 | 27.7575 | 8400.0 |
| 2014-12-09 04:30:00 | AAPL | Stock | 27.7575 | 27.7575 | 27.7575 | 27.7575 | 1860.0 |
| 2014-12-09 04:31:00 | AAPL | Stock | 27.7825 | 27.7825 | 27.7825 | 27.7825 | 1400.0 |
| 2014-12-09 04:32:00 | AAPL | Stock | 27.7775 | 27.78 | 27.7775 | 27.78 | 5600.0 |
| 2014-12-09 04:33:00 | AAPL | Stock | 27.7775 | 27.805 | 27.7775 | 27.7775 | 27200.0 |
| 2014-12-09 04:34:00 | AAPL | Stock | 27.7775 | 27.7775 | 27.7775 | 27.7775 | 13460.0 |
| 2014-12-09 04:35:00 | AAPL | Stock | 27.7775 | 27.7825 | 27.7775 | 27.7775 | 85540.0 |
| 2014-12-09 04:37:00 | AAPL | Stock | 27.75 | 27.75 | 27.675 | 27.685 | 22220.0 |
| 2014-12-09 04:39:00 | AAPL | Stock | 27.7025 | 27.7025 | 27.7025 | 27.7025 | 920.0 |
| 2014-12-09 04:41:00 | AAPL | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 756.0 |
| 2014-12-09 04:45:00 | AAPL | Stock | 27.715 | 27.715 | 27.715 | 27.715 | 400.0 |
| 2014-12-09 04:48:00 | AAPL | Stock | 27.7125 | 27.7125 | 27.7125 | 27.7125 | 1600.0 |
| 2014-12-09 04:52:00 | AAPL | Stock | 27.6875 | 27.6875 | 27.6875 | 27.6875 | 1600.0 |
| 2014-12-09 04:53:00 | AAPL | Stock | 27.6875 | 27.6875 | 27.6875 | 27.6875 | 11188.0 |
| 2014-12-09 04:54:00 | AAPL | Stock | 27.6875 | 27.6875 | 27.6875 | 27.6875 | 2400.0 |
| 2014-12-09 04:55:00 | AAPL | Stock | 27.6875 | 27.6875 | 27.6875 | 27.6875 | 400.0 |
| 2014-12-09 04:56:00 | AAPL | Stock | 27.6875 | 27.6875 | 27.6875 | 27.6875 | 400.0 |
| 2014-12-09 04:59:00 | AAPL | Stock | 27.72 | 27.72 | 27.72 | 27.72 | 2000.0 |
| 2014-12-09 05:04:00 | AAPL | Stock | 27.72 | 27.72 | 27.72 | 27.72 | 1980.0 |
| 2014-12-09 05:06:00 | AAPL | Stock | 27.6875 | 27.6875 | 27.6875 | 27.6875 | 400.0 |
| 2014-12-09 05:10:00 | AAPL | Stock | 27.73 | 27.73 | 27.73 | 27.73 | 1600.0 |
| 2014-12-09 05:16:00 | AAPL | Stock | 27.6925 | 27.6925 | 27.6925 | 27.6925 | 400.0 |
| 2014-12-09 05:20:00 | AAPL | Stock | 27.715 | 27.7225 | 27.715 | 27.7225 | 20808.0 |
| 2014-12-09 05:23:00 | AAPL | Stock | 27.75 | 27.765 | 27.75 | 27.765 | 7936.0 |
| 2014-12-09 05:25:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 3200.0 |
| 2014-12-09 05:26:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 800.0 |
| 2014-12-09 05:27:00 | AAPL | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 400.0 |
| 2014-12-09 05:29:00 | AAPL | Stock | 27.755 | 27.755 | 27.755 | 27.755 | 1552.0 |
| 2014-12-09 05:30:00 | AAPL | Stock | 27.765 | 27.765 | 27.765 | 27.765 | 14760.0 |
| 2014-12-09 05:33:00 | AAPL | Stock | 27.7875 | 27.7875 | 27.7875 | 27.7875 | 800.0 |
| 2014-12-09 05:35:00 | AAPL | Stock | 27.7725 | 27.7725 | 27.7725 | 27.7725 | 412.0 |
> showing 50 of 1,136,014 rows — these rows as CSV