PREVIEW / stock_1min / 2020-09-08
file: by_date/stock_1min/2020/2020-09-08.parquet size: 20.6 MB rows: 1,322,903 symbols: 2,098
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-09-08 04:00:00 | AAPL | Stock | 120.36 | 120.4 | 120.1 | 120.1 | 9398.0 |
| 2020-09-08 04:01:00 | AAPL | Stock | 120.02 | 120.02 | 119.9 | 119.9 | 6813.0 |
| 2020-09-08 04:02:00 | AAPL | Stock | 119.98 | 120.0 | 119.71 | 119.8 | 1596.0 |
| 2020-09-08 04:03:00 | AAPL | Stock | 119.73 | 119.97 | 119.71 | 119.86 | 3225.0 |
| 2020-09-08 04:04:00 | AAPL | Stock | 119.86 | 119.97 | 119.86 | 119.87 | 1823.0 |
| 2020-09-08 04:05:00 | AAPL | Stock | 119.84 | 119.86 | 119.54 | 119.54 | 3480.0 |
| 2020-09-08 04:06:00 | AAPL | Stock | 119.61 | 119.7 | 119.61 | 119.66 | 830.0 |
| 2020-09-08 04:07:00 | AAPL | Stock | 119.57 | 119.57 | 119.48 | 119.48 | 834.0 |
| 2020-09-08 04:08:00 | AAPL | Stock | 119.33 | 119.34 | 119.2 | 119.34 | 1068.0 |
| 2020-09-08 04:09:00 | AAPL | Stock | 119.3 | 119.48 | 119.3 | 119.47 | 3260.0 |
| 2020-09-08 04:10:00 | AAPL | Stock | 119.28 | 119.31 | 119.03 | 119.03 | 4231.0 |
| 2020-09-08 04:11:00 | AAPL | Stock | 119.12 | 119.12 | 118.99 | 119.0 | 5050.0 |
| 2020-09-08 04:12:00 | AAPL | Stock | 118.98 | 119.14 | 118.93 | 119.06 | 5653.0 |
| 2020-09-08 04:13:00 | AAPL | Stock | 119.06 | 119.06 | 118.6 | 118.78 | 6062.0 |
| 2020-09-08 04:14:00 | AAPL | Stock | 118.64 | 118.64 | 118.12 | 118.38 | 7704.0 |
| 2020-09-08 04:15:00 | AAPL | Stock | 118.16 | 118.28 | 118.14 | 118.16 | 4315.0 |
| 2020-09-08 04:16:00 | AAPL | Stock | 118.15 | 118.27 | 118.0 | 118.0 | 6885.0 |
| 2020-09-08 04:17:00 | AAPL | Stock | 118.0 | 118.0 | 117.6 | 117.7 | 2516.0 |
| 2020-09-08 04:18:00 | AAPL | Stock | 117.7 | 117.7 | 117.53 | 117.56 | 9359.0 |
| 2020-09-08 04:19:00 | AAPL | Stock | 117.42 | 117.56 | 117.17 | 117.25 | 4516.0 |
| 2020-09-08 04:20:00 | AAPL | Stock | 117.25 | 117.6 | 117.2 | 117.37 | 5360.0 |
| 2020-09-08 04:21:00 | AAPL | Stock | 117.37 | 117.7 | 117.2 | 117.69 | 3284.0 |
| 2020-09-08 04:22:00 | AAPL | Stock | 117.63 | 117.95 | 117.62 | 117.85 | 2542.0 |
| 2020-09-08 04:23:00 | AAPL | Stock | 117.85 | 117.89 | 117.32 | 117.32 | 4633.0 |
| 2020-09-08 04:24:00 | AAPL | Stock | 117.35 | 117.35 | 117.28 | 117.28 | 2449.0 |
| 2020-09-08 04:25:00 | AAPL | Stock | 117.3 | 117.46 | 117.3 | 117.46 | 713.0 |
| 2020-09-08 04:26:00 | AAPL | Stock | 117.4 | 117.4 | 117.21 | 117.21 | 5178.0 |
| 2020-09-08 04:27:00 | AAPL | Stock | 117.11 | 117.19 | 116.55 | 116.55 | 10189.0 |
| 2020-09-08 04:28:00 | AAPL | Stock | 116.58 | 117.01 | 116.57 | 116.9 | 4942.0 |
| 2020-09-08 04:29:00 | AAPL | Stock | 117.01 | 117.5 | 116.9 | 117.45 | 3719.0 |
| 2020-09-08 04:30:00 | AAPL | Stock | 117.49 | 117.49 | 117.25 | 117.42 | 1453.0 |
| 2020-09-08 04:31:00 | AAPL | Stock | 117.4 | 117.43 | 117.25 | 117.25 | 1455.0 |
| 2020-09-08 04:34:00 | AAPL | Stock | 117.36 | 117.37 | 117.23 | 117.32 | 710.0 |
| 2020-09-08 04:35:00 | AAPL | Stock | 117.31 | 117.31 | 117.31 | 117.31 | 957.0 |
| 2020-09-08 04:36:00 | AAPL | Stock | 117.32 | 117.89 | 117.15 | 117.3 | 1362.0 |
| 2020-09-08 04:37:00 | AAPL | Stock | 117.11 | 117.11 | 116.83 | 117.0 | 1447.0 |
| 2020-09-08 04:38:00 | AAPL | Stock | 117.3 | 117.5 | 117.16 | 117.2 | 1120.0 |
| 2020-09-08 04:39:00 | AAPL | Stock | 117.2 | 117.99 | 117.2 | 117.99 | 4276.0 |
| 2020-09-08 04:40:00 | AAPL | Stock | 117.95 | 117.95 | 117.7 | 117.7 | 3214.0 |
| 2020-09-08 04:41:00 | AAPL | Stock | 117.52 | 117.52 | 117.5 | 117.5 | 439.0 |
| 2020-09-08 04:42:00 | AAPL | Stock | 117.65 | 117.82 | 117.51 | 117.75 | 5942.0 |
| 2020-09-08 04:43:00 | AAPL | Stock | 117.75 | 117.75 | 117.5 | 117.5 | 3053.0 |
| 2020-09-08 04:44:00 | AAPL | Stock | 117.47 | 117.5 | 117.15 | 117.17 | 1400.0 |
| 2020-09-08 04:45:00 | AAPL | Stock | 117.38 | 117.49 | 116.53 | 117.0 | 4400.0 |
| 2020-09-08 04:46:00 | AAPL | Stock | 116.85 | 117.2 | 116.85 | 116.9 | 2612.0 |
| 2020-09-08 04:47:00 | AAPL | Stock | 116.93 | 117.14 | 116.81 | 116.81 | 4252.0 |
| 2020-09-08 04:48:00 | AAPL | Stock | 117.0 | 117.36 | 117.0 | 117.36 | 9452.0 |
| 2020-09-08 04:49:00 | AAPL | Stock | 117.24 | 117.24 | 117.24 | 117.24 | 838.0 |
| 2020-09-08 04:50:00 | AAPL | Stock | 117.22 | 117.22 | 117.0 | 117.1 | 3575.0 |
| 2020-09-08 04:51:00 | AAPL | Stock | 117.03 | 117.1 | 117.01 | 117.09 | 992.0 |
> showing 50 of 1,322,903 rows — these rows as CSV