PREVIEW / stock_1min / 2020-10-28
file: by_date/stock_1min/2020/2020-10-28.parquet size: 21.2 MB rows: 1,316,274 symbols: 2,136
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-28 04:00:00 | AAPL | Stock | 115.9 | 116.2 | 115.9 | 116.2 | 3694.0 |
| 2020-10-28 04:01:00 | AAPL | Stock | 116.03 | 116.03 | 116.03 | 116.03 | 100.0 |
| 2020-10-28 04:02:00 | AAPL | Stock | 116.02 | 116.02 | 116.01 | 116.01 | 439.0 |
| 2020-10-28 04:03:00 | AAPL | Stock | 116.01 | 116.01 | 116.01 | 116.01 | 211.0 |
| 2020-10-28 04:04:00 | AAPL | Stock | 116.19 | 116.25 | 116.19 | 116.25 | 573.0 |
| 2020-10-28 04:05:00 | AAPL | Stock | 116.05 | 116.05 | 116.05 | 116.05 | 150.0 |
| 2020-10-28 04:06:00 | AAPL | Stock | 116.08 | 116.08 | 116.03 | 116.03 | 1114.0 |
| 2020-10-28 04:07:00 | AAPL | Stock | 116.0 | 116.0 | 115.99 | 115.99 | 220.0 |
| 2020-10-28 04:08:00 | AAPL | Stock | 115.91 | 115.98 | 115.78 | 115.78 | 3241.0 |
| 2020-10-28 04:09:00 | AAPL | Stock | 115.78 | 115.79 | 115.78 | 115.79 | 862.0 |
| 2020-10-28 04:10:00 | AAPL | Stock | 115.78 | 115.78 | 115.78 | 115.78 | 100.0 |
| 2020-10-28 04:11:00 | AAPL | Stock | 115.77 | 115.9 | 115.77 | 115.9 | 1369.0 |
| 2020-10-28 04:12:00 | AAPL | Stock | 115.81 | 115.81 | 115.68 | 115.68 | 1988.0 |
| 2020-10-28 04:13:00 | AAPL | Stock | 115.68 | 115.68 | 115.68 | 115.68 | 272.0 |
| 2020-10-28 04:14:00 | AAPL | Stock | 115.72 | 115.72 | 115.69 | 115.69 | 500.0 |
| 2020-10-28 04:15:00 | AAPL | Stock | 115.71 | 115.71 | 115.71 | 115.71 | 300.0 |
| 2020-10-28 04:16:00 | AAPL | Stock | 115.61 | 115.61 | 115.5 | 115.5 | 1842.0 |
| 2020-10-28 04:17:00 | AAPL | Stock | 115.49 | 115.49 | 115.3 | 115.3 | 1418.0 |
| 2020-10-28 04:18:00 | AAPL | Stock | 115.32 | 115.32 | 115.32 | 115.32 | 685.0 |
| 2020-10-28 04:19:00 | AAPL | Stock | 115.49 | 115.49 | 115.3 | 115.3 | 848.0 |
| 2020-10-28 04:20:00 | AAPL | Stock | 115.25 | 115.25 | 115.21 | 115.21 | 520.0 |
| 2020-10-28 04:21:00 | AAPL | Stock | 115.23 | 115.38 | 115.22 | 115.38 | 1362.0 |
| 2020-10-28 04:22:00 | AAPL | Stock | 115.37 | 115.41 | 115.37 | 115.41 | 1082.0 |
| 2020-10-28 04:23:00 | AAPL | Stock | 115.33 | 115.33 | 115.33 | 115.33 | 100.0 |
| 2020-10-28 04:24:00 | AAPL | Stock | 115.42 | 115.48 | 115.42 | 115.48 | 645.0 |
| 2020-10-28 04:25:00 | AAPL | Stock | 115.48 | 115.48 | 115.45 | 115.45 | 1229.0 |
| 2020-10-28 04:26:00 | AAPL | Stock | 115.44 | 115.44 | 115.44 | 115.44 | 100.0 |
| 2020-10-28 04:27:00 | AAPL | Stock | 115.43 | 115.43 | 115.4 | 115.4 | 300.0 |
| 2020-10-28 04:28:00 | AAPL | Stock | 115.38 | 115.38 | 115.37 | 115.37 | 700.0 |
| 2020-10-28 04:29:00 | AAPL | Stock | 115.36 | 115.38 | 115.36 | 115.38 | 606.0 |
| 2020-10-28 04:31:00 | AAPL | Stock | 115.32 | 115.32 | 115.3 | 115.3 | 888.0 |
| 2020-10-28 04:32:00 | AAPL | Stock | 115.35 | 115.36 | 115.35 | 115.36 | 234.0 |
| 2020-10-28 04:34:00 | AAPL | Stock | 115.29 | 115.3 | 115.29 | 115.3 | 226.0 |
| 2020-10-28 04:36:00 | AAPL | Stock | 115.2 | 115.28 | 115.2 | 115.25 | 1622.0 |
| 2020-10-28 04:37:00 | AAPL | Stock | 115.25 | 115.31 | 115.25 | 115.31 | 1304.0 |
| 2020-10-28 04:38:00 | AAPL | Stock | 115.28 | 115.28 | 115.27 | 115.27 | 2979.0 |
| 2020-10-28 04:39:00 | AAPL | Stock | 115.32 | 115.34 | 115.3 | 115.3 | 1180.0 |
| 2020-10-28 04:40:00 | AAPL | Stock | 115.3 | 115.44 | 115.3 | 115.44 | 2077.0 |
| 2020-10-28 04:41:00 | AAPL | Stock | 115.44 | 115.52 | 115.44 | 115.52 | 1946.0 |
| 2020-10-28 04:42:00 | AAPL | Stock | 115.45 | 115.45 | 115.45 | 115.45 | 100.0 |
| 2020-10-28 04:43:00 | AAPL | Stock | 115.43 | 115.43 | 115.4 | 115.4 | 200.0 |
| 2020-10-28 04:44:00 | AAPL | Stock | 115.4 | 115.4 | 115.4 | 115.4 | 259.0 |
| 2020-10-28 04:45:00 | AAPL | Stock | 115.45 | 115.49 | 115.37 | 115.37 | 1878.0 |
| 2020-10-28 04:46:00 | AAPL | Stock | 115.37 | 115.42 | 115.36 | 115.36 | 2237.0 |
| 2020-10-28 04:48:00 | AAPL | Stock | 115.47 | 115.54 | 115.47 | 115.54 | 1031.0 |
| 2020-10-28 04:49:00 | AAPL | Stock | 115.51 | 115.51 | 115.51 | 115.51 | 398.0 |
| 2020-10-28 04:50:00 | AAPL | Stock | 115.57 | 115.6 | 115.57 | 115.6 | 6329.0 |
| 2020-10-28 04:51:00 | AAPL | Stock | 115.56 | 115.56 | 115.54 | 115.56 | 714.0 |
| 2020-10-28 04:52:00 | AAPL | Stock | 115.57 | 115.59 | 115.57 | 115.59 | 1064.0 |
| 2020-10-28 04:53:00 | AAPL | Stock | 115.57 | 115.6 | 115.57 | 115.6 | 4338.0 |
> showing 50 of 1,316,274 rows — these rows as CSV