PREVIEW / stock_1min / 2021-09-17
file: by_date/stock_1min/2021/2021-09-17.parquet size: 24.0 MB rows: 1,419,216 symbols: 2,314
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-17 04:00:00 | AAPL | Stock | 149.0 | 149.0 | 148.71 | 148.71 | 1420.0 |
| 2021-09-17 04:01:00 | AAPL | Stock | 148.9 | 148.94 | 148.9 | 148.94 | 220.0 |
| 2021-09-17 04:02:00 | AAPL | Stock | 149.0 | 149.02 | 149.0 | 149.0 | 2072.0 |
| 2021-09-17 04:03:00 | AAPL | Stock | 149.1 | 149.1 | 149.0 | 149.0 | 713.0 |
| 2021-09-17 04:04:00 | AAPL | Stock | 148.99 | 148.99 | 148.99 | 148.99 | 499.0 |
| 2021-09-17 04:06:00 | AAPL | Stock | 148.97 | 148.97 | 148.97 | 148.97 | 400.0 |
| 2021-09-17 04:07:00 | AAPL | Stock | 148.9 | 148.9 | 148.89 | 148.89 | 400.0 |
| 2021-09-17 04:10:00 | AAPL | Stock | 148.9 | 148.9 | 148.9 | 148.9 | 378.0 |
| 2021-09-17 04:11:00 | AAPL | Stock | 148.91 | 148.91 | 148.91 | 148.91 | 350.0 |
| 2021-09-17 04:12:00 | AAPL | Stock | 148.96 | 148.96 | 148.95 | 148.95 | 243.0 |
| 2021-09-17 04:16:00 | AAPL | Stock | 148.81 | 148.81 | 148.81 | 148.81 | 500.0 |
| 2021-09-17 04:17:00 | AAPL | Stock | 148.81 | 148.81 | 148.81 | 148.81 | 205.0 |
| 2021-09-17 04:18:00 | AAPL | Stock | 148.81 | 148.81 | 148.81 | 148.81 | 392.0 |
| 2021-09-17 04:23:00 | AAPL | Stock | 148.84 | 148.84 | 148.84 | 148.84 | 100.0 |
| 2021-09-17 04:24:00 | AAPL | Stock | 148.89 | 148.89 | 148.89 | 148.89 | 200.0 |
| 2021-09-17 04:25:00 | AAPL | Stock | 148.86 | 148.86 | 148.86 | 148.86 | 600.0 |
| 2021-09-17 04:33:00 | AAPL | Stock | 148.82 | 148.82 | 148.82 | 148.82 | 699.0 |
| 2021-09-17 04:34:00 | AAPL | Stock | 148.79 | 148.79 | 148.79 | 148.79 | 350.0 |
| 2021-09-17 04:39:00 | AAPL | Stock | 148.76 | 148.76 | 148.75 | 148.75 | 409.0 |
| 2021-09-17 04:43:00 | AAPL | Stock | 148.77 | 148.78 | 148.77 | 148.78 | 850.0 |
| 2021-09-17 04:58:00 | AAPL | Stock | 148.83 | 148.83 | 148.83 | 148.83 | 191.0 |
| 2021-09-17 05:04:00 | AAPL | Stock | 148.84 | 148.84 | 148.84 | 148.84 | 150.0 |
| 2021-09-17 05:08:00 | AAPL | Stock | 148.78 | 148.78 | 148.78 | 148.78 | 147.0 |
| 2021-09-17 05:15:00 | AAPL | Stock | 148.6 | 148.6 | 148.6 | 148.6 | 386.0 |
| 2021-09-17 05:17:00 | AAPL | Stock | 148.61 | 148.62 | 148.61 | 148.62 | 754.0 |
| 2021-09-17 05:19:00 | AAPL | Stock | 148.62 | 148.62 | 148.62 | 148.62 | 598.0 |
| 2021-09-17 05:21:00 | AAPL | Stock | 148.61 | 148.62 | 148.61 | 148.62 | 204.0 |
| 2021-09-17 05:30:00 | AAPL | Stock | 148.6 | 148.6 | 148.6 | 148.6 | 110.0 |
| 2021-09-17 05:42:00 | AAPL | Stock | 148.59 | 148.59 | 148.59 | 148.59 | 100.0 |
| 2021-09-17 05:43:00 | AAPL | Stock | 148.59 | 148.59 | 148.59 | 148.59 | 713.0 |
| 2021-09-17 05:48:00 | AAPL | Stock | 148.45 | 148.45 | 148.32 | 148.32 | 537.0 |
| 2021-09-17 05:51:00 | AAPL | Stock | 148.37 | 148.37 | 148.37 | 148.37 | 499.0 |
| 2021-09-17 05:54:00 | AAPL | Stock | 148.37 | 148.37 | 148.37 | 148.37 | 990.0 |
| 2021-09-17 05:55:00 | AAPL | Stock | 148.24 | 148.24 | 148.24 | 148.24 | 383.0 |
| 2021-09-17 05:56:00 | AAPL | Stock | 148.26 | 148.26 | 148.26 | 148.26 | 100.0 |
| 2021-09-17 05:58:00 | AAPL | Stock | 148.29 | 148.29 | 148.29 | 148.29 | 243.0 |
| 2021-09-17 06:09:00 | AAPL | Stock | 148.37 | 148.39 | 148.37 | 148.39 | 353.0 |
| 2021-09-17 06:12:00 | AAPL | Stock | 148.45 | 148.45 | 148.45 | 148.45 | 100.0 |
| 2021-09-17 06:14:00 | AAPL | Stock | 148.48 | 148.48 | 148.48 | 148.48 | 494.0 |
| 2021-09-17 06:15:00 | AAPL | Stock | 148.5 | 148.5 | 148.5 | 148.5 | 730.0 |
| 2021-09-17 06:18:00 | AAPL | Stock | 148.54 | 148.57 | 148.54 | 148.57 | 332.0 |
| 2021-09-17 06:23:00 | AAPL | Stock | 148.55 | 148.55 | 148.55 | 148.55 | 100.0 |
| 2021-09-17 06:26:00 | AAPL | Stock | 148.41 | 148.43 | 148.41 | 148.43 | 331.0 |
| 2021-09-17 06:57:00 | AAPL | Stock | 148.47 | 148.47 | 148.47 | 148.47 | 254.0 |
| 2021-09-17 07:00:00 | AAPL | Stock | 148.51 | 148.58 | 148.48 | 148.54 | 3503.0 |
| 2021-09-17 07:02:00 | AAPL | Stock | 148.57 | 148.57 | 148.52 | 148.52 | 428.0 |
| 2021-09-17 07:03:00 | AAPL | Stock | 148.56 | 148.57 | 148.56 | 148.57 | 518.0 |
| 2021-09-17 07:08:00 | AAPL | Stock | 148.6 | 148.6 | 148.6 | 148.6 | 1000.0 |
| 2021-09-17 07:10:00 | AAPL | Stock | 148.57 | 148.57 | 148.57 | 148.57 | 100.0 |
| 2021-09-17 07:11:00 | AAPL | Stock | 148.51 | 148.51 | 148.51 | 148.51 | 124.0 |
> showing 50 of 1,419,216 rows — these rows as CSV