PREVIEW / stock_1min / 2021-12-17
file: by_date/stock_1min/2021/2021-12-17.parquet size: 24.6 MB rows: 1,503,555 symbols: 2,280
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-12-17 04:00:00 | AAPL | Stock | 171.66 | 171.66 | 171.65 | 171.66 | 544.0 |
| 2021-12-17 04:01:00 | AAPL | Stock | 171.5 | 171.5 | 171.28 | 171.41 | 2665.0 |
| 2021-12-17 04:02:00 | AAPL | Stock | 171.25 | 171.49 | 171.2 | 171.2 | 10330.0 |
| 2021-12-17 04:03:00 | AAPL | Stock | 171.02 | 171.21 | 171.02 | 171.2 | 522.0 |
| 2021-12-17 04:04:00 | AAPL | Stock | 171.21 | 171.23 | 171.17 | 171.21 | 2019.0 |
| 2021-12-17 04:05:00 | AAPL | Stock | 171.16 | 171.16 | 171.09 | 171.11 | 1129.0 |
| 2021-12-17 04:06:00 | AAPL | Stock | 171.05 | 171.05 | 171.0 | 171.0 | 230.0 |
| 2021-12-17 04:07:00 | AAPL | Stock | 170.91 | 170.99 | 170.84 | 170.99 | 1227.0 |
| 2021-12-17 04:08:00 | AAPL | Stock | 171.05 | 171.05 | 170.99 | 171.01 | 1509.0 |
| 2021-12-17 04:09:00 | AAPL | Stock | 171.03 | 171.14 | 171.03 | 171.14 | 590.0 |
| 2021-12-17 04:10:00 | AAPL | Stock | 171.13 | 171.13 | 171.1 | 171.12 | 800.0 |
| 2021-12-17 04:11:00 | AAPL | Stock | 171.01 | 171.01 | 170.8 | 170.81 | 4479.0 |
| 2021-12-17 04:12:00 | AAPL | Stock | 170.73 | 170.73 | 170.73 | 170.73 | 100.0 |
| 2021-12-17 04:13:00 | AAPL | Stock | 170.61 | 170.61 | 170.4 | 170.42 | 1967.0 |
| 2021-12-17 04:14:00 | AAPL | Stock | 170.5 | 170.5 | 170.3 | 170.3 | 3558.0 |
| 2021-12-17 04:15:00 | AAPL | Stock | 170.21 | 170.22 | 170.03 | 170.07 | 4468.0 |
| 2021-12-17 04:16:00 | AAPL | Stock | 170.2 | 170.27 | 170.2 | 170.27 | 1194.0 |
| 2021-12-17 04:17:00 | AAPL | Stock | 170.29 | 170.36 | 170.29 | 170.36 | 270.0 |
| 2021-12-17 04:18:00 | AAPL | Stock | 170.43 | 170.43 | 170.43 | 170.43 | 100.0 |
| 2021-12-17 04:20:00 | AAPL | Stock | 170.78 | 170.78 | 170.77 | 170.77 | 655.0 |
| 2021-12-17 04:21:00 | AAPL | Stock | 170.88 | 170.9 | 170.88 | 170.9 | 6486.0 |
| 2021-12-17 04:24:00 | AAPL | Stock | 170.93 | 170.93 | 170.93 | 170.93 | 250.0 |
| 2021-12-17 04:27:00 | AAPL | Stock | 170.92 | 170.92 | 170.92 | 170.92 | 150.0 |
| 2021-12-17 04:30:00 | AAPL | Stock | 170.9 | 170.9 | 170.9 | 170.9 | 147.0 |
| 2021-12-17 04:32:00 | AAPL | Stock | 170.8 | 170.83 | 170.8 | 170.83 | 395.0 |
| 2021-12-17 04:33:00 | AAPL | Stock | 170.98 | 170.98 | 170.98 | 170.98 | 104.0 |
| 2021-12-17 04:34:00 | AAPL | Stock | 170.82 | 170.82 | 170.82 | 170.82 | 300.0 |
| 2021-12-17 04:35:00 | AAPL | Stock | 170.89 | 170.89 | 170.89 | 170.89 | 134.0 |
| 2021-12-17 04:38:00 | AAPL | Stock | 170.84 | 170.84 | 170.84 | 170.84 | 132.0 |
| 2021-12-17 04:41:00 | AAPL | Stock | 170.67 | 170.67 | 170.65 | 170.67 | 1119.0 |
| 2021-12-17 04:42:00 | AAPL | Stock | 170.7 | 170.74 | 170.64 | 170.64 | 1109.0 |
| 2021-12-17 04:43:00 | AAPL | Stock | 170.54 | 170.54 | 170.54 | 170.54 | 200.0 |
| 2021-12-17 04:44:00 | AAPL | Stock | 170.53 | 170.53 | 170.35 | 170.35 | 751.0 |
| 2021-12-17 04:45:00 | AAPL | Stock | 170.3 | 170.38 | 170.3 | 170.31 | 333.0 |
| 2021-12-17 04:46:00 | AAPL | Stock | 170.35 | 170.44 | 170.35 | 170.44 | 975.0 |
| 2021-12-17 04:47:00 | AAPL | Stock | 170.44 | 170.49 | 170.44 | 170.49 | 411.0 |
| 2021-12-17 04:48:00 | AAPL | Stock | 170.59 | 170.7 | 170.59 | 170.7 | 769.0 |
| 2021-12-17 04:49:00 | AAPL | Stock | 170.7 | 170.7 | 170.7 | 170.7 | 250.0 |
| 2021-12-17 04:51:00 | AAPL | Stock | 170.76 | 170.76 | 170.76 | 170.76 | 100.0 |
| 2021-12-17 04:52:00 | AAPL | Stock | 170.85 | 170.86 | 170.85 | 170.86 | 200.0 |
| 2021-12-17 04:53:00 | AAPL | Stock | 170.9 | 171.0 | 170.9 | 171.0 | 6448.0 |
| 2021-12-17 04:54:00 | AAPL | Stock | 170.95 | 170.95 | 170.95 | 170.95 | 169.0 |
| 2021-12-17 04:55:00 | AAPL | Stock | 170.9 | 170.9 | 170.8 | 170.8 | 442.0 |
| 2021-12-17 04:56:00 | AAPL | Stock | 170.99 | 171.0 | 170.99 | 171.0 | 686.0 |
| 2021-12-17 04:57:00 | AAPL | Stock | 170.97 | 170.99 | 170.97 | 170.99 | 750.0 |
| 2021-12-17 04:59:00 | AAPL | Stock | 170.98 | 170.98 | 170.98 | 170.98 | 100.0 |
| 2021-12-17 05:00:00 | AAPL | Stock | 170.96 | 170.96 | 170.96 | 170.96 | 140.0 |
| 2021-12-17 05:01:00 | AAPL | Stock | 170.91 | 170.91 | 170.89 | 170.89 | 425.0 |
| 2021-12-17 05:02:00 | AAPL | Stock | 170.94 | 170.94 | 170.94 | 170.94 | 150.0 |
| 2021-12-17 05:03:00 | AAPL | Stock | 170.89 | 170.89 | 170.88 | 170.88 | 250.0 |
> showing 50 of 1,503,555 rows — these rows as CSV