PREVIEW / stock_1min / 2021-09-30
file: by_date/stock_1min/2021/2021-09-30.parquet size: 24.0 MB rows: 1,398,150 symbols: 2,348
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-30 04:00:00 | AAPL | Stock | 144.0 | 144.0 | 144.0 | 144.0 | 367.0 |
| 2021-09-30 04:01:00 | AAPL | Stock | 144.08 | 144.08 | 144.08 | 144.08 | 400.0 |
| 2021-09-30 04:02:00 | AAPL | Stock | 144.08 | 144.08 | 144.0 | 144.0 | 3084.0 |
| 2021-09-30 04:03:00 | AAPL | Stock | 144.01 | 144.07 | 144.01 | 144.05 | 4943.0 |
| 2021-09-30 04:04:00 | AAPL | Stock | 144.06 | 144.07 | 144.06 | 144.07 | 419.0 |
| 2021-09-30 04:05:00 | AAPL | Stock | 144.06 | 144.06 | 144.06 | 144.06 | 200.0 |
| 2021-09-30 04:08:00 | AAPL | Stock | 144.04 | 144.06 | 144.04 | 144.06 | 854.0 |
| 2021-09-30 04:09:00 | AAPL | Stock | 144.06 | 144.1 | 144.06 | 144.1 | 2225.0 |
| 2021-09-30 04:12:00 | AAPL | Stock | 144.11 | 144.13 | 144.11 | 144.11 | 1695.0 |
| 2021-09-30 04:13:00 | AAPL | Stock | 144.08 | 144.08 | 144.08 | 144.08 | 100.0 |
| 2021-09-30 04:14:00 | AAPL | Stock | 144.09 | 144.09 | 144.01 | 144.01 | 240.0 |
| 2021-09-30 04:15:00 | AAPL | Stock | 143.98 | 143.98 | 143.98 | 143.98 | 397.0 |
| 2021-09-30 04:17:00 | AAPL | Stock | 143.83 | 143.83 | 143.83 | 143.83 | 139.0 |
| 2021-09-30 04:18:00 | AAPL | Stock | 143.83 | 143.83 | 143.81 | 143.81 | 409.0 |
| 2021-09-30 04:19:00 | AAPL | Stock | 143.89 | 143.89 | 143.89 | 143.89 | 416.0 |
| 2021-09-30 04:20:00 | AAPL | Stock | 143.77 | 143.82 | 143.77 | 143.82 | 559.0 |
| 2021-09-30 04:22:00 | AAPL | Stock | 143.88 | 143.9 | 143.88 | 143.9 | 798.0 |
| 2021-09-30 04:29:00 | AAPL | Stock | 143.95 | 143.95 | 143.95 | 143.95 | 200.0 |
| 2021-09-30 04:41:00 | AAPL | Stock | 143.8 | 143.8 | 143.8 | 143.8 | 510.0 |
| 2021-09-30 04:54:00 | AAPL | Stock | 143.9 | 143.9 | 143.9 | 143.9 | 100.0 |
| 2021-09-30 04:59:00 | AAPL | Stock | 143.92 | 143.92 | 143.92 | 143.92 | 100.0 |
| 2021-09-30 05:00:00 | AAPL | Stock | 143.98 | 143.98 | 143.98 | 143.98 | 126.0 |
| 2021-09-30 05:02:00 | AAPL | Stock | 143.95 | 143.95 | 143.95 | 143.95 | 103.0 |
| 2021-09-30 05:15:00 | AAPL | Stock | 143.89 | 143.89 | 143.89 | 143.89 | 129.0 |
| 2021-09-30 05:22:00 | AAPL | Stock | 143.87 | 143.87 | 143.87 | 143.87 | 149.0 |
| 2021-09-30 05:26:00 | AAPL | Stock | 143.86 | 143.86 | 143.86 | 143.86 | 185.0 |
| 2021-09-30 05:29:00 | AAPL | Stock | 143.72 | 143.75 | 143.72 | 143.75 | 1608.0 |
| 2021-09-30 05:42:00 | AAPL | Stock | 143.61 | 143.61 | 143.61 | 143.61 | 100.0 |
| 2021-09-30 05:43:00 | AAPL | Stock | 143.67 | 143.7 | 143.61 | 143.7 | 4078.0 |
| 2021-09-30 05:45:00 | AAPL | Stock | 143.55 | 143.55 | 143.51 | 143.51 | 509.0 |
| 2021-09-30 05:51:00 | AAPL | Stock | 143.51 | 143.51 | 143.51 | 143.51 | 299.0 |
| 2021-09-30 05:55:00 | AAPL | Stock | 143.7 | 143.7 | 143.7 | 143.7 | 350.0 |
| 2021-09-30 06:10:00 | AAPL | Stock | 143.96 | 143.97 | 143.96 | 143.97 | 1400.0 |
| 2021-09-30 06:12:00 | AAPL | Stock | 143.95 | 143.98 | 143.95 | 143.98 | 327.0 |
| 2021-09-30 06:17:00 | AAPL | Stock | 143.79 | 143.79 | 143.78 | 143.78 | 1005.0 |
| 2021-09-30 06:24:00 | AAPL | Stock | 143.51 | 143.51 | 143.37 | 143.37 | 1650.0 |
| 2021-09-30 06:36:00 | AAPL | Stock | 143.55 | 143.55 | 143.55 | 143.55 | 147.0 |
| 2021-09-30 06:45:00 | AAPL | Stock | 143.61 | 143.61 | 143.61 | 143.61 | 326.0 |
| 2021-09-30 06:55:00 | AAPL | Stock | 143.62 | 143.62 | 143.62 | 143.62 | 300.0 |
| 2021-09-30 06:56:00 | AAPL | Stock | 143.62 | 143.62 | 143.62 | 143.62 | 100.0 |
| 2021-09-30 06:58:00 | AAPL | Stock | 143.61 | 143.61 | 143.61 | 143.61 | 560.0 |
| 2021-09-30 06:59:00 | AAPL | Stock | 143.47 | 143.47 | 143.46 | 143.46 | 200.0 |
| 2021-09-30 07:00:00 | AAPL | Stock | 143.57 | 143.6 | 143.52 | 143.52 | 5938.0 |
| 2021-09-30 07:01:00 | AAPL | Stock | 143.52 | 143.52 | 143.52 | 143.52 | 100.0 |
| 2021-09-30 07:02:00 | AAPL | Stock | 143.51 | 143.51 | 143.48 | 143.48 | 1089.0 |
| 2021-09-30 07:03:00 | AAPL | Stock | 143.45 | 143.45 | 143.41 | 143.41 | 2812.0 |
| 2021-09-30 07:04:00 | AAPL | Stock | 143.41 | 143.41 | 143.4 | 143.4 | 1300.0 |
| 2021-09-30 07:05:00 | AAPL | Stock | 143.4 | 143.44 | 143.4 | 143.44 | 1413.0 |
| 2021-09-30 07:06:00 | AAPL | Stock | 143.5 | 143.5 | 143.5 | 143.5 | 258.0 |
| 2021-09-30 07:07:00 | AAPL | Stock | 143.53 | 143.55 | 143.53 | 143.55 | 400.0 |
> showing 50 of 1,398,150 rows — these rows as CSV