PREVIEW / stock_1min / 2014-11-03
file: by_date/stock_1min/2014/2014-11-03.parquet size: 15.4 MB rows: 1,117,408 symbols: 2,902
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-11-03 04:05:00 | AAPL | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 1920.0 |
| 2014-11-03 04:06:00 | AAPL | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 16080.0 |
| 2014-11-03 04:21:00 | AAPL | Stock | 26.99 | 26.99 | 26.99 | 26.99 | 436.0 |
| 2014-11-03 04:29:00 | AAPL | Stock | 26.9625 | 26.9625 | 26.96 | 26.96 | 4312.0 |
| 2014-11-03 04:30:00 | AAPL | Stock | 26.9675 | 26.9675 | 26.9675 | 26.9675 | 2000.0 |
| 2014-11-03 04:31:00 | AAPL | Stock | 26.9675 | 26.9675 | 26.9675 | 26.9675 | 2800.0 |
| 2014-11-03 04:44:00 | AAPL | Stock | 26.965 | 26.965 | 26.965 | 26.965 | 560.0 |
| 2014-11-03 04:45:00 | AAPL | Stock | 26.965 | 26.965 | 26.965 | 26.965 | 1200.0 |
| 2014-11-03 04:47:00 | AAPL | Stock | 26.9575 | 26.9575 | 26.9575 | 26.9575 | 800.0 |
| 2014-11-03 04:49:00 | AAPL | Stock | 26.9475 | 26.9475 | 26.9475 | 26.9475 | 2000.0 |
| 2014-11-03 04:50:00 | AAPL | Stock | 26.9375 | 26.9375 | 26.9375 | 26.9375 | 2000.0 |
| 2014-11-03 05:13:00 | AAPL | Stock | 26.975 | 26.975 | 26.975 | 26.975 | 572.0 |
| 2014-11-03 05:18:00 | AAPL | Stock | 26.975 | 26.975 | 26.975 | 26.975 | 1600.0 |
| 2014-11-03 05:19:00 | AAPL | Stock | 26.98 | 26.98 | 26.98 | 26.98 | 400.0 |
| 2014-11-03 05:30:00 | AAPL | Stock | 26.99 | 26.995 | 26.99 | 26.995 | 1520.0 |
| 2014-11-03 05:34:00 | AAPL | Stock | 26.9775 | 26.9775 | 26.9775 | 26.9775 | 8000.0 |
| 2014-11-03 06:13:00 | AAPL | Stock | 26.9875 | 26.9875 | 26.9875 | 26.9875 | 2000.0 |
| 2014-11-03 06:25:00 | AAPL | Stock | 26.9975 | 27.0 | 26.9975 | 27.0 | 3600.0 |
| 2014-11-03 06:31:00 | AAPL | Stock | 27.025 | 27.025 | 27.025 | 27.025 | 400.0 |
| 2014-11-03 06:33:00 | AAPL | Stock | 27.0025 | 27.0025 | 27.0025 | 27.0025 | 2000.0 |
| 2014-11-03 06:34:00 | AAPL | Stock | 27.0 | 27.0 | 27.0 | 27.0 | 3404.0 |
| 2014-11-03 06:35:00 | AAPL | Stock | 27.0 | 27.0 | 26.9875 | 26.9875 | 5276.0 |
| 2014-11-03 06:36:00 | AAPL | Stock | 26.98 | 26.98 | 26.98 | 26.98 | 2000.0 |
| 2014-11-03 06:41:00 | AAPL | Stock | 26.97 | 26.97 | 26.97 | 26.97 | 1200.0 |
| 2014-11-03 06:46:00 | AAPL | Stock | 26.975 | 26.9775 | 26.9725 | 26.9775 | 4748.0 |
| 2014-11-03 06:48:00 | AAPL | Stock | 26.985 | 26.985 | 26.985 | 26.985 | 1600.0 |
| 2014-11-03 06:49:00 | AAPL | Stock | 26.985 | 26.985 | 26.985 | 26.985 | 400.0 |
| 2014-11-03 06:58:00 | AAPL | Stock | 26.9775 | 26.9775 | 26.975 | 26.975 | 3200.0 |
| 2014-11-03 06:59:00 | AAPL | Stock | 26.975 | 26.975 | 26.975 | 26.975 | 2412.0 |
| 2014-11-03 07:01:00 | AAPL | Stock | 26.985 | 26.985 | 26.975 | 26.985 | 2000.0 |
| 2014-11-03 07:05:00 | AAPL | Stock | 26.9825 | 26.9825 | 26.9775 | 26.9775 | 2800.0 |
| 2014-11-03 07:07:00 | AAPL | Stock | 26.985 | 26.985 | 26.9825 | 26.9825 | 7504.0 |
| 2014-11-03 07:08:00 | AAPL | Stock | 26.9825 | 26.9825 | 26.9825 | 26.9825 | 400.0 |
| 2014-11-03 07:10:00 | AAPL | Stock | 26.9875 | 26.9875 | 26.985 | 26.985 | 5600.0 |
| 2014-11-03 07:13:00 | AAPL | Stock | 26.985 | 26.985 | 26.9825 | 26.985 | 3600.0 |
| 2014-11-03 07:16:00 | AAPL | Stock | 26.9825 | 26.9825 | 26.98 | 26.98 | 3392.0 |
| 2014-11-03 07:17:00 | AAPL | Stock | 26.9875 | 26.9875 | 26.9875 | 26.9875 | 400.0 |
| 2014-11-03 07:18:00 | AAPL | Stock | 26.98 | 26.98 | 26.975 | 26.975 | 4800.0 |
| 2014-11-03 07:20:00 | AAPL | Stock | 26.975 | 26.975 | 26.97 | 26.97 | 2400.0 |
| 2014-11-03 07:21:00 | AAPL | Stock | 26.9675 | 26.9675 | 26.965 | 26.965 | 2000.0 |
| 2014-11-03 07:22:00 | AAPL | Stock | 26.965 | 26.965 | 26.965 | 26.965 | 2000.0 |
| 2014-11-03 07:23:00 | AAPL | Stock | 26.965 | 26.965 | 26.965 | 26.965 | 8000.0 |
| 2014-11-03 07:26:00 | AAPL | Stock | 26.975 | 26.975 | 26.975 | 26.975 | 400.0 |
| 2014-11-03 07:30:00 | AAPL | Stock | 26.975 | 26.975 | 26.975 | 26.975 | 2000.0 |
| 2014-11-03 07:33:00 | AAPL | Stock | 26.9675 | 26.9675 | 26.9625 | 26.9625 | 3780.0 |
| 2014-11-03 07:34:00 | AAPL | Stock | 26.9725 | 26.9725 | 26.9725 | 26.9725 | 800.0 |
| 2014-11-03 07:36:00 | AAPL | Stock | 26.9675 | 26.9675 | 26.965 | 26.965 | 6800.0 |
| 2014-11-03 07:37:00 | AAPL | Stock | 26.97 | 26.97 | 26.97 | 26.97 | 400.0 |
| 2014-11-03 07:39:00 | AAPL | Stock | 26.9725 | 26.9775 | 26.9725 | 26.975 | 10000.0 |
| 2014-11-03 07:45:00 | AAPL | Stock | 26.975 | 26.975 | 26.975 | 26.975 | 2400.0 |
> showing 50 of 1,117,408 rows — these rows as CSV