PREVIEW / stock_1min / 2019-06-19
file: by_date/stock_1min/2019/2019-06-19.parquet size: 15.1 MB rows: 1,081,081 symbols: 2,166
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 |
|---|---|---|---|---|---|---|---|
| 2019-06-19 04:10:00 | AAPL | Stock | 49.77 | 49.77 | 49.77 | 49.77 | 604.0 |
| 2019-06-19 04:19:00 | AAPL | Stock | 49.7525 | 49.7525 | 49.735 | 49.735 | 3748.0 |
| 2019-06-19 04:28:00 | AAPL | Stock | 49.6925 | 49.6925 | 49.6925 | 49.6925 | 400.0 |
| 2019-06-19 04:34:00 | AAPL | Stock | 49.6875 | 49.6875 | 49.6875 | 49.6875 | 400.0 |
| 2019-06-19 04:35:00 | AAPL | Stock | 49.6675 | 49.6675 | 49.6675 | 49.6675 | 400.0 |
| 2019-06-19 04:46:00 | AAPL | Stock | 49.6375 | 49.6375 | 49.5625 | 49.5625 | 6672.0 |
| 2019-06-19 04:50:00 | AAPL | Stock | 49.575 | 49.575 | 49.575 | 49.575 | 920.0 |
| 2019-06-19 05:05:00 | AAPL | Stock | 49.625 | 49.625 | 49.625 | 49.625 | 400.0 |
| 2019-06-19 05:27:00 | AAPL | Stock | 49.6 | 49.6 | 49.5875 | 49.5875 | 3180.0 |
| 2019-06-19 05:33:00 | AAPL | Stock | 49.63 | 49.63 | 49.63 | 49.63 | 400.0 |
| 2019-06-19 05:51:00 | AAPL | Stock | 49.6875 | 49.725 | 49.6875 | 49.725 | 3000.0 |
| 2019-06-19 05:52:00 | AAPL | Stock | 49.75 | 49.75 | 49.75 | 49.75 | 2800.0 |
| 2019-06-19 05:53:00 | AAPL | Stock | 49.75 | 49.75 | 49.75 | 49.75 | 6744.0 |
| 2019-06-19 05:54:00 | AAPL | Stock | 49.75 | 49.75 | 49.75 | 49.75 | 1840.0 |
| 2019-06-19 05:55:00 | AAPL | Stock | 49.775 | 49.825 | 49.775 | 49.825 | 3600.0 |
| 2019-06-19 05:59:00 | AAPL | Stock | 49.825 | 49.85 | 49.825 | 49.85 | 2000.0 |
| 2019-06-19 06:04:00 | AAPL | Stock | 49.7875 | 49.7875 | 49.7875 | 49.7875 | 2700.0 |
| 2019-06-19 06:06:00 | AAPL | Stock | 49.7875 | 49.8125 | 49.7875 | 49.8125 | 2400.0 |
| 2019-06-19 06:07:00 | AAPL | Stock | 49.8125 | 49.8125 | 49.8125 | 49.8125 | 800.0 |
| 2019-06-19 06:08:00 | AAPL | Stock | 49.7675 | 49.7675 | 49.7675 | 49.7675 | 1840.0 |
| 2019-06-19 06:12:00 | AAPL | Stock | 49.825 | 49.825 | 49.825 | 49.825 | 400.0 |
| 2019-06-19 06:14:00 | AAPL | Stock | 49.845 | 49.85 | 49.845 | 49.85 | 4000.0 |
| 2019-06-19 06:17:00 | AAPL | Stock | 49.8275 | 49.8275 | 49.8275 | 49.8275 | 800.0 |
| 2019-06-19 06:18:00 | AAPL | Stock | 49.85 | 49.85 | 49.85 | 49.85 | 800.0 |
| 2019-06-19 06:19:00 | AAPL | Stock | 49.875 | 49.875 | 49.875 | 49.875 | 3940.0 |
| 2019-06-19 06:31:00 | AAPL | Stock | 49.875 | 49.875 | 49.875 | 49.875 | 2000.0 |
| 2019-06-19 06:42:00 | AAPL | Stock | 49.9 | 49.9 | 49.9 | 49.9 | 800.0 |
| 2019-06-19 06:43:00 | AAPL | Stock | 49.875 | 49.8975 | 49.865 | 49.8975 | 2576.0 |
| 2019-06-19 06:45:00 | AAPL | Stock | 49.85 | 49.85 | 49.85 | 49.85 | 1424.0 |
| 2019-06-19 06:47:00 | AAPL | Stock | 49.8575 | 49.8575 | 49.855 | 49.8575 | 7988.0 |
| 2019-06-19 06:58:00 | AAPL | Stock | 49.875 | 49.875 | 49.875 | 49.875 | 400.0 |
| 2019-06-19 07:00:00 | AAPL | Stock | 49.875 | 49.875 | 49.8275 | 49.8275 | 3456.0 |
| 2019-06-19 07:01:00 | AAPL | Stock | 49.85 | 49.8525 | 49.8375 | 49.8375 | 3308.0 |
| 2019-06-19 07:02:00 | AAPL | Stock | 49.8275 | 49.8275 | 49.8275 | 49.8275 | 400.0 |
| 2019-06-19 07:03:00 | AAPL | Stock | 49.84 | 49.84 | 49.84 | 49.84 | 400.0 |
| 2019-06-19 07:04:00 | AAPL | Stock | 49.8275 | 49.8275 | 49.8225 | 49.8225 | 2400.0 |
| 2019-06-19 07:07:00 | AAPL | Stock | 49.775 | 49.775 | 49.75 | 49.75 | 13096.0 |
| 2019-06-19 07:10:00 | AAPL | Stock | 49.75 | 49.75 | 49.75 | 49.75 | 2712.0 |
| 2019-06-19 07:13:00 | AAPL | Stock | 49.75 | 49.75 | 49.75 | 49.75 | 400.0 |
| 2019-06-19 07:18:00 | AAPL | Stock | 49.7475 | 49.7475 | 49.7475 | 49.7475 | 1680.0 |
| 2019-06-19 07:20:00 | AAPL | Stock | 49.7175 | 49.75 | 49.7175 | 49.75 | 2212.0 |
| 2019-06-19 07:24:00 | AAPL | Stock | 49.75 | 49.75 | 49.75 | 49.75 | 400.0 |
| 2019-06-19 07:27:00 | AAPL | Stock | 49.7725 | 49.775 | 49.7725 | 49.775 | 2800.0 |
| 2019-06-19 07:29:00 | AAPL | Stock | 49.785 | 49.82 | 49.785 | 49.8 | 1520.0 |
| 2019-06-19 07:30:00 | AAPL | Stock | 49.815 | 49.815 | 49.815 | 49.815 | 796.0 |
| 2019-06-19 07:32:00 | AAPL | Stock | 49.8125 | 49.8125 | 49.8 | 49.8 | 1460.0 |
| 2019-06-19 07:41:00 | AAPL | Stock | 49.8225 | 49.8225 | 49.8225 | 49.8225 | 2400.0 |
| 2019-06-19 07:42:00 | AAPL | Stock | 49.8375 | 49.8725 | 49.8375 | 49.8725 | 3592.0 |
| 2019-06-19 07:43:00 | AAPL | Stock | 49.875 | 49.91 | 49.875 | 49.91 | 8384.0 |
| 2019-06-19 07:44:00 | AAPL | Stock | 49.91 | 49.91 | 49.91 | 49.91 | 400.0 |
> showing 50 of 1,081,081 rows — these rows as CSV