PREVIEW / stock_1min / 2014-12-16
file: by_date/stock_1min/2014/2014-12-16.parquet size: 16.7 MB rows: 1,192,946 symbols: 2,893
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-16 04:00:00 | AAPL | Stock | 26.975 | 26.975 | 26.975 | 26.975 | 17660.0 |
| 2014-12-16 04:01:00 | AAPL | Stock | 26.8375 | 26.8375 | 26.8125 | 26.8125 | 2400.0 |
| 2014-12-16 04:02:00 | AAPL | Stock | 26.8025 | 26.8025 | 26.8 | 26.8 | 2800.0 |
| 2014-12-16 04:04:00 | AAPL | Stock | 26.8125 | 26.8125 | 26.77 | 26.7875 | 2000.0 |
| 2014-12-16 04:06:00 | AAPL | Stock | 26.79 | 26.7925 | 26.79 | 26.7925 | 2000.0 |
| 2014-12-16 04:07:00 | AAPL | Stock | 26.8175 | 26.8175 | 26.8175 | 26.8175 | 400.0 |
| 2014-12-16 04:10:00 | AAPL | Stock | 26.795 | 26.795 | 26.795 | 26.795 | 800.0 |
| 2014-12-16 04:14:00 | AAPL | Stock | 26.845 | 26.845 | 26.845 | 26.845 | 400.0 |
| 2014-12-16 04:15:00 | AAPL | Stock | 26.845 | 26.845 | 26.845 | 26.845 | 800.0 |
| 2014-12-16 04:19:00 | AAPL | Stock | 26.8975 | 26.8975 | 26.8975 | 26.8975 | 400.0 |
| 2014-12-16 04:31:00 | AAPL | Stock | 26.9 | 26.9 | 26.9 | 26.9 | 1200.0 |
| 2014-12-16 04:32:00 | AAPL | Stock | 26.8975 | 26.8975 | 26.8975 | 26.8975 | 400.0 |
| 2014-12-16 04:33:00 | AAPL | Stock | 26.95 | 26.95 | 26.95 | 26.95 | 2000.0 |
| 2014-12-16 04:34:00 | AAPL | Stock | 26.95 | 26.95 | 26.95 | 26.95 | 2000.0 |
| 2014-12-16 04:35:00 | AAPL | Stock | 26.95 | 26.9675 | 26.95 | 26.9675 | 2400.0 |
| 2014-12-16 04:43:00 | AAPL | Stock | 26.9025 | 26.925 | 26.9025 | 26.925 | 1212.0 |
| 2014-12-16 04:45:00 | AAPL | Stock | 26.9225 | 26.9225 | 26.9225 | 26.9225 | 400.0 |
| 2014-12-16 04:46:00 | AAPL | Stock | 26.925 | 26.925 | 26.925 | 26.925 | 6184.0 |
| 2014-12-16 04:52:00 | AAPL | Stock | 26.925 | 26.925 | 26.925 | 26.925 | 4000.0 |
| 2014-12-16 04:53:00 | AAPL | Stock | 26.945 | 26.945 | 26.945 | 26.945 | 2012.0 |
| 2014-12-16 04:58:00 | AAPL | Stock | 26.945 | 26.945 | 26.945 | 26.945 | 424.0 |
| 2014-12-16 05:00:00 | AAPL | Stock | 26.9525 | 26.9525 | 26.9525 | 26.9525 | 2000.0 |
| 2014-12-16 05:02:00 | AAPL | Stock | 26.945 | 26.945 | 26.945 | 26.945 | 400.0 |
| 2014-12-16 05:04:00 | AAPL | Stock | 26.9525 | 26.9525 | 26.9525 | 26.9525 | 7064.0 |
| 2014-12-16 05:23:00 | AAPL | Stock | 26.9575 | 26.9575 | 26.9575 | 26.9575 | 800.0 |
| 2014-12-16 05:26:00 | AAPL | Stock | 26.9475 | 26.9475 | 26.9475 | 26.9475 | 3640.0 |
| 2014-12-16 05:34:00 | AAPL | Stock | 26.9725 | 26.9725 | 26.9725 | 26.9725 | 2000.0 |
| 2014-12-16 05:42:00 | AAPL | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 400.0 |
| 2014-12-16 05:49:00 | AAPL | Stock | 26.9975 | 27.025 | 26.9975 | 27.025 | 6800.0 |
| 2014-12-16 06:01:00 | AAPL | Stock | 26.985 | 26.985 | 26.985 | 26.985 | 1976.0 |
| 2014-12-16 06:02:00 | AAPL | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 400.0 |
| 2014-12-16 06:10:00 | AAPL | Stock | 27.025 | 27.05 | 27.025 | 27.0475 | 11688.0 |
| 2014-12-16 06:11:00 | AAPL | Stock | 27.035 | 27.035 | 27.035 | 27.035 | 1200.0 |
| 2014-12-16 06:12:00 | AAPL | Stock | 27.05 | 27.05 | 27.05 | 27.05 | 2400.0 |
| 2014-12-16 06:15:00 | AAPL | Stock | 27.04 | 27.04 | 27.035 | 27.035 | 9996.0 |
| 2014-12-16 06:22:00 | AAPL | Stock | 27.0375 | 27.0375 | 27.0375 | 27.0375 | 3884.0 |
| 2014-12-16 06:24:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 1600.0 |
| 2014-12-16 06:31:00 | AAPL | Stock | 27.015 | 27.015 | 27.015 | 27.015 | 400.0 |
| 2014-12-16 06:32:00 | AAPL | Stock | 27.015 | 27.015 | 26.985 | 26.985 | 3176.0 |
| 2014-12-16 06:33:00 | AAPL | Stock | 26.9675 | 26.9675 | 26.9675 | 26.9675 | 1120.0 |
| 2014-12-16 06:34:00 | AAPL | Stock | 26.965 | 26.9675 | 26.965 | 26.9675 | 4000.0 |
| 2014-12-16 06:35:00 | AAPL | Stock | 26.965 | 26.965 | 26.965 | 26.965 | 2400.0 |
| 2014-12-16 06:38:00 | AAPL | Stock | 26.9625 | 26.9625 | 26.9625 | 26.9625 | 800.0 |
| 2014-12-16 06:41:00 | AAPL | Stock | 26.975 | 27.0125 | 26.9625 | 27.0125 | 4000.0 |
| 2014-12-16 06:44:00 | AAPL | Stock | 26.95 | 26.95 | 26.95 | 26.95 | 400.0 |
| 2014-12-16 06:45:00 | AAPL | Stock | 26.9375 | 26.9375 | 26.9375 | 26.9375 | 400.0 |
| 2014-12-16 06:47:00 | AAPL | Stock | 26.9375 | 26.9375 | 26.9375 | 26.9375 | 560.0 |
| 2014-12-16 06:48:00 | AAPL | Stock | 26.9375 | 26.9375 | 26.9375 | 26.9375 | 1020.0 |
| 2014-12-16 06:50:00 | AAPL | Stock | 26.92 | 26.92 | 26.92 | 26.92 | 800.0 |
| 2014-12-16 06:52:00 | AAPL | Stock | 26.9025 | 26.9025 | 26.9 | 26.9 | 8680.0 |
> showing 50 of 1,192,946 rows — these rows as CSV