PREVIEW / stock_1min / 2020-12-09
file: by_date/stock_1min/2020/2020-12-09.parquet size: 23.9 MB rows: 1,412,068 symbols: 2,263
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-12-09 04:00:00 | AAPL | Stock | 124.8 | 124.8 | 124.8 | 124.8 | 450.0 |
| 2020-12-09 04:01:00 | AAPL | Stock | 124.55 | 124.56 | 124.25 | 124.44 | 1044.0 |
| 2020-12-09 04:02:00 | AAPL | Stock | 124.57 | 124.57 | 124.43 | 124.43 | 500.0 |
| 2020-12-09 04:03:00 | AAPL | Stock | 124.42 | 124.42 | 124.38 | 124.38 | 1061.0 |
| 2020-12-09 04:04:00 | AAPL | Stock | 124.49 | 124.55 | 124.49 | 124.55 | 2738.0 |
| 2020-12-09 04:05:00 | AAPL | Stock | 124.55 | 124.6 | 124.55 | 124.6 | 900.0 |
| 2020-12-09 04:08:00 | AAPL | Stock | 124.62 | 124.62 | 124.62 | 124.62 | 210.0 |
| 2020-12-09 04:09:00 | AAPL | Stock | 124.58 | 124.58 | 124.58 | 124.58 | 100.0 |
| 2020-12-09 04:12:00 | AAPL | Stock | 124.43 | 124.43 | 124.36 | 124.36 | 500.0 |
| 2020-12-09 04:15:00 | AAPL | Stock | 124.28 | 124.28 | 124.28 | 124.28 | 400.0 |
| 2020-12-09 04:16:00 | AAPL | Stock | 124.25 | 124.25 | 124.25 | 124.25 | 495.0 |
| 2020-12-09 04:17:00 | AAPL | Stock | 124.24 | 124.24 | 124.24 | 124.24 | 100.0 |
| 2020-12-09 04:18:00 | AAPL | Stock | 124.06 | 124.06 | 124.01 | 124.01 | 900.0 |
| 2020-12-09 04:27:00 | AAPL | Stock | 124.18 | 124.2 | 124.18 | 124.2 | 615.0 |
| 2020-12-09 04:28:00 | AAPL | Stock | 124.17 | 124.17 | 124.17 | 124.17 | 146.0 |
| 2020-12-09 04:30:00 | AAPL | Stock | 124.1 | 124.1 | 124.1 | 124.1 | 100.0 |
| 2020-12-09 04:31:00 | AAPL | Stock | 124.08 | 124.08 | 124.08 | 124.08 | 100.0 |
| 2020-12-09 04:32:00 | AAPL | Stock | 124.1 | 124.1 | 124.08 | 124.08 | 630.0 |
| 2020-12-09 04:33:00 | AAPL | Stock | 124.07 | 124.07 | 124.07 | 124.07 | 500.0 |
| 2020-12-09 04:41:00 | AAPL | Stock | 124.19 | 124.19 | 124.19 | 124.19 | 150.0 |
| 2020-12-09 04:42:00 | AAPL | Stock | 124.19 | 124.2 | 124.19 | 124.2 | 490.0 |
| 2020-12-09 04:46:00 | AAPL | Stock | 124.21 | 124.21 | 124.2 | 124.2 | 411.0 |
| 2020-12-09 04:48:00 | AAPL | Stock | 124.13 | 124.13 | 124.13 | 124.13 | 110.0 |
| 2020-12-09 04:50:00 | AAPL | Stock | 124.19 | 124.19 | 124.13 | 124.13 | 384.0 |
| 2020-12-09 04:51:00 | AAPL | Stock | 124.19 | 124.19 | 124.19 | 124.19 | 358.0 |
| 2020-12-09 04:55:00 | AAPL | Stock | 124.12 | 124.12 | 124.12 | 124.12 | 379.0 |
| 2020-12-09 04:59:00 | AAPL | Stock | 124.12 | 124.12 | 124.12 | 124.12 | 200.0 |
| 2020-12-09 05:03:00 | AAPL | Stock | 124.14 | 124.14 | 124.14 | 124.14 | 419.0 |
| 2020-12-09 05:06:00 | AAPL | Stock | 124.2 | 124.37 | 124.2 | 124.37 | 1100.0 |
| 2020-12-09 05:08:00 | AAPL | Stock | 124.3 | 124.3 | 124.3 | 124.3 | 4439.0 |
| 2020-12-09 05:09:00 | AAPL | Stock | 124.35 | 124.35 | 124.34 | 124.35 | 300.0 |
| 2020-12-09 05:13:00 | AAPL | Stock | 124.3 | 124.3 | 124.3 | 124.3 | 100.0 |
| 2020-12-09 05:14:00 | AAPL | Stock | 124.3 | 124.3 | 124.11 | 124.11 | 700.0 |
| 2020-12-09 05:17:00 | AAPL | Stock | 124.12 | 124.12 | 124.12 | 124.12 | 200.0 |
| 2020-12-09 05:21:00 | AAPL | Stock | 124.15 | 124.15 | 124.15 | 124.15 | 500.0 |
| 2020-12-09 05:22:00 | AAPL | Stock | 124.06 | 124.06 | 124.06 | 124.06 | 100.0 |
| 2020-12-09 05:23:00 | AAPL | Stock | 124.06 | 124.06 | 124.01 | 124.01 | 571.0 |
| 2020-12-09 05:24:00 | AAPL | Stock | 124.09 | 124.09 | 124.09 | 124.09 | 100.0 |
| 2020-12-09 05:25:00 | AAPL | Stock | 124.09 | 124.14 | 124.01 | 124.07 | 1899.0 |
| 2020-12-09 05:28:00 | AAPL | Stock | 124.09 | 124.1 | 124.09 | 124.1 | 350.0 |
| 2020-12-09 05:29:00 | AAPL | Stock | 124.15 | 124.15 | 124.15 | 124.15 | 297.0 |
| 2020-12-09 05:33:00 | AAPL | Stock | 124.17 | 124.21 | 124.17 | 124.19 | 900.0 |
| 2020-12-09 05:37:00 | AAPL | Stock | 124.28 | 124.28 | 124.28 | 124.28 | 100.0 |
| 2020-12-09 05:39:00 | AAPL | Stock | 124.27 | 124.28 | 124.27 | 124.28 | 965.0 |
| 2020-12-09 05:42:00 | AAPL | Stock | 124.23 | 124.23 | 124.23 | 124.23 | 110.0 |
| 2020-12-09 05:45:00 | AAPL | Stock | 124.21 | 124.21 | 124.21 | 124.21 | 100.0 |
| 2020-12-09 05:46:00 | AAPL | Stock | 124.18 | 124.19 | 124.18 | 124.19 | 570.0 |
| 2020-12-09 05:51:00 | AAPL | Stock | 124.18 | 124.18 | 124.15 | 124.15 | 523.0 |
| 2020-12-09 05:53:00 | AAPL | Stock | 124.19 | 124.2 | 124.19 | 124.2 | 200.0 |
| 2020-12-09 05:59:00 | AAPL | Stock | 124.2 | 124.3 | 124.2 | 124.3 | 755.0 |
> showing 50 of 1,412,068 rows — these rows as CSV