PREVIEW / stock_1min / 2017-11-10
file: by_date/stock_1min/2017/2017-11-10.parquet size: 14.6 MB rows: 1,051,495 symbols: 2,445
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-10 04:13:00 | AAPL | Stock | 43.855 | 43.855 | 43.825 | 43.825 | 2788.0 |
| 2017-11-10 04:16:00 | AAPL | Stock | 43.825 | 43.855 | 43.825 | 43.855 | 2400.0 |
| 2017-11-10 04:20:00 | AAPL | Stock | 43.7875 | 43.7875 | 43.7875 | 43.7875 | 2388.0 |
| 2017-11-10 04:22:00 | AAPL | Stock | 43.7975 | 43.7975 | 43.75 | 43.75 | 11592.0 |
| 2017-11-10 04:27:00 | AAPL | Stock | 43.75 | 43.75 | 43.6825 | 43.6825 | 10940.0 |
| 2017-11-10 04:29:00 | AAPL | Stock | 43.68 | 43.68 | 43.66 | 43.66 | 2944.0 |
| 2017-11-10 04:30:00 | AAPL | Stock | 43.68 | 43.68 | 43.68 | 43.68 | 4000.0 |
| 2017-11-10 04:32:00 | AAPL | Stock | 43.67 | 43.67 | 43.67 | 43.67 | 584.0 |
| 2017-11-10 04:33:00 | AAPL | Stock | 43.675 | 43.68 | 43.675 | 43.68 | 1640.0 |
| 2017-11-10 04:34:00 | AAPL | Stock | 43.6775 | 43.6825 | 43.6775 | 43.6825 | 3600.0 |
| 2017-11-10 04:36:00 | AAPL | Stock | 43.65 | 43.65 | 43.65 | 43.65 | 3716.0 |
| 2017-11-10 04:56:00 | AAPL | Stock | 43.65 | 43.65 | 43.65 | 43.65 | 776.0 |
| 2017-11-10 04:57:00 | AAPL | Stock | 43.65 | 43.65 | 43.65 | 43.65 | 3200.0 |
| 2017-11-10 05:07:00 | AAPL | Stock | 43.625 | 43.625 | 43.6125 | 43.6125 | 5200.0 |
| 2017-11-10 05:19:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6125 | 43.6125 | 1600.0 |
| 2017-11-10 05:22:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6 | 43.6 | 7952.0 |
| 2017-11-10 05:30:00 | AAPL | Stock | 43.6075 | 43.6075 | 43.575 | 43.575 | 11520.0 |
| 2017-11-10 05:46:00 | AAPL | Stock | 43.67 | 43.76 | 43.67 | 43.76 | 13796.0 |
| 2017-11-10 05:52:00 | AAPL | Stock | 43.705 | 43.705 | 43.705 | 43.705 | 800.0 |
| 2017-11-10 05:53:00 | AAPL | Stock | 43.74 | 43.74 | 43.74 | 43.74 | 400.0 |
| 2017-11-10 05:54:00 | AAPL | Stock | 43.735 | 43.755 | 43.735 | 43.755 | 6400.0 |
| 2017-11-10 05:55:00 | AAPL | Stock | 43.7475 | 43.7475 | 43.7475 | 43.7475 | 400.0 |
| 2017-11-10 05:56:00 | AAPL | Stock | 43.745 | 43.745 | 43.745 | 43.745 | 400.0 |
| 2017-11-10 05:59:00 | AAPL | Stock | 43.665 | 43.665 | 43.66 | 43.66 | 1220.0 |
| 2017-11-10 06:00:00 | AAPL | Stock | 43.6625 | 43.6625 | 43.6625 | 43.6625 | 800.0 |
| 2017-11-10 06:03:00 | AAPL | Stock | 43.74 | 43.745 | 43.74 | 43.745 | 3400.0 |
| 2017-11-10 06:06:00 | AAPL | Stock | 43.72 | 43.72 | 43.72 | 43.72 | 4000.0 |
| 2017-11-10 06:14:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.7375 | 43.7375 | 768.0 |
| 2017-11-10 06:17:00 | AAPL | Stock | 43.7425 | 43.745 | 43.7425 | 43.745 | 3252.0 |
| 2017-11-10 06:23:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7125 | 43.7125 | 400.0 |
| 2017-11-10 06:25:00 | AAPL | Stock | 43.7125 | 43.7125 | 43.7125 | 43.7125 | 400.0 |
| 2017-11-10 06:28:00 | AAPL | Stock | 43.7 | 43.7 | 43.7 | 43.7 | 800.0 |
| 2017-11-10 06:34:00 | AAPL | Stock | 43.6975 | 43.6975 | 43.6975 | 43.6975 | 400.0 |
| 2017-11-10 06:49:00 | AAPL | Stock | 43.71 | 43.71 | 43.71 | 43.71 | 1200.0 |
| 2017-11-10 06:50:00 | AAPL | Stock | 43.6925 | 43.6925 | 43.6925 | 43.6925 | 400.0 |
| 2017-11-10 06:52:00 | AAPL | Stock | 43.6925 | 43.6925 | 43.6925 | 43.6925 | 400.0 |
| 2017-11-10 07:00:00 | AAPL | Stock | 43.71 | 43.75 | 43.71 | 43.75 | 2800.0 |
| 2017-11-10 07:01:00 | AAPL | Stock | 43.7275 | 43.73 | 43.725 | 43.73 | 8512.0 |
| 2017-11-10 07:02:00 | AAPL | Stock | 43.73 | 43.75 | 43.73 | 43.75 | 1200.0 |
| 2017-11-10 07:03:00 | AAPL | Stock | 43.76 | 43.76 | 43.75 | 43.75 | 1200.0 |
| 2017-11-10 07:05:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 2000.0 |
| 2017-11-10 07:07:00 | AAPL | Stock | 43.77 | 43.77 | 43.77 | 43.77 | 2800.0 |
| 2017-11-10 07:08:00 | AAPL | Stock | 43.77 | 43.77 | 43.77 | 43.77 | 4824.0 |
| 2017-11-10 07:09:00 | AAPL | Stock | 43.76 | 43.76 | 43.76 | 43.76 | 2400.0 |
| 2017-11-10 07:10:00 | AAPL | Stock | 43.7725 | 43.7725 | 43.7475 | 43.7475 | 24836.0 |
| 2017-11-10 07:17:00 | AAPL | Stock | 43.745 | 43.745 | 43.745 | 43.745 | 428.0 |
| 2017-11-10 07:18:00 | AAPL | Stock | 43.7425 | 43.7425 | 43.7425 | 43.7425 | 800.0 |
| 2017-11-10 07:22:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.7375 | 43.7375 | 3600.0 |
| 2017-11-10 07:23:00 | AAPL | Stock | 43.7275 | 43.7275 | 43.7275 | 43.7275 | 640.0 |
| 2017-11-10 07:25:00 | AAPL | Stock | 43.74 | 43.74 | 43.74 | 43.74 | 400.0 |
> showing 50 of 1,051,495 rows — these rows as CSV