PREVIEW / stock_1min / 2020-10-27
file: by_date/stock_1min/2020/2020-10-27.parquet size: 19.3 MB rows: 1,201,211 symbols: 2,119
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-27 04:00:00 | AAPL | Stock | 115.22 | 115.33 | 115.22 | 115.33 | 1745.0 |
| 2020-10-27 04:01:00 | AAPL | Stock | 115.33 | 115.33 | 115.32 | 115.32 | 1963.0 |
| 2020-10-27 04:02:00 | AAPL | Stock | 115.27 | 115.27 | 115.2 | 115.2 | 1346.0 |
| 2020-10-27 04:03:00 | AAPL | Stock | 115.27 | 115.3 | 115.27 | 115.3 | 460.0 |
| 2020-10-27 04:04:00 | AAPL | Stock | 115.25 | 115.25 | 115.25 | 115.25 | 1233.0 |
| 2020-10-27 04:05:00 | AAPL | Stock | 115.26 | 115.35 | 115.26 | 115.35 | 1544.0 |
| 2020-10-27 04:06:00 | AAPL | Stock | 115.35 | 115.35 | 115.35 | 115.35 | 349.0 |
| 2020-10-27 04:07:00 | AAPL | Stock | 115.35 | 115.36 | 115.35 | 115.35 | 1955.0 |
| 2020-10-27 04:08:00 | AAPL | Stock | 115.35 | 115.35 | 115.35 | 115.35 | 3292.0 |
| 2020-10-27 04:09:00 | AAPL | Stock | 115.33 | 115.33 | 115.26 | 115.26 | 300.0 |
| 2020-10-27 04:10:00 | AAPL | Stock | 115.25 | 115.25 | 115.25 | 115.25 | 289.0 |
| 2020-10-27 04:11:00 | AAPL | Stock | 115.2 | 115.2 | 115.2 | 115.2 | 200.0 |
| 2020-10-27 04:12:00 | AAPL | Stock | 115.08 | 115.08 | 115.0 | 115.0 | 1520.0 |
| 2020-10-27 04:14:00 | AAPL | Stock | 115.12 | 115.14 | 115.12 | 115.14 | 300.0 |
| 2020-10-27 04:16:00 | AAPL | Stock | 115.12 | 115.12 | 115.1 | 115.1 | 371.0 |
| 2020-10-27 04:17:00 | AAPL | Stock | 115.16 | 115.16 | 115.1 | 115.11 | 630.0 |
| 2020-10-27 04:20:00 | AAPL | Stock | 115.19 | 115.2 | 115.19 | 115.2 | 800.0 |
| 2020-10-27 04:21:00 | AAPL | Stock | 115.2 | 115.2 | 115.2 | 115.2 | 100.0 |
| 2020-10-27 04:22:00 | AAPL | Stock | 115.16 | 115.16 | 115.15 | 115.15 | 500.0 |
| 2020-10-27 04:24:00 | AAPL | Stock | 115.2 | 115.23 | 115.2 | 115.23 | 300.0 |
| 2020-10-27 04:29:00 | AAPL | Stock | 115.23 | 115.23 | 115.23 | 115.23 | 100.0 |
| 2020-10-27 04:31:00 | AAPL | Stock | 115.25 | 115.25 | 115.25 | 115.25 | 199.0 |
| 2020-10-27 04:32:00 | AAPL | Stock | 115.28 | 115.3 | 115.28 | 115.3 | 352.0 |
| 2020-10-27 04:40:00 | AAPL | Stock | 115.22 | 115.22 | 115.18 | 115.18 | 935.0 |
| 2020-10-27 04:42:00 | AAPL | Stock | 115.3 | 115.3 | 115.3 | 115.3 | 199.0 |
| 2020-10-27 04:43:00 | AAPL | Stock | 115.23 | 115.23 | 115.22 | 115.22 | 500.0 |
| 2020-10-27 04:44:00 | AAPL | Stock | 115.3 | 115.3 | 115.3 | 115.3 | 100.0 |
| 2020-10-27 04:46:00 | AAPL | Stock | 115.3 | 115.3 | 115.3 | 115.3 | 100.0 |
| 2020-10-27 04:48:00 | AAPL | Stock | 115.33 | 115.33 | 115.33 | 115.33 | 140.0 |
| 2020-10-27 04:49:00 | AAPL | Stock | 115.39 | 115.4 | 115.39 | 115.4 | 563.0 |
| 2020-10-27 04:50:00 | AAPL | Stock | 115.34 | 115.38 | 115.34 | 115.38 | 200.0 |
| 2020-10-27 04:52:00 | AAPL | Stock | 115.37 | 115.47 | 115.37 | 115.47 | 653.0 |
| 2020-10-27 04:54:00 | AAPL | Stock | 115.39 | 115.4 | 115.39 | 115.4 | 404.0 |
| 2020-10-27 04:55:00 | AAPL | Stock | 115.37 | 115.37 | 115.37 | 115.37 | 199.0 |
| 2020-10-27 04:56:00 | AAPL | Stock | 115.37 | 115.37 | 115.37 | 115.37 | 138.0 |
| 2020-10-27 04:58:00 | AAPL | Stock | 115.37 | 115.37 | 115.37 | 115.37 | 100.0 |
| 2020-10-27 05:00:00 | AAPL | Stock | 115.33 | 115.35 | 115.33 | 115.33 | 800.0 |
| 2020-10-27 05:01:00 | AAPL | Stock | 115.34 | 115.35 | 115.34 | 115.35 | 514.0 |
| 2020-10-27 05:03:00 | AAPL | Stock | 115.34 | 115.34 | 115.33 | 115.33 | 353.0 |
| 2020-10-27 05:05:00 | AAPL | Stock | 115.26 | 115.26 | 115.26 | 115.26 | 100.0 |
| 2020-10-27 05:06:00 | AAPL | Stock | 115.26 | 115.26 | 115.26 | 115.26 | 100.0 |
| 2020-10-27 05:10:00 | AAPL | Stock | 115.25 | 115.25 | 115.25 | 115.25 | 100.0 |
| 2020-10-27 05:11:00 | AAPL | Stock | 115.25 | 115.25 | 115.18 | 115.18 | 830.0 |
| 2020-10-27 05:12:00 | AAPL | Stock | 115.18 | 115.18 | 115.18 | 115.18 | 117.0 |
| 2020-10-27 05:13:00 | AAPL | Stock | 115.16 | 115.16 | 115.16 | 115.16 | 100.0 |
| 2020-10-27 05:21:00 | AAPL | Stock | 115.15 | 115.16 | 115.15 | 115.16 | 2046.0 |
| 2020-10-27 05:25:00 | AAPL | Stock | 115.2 | 115.2 | 115.2 | 115.2 | 342.0 |
| 2020-10-27 05:27:00 | AAPL | Stock | 115.25 | 115.25 | 115.25 | 115.25 | 100.0 |
| 2020-10-27 05:30:00 | AAPL | Stock | 115.26 | 115.26 | 115.26 | 115.26 | 298.0 |
| 2020-10-27 05:36:00 | AAPL | Stock | 115.32 | 115.32 | 115.32 | 115.32 | 100.0 |
> showing 50 of 1,201,211 rows — these rows as CSV