PREVIEW / stock_1min / 2020-11-11
file: by_date/stock_1min/2020/2020-11-11.parquet size: 20.5 MB rows: 1,247,598 symbols: 2,124
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-11-11 04:00:00 | AAPL | Stock | 117.67 | 117.67 | 117.5 | 117.5 | 7629.0 |
| 2020-11-11 04:01:00 | AAPL | Stock | 117.25 | 117.25 | 117.2 | 117.2 | 1016.0 |
| 2020-11-11 04:02:00 | AAPL | Stock | 117.25 | 117.34 | 117.2 | 117.32 | 1267.0 |
| 2020-11-11 04:03:00 | AAPL | Stock | 117.24 | 117.32 | 117.24 | 117.29 | 465.0 |
| 2020-11-11 04:04:00 | AAPL | Stock | 117.29 | 117.32 | 117.29 | 117.32 | 1072.0 |
| 2020-11-11 04:05:00 | AAPL | Stock | 117.31 | 117.31 | 117.3 | 117.3 | 414.0 |
| 2020-11-11 04:06:00 | AAPL | Stock | 117.48 | 117.48 | 117.28 | 117.42 | 1402.0 |
| 2020-11-11 04:07:00 | AAPL | Stock | 117.42 | 117.42 | 117.32 | 117.32 | 2029.0 |
| 2020-11-11 04:08:00 | AAPL | Stock | 117.31 | 117.31 | 117.29 | 117.29 | 219.0 |
| 2020-11-11 04:09:00 | AAPL | Stock | 117.21 | 117.21 | 117.21 | 117.21 | 112.0 |
| 2020-11-11 04:10:00 | AAPL | Stock | 117.2 | 117.2 | 117.11 | 117.11 | 915.0 |
| 2020-11-11 04:11:00 | AAPL | Stock | 117.19 | 117.19 | 117.1 | 117.1 | 1231.0 |
| 2020-11-11 04:12:00 | AAPL | Stock | 117.19 | 117.21 | 117.11 | 117.11 | 1300.0 |
| 2020-11-11 04:14:00 | AAPL | Stock | 117.21 | 117.21 | 117.1 | 117.1 | 679.0 |
| 2020-11-11 04:19:00 | AAPL | Stock | 117.07 | 117.09 | 117.07 | 117.09 | 200.0 |
| 2020-11-11 04:20:00 | AAPL | Stock | 117.11 | 117.11 | 117.11 | 117.11 | 200.0 |
| 2020-11-11 04:21:00 | AAPL | Stock | 117.12 | 117.18 | 117.12 | 117.18 | 1035.0 |
| 2020-11-11 04:22:00 | AAPL | Stock | 117.16 | 117.16 | 117.15 | 117.15 | 1899.0 |
| 2020-11-11 04:23:00 | AAPL | Stock | 117.25 | 117.25 | 117.25 | 117.25 | 315.0 |
| 2020-11-11 04:24:00 | AAPL | Stock | 117.25 | 117.25 | 117.25 | 117.25 | 625.0 |
| 2020-11-11 04:25:00 | AAPL | Stock | 117.25 | 117.25 | 117.25 | 117.25 | 1200.0 |
| 2020-11-11 04:26:00 | AAPL | Stock | 117.31 | 117.31 | 117.3 | 117.3 | 304.0 |
| 2020-11-11 04:27:00 | AAPL | Stock | 117.3 | 117.3 | 117.02 | 117.25 | 1649.0 |
| 2020-11-11 04:28:00 | AAPL | Stock | 117.25 | 117.25 | 117.25 | 117.25 | 1594.0 |
| 2020-11-11 04:29:00 | AAPL | Stock | 117.2 | 117.2 | 117.2 | 117.2 | 100.0 |
| 2020-11-11 04:30:00 | AAPL | Stock | 117.19 | 117.19 | 117.19 | 117.19 | 235.0 |
| 2020-11-11 04:31:00 | AAPL | Stock | 117.15 | 117.2 | 117.13 | 117.13 | 1376.0 |
| 2020-11-11 04:32:00 | AAPL | Stock | 117.09 | 117.09 | 117.09 | 117.09 | 100.0 |
| 2020-11-11 04:34:00 | AAPL | Stock | 117.1 | 117.1 | 117.1 | 117.1 | 322.0 |
| 2020-11-11 04:35:00 | AAPL | Stock | 117.01 | 117.01 | 116.89 | 116.97 | 6175.0 |
| 2020-11-11 04:37:00 | AAPL | Stock | 116.9 | 116.91 | 116.9 | 116.91 | 1097.0 |
| 2020-11-11 04:38:00 | AAPL | Stock | 116.9 | 116.91 | 116.9 | 116.91 | 200.0 |
| 2020-11-11 04:39:00 | AAPL | Stock | 116.87 | 116.87 | 116.87 | 116.87 | 100.0 |
| 2020-11-11 04:40:00 | AAPL | Stock | 116.85 | 116.85 | 116.85 | 116.85 | 233.0 |
| 2020-11-11 04:41:00 | AAPL | Stock | 116.98 | 116.98 | 116.98 | 116.98 | 100.0 |
| 2020-11-11 04:42:00 | AAPL | Stock | 117.46 | 117.46 | 117.2 | 117.32 | 5732.0 |
| 2020-11-11 04:43:00 | AAPL | Stock | 117.3 | 117.32 | 117.28 | 117.28 | 1612.0 |
| 2020-11-11 04:45:00 | AAPL | Stock | 117.26 | 117.26 | 117.26 | 117.26 | 220.0 |
| 2020-11-11 04:46:00 | AAPL | Stock | 117.2 | 117.26 | 117.2 | 117.2 | 862.0 |
| 2020-11-11 04:47:00 | AAPL | Stock | 117.21 | 117.21 | 117.21 | 117.21 | 300.0 |
| 2020-11-11 04:48:00 | AAPL | Stock | 117.25 | 117.25 | 117.25 | 117.25 | 417.0 |
| 2020-11-11 04:50:00 | AAPL | Stock | 117.2 | 117.2 | 117.2 | 117.2 | 468.0 |
| 2020-11-11 04:51:00 | AAPL | Stock | 117.25 | 117.25 | 117.25 | 117.25 | 200.0 |
| 2020-11-11 04:52:00 | AAPL | Stock | 117.17 | 117.17 | 117.0 | 117.0 | 1180.0 |
| 2020-11-11 04:55:00 | AAPL | Stock | 117.24 | 117.24 | 117.24 | 117.24 | 168.0 |
| 2020-11-11 04:58:00 | AAPL | Stock | 117.2 | 117.2 | 117.2 | 117.2 | 200.0 |
| 2020-11-11 04:59:00 | AAPL | Stock | 117.17 | 117.17 | 117.16 | 117.16 | 975.0 |
| 2020-11-11 05:00:00 | AAPL | Stock | 117.16 | 117.16 | 117.15 | 117.15 | 418.0 |
| 2020-11-11 05:01:00 | AAPL | Stock | 117.15 | 117.2 | 117.15 | 117.2 | 484.0 |
| 2020-11-11 05:02:00 | AAPL | Stock | 117.15 | 117.15 | 117.15 | 117.15 | 222.0 |
> showing 50 of 1,247,598 rows — these rows as CSV