PREVIEW / stock_1min / 2018-06-21
file: by_date/stock_1min/2018/2018-06-21.parquet size: 15.7 MB rows: 1,117,371 symbols: 2,356
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-21 04:42:00 | AAPL | Stock | 46.8325 | 46.8325 | 46.8325 | 46.8325 | 400.0 |
| 2018-06-21 05:02:00 | AAPL | Stock | 46.75 | 46.75 | 46.75 | 46.75 | 720.0 |
| 2018-06-21 05:03:00 | AAPL | Stock | 46.7025 | 46.7025 | 46.6925 | 46.6925 | 2800.0 |
| 2018-06-21 05:04:00 | AAPL | Stock | 46.6925 | 46.6925 | 46.6925 | 46.6925 | 400.0 |
| 2018-06-21 05:09:00 | AAPL | Stock | 46.63 | 46.63 | 46.6275 | 46.6275 | 4000.0 |
| 2018-06-21 05:10:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 400.0 |
| 2018-06-21 05:27:00 | AAPL | Stock | 46.6025 | 46.6025 | 46.6025 | 46.6025 | 1600.0 |
| 2018-06-21 05:56:00 | AAPL | Stock | 46.6625 | 46.6625 | 46.6625 | 46.6625 | 400.0 |
| 2018-06-21 06:09:00 | AAPL | Stock | 46.6575 | 46.7 | 46.6575 | 46.7 | 5244.0 |
| 2018-06-21 06:18:00 | AAPL | Stock | 46.6975 | 46.6975 | 46.6975 | 46.6975 | 400.0 |
| 2018-06-21 06:45:00 | AAPL | Stock | 46.7125 | 46.7125 | 46.7125 | 46.7125 | 800.0 |
| 2018-06-21 06:51:00 | AAPL | Stock | 46.7325 | 46.7325 | 46.7325 | 46.7325 | 416.0 |
| 2018-06-21 06:53:00 | AAPL | Stock | 46.705 | 46.705 | 46.705 | 46.705 | 400.0 |
| 2018-06-21 06:54:00 | AAPL | Stock | 46.7325 | 46.7325 | 46.7325 | 46.7325 | 2396.0 |
| 2018-06-21 06:55:00 | AAPL | Stock | 46.745 | 46.745 | 46.745 | 46.745 | 800.0 |
| 2018-06-21 06:59:00 | AAPL | Stock | 46.76 | 46.76 | 46.76 | 46.76 | 652.0 |
| 2018-06-21 07:00:00 | AAPL | Stock | 46.8875 | 46.8875 | 46.755 | 46.86 | 8016.0 |
| 2018-06-21 07:02:00 | AAPL | Stock | 46.835 | 46.835 | 46.835 | 46.835 | 400.0 |
| 2018-06-21 07:03:00 | AAPL | Stock | 46.85 | 46.85 | 46.85 | 46.85 | 400.0 |
| 2018-06-21 07:05:00 | AAPL | Stock | 46.795 | 46.795 | 46.795 | 46.795 | 932.0 |
| 2018-06-21 07:11:00 | AAPL | Stock | 46.845 | 46.845 | 46.845 | 46.845 | 4000.0 |
| 2018-06-21 07:12:00 | AAPL | Stock | 46.845 | 46.845 | 46.845 | 46.845 | 8000.0 |
| 2018-06-21 07:14:00 | AAPL | Stock | 46.8425 | 46.845 | 46.8425 | 46.845 | 800.0 |
| 2018-06-21 07:17:00 | AAPL | Stock | 46.8425 | 46.8425 | 46.825 | 46.825 | 3808.0 |
| 2018-06-21 07:28:00 | AAPL | Stock | 46.8225 | 46.8225 | 46.8225 | 46.8225 | 800.0 |
| 2018-06-21 07:29:00 | AAPL | Stock | 46.8225 | 46.8225 | 46.8225 | 46.8225 | 800.0 |
| 2018-06-21 07:30:00 | AAPL | Stock | 46.8225 | 46.8225 | 46.8225 | 46.8225 | 664.0 |
| 2018-06-21 07:32:00 | AAPL | Stock | 46.8225 | 46.825 | 46.8225 | 46.825 | 2400.0 |
| 2018-06-21 07:34:00 | AAPL | Stock | 46.8425 | 46.875 | 46.8425 | 46.8625 | 2220.0 |
| 2018-06-21 07:37:00 | AAPL | Stock | 46.85 | 46.85 | 46.85 | 46.85 | 400.0 |
| 2018-06-21 07:38:00 | AAPL | Stock | 46.8725 | 46.8725 | 46.8725 | 46.8725 | 400.0 |
| 2018-06-21 07:40:00 | AAPL | Stock | 46.8725 | 46.8725 | 46.8725 | 46.8725 | 400.0 |
| 2018-06-21 07:44:00 | AAPL | Stock | 46.875 | 46.875 | 46.875 | 46.875 | 400.0 |
| 2018-06-21 07:45:00 | AAPL | Stock | 46.875 | 46.9375 | 46.875 | 46.9375 | 11252.0 |
| 2018-06-21 07:46:00 | AAPL | Stock | 46.9375 | 46.9375 | 46.875 | 46.8875 | 26452.0 |
| 2018-06-21 07:50:00 | AAPL | Stock | 46.89 | 46.89 | 46.89 | 46.89 | 544.0 |
| 2018-06-21 07:55:00 | AAPL | Stock | 46.905 | 46.905 | 46.905 | 46.905 | 400.0 |
| 2018-06-21 07:56:00 | AAPL | Stock | 46.925 | 46.9375 | 46.9175 | 46.9375 | 22328.0 |
| 2018-06-21 07:57:00 | AAPL | Stock | 46.9375 | 46.96 | 46.9375 | 46.95 | 18772.0 |
| 2018-06-21 07:58:00 | AAPL | Stock | 46.95 | 46.965 | 46.95 | 46.9625 | 8424.0 |
| 2018-06-21 08:00:00 | AAPL | Stock | 46.8495 | 46.9675 | 46.8175 | 46.9675 | 38100.0 |
| 2018-06-21 08:01:00 | AAPL | Stock | 46.9625 | 46.9625 | 46.9575 | 46.9575 | 2000.0 |
| 2018-06-21 08:02:00 | AAPL | Stock | 46.9525 | 46.97 | 46.9375 | 46.97 | 30276.0 |
| 2018-06-21 08:03:00 | AAPL | Stock | 46.9675 | 46.9675 | 46.95 | 46.95 | 7888.0 |
| 2018-06-21 08:04:00 | AAPL | Stock | 46.9675 | 46.9675 | 46.95 | 46.95 | 1596.0 |
| 2018-06-21 08:05:00 | AAPL | Stock | 46.9625 | 46.9625 | 46.94 | 46.94 | 1576.0 |
| 2018-06-21 08:06:00 | AAPL | Stock | 46.9625 | 46.9625 | 46.9575 | 46.9575 | 2400.0 |
| 2018-06-21 08:07:00 | AAPL | Stock | 46.9625 | 46.9625 | 46.9625 | 46.9625 | 500.0 |
| 2018-06-21 08:08:00 | AAPL | Stock | 46.9625 | 46.9625 | 46.9425 | 46.9425 | 14840.0 |
| 2018-06-21 08:10:00 | AAPL | Stock | 46.945 | 46.9625 | 46.94 | 46.9625 | 2216.0 |
> showing 50 of 1,117,371 rows — these rows as CSV