PREVIEW / stock_5min / 2021-09-30
file: by_date/stock_5min/2021/2021-09-30.parquet size: 7.5 MB rows: 460,811 symbols: 2,751
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-30 04:00:00 | AAPL | Stock | 144.0 | 144.08 | 144.0 | 144.07 | 9213.0 |
| 2021-09-30 04:05:00 | AAPL | Stock | 144.06 | 144.1 | 144.04 | 144.1 | 3279.0 |
| 2021-09-30 04:10:00 | AAPL | Stock | 144.11 | 144.13 | 144.01 | 144.01 | 2035.0 |
| 2021-09-30 04:15:00 | AAPL | Stock | 143.98 | 143.98 | 143.81 | 143.89 | 1361.0 |
| 2021-09-30 04:20:00 | AAPL | Stock | 143.77 | 143.9 | 143.77 | 143.9 | 1357.0 |
| 2021-09-30 04:25:00 | AAPL | Stock | 143.95 | 143.95 | 143.95 | 143.95 | 200.0 |
| 2021-09-30 04:40:00 | AAPL | Stock | 143.8 | 143.8 | 143.8 | 143.8 | 510.0 |
| 2021-09-30 04:50:00 | AAPL | Stock | 143.9 | 143.9 | 143.9 | 143.9 | 100.0 |
| 2021-09-30 04:55:00 | AAPL | Stock | 143.92 | 143.92 | 143.92 | 143.92 | 100.0 |
| 2021-09-30 05:00:00 | AAPL | Stock | 143.98 | 143.98 | 143.95 | 143.95 | 229.0 |
| 2021-09-30 05:15:00 | AAPL | Stock | 143.89 | 143.89 | 143.89 | 143.89 | 129.0 |
| 2021-09-30 05:20:00 | AAPL | Stock | 143.87 | 143.87 | 143.87 | 143.87 | 149.0 |
| 2021-09-30 05:25:00 | AAPL | Stock | 143.86 | 143.86 | 143.72 | 143.75 | 1793.0 |
| 2021-09-30 05:40:00 | AAPL | Stock | 143.61 | 143.7 | 143.61 | 143.7 | 4178.0 |
| 2021-09-30 05:45:00 | AAPL | Stock | 143.55 | 143.55 | 143.51 | 143.51 | 509.0 |
| 2021-09-30 05:50:00 | AAPL | Stock | 143.51 | 143.51 | 143.51 | 143.51 | 299.0 |
| 2021-09-30 05:55:00 | AAPL | Stock | 143.7 | 143.7 | 143.7 | 143.7 | 350.0 |
| 2021-09-30 06:10:00 | AAPL | Stock | 143.96 | 143.98 | 143.95 | 143.98 | 1727.0 |
| 2021-09-30 06:15:00 | AAPL | Stock | 143.79 | 143.79 | 143.78 | 143.78 | 1005.0 |
| 2021-09-30 06:20:00 | AAPL | Stock | 143.51 | 143.51 | 143.37 | 143.37 | 1650.0 |
| 2021-09-30 06:35:00 | AAPL | Stock | 143.55 | 143.55 | 143.55 | 143.55 | 147.0 |
| 2021-09-30 06:45:00 | AAPL | Stock | 143.61 | 143.61 | 143.61 | 143.61 | 326.0 |
| 2021-09-30 06:55:00 | AAPL | Stock | 143.62 | 143.62 | 143.46 | 143.46 | 1160.0 |
| 2021-09-30 07:00:00 | AAPL | Stock | 143.57 | 143.6 | 143.4 | 143.4 | 11239.0 |
| 2021-09-30 07:05:00 | AAPL | Stock | 143.4 | 143.55 | 143.4 | 143.55 | 2071.0 |
| 2021-09-30 07:10:00 | AAPL | Stock | 143.6 | 143.64 | 143.54 | 143.55 | 4946.0 |
| 2021-09-30 07:15:00 | AAPL | Stock | 143.54 | 143.55 | 143.47 | 143.55 | 3758.0 |
| 2021-09-30 07:20:00 | AAPL | Stock | 143.55 | 143.55 | 143.44 | 143.47 | 3301.0 |
| 2021-09-30 07:25:00 | AAPL | Stock | 143.44 | 143.49 | 143.4 | 143.44 | 8814.0 |
| 2021-09-30 07:30:00 | AAPL | Stock | 143.44 | 143.44 | 143.42 | 143.42 | 1399.0 |
| 2021-09-30 07:35:00 | AAPL | Stock | 143.42 | 143.42 | 143.36 | 143.36 | 3745.0 |
| 2021-09-30 07:40:00 | AAPL | Stock | 143.36 | 143.36 | 143.25 | 143.27 | 5766.0 |
| 2021-09-30 07:45:00 | AAPL | Stock | 143.28 | 143.33 | 143.28 | 143.28 | 3039.0 |
| 2021-09-30 07:50:00 | AAPL | Stock | 143.3 | 143.47 | 143.3 | 143.44 | 5168.0 |
| 2021-09-30 07:55:00 | AAPL | Stock | 143.41 | 143.45 | 143.38 | 143.45 | 4471.0 |
| 2021-09-30 08:00:00 | AAPL | Stock | 143.5497 | 143.62 | 143.187 | 143.45 | 150988.0 |
| 2021-09-30 08:05:00 | AAPL | Stock | 143.41 | 143.47 | 143.4 | 143.44 | 13208.0 |
| 2021-09-30 08:10:00 | AAPL | Stock | 143.41 | 143.42 | 143.38 | 143.38 | 7300.0 |
| 2021-09-30 08:15:00 | AAPL | Stock | 143.4 | 143.43 | 143.38 | 143.38 | 2957.0 |
| 2021-09-30 08:20:00 | AAPL | Stock | 143.4 | 143.44 | 143.37 | 143.4 | 26945.0 |
| 2021-09-30 08:25:00 | AAPL | Stock | 143.42 | 143.44 | 143.35 | 143.44 | 5947.0 |
| 2021-09-30 08:30:00 | AAPL | Stock | 143.49 | 143.65 | 143.49 | 143.58 | 17579.0 |
| 2021-09-30 08:35:00 | AAPL | Stock | 143.52 | 143.61 | 143.43 | 143.4301 | 27552.0 |
| 2021-09-30 08:40:00 | AAPL | Stock | 143.4601 | 143.6 | 143.46 | 143.5701 | 28838.0 |
| 2021-09-30 08:45:00 | AAPL | Stock | 143.59 | 143.64 | 143.59 | 143.64 | 7877.0 |
| 2021-09-30 08:50:00 | AAPL | Stock | 143.64 | 143.64 | 143.55 | 143.5899 | 21093.0 |
| 2021-09-30 08:55:00 | AAPL | Stock | 143.59 | 143.63 | 143.55 | 143.58 | 20079.0 |
| 2021-09-30 09:00:00 | AAPL | Stock | 143.56 | 143.58 | 143.44 | 143.45 | 29995.0 |
| 2021-09-30 09:05:00 | AAPL | Stock | 143.44 | 143.44 | 143.33 | 143.38 | 54054.0 |
| 2021-09-30 09:10:00 | AAPL | Stock | 143.41 | 143.46 | 143.39 | 143.449 | 18685.0 |
> showing 50 of 460,811 rows — these rows as CSV