PREVIEW / stock_1min / 2018-10-09
file: by_date/stock_1min/2018/2018-10-09.parquet size: 15.8 MB rows: 1,101,620 symbols: 2,333
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-09 04:02:00 | AAPL | Stock | 55.8675 | 55.8675 | 55.865 | 55.865 | 1536.0 |
| 2018-10-09 04:10:00 | AAPL | Stock | 55.7975 | 55.7975 | 55.7975 | 55.7975 | 400.0 |
| 2018-10-09 04:24:00 | AAPL | Stock | 55.7975 | 55.7975 | 55.7975 | 55.7975 | 540.0 |
| 2018-10-09 04:30:00 | AAPL | Stock | 55.75 | 55.75 | 55.75 | 55.75 | 416.0 |
| 2018-10-09 04:42:00 | AAPL | Stock | 55.86 | 55.86 | 55.86 | 55.86 | 400.0 |
| 2018-10-09 05:06:00 | AAPL | Stock | 55.8275 | 55.8275 | 55.825 | 55.825 | 4000.0 |
| 2018-10-09 05:08:00 | AAPL | Stock | 55.825 | 55.825 | 55.825 | 55.825 | 400.0 |
| 2018-10-09 05:19:00 | AAPL | Stock | 55.8325 | 55.8325 | 55.825 | 55.825 | 2112.0 |
| 2018-10-09 05:28:00 | AAPL | Stock | 55.8 | 55.8 | 55.8 | 55.8 | 400.0 |
| 2018-10-09 05:39:00 | AAPL | Stock | 55.775 | 55.775 | 55.775 | 55.775 | 400.0 |
| 2018-10-09 06:02:00 | AAPL | Stock | 55.695 | 55.695 | 55.695 | 55.695 | 400.0 |
| 2018-10-09 06:04:00 | AAPL | Stock | 55.715 | 55.715 | 55.715 | 55.715 | 400.0 |
| 2018-10-09 06:07:00 | AAPL | Stock | 55.725 | 55.725 | 55.725 | 55.725 | 400.0 |
| 2018-10-09 06:09:00 | AAPL | Stock | 55.725 | 55.725 | 55.725 | 55.725 | 956.0 |
| 2018-10-09 06:12:00 | AAPL | Stock | 55.75 | 55.75 | 55.75 | 55.75 | 1200.0 |
| 2018-10-09 06:26:00 | AAPL | Stock | 55.675 | 55.675 | 55.675 | 55.675 | 400.0 |
| 2018-10-09 06:37:00 | AAPL | Stock | 55.725 | 55.725 | 55.725 | 55.725 | 800.0 |
| 2018-10-09 06:38:00 | AAPL | Stock | 55.755 | 55.7625 | 55.755 | 55.7625 | 2000.0 |
| 2018-10-09 06:40:00 | AAPL | Stock | 55.7625 | 55.7625 | 55.7625 | 55.7625 | 400.0 |
| 2018-10-09 06:54:00 | AAPL | Stock | 55.775 | 55.785 | 55.775 | 55.785 | 4864.0 |
| 2018-10-09 06:55:00 | AAPL | Stock | 55.79 | 55.79 | 55.79 | 55.79 | 1200.0 |
| 2018-10-09 07:00:00 | AAPL | Stock | 55.845 | 55.845 | 55.845 | 55.845 | 840.0 |
| 2018-10-09 07:02:00 | AAPL | Stock | 55.8 | 55.8 | 55.795 | 55.795 | 2672.0 |
| 2018-10-09 07:05:00 | AAPL | Stock | 55.8125 | 55.8125 | 55.8125 | 55.8125 | 800.0 |
| 2018-10-09 07:07:00 | AAPL | Stock | 55.79 | 55.79 | 55.785 | 55.785 | 1596.0 |
| 2018-10-09 07:08:00 | AAPL | Stock | 55.7775 | 55.7775 | 55.7775 | 55.7775 | 1944.0 |
| 2018-10-09 07:10:00 | AAPL | Stock | 55.765 | 55.765 | 55.765 | 55.765 | 400.0 |
| 2018-10-09 07:11:00 | AAPL | Stock | 55.755 | 55.755 | 55.725 | 55.725 | 23376.0 |
| 2018-10-09 07:14:00 | AAPL | Stock | 55.71 | 55.71 | 55.69 | 55.69 | 2748.0 |
| 2018-10-09 07:15:00 | AAPL | Stock | 55.69 | 55.69 | 55.6775 | 55.6775 | 10452.0 |
| 2018-10-09 07:16:00 | AAPL | Stock | 55.6775 | 55.6775 | 55.675 | 55.675 | 2800.0 |
| 2018-10-09 07:17:00 | AAPL | Stock | 55.65 | 55.6725 | 55.65 | 55.6725 | 2000.0 |
| 2018-10-09 07:18:00 | AAPL | Stock | 55.6275 | 55.6275 | 55.625 | 55.625 | 2792.0 |
| 2018-10-09 07:20:00 | AAPL | Stock | 55.65 | 55.65 | 55.65 | 55.65 | 9600.0 |
| 2018-10-09 07:21:00 | AAPL | Stock | 55.625 | 55.6275 | 55.5825 | 55.5825 | 13112.0 |
| 2018-10-09 07:22:00 | AAPL | Stock | 55.5825 | 55.5825 | 55.5525 | 55.5525 | 2620.0 |
| 2018-10-09 07:23:00 | AAPL | Stock | 55.5975 | 55.6 | 55.565 | 55.6 | 1600.0 |
| 2018-10-09 07:24:00 | AAPL | Stock | 55.59 | 55.625 | 55.5775 | 55.625 | 2436.0 |
| 2018-10-09 07:25:00 | AAPL | Stock | 55.6575 | 55.6575 | 55.65 | 55.65 | 16836.0 |
| 2018-10-09 07:26:00 | AAPL | Stock | 55.63 | 55.63 | 55.63 | 55.63 | 800.0 |
| 2018-10-09 07:27:00 | AAPL | Stock | 55.6725 | 55.6725 | 55.67 | 55.67 | 5680.0 |
| 2018-10-09 07:28:00 | AAPL | Stock | 55.675 | 55.6875 | 55.6675 | 55.6675 | 14200.0 |
| 2018-10-09 07:29:00 | AAPL | Stock | 55.67 | 55.67 | 55.6325 | 55.6325 | 2020.0 |
| 2018-10-09 07:30:00 | AAPL | Stock | 55.65 | 55.65 | 55.625 | 55.625 | 16780.0 |
| 2018-10-09 07:31:00 | AAPL | Stock | 55.6125 | 55.6125 | 55.6125 | 55.6125 | 3796.0 |
| 2018-10-09 07:32:00 | AAPL | Stock | 55.6125 | 55.6125 | 55.6125 | 55.6125 | 2000.0 |
| 2018-10-09 07:33:00 | AAPL | Stock | 55.5775 | 55.5775 | 55.56 | 55.56 | 2488.0 |
| 2018-10-09 07:34:00 | AAPL | Stock | 55.575 | 55.575 | 55.5125 | 55.515 | 11032.0 |
| 2018-10-09 07:35:00 | AAPL | Stock | 55.5675 | 55.5675 | 55.5225 | 55.5375 | 8020.0 |
| 2018-10-09 07:36:00 | AAPL | Stock | 55.55 | 55.55 | 55.55 | 55.55 | 800.0 |
> showing 50 of 1,101,620 rows — these rows as CSV