PREVIEW / stock_1min / 2016-05-25
file: by_date/stock_1min/2016/2016-05-25.parquet size: 14.5 MB rows: 1,068,546 symbols: 2,696
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-25 04:00:00 | AAPL | Stock | 24.6125 | 24.6725 | 24.6125 | 24.6725 | 11000.0 |
| 2016-05-25 04:02:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 2632.0 |
| 2016-05-25 04:03:00 | AAPL | Stock | 24.6625 | 24.67 | 24.6625 | 24.67 | 800.0 |
| 2016-05-25 04:05:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.6725 | 24.6725 | 3600.0 |
| 2016-05-25 04:10:00 | AAPL | Stock | 24.67 | 24.67 | 24.67 | 24.67 | 400.0 |
| 2016-05-25 04:12:00 | AAPL | Stock | 24.67 | 24.67 | 24.67 | 24.67 | 1912.0 |
| 2016-05-25 04:17:00 | AAPL | Stock | 24.675 | 24.6875 | 24.675 | 24.6875 | 3896.0 |
| 2016-05-25 04:21:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.6875 | 24.6875 | 860.0 |
| 2016-05-25 04:23:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.6875 | 24.6875 | 2208.0 |
| 2016-05-25 04:31:00 | AAPL | Stock | 24.685 | 24.685 | 24.6525 | 24.6525 | 952.0 |
| 2016-05-25 04:33:00 | AAPL | Stock | 24.6625 | 24.6625 | 24.6625 | 24.6625 | 840.0 |
| 2016-05-25 04:57:00 | AAPL | Stock | 24.685 | 24.685 | 24.685 | 24.685 | 920.0 |
| 2016-05-25 04:58:00 | AAPL | Stock | 24.6875 | 24.6925 | 24.6875 | 24.6925 | 1220.0 |
| 2016-05-25 05:15:00 | AAPL | Stock | 24.7225 | 24.7225 | 24.7225 | 24.7225 | 1400.0 |
| 2016-05-25 05:24:00 | AAPL | Stock | 24.7375 | 24.7375 | 24.7375 | 24.7375 | 908.0 |
| 2016-05-25 05:30:00 | AAPL | Stock | 24.7325 | 24.7325 | 24.7325 | 24.7325 | 400.0 |
| 2016-05-25 05:31:00 | AAPL | Stock | 24.73 | 24.73 | 24.73 | 24.73 | 560.0 |
| 2016-05-25 05:33:00 | AAPL | Stock | 24.7375 | 24.7375 | 24.675 | 24.675 | 800.0 |
| 2016-05-25 05:45:00 | AAPL | Stock | 24.7375 | 24.7375 | 24.735 | 24.735 | 2800.0 |
| 2016-05-25 05:54:00 | AAPL | Stock | 24.7225 | 24.7225 | 24.7225 | 24.7225 | 1600.0 |
| 2016-05-25 05:57:00 | AAPL | Stock | 24.7225 | 24.7225 | 24.7125 | 24.7125 | 1200.0 |
| 2016-05-25 06:05:00 | AAPL | Stock | 24.7 | 24.7 | 24.6775 | 24.6775 | 1320.0 |
| 2016-05-25 06:06:00 | AAPL | Stock | 24.69 | 24.69 | 24.69 | 24.69 | 1868.0 |
| 2016-05-25 06:07:00 | AAPL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 800.0 |
| 2016-05-25 06:09:00 | AAPL | Stock | 24.675 | 24.675 | 24.67 | 24.675 | 2112.0 |
| 2016-05-25 06:12:00 | AAPL | Stock | 24.71 | 24.71 | 24.71 | 24.71 | 400.0 |
| 2016-05-25 06:18:00 | AAPL | Stock | 24.6875 | 24.6875 | 24.6875 | 24.6875 | 4000.0 |
| 2016-05-25 06:20:00 | AAPL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 400.0 |
| 2016-05-25 06:24:00 | AAPL | Stock | 24.71 | 24.71 | 24.71 | 24.71 | 400.0 |
| 2016-05-25 06:25:00 | AAPL | Stock | 24.7125 | 24.7125 | 24.7125 | 24.7125 | 600.0 |
| 2016-05-25 06:26:00 | AAPL | Stock | 24.7125 | 24.7125 | 24.7125 | 24.7125 | 4624.0 |
| 2016-05-25 06:29:00 | AAPL | Stock | 24.7 | 24.7 | 24.6975 | 24.6975 | 1600.0 |
| 2016-05-25 06:30:00 | AAPL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 1600.0 |
| 2016-05-25 06:33:00 | AAPL | Stock | 24.7 | 24.7 | 24.7 | 24.7 | 4000.0 |
| 2016-05-25 06:37:00 | AAPL | Stock | 24.6875 | 24.69 | 24.6875 | 24.69 | 1600.0 |
| 2016-05-25 06:38:00 | AAPL | Stock | 24.6775 | 24.6775 | 24.675 | 24.675 | 2600.0 |
| 2016-05-25 06:39:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 3764.0 |
| 2016-05-25 06:40:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 400.0 |
| 2016-05-25 06:43:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 800.0 |
| 2016-05-25 06:45:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 400.0 |
| 2016-05-25 06:46:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 400.0 |
| 2016-05-25 06:47:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 1572.0 |
| 2016-05-25 06:48:00 | AAPL | Stock | 24.67 | 24.67 | 24.67 | 24.67 | 2000.0 |
| 2016-05-25 06:50:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 400.0 |
| 2016-05-25 06:54:00 | AAPL | Stock | 24.67 | 24.67 | 24.67 | 24.67 | 4000.0 |
| 2016-05-25 06:55:00 | AAPL | Stock | 24.6725 | 24.6725 | 24.6725 | 24.6725 | 4000.0 |
| 2016-05-25 06:56:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 400.0 |
| 2016-05-25 06:58:00 | AAPL | Stock | 24.675 | 24.675 | 24.675 | 24.675 | 1956.0 |
| 2016-05-25 06:59:00 | AAPL | Stock | 24.665 | 24.665 | 24.665 | 24.665 | 2600.0 |
| 2016-05-25 07:00:00 | AAPL | Stock | 24.67 | 24.67 | 24.67 | 24.67 | 416.0 |
> showing 50 of 1,068,546 rows — these rows as CSV