PREVIEW / stock_1min / 2021-12-20
file: by_date/stock_1min/2021/2021-12-20.parquet size: 24.9 MB rows: 1,490,980 symbols: 2,279
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-20 04:00:00 | AAPL | Stock | 167.98 | 168.49 | 167.89 | 168.0 | 3743.0 |
| 2021-12-20 04:01:00 | AAPL | Stock | 168.0 | 168.0 | 167.5 | 167.5 | 3500.0 |
| 2021-12-20 04:02:00 | AAPL | Stock | 167.6 | 167.6 | 167.11 | 167.11 | 5843.0 |
| 2021-12-20 04:03:00 | AAPL | Stock | 167.18 | 167.21 | 167.13 | 167.21 | 300.0 |
| 2021-12-20 04:04:00 | AAPL | Stock | 167.47 | 167.49 | 167.26 | 167.49 | 6671.0 |
| 2021-12-20 04:05:00 | AAPL | Stock | 167.37 | 167.37 | 167.37 | 167.37 | 177.0 |
| 2021-12-20 04:06:00 | AAPL | Stock | 167.41 | 167.41 | 167.1 | 167.11 | 3981.0 |
| 2021-12-20 04:07:00 | AAPL | Stock | 167.05 | 167.1 | 167.05 | 167.1 | 673.0 |
| 2021-12-20 04:08:00 | AAPL | Stock | 167.11 | 167.25 | 167.11 | 167.25 | 1762.0 |
| 2021-12-20 04:09:00 | AAPL | Stock | 167.32 | 167.32 | 167.32 | 167.32 | 100.0 |
| 2021-12-20 04:10:00 | AAPL | Stock | 167.5 | 167.5 | 167.5 | 167.5 | 100.0 |
| 2021-12-20 04:11:00 | AAPL | Stock | 167.7 | 167.85 | 167.7 | 167.85 | 3266.0 |
| 2021-12-20 04:12:00 | AAPL | Stock | 167.81 | 167.82 | 167.52 | 167.52 | 2029.0 |
| 2021-12-20 04:13:00 | AAPL | Stock | 167.56 | 167.57 | 167.5 | 167.5 | 709.0 |
| 2021-12-20 04:14:00 | AAPL | Stock | 167.43 | 167.43 | 167.25 | 167.25 | 1494.0 |
| 2021-12-20 04:15:00 | AAPL | Stock | 167.18 | 167.25 | 167.15 | 167.2 | 2250.0 |
| 2021-12-20 04:16:00 | AAPL | Stock | 167.18 | 167.19 | 167.18 | 167.19 | 396.0 |
| 2021-12-20 04:17:00 | AAPL | Stock | 167.19 | 167.23 | 167.13 | 167.23 | 5462.0 |
| 2021-12-20 04:18:00 | AAPL | Stock | 167.23 | 167.23 | 167.16 | 167.19 | 4616.0 |
| 2021-12-20 04:19:00 | AAPL | Stock | 167.17 | 167.34 | 167.17 | 167.31 | 2999.0 |
| 2021-12-20 04:20:00 | AAPL | Stock | 167.31 | 167.31 | 167.29 | 167.29 | 2909.0 |
| 2021-12-20 04:21:00 | AAPL | Stock | 167.34 | 167.34 | 167.34 | 167.34 | 100.0 |
| 2021-12-20 04:22:00 | AAPL | Stock | 167.39 | 167.5 | 167.39 | 167.5 | 1558.0 |
| 2021-12-20 04:23:00 | AAPL | Stock | 167.57 | 167.57 | 167.57 | 167.57 | 100.0 |
| 2021-12-20 04:24:00 | AAPL | Stock | 167.53 | 167.53 | 167.53 | 167.53 | 152.0 |
| 2021-12-20 04:25:00 | AAPL | Stock | 167.51 | 167.51 | 167.51 | 167.51 | 121.0 |
| 2021-12-20 04:26:00 | AAPL | Stock | 167.46 | 167.46 | 167.46 | 167.46 | 160.0 |
| 2021-12-20 04:27:00 | AAPL | Stock | 167.41 | 167.45 | 167.41 | 167.41 | 953.0 |
| 2021-12-20 04:28:00 | AAPL | Stock | 167.4 | 167.41 | 167.33 | 167.33 | 542.0 |
| 2021-12-20 04:29:00 | AAPL | Stock | 167.41 | 167.41 | 167.41 | 167.41 | 150.0 |
| 2021-12-20 04:30:00 | AAPL | Stock | 167.44 | 167.5 | 167.44 | 167.5 | 460.0 |
| 2021-12-20 04:31:00 | AAPL | Stock | 167.51 | 167.51 | 167.5 | 167.51 | 4067.0 |
| 2021-12-20 04:32:00 | AAPL | Stock | 167.5 | 167.5 | 167.5 | 167.5 | 177.0 |
| 2021-12-20 04:34:00 | AAPL | Stock | 167.56 | 167.71 | 167.56 | 167.7 | 3061.0 |
| 2021-12-20 04:35:00 | AAPL | Stock | 167.58 | 167.58 | 167.55 | 167.55 | 923.0 |
| 2021-12-20 04:37:00 | AAPL | Stock | 167.66 | 167.66 | 167.66 | 167.66 | 378.0 |
| 2021-12-20 04:39:00 | AAPL | Stock | 167.7 | 167.7 | 167.67 | 167.67 | 800.0 |
| 2021-12-20 04:40:00 | AAPL | Stock | 167.7 | 167.7 | 167.7 | 167.7 | 169.0 |
| 2021-12-20 04:41:00 | AAPL | Stock | 167.6 | 167.6 | 167.57 | 167.57 | 200.0 |
| 2021-12-20 04:42:00 | AAPL | Stock | 167.56 | 167.56 | 167.5 | 167.5 | 250.0 |
| 2021-12-20 04:43:00 | AAPL | Stock | 167.56 | 167.64 | 167.48 | 167.64 | 2140.0 |
| 2021-12-20 04:44:00 | AAPL | Stock | 167.66 | 167.66 | 167.53 | 167.53 | 200.0 |
| 2021-12-20 04:45:00 | AAPL | Stock | 167.59 | 167.6 | 167.59 | 167.6 | 225.0 |
| 2021-12-20 04:46:00 | AAPL | Stock | 167.59 | 167.59 | 167.59 | 167.59 | 300.0 |
| 2021-12-20 04:47:00 | AAPL | Stock | 167.59 | 167.6 | 167.59 | 167.6 | 958.0 |
| 2021-12-20 04:48:00 | AAPL | Stock | 167.56 | 167.6 | 167.56 | 167.6 | 200.0 |
| 2021-12-20 04:50:00 | AAPL | Stock | 167.57 | 167.57 | 167.54 | 167.54 | 476.0 |
| 2021-12-20 04:52:00 | AAPL | Stock | 167.45 | 167.45 | 167.43 | 167.43 | 1150.0 |
| 2021-12-20 04:54:00 | AAPL | Stock | 167.46 | 167.46 | 167.46 | 167.46 | 200.0 |
| 2021-12-20 04:55:00 | AAPL | Stock | 167.49 | 167.5 | 167.49 | 167.49 | 604.0 |
> showing 50 of 1,490,980 rows — these rows as CSV