PREVIEW / stock_5min / 2021-07-16
file: by_date/stock_5min/2021/2021-07-16.parquet size: 7.3 MB rows: 448,894 symbols: 2,881
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-07-16 04:00:00 | AAPL | Stock | 148.34 | 148.35 | 148.1 | 148.35 | 5509.0 |
| 2021-07-16 04:15:00 | AAPL | Stock | 148.28 | 148.3 | 148.28 | 148.3 | 453.0 |
| 2021-07-16 04:20:00 | AAPL | Stock | 148.32 | 148.32 | 148.32 | 148.32 | 190.0 |
| 2021-07-16 04:25:00 | AAPL | Stock | 148.27 | 148.27 | 148.27 | 148.27 | 124.0 |
| 2021-07-16 04:30:00 | AAPL | Stock | 148.27 | 148.29 | 148.27 | 148.29 | 800.0 |
| 2021-07-16 04:40:00 | AAPL | Stock | 148.22 | 148.22 | 148.21 | 148.22 | 789.0 |
| 2021-07-16 04:45:00 | AAPL | Stock | 148.22 | 148.22 | 148.22 | 148.22 | 100.0 |
| 2021-07-16 04:50:00 | AAPL | Stock | 148.33 | 148.34 | 148.33 | 148.34 | 659.0 |
| 2021-07-16 04:55:00 | AAPL | Stock | 148.35 | 148.35 | 148.35 | 148.35 | 2331.0 |
| 2021-07-16 05:00:00 | AAPL | Stock | 148.38 | 148.38 | 148.35 | 148.35 | 3073.0 |
| 2021-07-16 05:05:00 | AAPL | Stock | 148.34 | 148.38 | 148.33 | 148.38 | 7519.0 |
| 2021-07-16 05:10:00 | AAPL | Stock | 148.38 | 148.4 | 148.35 | 148.4 | 1641.0 |
| 2021-07-16 05:15:00 | AAPL | Stock | 148.43 | 148.43 | 148.31 | 148.31 | 1750.0 |
| 2021-07-16 05:20:00 | AAPL | Stock | 148.35 | 148.36 | 148.35 | 148.36 | 2190.0 |
| 2021-07-16 05:25:00 | AAPL | Stock | 148.38 | 148.38 | 148.35 | 148.35 | 1107.0 |
| 2021-07-16 05:30:00 | AAPL | Stock | 148.35 | 148.35 | 148.32 | 148.32 | 214.0 |
| 2021-07-16 05:35:00 | AAPL | Stock | 148.4 | 148.4 | 148.3 | 148.3 | 749.0 |
| 2021-07-16 05:40:00 | AAPL | Stock | 148.36 | 148.36 | 148.36 | 148.36 | 100.0 |
| 2021-07-16 05:55:00 | AAPL | Stock | 148.32 | 148.34 | 148.32 | 148.34 | 668.0 |
| 2021-07-16 06:00:00 | AAPL | Stock | 148.35 | 148.45 | 148.34 | 148.34 | 2102.0 |
| 2021-07-16 06:05:00 | AAPL | Stock | 148.35 | 148.36 | 148.35 | 148.35 | 819.0 |
| 2021-07-16 06:10:00 | AAPL | Stock | 148.3 | 148.3 | 148.2 | 148.2 | 957.0 |
| 2021-07-16 06:20:00 | AAPL | Stock | 148.23 | 148.23 | 148.2 | 148.23 | 612.0 |
| 2021-07-16 06:25:00 | AAPL | Stock | 148.24 | 148.24 | 148.24 | 148.24 | 100.0 |
| 2021-07-16 06:45:00 | AAPL | Stock | 148.37 | 148.65 | 148.37 | 148.65 | 6393.0 |
| 2021-07-16 06:50:00 | AAPL | Stock | 148.74 | 148.78 | 148.51 | 148.65 | 19349.0 |
| 2021-07-16 06:55:00 | AAPL | Stock | 148.65 | 148.7 | 148.64 | 148.7 | 541.0 |
| 2021-07-16 07:00:00 | AAPL | Stock | 148.65 | 148.8 | 148.61 | 148.75 | 21133.0 |
| 2021-07-16 07:05:00 | AAPL | Stock | 148.79 | 148.88 | 148.77 | 148.77 | 11421.0 |
| 2021-07-16 07:10:00 | AAPL | Stock | 148.77 | 148.81 | 148.69 | 148.81 | 22191.0 |
| 2021-07-16 07:15:00 | AAPL | Stock | 148.82 | 148.85 | 148.74 | 148.76 | 9625.0 |
| 2021-07-16 07:20:00 | AAPL | Stock | 148.79 | 148.79 | 148.68 | 148.68 | 5836.0 |
| 2021-07-16 07:25:00 | AAPL | Stock | 148.65 | 148.68 | 148.63 | 148.67 | 3251.0 |
| 2021-07-16 07:30:00 | AAPL | Stock | 148.68 | 148.71 | 148.65 | 148.66 | 6180.0 |
| 2021-07-16 07:35:00 | AAPL | Stock | 148.66 | 148.68 | 148.64 | 148.65 | 2994.0 |
| 2021-07-16 07:40:00 | AAPL | Stock | 148.64 | 148.68 | 148.64 | 148.67 | 6321.0 |
| 2021-07-16 07:45:00 | AAPL | Stock | 148.65 | 148.68 | 148.64 | 148.66 | 3038.0 |
| 2021-07-16 07:50:00 | AAPL | Stock | 148.67 | 148.79 | 148.67 | 148.76 | 15468.0 |
| 2021-07-16 07:55:00 | AAPL | Stock | 148.76 | 148.89 | 148.76 | 148.78 | 18763.0 |
| 2021-07-16 08:00:00 | AAPL | Stock | 148.6999 | 148.89 | 148.109 | 148.84 | 182321.0 |
| 2021-07-16 08:05:00 | AAPL | Stock | 148.85 | 148.9199 | 148.85 | 148.9 | 31947.0 |
| 2021-07-16 08:10:00 | AAPL | Stock | 148.9 | 148.96 | 148.9 | 148.95 | 26476.0 |
| 2021-07-16 08:15:00 | AAPL | Stock | 148.96 | 149.02 | 148.95 | 148.961 | 50487.0 |
| 2021-07-16 08:20:00 | AAPL | Stock | 148.98 | 149.0 | 148.93 | 148.96 | 19956.0 |
| 2021-07-16 08:25:00 | AAPL | Stock | 148.95 | 148.98 | 148.92 | 148.92 | 19472.0 |
| 2021-07-16 08:30:00 | AAPL | Stock | 148.96 | 148.99 | 148.8 | 148.9 | 33450.0 |
| 2021-07-16 08:35:00 | AAPL | Stock | 148.91 | 149.0 | 148.9 | 148.95 | 37821.0 |
| 2021-07-16 08:40:00 | AAPL | Stock | 148.93 | 149.01 | 148.88 | 148.97 | 33070.0 |
| 2021-07-16 08:45:00 | AAPL | Stock | 148.96 | 148.99 | 148.92 | 148.95 | 10450.0 |
| 2021-07-16 08:50:00 | AAPL | Stock | 148.93 | 148.95 | 148.91 | 148.92 | 27065.0 |
> showing 50 of 448,894 rows — these rows as CSV