PREVIEW / stock_1min / 2021-11-16
file: by_date/stock_1min/2021/2021-11-16.parquet size: 24.3 MB rows: 1,423,429 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-11-16 04:01:00 | AAPL | Stock | 149.92 | 149.92 | 149.92 | 149.92 | 153.0 |
| 2021-11-16 04:32:00 | AAPL | Stock | 149.8 | 149.8 | 149.79 | 149.79 | 1049.0 |
| 2021-11-16 04:33:00 | AAPL | Stock | 149.79 | 149.79 | 149.75 | 149.75 | 396.0 |
| 2021-11-16 04:34:00 | AAPL | Stock | 149.76 | 149.76 | 149.75 | 149.75 | 3730.0 |
| 2021-11-16 04:35:00 | AAPL | Stock | 149.76 | 149.76 | 149.75 | 149.75 | 629.0 |
| 2021-11-16 04:43:00 | AAPL | Stock | 149.69 | 149.69 | 149.69 | 149.69 | 134.0 |
| 2021-11-16 04:44:00 | AAPL | Stock | 149.7 | 149.7 | 149.69 | 149.69 | 209.0 |
| 2021-11-16 04:47:00 | AAPL | Stock | 149.6 | 149.61 | 149.6 | 149.61 | 369.0 |
| 2021-11-16 04:53:00 | AAPL | Stock | 149.63 | 149.63 | 149.62 | 149.63 | 759.0 |
| 2021-11-16 04:55:00 | AAPL | Stock | 149.62 | 149.62 | 149.62 | 149.62 | 440.0 |
| 2021-11-16 04:58:00 | AAPL | Stock | 149.68 | 149.7 | 149.68 | 149.7 | 206.0 |
| 2021-11-16 05:00:00 | AAPL | Stock | 149.62 | 149.62 | 149.62 | 149.62 | 200.0 |
| 2021-11-16 05:01:00 | AAPL | Stock | 149.62 | 149.62 | 149.61 | 149.61 | 1000.0 |
| 2021-11-16 05:03:00 | AAPL | Stock | 149.61 | 149.62 | 149.61 | 149.62 | 549.0 |
| 2021-11-16 05:07:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 220.0 |
| 2021-11-16 05:17:00 | AAPL | Stock | 149.57 | 149.57 | 149.57 | 149.57 | 137.0 |
| 2021-11-16 05:30:00 | AAPL | Stock | 149.57 | 149.57 | 149.57 | 149.57 | 148.0 |
| 2021-11-16 05:31:00 | AAPL | Stock | 149.57 | 149.57 | 149.57 | 149.57 | 251.0 |
| 2021-11-16 05:35:00 | AAPL | Stock | 149.58 | 149.58 | 149.58 | 149.58 | 143.0 |
| 2021-11-16 05:42:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 1386.0 |
| 2021-11-16 05:46:00 | AAPL | Stock | 149.6 | 149.6 | 149.6 | 149.6 | 228.0 |
| 2021-11-16 05:53:00 | AAPL | Stock | 149.62 | 149.62 | 149.62 | 149.62 | 100.0 |
| 2021-11-16 05:55:00 | AAPL | Stock | 149.65 | 149.65 | 149.65 | 149.65 | 100.0 |
| 2021-11-16 05:56:00 | AAPL | Stock | 149.68 | 149.68 | 149.68 | 149.68 | 110.0 |
| 2021-11-16 06:00:00 | AAPL | Stock | 149.67 | 149.67 | 149.66 | 149.66 | 940.0 |
| 2021-11-16 06:28:00 | AAPL | Stock | 149.72 | 149.72 | 149.72 | 149.72 | 302.0 |
| 2021-11-16 06:29:00 | AAPL | Stock | 149.72 | 149.72 | 149.72 | 149.72 | 232.0 |
| 2021-11-16 06:30:00 | AAPL | Stock | 149.75 | 149.75 | 149.75 | 149.75 | 263.0 |
| 2021-11-16 06:33:00 | AAPL | Stock | 149.76 | 149.76 | 149.76 | 149.76 | 126.0 |
| 2021-11-16 06:34:00 | AAPL | Stock | 149.82 | 149.82 | 149.82 | 149.82 | 263.0 |
| 2021-11-16 06:37:00 | AAPL | Stock | 149.77 | 149.77 | 149.77 | 149.77 | 199.0 |
| 2021-11-16 06:51:00 | AAPL | Stock | 149.82 | 149.85 | 149.82 | 149.85 | 400.0 |
| 2021-11-16 06:54:00 | AAPL | Stock | 149.88 | 149.88 | 149.88 | 149.88 | 180.0 |
| 2021-11-16 06:56:00 | AAPL | Stock | 149.98 | 149.99 | 149.98 | 149.99 | 724.0 |
| 2021-11-16 06:57:00 | AAPL | Stock | 149.98 | 150.0 | 149.98 | 150.0 | 629.0 |
| 2021-11-16 06:59:00 | AAPL | Stock | 149.97 | 149.99 | 149.97 | 149.99 | 200.0 |
| 2021-11-16 07:00:00 | AAPL | Stock | 149.98 | 150.1 | 149.98 | 150.09 | 1400.0 |
| 2021-11-16 07:03:00 | AAPL | Stock | 150.1 | 150.1 | 150.1 | 150.1 | 250.0 |
| 2021-11-16 07:04:00 | AAPL | Stock | 150.12 | 150.12 | 150.09 | 150.09 | 1114.0 |
| 2021-11-16 07:05:00 | AAPL | Stock | 150.09 | 150.09 | 150.09 | 150.09 | 368.0 |
| 2021-11-16 07:06:00 | AAPL | Stock | 150.13 | 150.13 | 150.13 | 150.13 | 291.0 |
| 2021-11-16 07:07:00 | AAPL | Stock | 150.11 | 150.11 | 150.11 | 150.11 | 200.0 |
| 2021-11-16 07:08:00 | AAPL | Stock | 150.08 | 150.08 | 150.08 | 150.08 | 1000.0 |
| 2021-11-16 07:09:00 | AAPL | Stock | 150.07 | 150.1 | 150.07 | 150.1 | 549.0 |
| 2021-11-16 07:10:00 | AAPL | Stock | 150.1 | 150.15 | 150.1 | 150.15 | 1574.0 |
| 2021-11-16 07:11:00 | AAPL | Stock | 150.14 | 150.14 | 150.13 | 150.13 | 200.0 |
| 2021-11-16 07:12:00 | AAPL | Stock | 150.13 | 150.13 | 150.09 | 150.09 | 1229.0 |
| 2021-11-16 07:13:00 | AAPL | Stock | 150.11 | 150.12 | 150.11 | 150.12 | 200.0 |
| 2021-11-16 07:14:00 | AAPL | Stock | 150.1 | 150.12 | 150.1 | 150.12 | 399.0 |
| 2021-11-16 07:15:00 | AAPL | Stock | 150.12 | 150.12 | 150.11 | 150.11 | 200.0 |
> showing 50 of 1,423,429 rows — these rows as CSV