PREVIEW / stock_1min / 2021-07-12
file: by_date/stock_1min/2021/2021-07-12.parquet size: 23.0 MB rows: 1,318,163 symbols: 2,446
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-07-12 04:00:00 | AAPL | Stock | 144.8 | 144.81 | 144.75 | 144.8 | 2088.0 |
| 2021-07-12 04:01:00 | AAPL | Stock | 144.91 | 144.92 | 144.82 | 144.82 | 1451.0 |
| 2021-07-12 04:02:00 | AAPL | Stock | 144.9 | 144.93 | 144.9 | 144.93 | 543.0 |
| 2021-07-12 04:04:00 | AAPL | Stock | 145.0 | 145.0 | 145.0 | 145.0 | 175.0 |
| 2021-07-12 04:05:00 | AAPL | Stock | 145.0 | 145.0 | 144.92 | 144.99 | 1368.0 |
| 2021-07-12 04:07:00 | AAPL | Stock | 145.03 | 145.07 | 145.03 | 145.07 | 1553.0 |
| 2021-07-12 04:09:00 | AAPL | Stock | 145.07 | 145.07 | 145.07 | 145.07 | 116.0 |
| 2021-07-12 04:10:00 | AAPL | Stock | 145.15 | 145.37 | 145.15 | 145.37 | 2070.0 |
| 2021-07-12 04:11:00 | AAPL | Stock | 145.34 | 145.35 | 145.22 | 145.29 | 3026.0 |
| 2021-07-12 04:12:00 | AAPL | Stock | 145.22 | 145.25 | 145.2 | 145.25 | 1633.0 |
| 2021-07-12 04:14:00 | AAPL | Stock | 145.2 | 145.2 | 145.2 | 145.2 | 107.0 |
| 2021-07-12 04:15:00 | AAPL | Stock | 145.24 | 145.24 | 145.24 | 145.24 | 418.0 |
| 2021-07-12 04:17:00 | AAPL | Stock | 145.25 | 145.35 | 145.25 | 145.35 | 400.0 |
| 2021-07-12 04:18:00 | AAPL | Stock | 145.4 | 145.4 | 145.4 | 145.4 | 100.0 |
| 2021-07-12 04:21:00 | AAPL | Stock | 145.4 | 145.4 | 145.38 | 145.38 | 690.0 |
| 2021-07-12 04:23:00 | AAPL | Stock | 145.23 | 145.24 | 145.22 | 145.22 | 4837.0 |
| 2021-07-12 04:24:00 | AAPL | Stock | 145.34 | 145.4 | 145.34 | 145.4 | 1100.0 |
| 2021-07-12 04:26:00 | AAPL | Stock | 145.45 | 145.47 | 145.45 | 145.47 | 449.0 |
| 2021-07-12 04:27:00 | AAPL | Stock | 145.46 | 145.46 | 145.46 | 145.46 | 700.0 |
| 2021-07-12 04:29:00 | AAPL | Stock | 145.44 | 145.44 | 145.44 | 145.44 | 374.0 |
| 2021-07-12 04:32:00 | AAPL | Stock | 145.48 | 145.5 | 145.48 | 145.5 | 368.0 |
| 2021-07-12 04:33:00 | AAPL | Stock | 145.49 | 145.49 | 145.49 | 145.49 | 100.0 |
| 2021-07-12 04:34:00 | AAPL | Stock | 145.5 | 145.5 | 145.5 | 145.5 | 217.0 |
| 2021-07-12 04:35:00 | AAPL | Stock | 145.53 | 145.53 | 145.53 | 145.53 | 667.0 |
| 2021-07-12 04:38:00 | AAPL | Stock | 145.54 | 145.54 | 145.54 | 145.54 | 888.0 |
| 2021-07-12 04:40:00 | AAPL | Stock | 145.52 | 145.54 | 145.52 | 145.54 | 455.0 |
| 2021-07-12 04:45:00 | AAPL | Stock | 145.52 | 145.52 | 145.5 | 145.5 | 678.0 |
| 2021-07-12 04:47:00 | AAPL | Stock | 145.47 | 145.5 | 145.43 | 145.5 | 879.0 |
| 2021-07-12 04:48:00 | AAPL | Stock | 145.5 | 145.5 | 145.5 | 145.5 | 612.0 |
| 2021-07-12 04:50:00 | AAPL | Stock | 145.51 | 145.51 | 145.5 | 145.5 | 1417.0 |
| 2021-07-12 04:51:00 | AAPL | Stock | 145.5 | 145.5 | 145.5 | 145.5 | 167.0 |
| 2021-07-12 04:54:00 | AAPL | Stock | 145.54 | 145.54 | 145.54 | 145.54 | 100.0 |
| 2021-07-12 04:58:00 | AAPL | Stock | 145.53 | 145.53 | 145.53 | 145.53 | 583.0 |
| 2021-07-12 04:59:00 | AAPL | Stock | 145.53 | 145.53 | 145.53 | 145.53 | 200.0 |
| 2021-07-12 05:03:00 | AAPL | Stock | 145.54 | 145.55 | 145.54 | 145.55 | 731.0 |
| 2021-07-12 05:08:00 | AAPL | Stock | 145.52 | 145.52 | 145.5 | 145.5 | 674.0 |
| 2021-07-12 05:09:00 | AAPL | Stock | 145.5 | 145.5 | 145.5 | 145.5 | 100.0 |
| 2021-07-12 05:13:00 | AAPL | Stock | 145.53 | 145.61 | 145.53 | 145.6 | 6609.0 |
| 2021-07-12 05:14:00 | AAPL | Stock | 145.59 | 145.6 | 145.59 | 145.6 | 2366.0 |
| 2021-07-12 05:19:00 | AAPL | Stock | 145.57 | 145.57 | 145.57 | 145.57 | 193.0 |
| 2021-07-12 05:22:00 | AAPL | Stock | 145.52 | 145.52 | 145.52 | 145.52 | 169.0 |
| 2021-07-12 05:23:00 | AAPL | Stock | 145.52 | 145.52 | 145.52 | 145.52 | 200.0 |
| 2021-07-12 05:24:00 | AAPL | Stock | 145.52 | 145.52 | 145.52 | 145.52 | 775.0 |
| 2021-07-12 05:25:00 | AAPL | Stock | 145.51 | 145.51 | 145.5 | 145.5 | 2352.0 |
| 2021-07-12 05:26:00 | AAPL | Stock | 145.51 | 145.52 | 145.51 | 145.51 | 990.0 |
| 2021-07-12 05:28:00 | AAPL | Stock | 145.51 | 145.51 | 145.51 | 145.51 | 100.0 |
| 2021-07-12 05:30:00 | AAPL | Stock | 145.49 | 145.49 | 145.49 | 145.49 | 200.0 |
| 2021-07-12 05:35:00 | AAPL | Stock | 145.55 | 145.55 | 145.55 | 145.55 | 454.0 |
| 2021-07-12 05:36:00 | AAPL | Stock | 145.55 | 145.58 | 145.55 | 145.58 | 898.0 |
| 2021-07-12 05:37:00 | AAPL | Stock | 145.6 | 145.6 | 145.6 | 145.6 | 484.0 |
> showing 50 of 1,318,163 rows — these rows as CSV