PREVIEW / stock_1min / 2020-10-23
file: by_date/stock_1min/2020/2020-10-23.parquet size: 18.8 MB rows: 1,170,089 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-10-23 04:00:00 | AAPL | Stock | 116.25 | 116.35 | 116.25 | 116.35 | 5510.0 |
| 2020-10-23 04:01:00 | AAPL | Stock | 116.35 | 116.49 | 116.35 | 116.35 | 6762.0 |
| 2020-10-23 04:04:00 | AAPL | Stock | 116.36 | 116.38 | 116.36 | 116.38 | 990.0 |
| 2020-10-23 04:05:00 | AAPL | Stock | 116.41 | 116.48 | 116.39 | 116.48 | 825.0 |
| 2020-10-23 04:06:00 | AAPL | Stock | 116.41 | 116.41 | 116.4 | 116.4 | 2170.0 |
| 2020-10-23 04:08:00 | AAPL | Stock | 116.39 | 116.39 | 116.35 | 116.35 | 1953.0 |
| 2020-10-23 04:09:00 | AAPL | Stock | 116.35 | 116.35 | 116.35 | 116.35 | 1626.0 |
| 2020-10-23 04:10:00 | AAPL | Stock | 116.36 | 116.36 | 116.36 | 116.36 | 159.0 |
| 2020-10-23 04:11:00 | AAPL | Stock | 116.35 | 116.36 | 116.35 | 116.36 | 400.0 |
| 2020-10-23 04:12:00 | AAPL | Stock | 116.4 | 116.52 | 116.4 | 116.52 | 374.0 |
| 2020-10-23 04:13:00 | AAPL | Stock | 116.5 | 116.6 | 116.5 | 116.6 | 574.0 |
| 2020-10-23 04:14:00 | AAPL | Stock | 116.59 | 116.6 | 116.59 | 116.6 | 406.0 |
| 2020-10-23 04:15:00 | AAPL | Stock | 116.65 | 116.65 | 116.65 | 116.65 | 158.0 |
| 2020-10-23 04:16:00 | AAPL | Stock | 116.65 | 116.65 | 116.6 | 116.6 | 1720.0 |
| 2020-10-23 04:17:00 | AAPL | Stock | 116.61 | 116.63 | 116.6 | 116.6 | 5126.0 |
| 2020-10-23 04:18:00 | AAPL | Stock | 116.58 | 116.6 | 116.53 | 116.53 | 5858.0 |
| 2020-10-23 04:19:00 | AAPL | Stock | 116.49 | 116.49 | 116.49 | 116.49 | 290.0 |
| 2020-10-23 04:20:00 | AAPL | Stock | 116.5 | 116.53 | 116.5 | 116.5 | 820.0 |
| 2020-10-23 04:21:00 | AAPL | Stock | 116.5 | 116.5 | 116.5 | 116.5 | 724.0 |
| 2020-10-23 04:23:00 | AAPL | Stock | 116.5 | 116.5 | 116.5 | 116.5 | 883.0 |
| 2020-10-23 04:24:00 | AAPL | Stock | 116.56 | 116.56 | 116.56 | 116.56 | 105.0 |
| 2020-10-23 04:27:00 | AAPL | Stock | 116.56 | 116.56 | 116.56 | 116.56 | 331.0 |
| 2020-10-23 04:28:00 | AAPL | Stock | 116.5 | 116.5 | 116.5 | 116.5 | 139.0 |
| 2020-10-23 04:29:00 | AAPL | Stock | 116.54 | 116.56 | 116.54 | 116.56 | 648.0 |
| 2020-10-23 04:30:00 | AAPL | Stock | 116.57 | 116.59 | 116.56 | 116.56 | 2044.0 |
| 2020-10-23 04:31:00 | AAPL | Stock | 116.57 | 116.59 | 116.57 | 116.59 | 2858.0 |
| 2020-10-23 04:33:00 | AAPL | Stock | 116.51 | 116.57 | 116.51 | 116.51 | 2206.0 |
| 2020-10-23 04:34:00 | AAPL | Stock | 116.51 | 116.51 | 116.51 | 116.51 | 500.0 |
| 2020-10-23 04:35:00 | AAPL | Stock | 116.51 | 116.51 | 116.35 | 116.35 | 1806.0 |
| 2020-10-23 04:37:00 | AAPL | Stock | 116.41 | 116.41 | 116.33 | 116.33 | 900.0 |
| 2020-10-23 04:38:00 | AAPL | Stock | 116.46 | 116.5 | 116.46 | 116.5 | 758.0 |
| 2020-10-23 04:39:00 | AAPL | Stock | 116.37 | 116.37 | 116.35 | 116.35 | 920.0 |
| 2020-10-23 04:40:00 | AAPL | Stock | 116.44 | 116.44 | 116.44 | 116.44 | 158.0 |
| 2020-10-23 04:41:00 | AAPL | Stock | 116.46 | 116.46 | 116.45 | 116.45 | 200.0 |
| 2020-10-23 04:42:00 | AAPL | Stock | 116.46 | 116.46 | 116.46 | 116.46 | 181.0 |
| 2020-10-23 04:43:00 | AAPL | Stock | 116.48 | 116.48 | 116.45 | 116.45 | 300.0 |
| 2020-10-23 04:44:00 | AAPL | Stock | 116.41 | 116.41 | 116.41 | 116.41 | 340.0 |
| 2020-10-23 04:45:00 | AAPL | Stock | 116.36 | 116.36 | 116.36 | 116.36 | 910.0 |
| 2020-10-23 04:46:00 | AAPL | Stock | 116.28 | 116.3 | 116.21 | 116.21 | 1700.0 |
| 2020-10-23 04:47:00 | AAPL | Stock | 116.22 | 116.22 | 116.16 | 116.16 | 8311.0 |
| 2020-10-23 04:49:00 | AAPL | Stock | 116.19 | 116.25 | 116.19 | 116.25 | 850.0 |
| 2020-10-23 04:51:00 | AAPL | Stock | 116.34 | 116.37 | 116.34 | 116.37 | 573.0 |
| 2020-10-23 04:52:00 | AAPL | Stock | 116.38 | 116.38 | 116.38 | 116.38 | 100.0 |
| 2020-10-23 04:53:00 | AAPL | Stock | 116.21 | 116.22 | 116.21 | 116.22 | 995.0 |
| 2020-10-23 04:56:00 | AAPL | Stock | 116.2 | 116.2 | 116.2 | 116.2 | 200.0 |
| 2020-10-23 04:58:00 | AAPL | Stock | 116.21 | 116.29 | 116.1 | 116.29 | 4854.0 |
| 2020-10-23 05:02:00 | AAPL | Stock | 116.17 | 116.17 | 116.17 | 116.17 | 100.0 |
| 2020-10-23 05:04:00 | AAPL | Stock | 116.2 | 116.2 | 116.05 | 116.14 | 3282.0 |
| 2020-10-23 05:05:00 | AAPL | Stock | 116.14 | 116.14 | 116.14 | 116.14 | 200.0 |
| 2020-10-23 05:07:00 | AAPL | Stock | 116.2 | 116.21 | 116.2 | 116.21 | 308.0 |
> showing 50 of 1,170,089 rows — these rows as CSV