PREVIEW / stock_1min / 2019-04-16
file: by_date/stock_1min/2019/2019-04-16.parquet size: 15.5 MB rows: 1,069,738 symbols: 2,213
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-04-16 04:00:00 | AAPL | Stock | 49.8975 | 49.8975 | 49.8475 | 49.8475 | 1212.0 |
| 2019-04-16 04:14:00 | AAPL | Stock | 49.98 | 49.98 | 49.98 | 49.98 | 400.0 |
| 2019-04-16 04:17:00 | AAPL | Stock | 49.995 | 49.9975 | 49.995 | 49.9975 | 6400.0 |
| 2019-04-16 04:18:00 | AAPL | Stock | 49.9825 | 49.9825 | 49.9825 | 49.9825 | 412.0 |
| 2019-04-16 04:20:00 | AAPL | Stock | 49.9825 | 49.9825 | 49.9825 | 49.9825 | 800.0 |
| 2019-04-16 04:23:00 | AAPL | Stock | 49.9425 | 49.9425 | 49.9425 | 49.9425 | 824.0 |
| 2019-04-16 04:24:00 | AAPL | Stock | 49.9425 | 49.9425 | 49.9425 | 49.9425 | 968.0 |
| 2019-04-16 04:30:00 | AAPL | Stock | 50.0175 | 50.0175 | 50.0175 | 50.0175 | 400.0 |
| 2019-04-16 05:47:00 | AAPL | Stock | 50.0225 | 50.025 | 50.0225 | 50.025 | 872.0 |
| 2019-04-16 06:10:00 | AAPL | Stock | 49.975 | 49.975 | 49.975 | 49.975 | 2000.0 |
| 2019-04-16 06:27:00 | AAPL | Stock | 49.975 | 49.975 | 49.975 | 49.975 | 1140.0 |
| 2019-04-16 06:47:00 | AAPL | Stock | 49.9675 | 49.9675 | 49.9675 | 49.9675 | 800.0 |
| 2019-04-16 06:52:00 | AAPL | Stock | 49.9675 | 49.9675 | 49.9675 | 49.9675 | 1360.0 |
| 2019-04-16 07:00:00 | AAPL | Stock | 49.9275 | 49.9275 | 49.915 | 49.925 | 5056.0 |
| 2019-04-16 07:02:00 | AAPL | Stock | 49.95 | 49.95 | 49.95 | 49.95 | 516.0 |
| 2019-04-16 07:03:00 | AAPL | Stock | 49.9675 | 49.97 | 49.95 | 49.97 | 4400.0 |
| 2019-04-16 07:04:00 | AAPL | Stock | 49.9425 | 49.9425 | 49.9425 | 49.9425 | 400.0 |
| 2019-04-16 07:05:00 | AAPL | Stock | 49.9425 | 49.9425 | 49.935 | 49.9375 | 18400.0 |
| 2019-04-16 07:08:00 | AAPL | Stock | 49.95 | 49.95 | 49.95 | 49.95 | 4000.0 |
| 2019-04-16 07:10:00 | AAPL | Stock | 49.95 | 49.95 | 49.95 | 49.95 | 400.0 |
| 2019-04-16 07:11:00 | AAPL | Stock | 49.95 | 49.95 | 49.95 | 49.95 | 1996.0 |
| 2019-04-16 07:12:00 | AAPL | Stock | 49.955 | 49.955 | 49.955 | 49.955 | 4000.0 |
| 2019-04-16 07:18:00 | AAPL | Stock | 49.95 | 49.95 | 49.9375 | 49.9375 | 2800.0 |
| 2019-04-16 07:25:00 | AAPL | Stock | 49.9375 | 49.9375 | 49.9375 | 49.9375 | 2008.0 |
| 2019-04-16 07:27:00 | AAPL | Stock | 49.9475 | 49.9475 | 49.9475 | 49.9475 | 3992.0 |
| 2019-04-16 07:30:00 | AAPL | Stock | 49.94 | 49.94 | 49.94 | 49.94 | 408.0 |
| 2019-04-16 07:35:00 | AAPL | Stock | 49.9475 | 49.9475 | 49.9475 | 49.9475 | 400.0 |
| 2019-04-16 07:37:00 | AAPL | Stock | 49.95 | 49.95 | 49.95 | 49.95 | 4400.0 |
| 2019-04-16 07:39:00 | AAPL | Stock | 49.96 | 49.96 | 49.96 | 49.96 | 800.0 |
| 2019-04-16 07:43:00 | AAPL | Stock | 49.96 | 49.9625 | 49.96 | 49.9625 | 6800.0 |
| 2019-04-16 07:45:00 | AAPL | Stock | 49.98 | 49.98 | 49.9725 | 49.975 | 3172.0 |
| 2019-04-16 07:46:00 | AAPL | Stock | 49.975 | 49.975 | 49.975 | 49.975 | 400.0 |
| 2019-04-16 07:47:00 | AAPL | Stock | 49.975 | 49.975 | 49.975 | 49.975 | 3996.0 |
| 2019-04-16 07:48:00 | AAPL | Stock | 49.965 | 49.965 | 49.965 | 49.965 | 952.0 |
| 2019-04-16 07:49:00 | AAPL | Stock | 49.9725 | 49.9875 | 49.9725 | 49.975 | 4916.0 |
| 2019-04-16 07:50:00 | AAPL | Stock | 49.9775 | 49.9775 | 49.9775 | 49.9775 | 400.0 |
| 2019-04-16 07:51:00 | AAPL | Stock | 49.985 | 49.985 | 49.985 | 49.985 | 800.0 |
| 2019-04-16 07:52:00 | AAPL | Stock | 49.985 | 49.9875 | 49.9825 | 49.9875 | 2680.0 |
| 2019-04-16 07:53:00 | AAPL | Stock | 49.9875 | 49.9875 | 49.9875 | 49.9875 | 4800.0 |
| 2019-04-16 07:56:00 | AAPL | Stock | 49.9875 | 49.9875 | 49.9875 | 49.9875 | 1960.0 |
| 2019-04-16 07:57:00 | AAPL | Stock | 49.985 | 49.9875 | 49.985 | 49.9875 | 8512.0 |
| 2019-04-16 08:00:00 | AAPL | Stock | 49.97 | 49.9875 | 49.915 | 49.97 | 51800.0 |
| 2019-04-16 08:01:00 | AAPL | Stock | 49.9875 | 49.9875 | 49.9875 | 49.9875 | 1028.0 |
| 2019-04-16 08:02:00 | AAPL | Stock | 49.9925 | 49.9925 | 49.9925 | 49.9925 | 400.0 |
| 2019-04-16 08:03:00 | AAPL | Stock | 49.995 | 49.995 | 49.995 | 49.995 | 2680.0 |
| 2019-04-16 08:04:00 | AAPL | Stock | 49.995 | 49.995 | 49.9925 | 49.9925 | 6892.0 |
| 2019-04-16 08:06:00 | AAPL | Stock | 49.9975 | 49.9975 | 49.9975 | 49.9975 | 400.0 |
| 2019-04-16 08:09:00 | AAPL | Stock | 49.9975 | 50.0 | 49.9975 | 50.0 | 33888.0 |
| 2019-04-16 08:10:00 | AAPL | Stock | 50.0 | 50.005 | 50.0 | 50.0 | 6864.0 |
| 2019-04-16 08:11:00 | AAPL | Stock | 49.9975 | 50.0025 | 49.9975 | 50.0 | 3000.0 |
> showing 50 of 1,069,738 rows — these rows as CSV