PREVIEW / stock_1min / 2021-09-23
file: by_date/stock_1min/2021/2021-09-23.parquet size: 23.9 MB rows: 1,356,936 symbols: 2,332
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-09-23 04:00:00 | AAPL | Stock | 146.71 | 147.0 | 146.71 | 147.0 | 1616.0 |
| 2021-09-23 04:01:00 | AAPL | Stock | 146.9 | 147.0 | 146.9 | 146.91 | 400.0 |
| 2021-09-23 04:03:00 | AAPL | Stock | 146.93 | 146.93 | 146.93 | 146.93 | 100.0 |
| 2021-09-23 04:04:00 | AAPL | Stock | 146.91 | 146.93 | 146.89 | 146.92 | 1116.0 |
| 2021-09-23 04:05:00 | AAPL | Stock | 146.9 | 146.93 | 146.9 | 146.93 | 650.0 |
| 2021-09-23 04:06:00 | AAPL | Stock | 146.93 | 146.93 | 146.93 | 146.93 | 1330.0 |
| 2021-09-23 04:07:00 | AAPL | Stock | 146.98 | 147.07 | 146.98 | 147.07 | 1626.0 |
| 2021-09-23 04:09:00 | AAPL | Stock | 147.06 | 147.1 | 147.01 | 147.1 | 7568.0 |
| 2021-09-23 04:10:00 | AAPL | Stock | 147.0 | 147.0 | 146.98 | 146.98 | 1834.0 |
| 2021-09-23 04:11:00 | AAPL | Stock | 146.95 | 146.95 | 146.95 | 146.95 | 275.0 |
| 2021-09-23 04:12:00 | AAPL | Stock | 146.91 | 146.91 | 146.91 | 146.91 | 840.0 |
| 2021-09-23 04:13:00 | AAPL | Stock | 146.98 | 146.98 | 146.94 | 146.94 | 220.0 |
| 2021-09-23 04:15:00 | AAPL | Stock | 146.92 | 146.92 | 146.91 | 146.91 | 1106.0 |
| 2021-09-23 04:17:00 | AAPL | Stock | 146.91 | 146.98 | 146.91 | 146.98 | 1688.0 |
| 2021-09-23 04:18:00 | AAPL | Stock | 146.98 | 146.99 | 146.98 | 146.99 | 891.0 |
| 2021-09-23 04:19:00 | AAPL | Stock | 147.0 | 147.0 | 146.98 | 146.98 | 600.0 |
| 2021-09-23 04:21:00 | AAPL | Stock | 146.98 | 146.98 | 146.94 | 146.94 | 1800.0 |
| 2021-09-23 04:25:00 | AAPL | Stock | 146.92 | 146.92 | 146.92 | 146.92 | 489.0 |
| 2021-09-23 04:26:00 | AAPL | Stock | 146.93 | 146.93 | 146.93 | 146.93 | 813.0 |
| 2021-09-23 04:27:00 | AAPL | Stock | 146.96 | 146.96 | 146.96 | 146.96 | 100.0 |
| 2021-09-23 04:28:00 | AAPL | Stock | 146.97 | 146.97 | 146.97 | 146.97 | 487.0 |
| 2021-09-23 04:36:00 | AAPL | Stock | 146.97 | 146.98 | 146.97 | 146.98 | 2927.0 |
| 2021-09-23 04:37:00 | AAPL | Stock | 146.98 | 146.99 | 146.98 | 146.99 | 411.0 |
| 2021-09-23 04:38:00 | AAPL | Stock | 146.98 | 146.98 | 146.98 | 146.98 | 200.0 |
| 2021-09-23 04:39:00 | AAPL | Stock | 146.98 | 147.0 | 146.98 | 147.0 | 1351.0 |
| 2021-09-23 04:41:00 | AAPL | Stock | 147.08 | 147.09 | 147.08 | 147.09 | 852.0 |
| 2021-09-23 04:42:00 | AAPL | Stock | 147.07 | 147.07 | 147.07 | 147.07 | 255.0 |
| 2021-09-23 04:44:00 | AAPL | Stock | 147.06 | 147.06 | 147.06 | 147.06 | 1174.0 |
| 2021-09-23 04:45:00 | AAPL | Stock | 147.06 | 147.06 | 147.06 | 147.06 | 100.0 |
| 2021-09-23 04:48:00 | AAPL | Stock | 147.1 | 147.1 | 147.1 | 147.1 | 300.0 |
| 2021-09-23 04:52:00 | AAPL | Stock | 147.1 | 147.1 | 147.1 | 147.1 | 350.0 |
| 2021-09-23 04:53:00 | AAPL | Stock | 147.12 | 147.15 | 147.12 | 147.15 | 600.0 |
| 2021-09-23 04:55:00 | AAPL | Stock | 147.25 | 147.25 | 147.21 | 147.21 | 474.0 |
| 2021-09-23 05:00:00 | AAPL | Stock | 147.21 | 147.21 | 147.21 | 147.21 | 218.0 |
| 2021-09-23 05:07:00 | AAPL | Stock | 147.29 | 147.29 | 147.29 | 147.29 | 100.0 |
| 2021-09-23 05:08:00 | AAPL | Stock | 147.3 | 147.42 | 147.25 | 147.42 | 3780.0 |
| 2021-09-23 05:09:00 | AAPL | Stock | 147.4 | 147.4 | 147.12 | 147.12 | 2655.0 |
| 2021-09-23 05:11:00 | AAPL | Stock | 147.3 | 147.38 | 147.3 | 147.37 | 1208.0 |
| 2021-09-23 05:12:00 | AAPL | Stock | 147.38 | 147.38 | 147.38 | 147.38 | 2352.0 |
| 2021-09-23 05:13:00 | AAPL | Stock | 147.38 | 147.38 | 147.38 | 147.38 | 842.0 |
| 2021-09-23 05:15:00 | AAPL | Stock | 147.59 | 147.68 | 147.46 | 147.53 | 3045.0 |
| 2021-09-23 05:18:00 | AAPL | Stock | 147.5 | 147.5 | 147.5 | 147.5 | 100.0 |
| 2021-09-23 05:21:00 | AAPL | Stock | 147.56 | 147.56 | 147.56 | 147.56 | 100.0 |
| 2021-09-23 05:22:00 | AAPL | Stock | 147.57 | 147.57 | 147.56 | 147.56 | 2428.0 |
| 2021-09-23 05:24:00 | AAPL | Stock | 147.53 | 147.54 | 147.45 | 147.45 | 1765.0 |
| 2021-09-23 05:26:00 | AAPL | Stock | 147.4 | 147.4 | 147.4 | 147.4 | 275.0 |
| 2021-09-23 05:27:00 | AAPL | Stock | 147.44 | 147.44 | 147.44 | 147.44 | 200.0 |
| 2021-09-23 05:30:00 | AAPL | Stock | 147.5 | 147.5 | 147.5 | 147.5 | 1171.0 |
| 2021-09-23 05:31:00 | AAPL | Stock | 147.51 | 147.51 | 147.51 | 147.51 | 6000.0 |
| 2021-09-23 05:32:00 | AAPL | Stock | 147.51 | 147.57 | 147.51 | 147.57 | 640.0 |
> showing 50 of 1,356,936 rows — these rows as CSV