PREVIEW / stock_5min / 2022-11-14
file: by_date/stock_5min/2022/2022-11-14.parquet size: 7.0 MB rows: 432,261 symbols: 2,144
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-14 04:00:00 | AAPL | Stock | 149.24 | 149.24 | 148.75 | 148.75 | 2889.0 |
| 2022-11-14 04:05:00 | AAPL | Stock | 148.79 | 148.8 | 148.5 | 148.5 | 2613.0 |
| 2022-11-14 04:10:00 | AAPL | Stock | 148.47 | 148.57 | 148.45 | 148.57 | 1880.0 |
| 2022-11-14 04:15:00 | AAPL | Stock | 148.47 | 148.5 | 148.29 | 148.29 | 1711.0 |
| 2022-11-14 04:20:00 | AAPL | Stock | 148.3 | 148.38 | 148.3 | 148.31 | 2889.0 |
| 2022-11-14 04:25:00 | AAPL | Stock | 148.33 | 148.57 | 148.26 | 148.5 | 8395.0 |
| 2022-11-14 04:30:00 | AAPL | Stock | 148.61 | 148.63 | 148.61 | 148.63 | 845.0 |
| 2022-11-14 04:35:00 | AAPL | Stock | 148.52 | 148.7 | 148.52 | 148.6 | 1866.0 |
| 2022-11-14 04:40:00 | AAPL | Stock | 148.62 | 148.72 | 148.59 | 148.69 | 4631.0 |
| 2022-11-14 04:45:00 | AAPL | Stock | 148.72 | 148.72 | 148.53 | 148.53 | 1892.0 |
| 2022-11-14 04:50:00 | AAPL | Stock | 148.45 | 148.45 | 148.41 | 148.45 | 8462.0 |
| 2022-11-14 04:55:00 | AAPL | Stock | 148.4 | 148.4 | 148.4 | 148.4 | 1267.0 |
| 2022-11-14 05:00:00 | AAPL | Stock | 148.45 | 148.45 | 148.12 | 148.12 | 2214.0 |
| 2022-11-14 05:05:00 | AAPL | Stock | 148.24 | 148.24 | 148.24 | 148.24 | 661.0 |
| 2022-11-14 05:10:00 | AAPL | Stock | 148.33 | 148.4 | 148.32 | 148.32 | 2865.0 |
| 2022-11-14 05:15:00 | AAPL | Stock | 148.34 | 148.4 | 148.33 | 148.35 | 1102.0 |
| 2022-11-14 05:20:00 | AAPL | Stock | 148.36 | 148.41 | 148.35 | 148.41 | 1706.0 |
| 2022-11-14 05:25:00 | AAPL | Stock | 148.43 | 148.49 | 148.41 | 148.44 | 1972.0 |
| 2022-11-14 05:30:00 | AAPL | Stock | 148.32 | 148.32 | 148.32 | 148.32 | 6630.0 |
| 2022-11-14 05:35:00 | AAPL | Stock | 148.32 | 148.32 | 148.2 | 148.2 | 2667.0 |
| 2022-11-14 05:40:00 | AAPL | Stock | 148.2 | 148.23 | 148.2 | 148.2 | 5271.0 |
| 2022-11-14 05:45:00 | AAPL | Stock | 148.22 | 148.22 | 148.22 | 148.22 | 5570.0 |
| 2022-11-14 05:50:00 | AAPL | Stock | 148.35 | 148.35 | 148.31 | 148.31 | 1813.0 |
| 2022-11-14 05:55:00 | AAPL | Stock | 148.35 | 148.36 | 148.35 | 148.36 | 1807.0 |
| 2022-11-14 06:00:00 | AAPL | Stock | 148.36 | 148.36 | 148.36 | 148.36 | 102.0 |
| 2022-11-14 06:05:00 | AAPL | Stock | 148.25 | 148.25 | 148.25 | 148.25 | 630.0 |
| 2022-11-14 06:20:00 | AAPL | Stock | 148.25 | 148.25 | 148.25 | 148.25 | 100.0 |
| 2022-11-14 06:30:00 | AAPL | Stock | 148.28 | 148.34 | 148.23 | 148.34 | 947.0 |
| 2022-11-14 06:50:00 | AAPL | Stock | 148.28 | 148.28 | 148.25 | 148.28 | 1905.0 |
| 2022-11-14 06:55:00 | AAPL | Stock | 148.28 | 148.3 | 148.28 | 148.3 | 1795.0 |
| 2022-11-14 07:00:00 | AAPL | Stock | 148.32 | 148.44 | 148.25 | 148.31 | 8534.0 |
| 2022-11-14 07:05:00 | AAPL | Stock | 148.3 | 148.46 | 148.3 | 148.46 | 4555.0 |
| 2022-11-14 07:10:00 | AAPL | Stock | 148.48 | 148.58 | 148.4 | 148.55 | 12886.0 |
| 2022-11-14 07:15:00 | AAPL | Stock | 148.55 | 148.55 | 148.5 | 148.5 | 949.0 |
| 2022-11-14 07:20:00 | AAPL | Stock | 148.58 | 148.75 | 148.58 | 148.75 | 9306.0 |
| 2022-11-14 07:25:00 | AAPL | Stock | 148.75 | 148.75 | 148.74 | 148.74 | 300.0 |
| 2022-11-14 07:30:00 | AAPL | Stock | 148.68 | 148.72 | 148.67 | 148.72 | 4275.0 |
| 2022-11-14 07:35:00 | AAPL | Stock | 148.74 | 148.74 | 148.65 | 148.65 | 3543.0 |
| 2022-11-14 07:40:00 | AAPL | Stock | 148.74 | 148.87 | 148.64 | 148.77 | 19564.0 |
| 2022-11-14 07:45:00 | AAPL | Stock | 148.7 | 148.73 | 148.67 | 148.7 | 8516.0 |
| 2022-11-14 07:50:00 | AAPL | Stock | 148.67 | 148.74 | 148.67 | 148.72 | 1225.0 |
| 2022-11-14 07:55:00 | AAPL | Stock | 148.72 | 148.82 | 148.72 | 148.82 | 3222.0 |
| 2022-11-14 08:00:00 | AAPL | Stock | 148.44 | 148.85 | 147.96 | 148.55 | 65042.0 |
| 2022-11-14 08:05:00 | AAPL | Stock | 148.57 | 148.7835 | 148.57 | 148.66 | 17066.0 |
| 2022-11-14 08:10:00 | AAPL | Stock | 148.64 | 148.77 | 148.6 | 148.77 | 7147.0 |
| 2022-11-14 08:15:00 | AAPL | Stock | 148.79 | 148.88 | 148.68 | 148.88 | 10394.0 |
| 2022-11-14 08:20:00 | AAPL | Stock | 148.87 | 148.88 | 148.66 | 148.79 | 14156.0 |
| 2022-11-14 08:25:00 | AAPL | Stock | 148.81 | 148.81 | 148.67 | 148.75 | 7077.0 |
| 2022-11-14 08:30:00 | AAPL | Stock | 148.68 | 148.7 | 148.59 | 148.7 | 8886.0 |
| 2022-11-14 08:35:00 | AAPL | Stock | 148.7 | 148.75 | 148.67 | 148.67 | 9296.0 |
> showing 50 of 432,261 rows — these rows as CSV