PREVIEW / stock_1min / 2020-09-23
file: by_date/stock_1min/2020/2020-09-23.parquet size: 20.3 MB rows: 1,299,583 symbols: 2,120
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-23 04:00:00 | AAPL | Stock | 111.15 | 111.65 | 111.15 | 111.64 | 6237.0 |
| 2020-09-23 04:01:00 | AAPL | Stock | 111.64 | 111.74 | 111.64 | 111.71 | 1947.0 |
| 2020-09-23 04:02:00 | AAPL | Stock | 111.66 | 111.77 | 111.56 | 111.77 | 6401.0 |
| 2020-09-23 04:03:00 | AAPL | Stock | 111.77 | 111.77 | 111.71 | 111.72 | 1523.0 |
| 2020-09-23 04:05:00 | AAPL | Stock | 111.68 | 111.72 | 111.68 | 111.72 | 2711.0 |
| 2020-09-23 04:06:00 | AAPL | Stock | 111.66 | 111.66 | 111.57 | 111.57 | 573.0 |
| 2020-09-23 04:07:00 | AAPL | Stock | 111.6 | 111.6 | 111.5 | 111.5 | 590.0 |
| 2020-09-23 04:08:00 | AAPL | Stock | 111.5 | 111.5 | 111.43 | 111.43 | 1453.0 |
| 2020-09-23 04:09:00 | AAPL | Stock | 111.41 | 111.41 | 111.36 | 111.41 | 1061.0 |
| 2020-09-23 04:10:00 | AAPL | Stock | 111.41 | 111.42 | 111.34 | 111.34 | 646.0 |
| 2020-09-23 04:12:00 | AAPL | Stock | 111.31 | 111.31 | 111.21 | 111.26 | 630.0 |
| 2020-09-23 04:13:00 | AAPL | Stock | 111.26 | 111.26 | 111.25 | 111.25 | 200.0 |
| 2020-09-23 04:15:00 | AAPL | Stock | 111.49 | 111.49 | 111.49 | 111.49 | 100.0 |
| 2020-09-23 04:16:00 | AAPL | Stock | 111.5 | 111.5 | 111.49 | 111.49 | 575.0 |
| 2020-09-23 04:17:00 | AAPL | Stock | 111.51 | 111.55 | 111.48 | 111.55 | 3224.0 |
| 2020-09-23 04:18:00 | AAPL | Stock | 111.55 | 111.55 | 111.55 | 111.55 | 430.0 |
| 2020-09-23 04:21:00 | AAPL | Stock | 111.5 | 111.5 | 111.5 | 111.5 | 100.0 |
| 2020-09-23 04:22:00 | AAPL | Stock | 111.6 | 111.6 | 111.5 | 111.5 | 865.0 |
| 2020-09-23 04:23:00 | AAPL | Stock | 111.55 | 111.55 | 111.5 | 111.5 | 390.0 |
| 2020-09-23 04:24:00 | AAPL | Stock | 111.55 | 111.55 | 111.55 | 111.55 | 325.0 |
| 2020-09-23 04:25:00 | AAPL | Stock | 111.56 | 111.56 | 111.48 | 111.48 | 983.0 |
| 2020-09-23 04:27:00 | AAPL | Stock | 111.55 | 111.55 | 111.55 | 111.55 | 286.0 |
| 2020-09-23 04:28:00 | AAPL | Stock | 111.55 | 111.59 | 111.55 | 111.59 | 397.0 |
| 2020-09-23 04:29:00 | AAPL | Stock | 111.59 | 111.62 | 111.59 | 111.62 | 2425.0 |
| 2020-09-23 04:30:00 | AAPL | Stock | 111.72 | 111.77 | 111.72 | 111.77 | 1151.0 |
| 2020-09-23 04:31:00 | AAPL | Stock | 111.8 | 111.83 | 111.8 | 111.83 | 1700.0 |
| 2020-09-23 04:33:00 | AAPL | Stock | 111.82 | 111.89 | 111.82 | 111.89 | 281.0 |
| 2020-09-23 04:34:00 | AAPL | Stock | 111.89 | 111.94 | 111.89 | 111.9 | 1761.0 |
| 2020-09-23 04:35:00 | AAPL | Stock | 111.9 | 111.97 | 111.9 | 111.97 | 442.0 |
| 2020-09-23 04:36:00 | AAPL | Stock | 111.97 | 111.97 | 111.97 | 111.97 | 1899.0 |
| 2020-09-23 04:37:00 | AAPL | Stock | 111.97 | 111.97 | 111.97 | 111.97 | 100.0 |
| 2020-09-23 04:38:00 | AAPL | Stock | 111.96 | 111.96 | 111.96 | 111.96 | 168.0 |
| 2020-09-23 04:39:00 | AAPL | Stock | 111.94 | 111.98 | 111.94 | 111.97 | 4306.0 |
| 2020-09-23 04:40:00 | AAPL | Stock | 111.95 | 111.99 | 111.95 | 111.95 | 500.0 |
| 2020-09-23 04:42:00 | AAPL | Stock | 111.95 | 111.95 | 111.95 | 111.95 | 190.0 |
| 2020-09-23 04:43:00 | AAPL | Stock | 111.94 | 111.94 | 111.94 | 111.94 | 100.0 |
| 2020-09-23 04:44:00 | AAPL | Stock | 111.94 | 112.0 | 111.94 | 112.0 | 3106.0 |
| 2020-09-23 04:45:00 | AAPL | Stock | 112.06 | 112.06 | 112.03 | 112.03 | 200.0 |
| 2020-09-23 04:46:00 | AAPL | Stock | 112.07 | 112.2 | 112.07 | 112.2 | 1902.0 |
| 2020-09-23 04:47:00 | AAPL | Stock | 112.15 | 112.19 | 112.12 | 112.12 | 2203.0 |
| 2020-09-23 04:48:00 | AAPL | Stock | 112.15 | 112.19 | 112.15 | 112.15 | 2945.0 |
| 2020-09-23 04:49:00 | AAPL | Stock | 112.15 | 112.15 | 112.1 | 112.1 | 641.0 |
| 2020-09-23 04:50:00 | AAPL | Stock | 112.12 | 112.12 | 112.07 | 112.07 | 200.0 |
| 2020-09-23 04:51:00 | AAPL | Stock | 112.07 | 112.07 | 112.07 | 112.07 | 100.0 |
| 2020-09-23 04:52:00 | AAPL | Stock | 112.0 | 112.0 | 112.0 | 112.0 | 174.0 |
| 2020-09-23 04:53:00 | AAPL | Stock | 112.0 | 112.03 | 112.0 | 112.03 | 500.0 |
| 2020-09-23 04:56:00 | AAPL | Stock | 112.06 | 112.06 | 112.06 | 112.06 | 109.0 |
| 2020-09-23 04:58:00 | AAPL | Stock | 112.14 | 112.19 | 112.14 | 112.19 | 2818.0 |
| 2020-09-23 04:59:00 | AAPL | Stock | 112.2 | 112.2 | 112.19 | 112.19 | 485.0 |
| 2020-09-23 05:00:00 | AAPL | Stock | 112.17 | 112.17 | 112.17 | 112.17 | 1431.0 |
> showing 50 of 1,299,583 rows — these rows as CSV