PREVIEW / stock_1min / 2017-02-24
file: by_date/stock_1min/2017/2017-02-24.parquet size: 14.5 MB rows: 1,055,788 symbols: 2,554
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-02-24 04:00:00 | AAPL | Stock | 34.0375 | 34.0375 | 34.0375 | 34.0375 | 1736.0 |
| 2017-02-24 04:02:00 | AAPL | Stock | 34.0025 | 34.0075 | 34.0 | 34.0075 | 2000.0 |
| 2017-02-24 04:03:00 | AAPL | Stock | 34.0 | 34.0 | 34.0 | 34.0 | 5200.0 |
| 2017-02-24 04:16:00 | AAPL | Stock | 33.99 | 33.99 | 33.99 | 33.99 | 400.0 |
| 2017-02-24 04:31:00 | AAPL | Stock | 33.975 | 33.975 | 33.975 | 33.975 | 1600.0 |
| 2017-02-24 04:33:00 | AAPL | Stock | 33.975 | 33.975 | 33.975 | 33.975 | 800.0 |
| 2017-02-24 04:34:00 | AAPL | Stock | 33.9125 | 33.9725 | 33.9125 | 33.9425 | 3036.0 |
| 2017-02-24 04:36:00 | AAPL | Stock | 33.9425 | 33.9425 | 33.9425 | 33.9425 | 432.0 |
| 2017-02-24 04:38:00 | AAPL | Stock | 33.9 | 33.9 | 33.8775 | 33.8775 | 1056.0 |
| 2017-02-24 04:44:00 | AAPL | Stock | 33.95 | 33.9575 | 33.8775 | 33.88 | 5064.0 |
| 2017-02-24 04:45:00 | AAPL | Stock | 33.88 | 33.88 | 33.88 | 33.88 | 400.0 |
| 2017-02-24 05:14:00 | AAPL | Stock | 33.87 | 33.87 | 33.7525 | 33.7575 | 4132.0 |
| 2017-02-24 05:15:00 | AAPL | Stock | 33.7575 | 33.7575 | 33.7575 | 33.7575 | 3600.0 |
| 2017-02-24 05:18:00 | AAPL | Stock | 33.785 | 33.785 | 33.785 | 33.785 | 400.0 |
| 2017-02-24 05:19:00 | AAPL | Stock | 33.795 | 33.81 | 33.795 | 33.81 | 2016.0 |
| 2017-02-24 05:28:00 | AAPL | Stock | 33.81 | 33.81 | 33.7975 | 33.7975 | 1844.0 |
| 2017-02-24 05:34:00 | AAPL | Stock | 33.8 | 33.8 | 33.795 | 33.795 | 2188.0 |
| 2017-02-24 05:35:00 | AAPL | Stock | 33.795 | 33.795 | 33.795 | 33.795 | 1600.0 |
| 2017-02-24 05:43:00 | AAPL | Stock | 33.8 | 33.8 | 33.795 | 33.795 | 1200.0 |
| 2017-02-24 05:45:00 | AAPL | Stock | 33.775 | 33.775 | 33.75 | 33.75 | 3084.0 |
| 2017-02-24 05:46:00 | AAPL | Stock | 33.7275 | 33.7275 | 33.725 | 33.725 | 5680.0 |
| 2017-02-24 05:47:00 | AAPL | Stock | 33.7275 | 33.7275 | 33.7025 | 33.725 | 2800.0 |
| 2017-02-24 05:49:00 | AAPL | Stock | 33.675 | 33.675 | 33.675 | 33.675 | 1400.0 |
| 2017-02-24 05:50:00 | AAPL | Stock | 33.675 | 33.675 | 33.655 | 33.655 | 4900.0 |
| 2017-02-24 05:56:00 | AAPL | Stock | 33.6775 | 33.6775 | 33.6775 | 33.6775 | 432.0 |
| 2017-02-24 05:57:00 | AAPL | Stock | 33.715 | 33.715 | 33.715 | 33.715 | 4000.0 |
| 2017-02-24 06:05:00 | AAPL | Stock | 33.7175 | 33.7175 | 33.7175 | 33.7175 | 2260.0 |
| 2017-02-24 06:07:00 | AAPL | Stock | 33.7275 | 33.7275 | 33.7175 | 33.7175 | 6000.0 |
| 2017-02-24 06:10:00 | AAPL | Stock | 33.7275 | 33.7275 | 33.7275 | 33.7275 | 400.0 |
| 2017-02-24 06:12:00 | AAPL | Stock | 33.7175 | 33.725 | 33.7175 | 33.725 | 2000.0 |
| 2017-02-24 06:15:00 | AAPL | Stock | 33.7175 | 33.7175 | 33.7175 | 33.7175 | 4204.0 |
| 2017-02-24 06:16:00 | AAPL | Stock | 33.725 | 33.725 | 33.7175 | 33.7175 | 6800.0 |
| 2017-02-24 06:17:00 | AAPL | Stock | 33.7175 | 33.7175 | 33.7175 | 33.7175 | 4000.0 |
| 2017-02-24 06:18:00 | AAPL | Stock | 33.7175 | 33.725 | 33.7175 | 33.725 | 1600.0 |
| 2017-02-24 06:20:00 | AAPL | Stock | 33.7175 | 33.7175 | 33.7175 | 33.7175 | 400.0 |
| 2017-02-24 06:21:00 | AAPL | Stock | 33.7175 | 33.7175 | 33.7175 | 33.7175 | 4472.0 |
| 2017-02-24 06:23:00 | AAPL | Stock | 33.7175 | 33.7175 | 33.7175 | 33.7175 | 976.0 |
| 2017-02-24 06:25:00 | AAPL | Stock | 33.7175 | 33.7175 | 33.7175 | 33.7175 | 400.0 |
| 2017-02-24 06:26:00 | AAPL | Stock | 33.72 | 33.72 | 33.72 | 33.72 | 400.0 |
| 2017-02-24 06:27:00 | AAPL | Stock | 33.7175 | 33.72 | 33.7175 | 33.72 | 2220.0 |
| 2017-02-24 06:28:00 | AAPL | Stock | 33.7175 | 33.7175 | 33.7175 | 33.7175 | 2552.0 |
| 2017-02-24 06:30:00 | AAPL | Stock | 33.7225 | 33.7275 | 33.7225 | 33.7275 | 11372.0 |
| 2017-02-24 06:35:00 | AAPL | Stock | 33.765 | 33.77 | 33.765 | 33.77 | 8480.0 |
| 2017-02-24 06:37:00 | AAPL | Stock | 33.7975 | 33.7975 | 33.7975 | 33.7975 | 1892.0 |
| 2017-02-24 06:38:00 | AAPL | Stock | 33.825 | 33.825 | 33.825 | 33.825 | 1464.0 |
| 2017-02-24 06:39:00 | AAPL | Stock | 33.79 | 33.79 | 33.7775 | 33.7775 | 4400.0 |
| 2017-02-24 06:40:00 | AAPL | Stock | 33.7525 | 33.7525 | 33.75 | 33.75 | 2800.0 |
| 2017-02-24 06:41:00 | AAPL | Stock | 33.75 | 33.75 | 33.75 | 33.75 | 1120.0 |
| 2017-02-24 06:42:00 | AAPL | Stock | 33.785 | 33.7875 | 33.785 | 33.7875 | 2000.0 |
| 2017-02-24 06:45:00 | AAPL | Stock | 33.75 | 33.75 | 33.75 | 33.75 | 700.0 |
> showing 50 of 1,055,788 rows — these rows as CSV