PREVIEW / stock_1min / 2020-09-04
file: by_date/stock_1min/2020/2020-09-04.parquet size: 21.4 MB rows: 1,303,429 symbols: 2,084
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-09-04 04:00:00 | AAPL | Stock | 116.0 | 120.98 | 116.0 | 120.0 | 47207.0 |
| 2020-09-04 04:01:00 | AAPL | Stock | 120.3 | 120.36 | 120.11 | 120.35 | 6053.0 |
| 2020-09-04 04:02:00 | AAPL | Stock | 120.35 | 120.4 | 120.0 | 120.34 | 5985.0 |
| 2020-09-04 04:03:00 | AAPL | Stock | 120.32 | 120.34 | 120.0 | 120.1 | 8425.0 |
| 2020-09-04 04:04:00 | AAPL | Stock | 120.0 | 120.28 | 119.3 | 119.34 | 9767.0 |
| 2020-09-04 04:05:00 | AAPL | Stock | 119.32 | 119.33 | 119.0 | 119.01 | 3635.0 |
| 2020-09-04 04:06:00 | AAPL | Stock | 119.0 | 119.0 | 118.78 | 118.82 | 9222.0 |
| 2020-09-04 04:07:00 | AAPL | Stock | 118.9 | 119.0 | 118.85 | 118.85 | 4403.0 |
| 2020-09-04 04:08:00 | AAPL | Stock | 118.83 | 119.1 | 118.83 | 119.1 | 5526.0 |
| 2020-09-04 04:09:00 | AAPL | Stock | 119.33 | 119.6 | 119.33 | 119.55 | 1876.0 |
| 2020-09-04 04:10:00 | AAPL | Stock | 119.6 | 119.9 | 119.54 | 119.75 | 4940.0 |
| 2020-09-04 04:11:00 | AAPL | Stock | 119.89 | 119.89 | 119.37 | 119.37 | 3320.0 |
| 2020-09-04 04:12:00 | AAPL | Stock | 119.21 | 119.47 | 119.21 | 119.43 | 1464.0 |
| 2020-09-04 04:13:00 | AAPL | Stock | 119.35 | 119.5 | 119.23 | 119.5 | 3573.0 |
| 2020-09-04 04:14:00 | AAPL | Stock | 119.5 | 119.69 | 119.5 | 119.66 | 923.0 |
| 2020-09-04 04:15:00 | AAPL | Stock | 119.64 | 119.75 | 119.64 | 119.65 | 2336.0 |
| 2020-09-04 04:16:00 | AAPL | Stock | 119.75 | 119.97 | 119.75 | 119.84 | 1530.0 |
| 2020-09-04 04:17:00 | AAPL | Stock | 119.84 | 119.9 | 119.75 | 119.9 | 5202.0 |
| 2020-09-04 04:18:00 | AAPL | Stock | 119.97 | 120.03 | 119.62 | 119.67 | 9297.0 |
| 2020-09-04 04:19:00 | AAPL | Stock | 119.76 | 119.76 | 119.5 | 119.7 | 1059.0 |
| 2020-09-04 04:20:00 | AAPL | Stock | 119.65 | 120.05 | 119.5 | 119.57 | 3907.0 |
| 2020-09-04 04:21:00 | AAPL | Stock | 119.57 | 119.78 | 119.51 | 119.78 | 2376.0 |
| 2020-09-04 04:22:00 | AAPL | Stock | 119.67 | 119.67 | 119.57 | 119.64 | 2061.0 |
| 2020-09-04 04:23:00 | AAPL | Stock | 119.67 | 119.67 | 119.5 | 119.5 | 1017.0 |
| 2020-09-04 04:24:00 | AAPL | Stock | 119.65 | 119.65 | 119.4 | 119.5 | 1926.0 |
| 2020-09-04 04:25:00 | AAPL | Stock | 119.48 | 119.48 | 119.3 | 119.43 | 2184.0 |
| 2020-09-04 04:26:00 | AAPL | Stock | 119.62 | 119.62 | 119.41 | 119.54 | 702.0 |
| 2020-09-04 04:27:00 | AAPL | Stock | 119.57 | 119.64 | 119.5 | 119.62 | 3311.0 |
| 2020-09-04 04:28:00 | AAPL | Stock | 119.52 | 119.58 | 119.45 | 119.58 | 2191.0 |
| 2020-09-04 04:29:00 | AAPL | Stock | 119.53 | 119.53 | 119.45 | 119.45 | 1402.0 |
| 2020-09-04 04:30:00 | AAPL | Stock | 119.55 | 119.55 | 119.55 | 119.55 | 100.0 |
| 2020-09-04 04:31:00 | AAPL | Stock | 119.49 | 119.55 | 119.4 | 119.55 | 1944.0 |
| 2020-09-04 04:32:00 | AAPL | Stock | 119.58 | 119.58 | 119.52 | 119.52 | 3242.0 |
| 2020-09-04 04:33:00 | AAPL | Stock | 119.66 | 119.8 | 119.66 | 119.8 | 1479.0 |
| 2020-09-04 04:34:00 | AAPL | Stock | 119.73 | 120.33 | 119.73 | 120.33 | 3599.0 |
| 2020-09-04 04:35:00 | AAPL | Stock | 120.15 | 120.52 | 120.15 | 120.5 | 3906.0 |
| 2020-09-04 04:36:00 | AAPL | Stock | 120.4 | 120.5 | 120.3 | 120.3 | 1674.0 |
| 2020-09-04 04:37:00 | AAPL | Stock | 120.3 | 120.3 | 120.2 | 120.2 | 3063.0 |
| 2020-09-04 04:38:00 | AAPL | Stock | 120.19 | 120.2 | 119.75 | 120.02 | 1133.0 |
| 2020-09-04 04:39:00 | AAPL | Stock | 120.0 | 120.14 | 120.0 | 120.14 | 370.0 |
| 2020-09-04 04:40:00 | AAPL | Stock | 119.99 | 119.99 | 119.9 | 119.9 | 250.0 |
| 2020-09-04 04:41:00 | AAPL | Stock | 119.89 | 120.24 | 119.89 | 120.23 | 7640.0 |
| 2020-09-04 04:42:00 | AAPL | Stock | 120.39 | 120.39 | 120.36 | 120.36 | 600.0 |
| 2020-09-04 04:43:00 | AAPL | Stock | 120.27 | 120.38 | 120.21 | 120.38 | 1151.0 |
| 2020-09-04 04:44:00 | AAPL | Stock | 120.36 | 120.43 | 120.02 | 120.02 | 5681.0 |
| 2020-09-04 04:45:00 | AAPL | Stock | 120.02 | 120.16 | 120.0 | 120.1 | 4719.0 |
| 2020-09-04 04:46:00 | AAPL | Stock | 120.1 | 120.2 | 120.04 | 120.1 | 1373.0 |
| 2020-09-04 04:48:00 | AAPL | Stock | 120.17 | 120.3 | 120.17 | 120.3 | 7636.0 |
| 2020-09-04 04:49:00 | AAPL | Stock | 120.2 | 120.5 | 120.2 | 120.35 | 4958.0 |
| 2020-09-04 04:50:00 | AAPL | Stock | 120.4 | 120.44 | 120.4 | 120.4 | 1600.0 |
> showing 50 of 1,303,429 rows — these rows as CSV