PREVIEW / stock_1min / 2018-06-04
file: by_date/stock_1min/2018/2018-06-04.parquet size: 15.5 MB rows: 1,103,710 symbols: 2,366
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-06-04 04:00:00 | AAPL | Stock | 47.69 | 47.75 | 47.69 | 47.75 | 8564.0 |
| 2018-06-04 04:02:00 | AAPL | Stock | 47.8 | 47.8 | 47.8 | 47.8 | 800.0 |
| 2018-06-04 04:04:00 | AAPL | Stock | 47.75 | 47.75 | 47.75 | 47.75 | 600.0 |
| 2018-06-04 04:05:00 | AAPL | Stock | 47.7525 | 47.7525 | 47.7525 | 47.7525 | 800.0 |
| 2018-06-04 04:06:00 | AAPL | Stock | 47.7625 | 47.7625 | 47.7625 | 47.7625 | 400.0 |
| 2018-06-04 04:07:00 | AAPL | Stock | 47.775 | 47.775 | 47.775 | 47.775 | 400.0 |
| 2018-06-04 04:27:00 | AAPL | Stock | 47.8075 | 47.8075 | 47.8075 | 47.8075 | 416.0 |
| 2018-06-04 04:33:00 | AAPL | Stock | 47.7875 | 47.7875 | 47.7875 | 47.7875 | 4000.0 |
| 2018-06-04 04:35:00 | AAPL | Stock | 47.805 | 47.805 | 47.805 | 47.805 | 400.0 |
| 2018-06-04 04:38:00 | AAPL | Stock | 47.805 | 47.805 | 47.805 | 47.805 | 1040.0 |
| 2018-06-04 04:54:00 | AAPL | Stock | 47.86 | 47.86 | 47.86 | 47.86 | 404.0 |
| 2018-06-04 05:01:00 | AAPL | Stock | 47.805 | 47.805 | 47.805 | 47.805 | 400.0 |
| 2018-06-04 05:14:00 | AAPL | Stock | 47.8225 | 47.8225 | 47.8225 | 47.8225 | 3552.0 |
| 2018-06-04 05:16:00 | AAPL | Stock | 47.805 | 47.805 | 47.805 | 47.805 | 400.0 |
| 2018-06-04 05:19:00 | AAPL | Stock | 47.815 | 47.815 | 47.815 | 47.815 | 400.0 |
| 2018-06-04 05:21:00 | AAPL | Stock | 47.8475 | 47.8475 | 47.8475 | 47.8475 | 520.0 |
| 2018-06-04 05:43:00 | AAPL | Stock | 47.86 | 47.86 | 47.86 | 47.86 | 1200.0 |
| 2018-06-04 05:45:00 | AAPL | Stock | 47.8625 | 47.8625 | 47.8625 | 47.8625 | 400.0 |
| 2018-06-04 05:46:00 | AAPL | Stock | 47.8625 | 47.8625 | 47.8625 | 47.8625 | 400.0 |
| 2018-06-04 05:58:00 | AAPL | Stock | 47.845 | 47.845 | 47.845 | 47.845 | 400.0 |
| 2018-06-04 06:03:00 | AAPL | Stock | 47.825 | 47.825 | 47.825 | 47.825 | 2000.0 |
| 2018-06-04 06:04:00 | AAPL | Stock | 47.825 | 47.825 | 47.825 | 47.825 | 3496.0 |
| 2018-06-04 06:12:00 | AAPL | Stock | 47.8175 | 47.8175 | 47.8175 | 47.8175 | 1200.0 |
| 2018-06-04 06:14:00 | AAPL | Stock | 47.8225 | 47.8225 | 47.8225 | 47.8225 | 400.0 |
| 2018-06-04 06:15:00 | AAPL | Stock | 47.8125 | 47.8125 | 47.8125 | 47.8125 | 472.0 |
| 2018-06-04 06:18:00 | AAPL | Stock | 47.7925 | 47.7925 | 47.7875 | 47.7875 | 1996.0 |
| 2018-06-04 06:21:00 | AAPL | Stock | 47.8125 | 47.8125 | 47.8125 | 47.8125 | 500.0 |
| 2018-06-04 06:22:00 | AAPL | Stock | 47.8125 | 47.8125 | 47.8125 | 47.8125 | 800.0 |
| 2018-06-04 06:23:00 | AAPL | Stock | 47.8125 | 47.8125 | 47.8125 | 47.8125 | 1576.0 |
| 2018-06-04 06:24:00 | AAPL | Stock | 47.8 | 47.8125 | 47.8 | 47.8125 | 824.0 |
| 2018-06-04 06:26:00 | AAPL | Stock | 47.8125 | 47.8125 | 47.8125 | 47.8125 | 676.0 |
| 2018-06-04 06:32:00 | AAPL | Stock | 47.8 | 47.8 | 47.7875 | 47.7875 | 4372.0 |
| 2018-06-04 06:33:00 | AAPL | Stock | 47.7875 | 47.795 | 47.7875 | 47.795 | 12760.0 |
| 2018-06-04 06:35:00 | AAPL | Stock | 47.795 | 47.795 | 47.795 | 47.795 | 400.0 |
| 2018-06-04 06:39:00 | AAPL | Stock | 47.775 | 47.775 | 47.775 | 47.775 | 7144.0 |
| 2018-06-04 06:44:00 | AAPL | Stock | 47.7625 | 47.7625 | 47.7625 | 47.7625 | 4000.0 |
| 2018-06-04 06:46:00 | AAPL | Stock | 47.76 | 47.76 | 47.76 | 47.76 | 400.0 |
| 2018-06-04 06:51:00 | AAPL | Stock | 47.76 | 47.7975 | 47.76 | 47.7975 | 3984.0 |
| 2018-06-04 06:53:00 | AAPL | Stock | 47.7625 | 47.795 | 47.7625 | 47.795 | 4592.0 |
| 2018-06-04 06:59:00 | AAPL | Stock | 47.765 | 47.765 | 47.75 | 47.75 | 8564.0 |
| 2018-06-04 07:00:00 | AAPL | Stock | 47.685 | 47.75 | 47.67 | 47.725 | 12780.0 |
| 2018-06-04 07:01:00 | AAPL | Stock | 47.725 | 47.725 | 47.6975 | 47.7 | 10052.0 |
| 2018-06-04 07:04:00 | AAPL | Stock | 47.7325 | 47.7325 | 47.7125 | 47.7125 | 800.0 |
| 2018-06-04 07:05:00 | AAPL | Stock | 47.7125 | 47.7125 | 47.7125 | 47.7125 | 1600.0 |
| 2018-06-04 07:06:00 | AAPL | Stock | 47.7025 | 47.7025 | 47.7 | 47.7 | 1600.0 |
| 2018-06-04 07:07:00 | AAPL | Stock | 47.7075 | 47.7075 | 47.7075 | 47.7075 | 600.0 |
| 2018-06-04 07:10:00 | AAPL | Stock | 47.7125 | 47.7125 | 47.7125 | 47.7125 | 800.0 |
| 2018-06-04 07:11:00 | AAPL | Stock | 47.7175 | 47.7225 | 47.7125 | 47.7225 | 9600.0 |
| 2018-06-04 07:13:00 | AAPL | Stock | 47.725 | 47.74 | 47.725 | 47.74 | 3280.0 |
| 2018-06-04 07:14:00 | AAPL | Stock | 47.735 | 47.735 | 47.735 | 47.735 | 400.0 |
> showing 50 of 1,103,710 rows — these rows as CSV