PREVIEW / stock_1min / 2019-05-23
file: by_date/stock_1min/2019/2019-05-23.parquet size: 15.9 MB rows: 1,117,614 symbols: 2,191
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-05-23 04:00:00 | AAPL | Stock | 44.875 | 44.875 | 44.8225 | 44.8225 | 12420.0 |
| 2019-05-23 04:01:00 | AAPL | Stock | 44.84 | 44.84 | 44.84 | 44.84 | 2400.0 |
| 2019-05-23 04:02:00 | AAPL | Stock | 44.885 | 44.92 | 44.885 | 44.92 | 1200.0 |
| 2019-05-23 04:03:00 | AAPL | Stock | 44.92 | 44.92 | 44.92 | 44.92 | 3200.0 |
| 2019-05-23 04:06:00 | AAPL | Stock | 44.935 | 44.935 | 44.935 | 44.935 | 400.0 |
| 2019-05-23 04:07:00 | AAPL | Stock | 44.945 | 44.95 | 44.945 | 44.95 | 1200.0 |
| 2019-05-23 04:08:00 | AAPL | Stock | 44.95 | 45.035 | 44.95 | 45.0 | 22952.0 |
| 2019-05-23 04:15:00 | AAPL | Stock | 44.94 | 44.94 | 44.9225 | 44.9225 | 11412.0 |
| 2019-05-23 04:19:00 | AAPL | Stock | 44.87 | 44.87 | 44.8625 | 44.8625 | 4800.0 |
| 2019-05-23 04:21:00 | AAPL | Stock | 44.8525 | 44.8525 | 44.8475 | 44.8475 | 4136.0 |
| 2019-05-23 04:22:00 | AAPL | Stock | 44.825 | 44.825 | 44.825 | 44.825 | 1776.0 |
| 2019-05-23 04:24:00 | AAPL | Stock | 44.815 | 44.815 | 44.815 | 44.815 | 2000.0 |
| 2019-05-23 04:25:00 | AAPL | Stock | 44.8175 | 44.845 | 44.8175 | 44.845 | 1200.0 |
| 2019-05-23 04:28:00 | AAPL | Stock | 44.875 | 44.875 | 44.875 | 44.875 | 780.0 |
| 2019-05-23 04:29:00 | AAPL | Stock | 44.875 | 44.875 | 44.875 | 44.875 | 1688.0 |
| 2019-05-23 04:32:00 | AAPL | Stock | 44.87 | 44.87 | 44.87 | 44.87 | 400.0 |
| 2019-05-23 04:35:00 | AAPL | Stock | 44.845 | 44.845 | 44.845 | 44.845 | 400.0 |
| 2019-05-23 04:39:00 | AAPL | Stock | 44.825 | 44.825 | 44.825 | 44.825 | 4000.0 |
| 2019-05-23 04:40:00 | AAPL | Stock | 44.8125 | 44.8125 | 44.8125 | 44.8125 | 10400.0 |
| 2019-05-23 04:42:00 | AAPL | Stock | 44.8125 | 44.8125 | 44.8125 | 44.8125 | 4632.0 |
| 2019-05-23 04:43:00 | AAPL | Stock | 44.825 | 44.825 | 44.825 | 44.825 | 1200.0 |
| 2019-05-23 04:46:00 | AAPL | Stock | 44.845 | 44.845 | 44.845 | 44.845 | 624.0 |
| 2019-05-23 04:47:00 | AAPL | Stock | 44.8325 | 44.845 | 44.8125 | 44.845 | 4336.0 |
| 2019-05-23 04:48:00 | AAPL | Stock | 44.855 | 44.855 | 44.855 | 44.855 | 800.0 |
| 2019-05-23 04:51:00 | AAPL | Stock | 44.855 | 44.855 | 44.855 | 44.855 | 12480.0 |
| 2019-05-23 04:57:00 | AAPL | Stock | 44.825 | 44.825 | 44.8125 | 44.8125 | 1600.0 |
| 2019-05-23 05:01:00 | AAPL | Stock | 44.825 | 44.825 | 44.825 | 44.825 | 400.0 |
| 2019-05-23 05:05:00 | AAPL | Stock | 44.8525 | 44.8625 | 44.8525 | 44.8625 | 1740.0 |
| 2019-05-23 05:15:00 | AAPL | Stock | 44.9075 | 44.9125 | 44.9075 | 44.9125 | 4732.0 |
| 2019-05-23 05:18:00 | AAPL | Stock | 44.875 | 44.875 | 44.875 | 44.875 | 400.0 |
| 2019-05-23 05:19:00 | AAPL | Stock | 44.8475 | 44.8475 | 44.8475 | 44.8475 | 400.0 |
| 2019-05-23 05:21:00 | AAPL | Stock | 44.835 | 44.835 | 44.835 | 44.835 | 400.0 |
| 2019-05-23 05:22:00 | AAPL | Stock | 44.8 | 44.8 | 44.7525 | 44.7525 | 3540.0 |
| 2019-05-23 05:23:00 | AAPL | Stock | 44.7525 | 44.7525 | 44.745 | 44.745 | 4100.0 |
| 2019-05-23 05:24:00 | AAPL | Stock | 44.7575 | 44.7575 | 44.7575 | 44.7575 | 2000.0 |
| 2019-05-23 05:37:00 | AAPL | Stock | 44.725 | 44.725 | 44.71 | 44.71 | 1200.0 |
| 2019-05-23 05:40:00 | AAPL | Stock | 44.6925 | 44.6925 | 44.6875 | 44.6875 | 868.0 |
| 2019-05-23 05:41:00 | AAPL | Stock | 44.675 | 44.6825 | 44.675 | 44.6825 | 3400.0 |
| 2019-05-23 05:44:00 | AAPL | Stock | 44.685 | 44.69 | 44.685 | 44.69 | 992.0 |
| 2019-05-23 05:49:00 | AAPL | Stock | 44.72 | 44.72 | 44.6775 | 44.6775 | 3040.0 |
| 2019-05-23 05:50:00 | AAPL | Stock | 44.6925 | 44.6925 | 44.6925 | 44.6925 | 1200.0 |
| 2019-05-23 05:54:00 | AAPL | Stock | 44.725 | 44.725 | 44.725 | 44.725 | 400.0 |
| 2019-05-23 06:01:00 | AAPL | Stock | 44.68 | 44.68 | 44.68 | 44.68 | 2400.0 |
| 2019-05-23 06:02:00 | AAPL | Stock | 44.6675 | 44.6675 | 44.6475 | 44.6475 | 2480.0 |
| 2019-05-23 06:03:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 2060.0 |
| 2019-05-23 06:04:00 | AAPL | Stock | 44.65 | 44.6675 | 44.64 | 44.64 | 3444.0 |
| 2019-05-23 06:05:00 | AAPL | Stock | 44.6375 | 44.6375 | 44.6275 | 44.6275 | 4400.0 |
| 2019-05-23 06:06:00 | AAPL | Stock | 44.5875 | 44.5875 | 44.5875 | 44.5875 | 6080.0 |
| 2019-05-23 06:10:00 | AAPL | Stock | 44.625 | 44.64 | 44.625 | 44.64 | 6512.0 |
| 2019-05-23 06:11:00 | AAPL | Stock | 44.64 | 44.64 | 44.64 | 44.64 | 1600.0 |
> showing 50 of 1,117,614 rows — these rows as CSV