PREVIEW / stock_5min / 2021-09-29
file: by_date/stock_5min/2021/2021-09-29.parquet size: 7.4 MB rows: 452,938 symbols: 2,717
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-29 04:00:00 | AAPL | Stock | 143.6 | 143.94 | 143.44 | 143.54 | 13994.0 |
| 2021-09-29 04:05:00 | AAPL | Stock | 143.63 | 143.63 | 143.22 | 143.57 | 7549.0 |
| 2021-09-29 04:10:00 | AAPL | Stock | 143.47 | 143.63 | 143.47 | 143.55 | 11479.0 |
| 2021-09-29 04:15:00 | AAPL | Stock | 143.39 | 143.48 | 143.27 | 143.27 | 2625.0 |
| 2021-09-29 04:20:00 | AAPL | Stock | 143.3 | 143.33 | 143.3 | 143.33 | 515.0 |
| 2021-09-29 04:25:00 | AAPL | Stock | 143.4 | 143.66 | 143.4 | 143.66 | 7705.0 |
| 2021-09-29 04:30:00 | AAPL | Stock | 143.61 | 143.61 | 143.5 | 143.5 | 705.0 |
| 2021-09-29 04:35:00 | AAPL | Stock | 143.39 | 143.39 | 143.34 | 143.34 | 552.0 |
| 2021-09-29 04:40:00 | AAPL | Stock | 143.39 | 143.47 | 143.38 | 143.38 | 1652.0 |
| 2021-09-29 04:50:00 | AAPL | Stock | 143.44 | 143.51 | 143.38 | 143.51 | 4635.0 |
| 2021-09-29 04:55:00 | AAPL | Stock | 143.55 | 143.57 | 143.53 | 143.57 | 1054.0 |
| 2021-09-29 05:00:00 | AAPL | Stock | 143.6 | 143.63 | 143.6 | 143.63 | 200.0 |
| 2021-09-29 05:05:00 | AAPL | Stock | 143.63 | 143.63 | 143.63 | 143.63 | 725.0 |
| 2021-09-29 05:10:00 | AAPL | Stock | 143.6 | 143.6 | 143.5 | 143.5 | 2757.0 |
| 2021-09-29 05:15:00 | AAPL | Stock | 143.61 | 143.61 | 143.42 | 143.42 | 1830.0 |
| 2021-09-29 05:20:00 | AAPL | Stock | 143.43 | 143.43 | 143.37 | 143.37 | 583.0 |
| 2021-09-29 05:25:00 | AAPL | Stock | 143.31 | 143.54 | 143.27 | 143.54 | 980.0 |
| 2021-09-29 05:30:00 | AAPL | Stock | 143.51 | 143.51 | 143.37 | 143.37 | 2441.0 |
| 2021-09-29 05:50:00 | AAPL | Stock | 143.44 | 143.6 | 143.44 | 143.6 | 2431.0 |
| 2021-09-29 05:55:00 | AAPL | Stock | 143.58 | 143.6 | 143.58 | 143.6 | 1150.0 |
| 2021-09-29 06:00:00 | AAPL | Stock | 143.6 | 143.68 | 143.6 | 143.68 | 4811.0 |
| 2021-09-29 06:05:00 | AAPL | Stock | 143.68 | 143.68 | 143.6 | 143.6 | 1814.0 |
| 2021-09-29 06:10:00 | AAPL | Stock | 143.57 | 143.57 | 143.57 | 143.57 | 399.0 |
| 2021-09-29 06:15:00 | AAPL | Stock | 143.59 | 143.59 | 143.59 | 143.59 | 358.0 |
| 2021-09-29 06:20:00 | AAPL | Stock | 143.6 | 143.67 | 143.6 | 143.6 | 2134.0 |
| 2021-09-29 06:25:00 | AAPL | Stock | 143.53 | 143.53 | 143.53 | 143.53 | 150.0 |
| 2021-09-29 06:35:00 | AAPL | Stock | 143.55 | 143.55 | 143.5 | 143.5 | 547.0 |
| 2021-09-29 06:40:00 | AAPL | Stock | 143.5 | 143.5 | 143.5 | 143.5 | 872.0 |
| 2021-09-29 06:45:00 | AAPL | Stock | 143.46 | 143.46 | 143.37 | 143.37 | 1374.0 |
| 2021-09-29 06:50:00 | AAPL | Stock | 143.37 | 143.37 | 143.37 | 143.37 | 500.0 |
| 2021-09-29 06:55:00 | AAPL | Stock | 143.31 | 143.31 | 143.3 | 143.3 | 624.0 |
| 2021-09-29 07:00:00 | AAPL | Stock | 143.26 | 143.4 | 143.19 | 143.2 | 48336.0 |
| 2021-09-29 07:05:00 | AAPL | Stock | 143.2 | 143.2 | 142.92 | 142.97 | 26854.0 |
| 2021-09-29 07:10:00 | AAPL | Stock | 142.97 | 142.97 | 142.81 | 142.94 | 11969.0 |
| 2021-09-29 07:15:00 | AAPL | Stock | 142.96 | 143.0 | 142.83 | 142.91 | 13005.0 |
| 2021-09-29 07:20:00 | AAPL | Stock | 142.92 | 142.99 | 142.9 | 142.95 | 4545.0 |
| 2021-09-29 07:25:00 | AAPL | Stock | 142.95 | 143.04 | 142.95 | 143.0 | 11183.0 |
| 2021-09-29 07:30:00 | AAPL | Stock | 143.0 | 143.05 | 142.96 | 143.0 | 6936.0 |
| 2021-09-29 07:35:00 | AAPL | Stock | 142.99 | 143.01 | 142.8 | 142.83 | 21260.0 |
| 2021-09-29 07:40:00 | AAPL | Stock | 142.85 | 142.91 | 142.75 | 142.86 | 37189.0 |
| 2021-09-29 07:45:00 | AAPL | Stock | 142.89 | 142.93 | 142.77 | 142.8 | 55773.0 |
| 2021-09-29 07:50:00 | AAPL | Stock | 142.84 | 142.87 | 142.79 | 142.87 | 31340.0 |
| 2021-09-29 07:55:00 | AAPL | Stock | 142.87 | 143.0 | 142.84 | 142.86 | 85589.0 |
| 2021-09-29 08:00:00 | AAPL | Stock | 142.9501 | 143.39 | 142.264 | 143.0 | 119218.0 |
| 2021-09-29 08:05:00 | AAPL | Stock | 143.0 | 143.01 | 142.92 | 142.96 | 15576.0 |
| 2021-09-29 08:10:00 | AAPL | Stock | 142.99 | 143.0 | 142.83 | 142.86 | 31499.0 |
| 2021-09-29 08:15:00 | AAPL | Stock | 142.86 | 142.93 | 142.8 | 142.92 | 79989.0 |
| 2021-09-29 08:20:00 | AAPL | Stock | 142.92 | 142.95 | 142.81 | 142.83 | 43465.0 |
| 2021-09-29 08:25:00 | AAPL | Stock | 142.87 | 142.99 | 142.82 | 142.89 | 18276.0 |
| 2021-09-29 08:30:00 | AAPL | Stock | 142.89 | 142.89 | 142.81 | 142.85 | 13752.0 |
> showing 50 of 452,938 rows — these rows as CSV