PREVIEW / stock_1min / 2021-10-18
file: by_date/stock_1min/2021/2021-10-18.parquet size: 23.5 MB rows: 1,315,543 symbols: 2,283
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-10-18 04:00:00 | AAPL | Stock | 144.39 | 144.39 | 144.04 | 144.19 | 1931.0 |
| 2021-10-18 04:01:00 | AAPL | Stock | 144.19 | 144.34 | 144.19 | 144.34 | 1124.0 |
| 2021-10-18 04:02:00 | AAPL | Stock | 144.34 | 144.34 | 144.34 | 144.34 | 452.0 |
| 2021-10-18 04:04:00 | AAPL | Stock | 144.21 | 144.24 | 144.21 | 144.24 | 750.0 |
| 2021-10-18 04:05:00 | AAPL | Stock | 144.34 | 144.34 | 144.34 | 144.34 | 500.0 |
| 2021-10-18 04:06:00 | AAPL | Stock | 144.31 | 144.31 | 144.31 | 144.31 | 325.0 |
| 2021-10-18 04:07:00 | AAPL | Stock | 144.24 | 144.24 | 144.24 | 144.24 | 306.0 |
| 2021-10-18 04:08:00 | AAPL | Stock | 144.21 | 144.25 | 144.21 | 144.25 | 542.0 |
| 2021-10-18 04:09:00 | AAPL | Stock | 144.25 | 144.25 | 144.25 | 144.25 | 376.0 |
| 2021-10-18 04:10:00 | AAPL | Stock | 144.27 | 144.27 | 144.26 | 144.26 | 330.0 |
| 2021-10-18 04:13:00 | AAPL | Stock | 144.22 | 144.22 | 144.2 | 144.2 | 368.0 |
| 2021-10-18 04:14:00 | AAPL | Stock | 144.2 | 144.2 | 144.2 | 144.2 | 281.0 |
| 2021-10-18 04:15:00 | AAPL | Stock | 144.18 | 144.18 | 144.18 | 144.18 | 100.0 |
| 2021-10-18 04:19:00 | AAPL | Stock | 144.25 | 144.25 | 144.25 | 144.25 | 150.0 |
| 2021-10-18 04:23:00 | AAPL | Stock | 144.24 | 144.24 | 144.24 | 144.24 | 662.0 |
| 2021-10-18 04:25:00 | AAPL | Stock | 144.25 | 144.25 | 144.25 | 144.25 | 440.0 |
| 2021-10-18 04:26:00 | AAPL | Stock | 144.2 | 144.2 | 144.2 | 144.2 | 150.0 |
| 2021-10-18 04:37:00 | AAPL | Stock | 144.25 | 144.25 | 144.23 | 144.23 | 450.0 |
| 2021-10-18 04:39:00 | AAPL | Stock | 144.21 | 144.28 | 144.21 | 144.28 | 340.0 |
| 2021-10-18 04:40:00 | AAPL | Stock | 144.22 | 144.22 | 144.22 | 144.22 | 100.0 |
| 2021-10-18 04:44:00 | AAPL | Stock | 144.21 | 144.21 | 144.21 | 144.21 | 474.0 |
| 2021-10-18 04:46:00 | AAPL | Stock | 144.23 | 144.23 | 144.23 | 144.23 | 106.0 |
| 2021-10-18 04:47:00 | AAPL | Stock | 144.25 | 144.25 | 144.25 | 144.25 | 300.0 |
| 2021-10-18 04:49:00 | AAPL | Stock | 144.28 | 144.28 | 144.27 | 144.27 | 399.0 |
| 2021-10-18 04:50:00 | AAPL | Stock | 144.26 | 144.26 | 144.25 | 144.25 | 400.0 |
| 2021-10-18 04:51:00 | AAPL | Stock | 144.23 | 144.23 | 144.22 | 144.22 | 300.0 |
| 2021-10-18 04:53:00 | AAPL | Stock | 144.2 | 144.2 | 144.2 | 144.2 | 405.0 |
| 2021-10-18 04:55:00 | AAPL | Stock | 144.25 | 144.25 | 144.25 | 144.25 | 100.0 |
| 2021-10-18 05:02:00 | AAPL | Stock | 144.21 | 144.22 | 144.21 | 144.21 | 1132.0 |
| 2021-10-18 05:03:00 | AAPL | Stock | 144.21 | 144.21 | 144.21 | 144.21 | 150.0 |
| 2021-10-18 05:04:00 | AAPL | Stock | 144.2 | 144.2 | 144.17 | 144.17 | 2591.0 |
| 2021-10-18 05:06:00 | AAPL | Stock | 144.17 | 144.17 | 144.17 | 144.17 | 250.0 |
| 2021-10-18 05:07:00 | AAPL | Stock | 144.16 | 144.16 | 144.16 | 144.16 | 320.0 |
| 2021-10-18 05:08:00 | AAPL | Stock | 144.18 | 144.18 | 144.18 | 144.18 | 138.0 |
| 2021-10-18 05:09:00 | AAPL | Stock | 144.18 | 144.18 | 144.18 | 144.18 | 126.0 |
| 2021-10-18 05:15:00 | AAPL | Stock | 144.19 | 144.19 | 144.19 | 144.19 | 150.0 |
| 2021-10-18 05:17:00 | AAPL | Stock | 144.19 | 144.19 | 144.19 | 144.19 | 450.0 |
| 2021-10-18 05:19:00 | AAPL | Stock | 144.2 | 144.2 | 144.19 | 144.19 | 254.0 |
| 2021-10-18 05:20:00 | AAPL | Stock | 144.22 | 144.22 | 144.22 | 144.22 | 544.0 |
| 2021-10-18 05:26:00 | AAPL | Stock | 144.34 | 144.35 | 144.34 | 144.35 | 238.0 |
| 2021-10-18 05:27:00 | AAPL | Stock | 144.4 | 144.4 | 144.4 | 144.4 | 592.0 |
| 2021-10-18 05:28:00 | AAPL | Stock | 144.35 | 144.35 | 144.35 | 144.35 | 1229.0 |
| 2021-10-18 05:36:00 | AAPL | Stock | 144.28 | 144.28 | 144.22 | 144.23 | 898.0 |
| 2021-10-18 05:37:00 | AAPL | Stock | 144.22 | 144.22 | 144.22 | 144.22 | 100.0 |
| 2021-10-18 05:43:00 | AAPL | Stock | 144.29 | 144.29 | 144.29 | 144.29 | 395.0 |
| 2021-10-18 05:47:00 | AAPL | Stock | 144.26 | 144.26 | 144.26 | 144.26 | 269.0 |
| 2021-10-18 05:48:00 | AAPL | Stock | 144.26 | 144.26 | 144.26 | 144.26 | 211.0 |
| 2021-10-18 05:51:00 | AAPL | Stock | 144.32 | 144.32 | 144.32 | 144.32 | 210.0 |
| 2021-10-18 06:00:00 | AAPL | Stock | 144.3 | 144.3 | 144.25 | 144.27 | 1411.0 |
| 2021-10-18 06:03:00 | AAPL | Stock | 144.31 | 144.32 | 144.31 | 144.32 | 470.0 |
> showing 50 of 1,315,543 rows — these rows as CSV