PREVIEW / stock_5min / 2022-08-19
file: by_date/stock_5min/2022/2022-08-19.parquet size: 6.9 MB rows: 427,569 symbols: 2,205
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-08-19 04:00:00 | AAPL | Stock | 173.6 | 173.6 | 172.8 | 173.1 | 6902.0 |
| 2022-08-19 04:05:00 | AAPL | Stock | 173.05 | 173.08 | 172.8 | 172.9 | 5827.0 |
| 2022-08-19 04:10:00 | AAPL | Stock | 172.84 | 172.9 | 172.77 | 172.9 | 3092.0 |
| 2022-08-19 04:15:00 | AAPL | Stock | 172.9 | 172.91 | 172.82 | 172.89 | 6489.0 |
| 2022-08-19 04:20:00 | AAPL | Stock | 172.87 | 172.91 | 172.63 | 172.63 | 8157.0 |
| 2022-08-19 04:25:00 | AAPL | Stock | 172.64 | 172.7 | 172.62 | 172.67 | 3532.0 |
| 2022-08-19 04:30:00 | AAPL | Stock | 172.64 | 172.7 | 172.4 | 172.41 | 6623.0 |
| 2022-08-19 04:35:00 | AAPL | Stock | 172.41 | 172.66 | 172.41 | 172.66 | 2561.0 |
| 2022-08-19 04:40:00 | AAPL | Stock | 172.67 | 172.7 | 172.63 | 172.7 | 2194.0 |
| 2022-08-19 04:45:00 | AAPL | Stock | 172.75 | 172.79 | 172.75 | 172.79 | 800.0 |
| 2022-08-19 04:50:00 | AAPL | Stock | 172.52 | 172.65 | 172.5 | 172.65 | 860.0 |
| 2022-08-19 04:55:00 | AAPL | Stock | 172.7 | 172.77 | 172.69 | 172.69 | 7484.0 |
| 2022-08-19 05:00:00 | AAPL | Stock | 172.66 | 172.69 | 172.62 | 172.69 | 1512.0 |
| 2022-08-19 05:10:00 | AAPL | Stock | 172.66 | 172.7 | 172.62 | 172.7 | 2444.0 |
| 2022-08-19 05:15:00 | AAPL | Stock | 172.75 | 172.85 | 172.75 | 172.79 | 509.0 |
| 2022-08-19 05:25:00 | AAPL | Stock | 172.64 | 172.64 | 172.64 | 172.64 | 499.0 |
| 2022-08-19 05:30:00 | AAPL | Stock | 172.66 | 172.66 | 172.65 | 172.66 | 874.0 |
| 2022-08-19 05:35:00 | AAPL | Stock | 172.79 | 172.84 | 172.79 | 172.84 | 955.0 |
| 2022-08-19 05:40:00 | AAPL | Stock | 172.84 | 172.85 | 172.72 | 172.72 | 1461.0 |
| 2022-08-19 05:45:00 | AAPL | Stock | 172.72 | 172.72 | 172.7 | 172.7 | 499.0 |
| 2022-08-19 05:50:00 | AAPL | Stock | 172.66 | 172.66 | 172.61 | 172.64 | 2917.0 |
| 2022-08-19 05:55:00 | AAPL | Stock | 172.61 | 172.72 | 172.57 | 172.6 | 14317.0 |
| 2022-08-19 06:00:00 | AAPL | Stock | 172.59 | 172.6 | 172.5 | 172.5 | 3981.0 |
| 2022-08-19 06:05:00 | AAPL | Stock | 172.46 | 172.46 | 172.45 | 172.45 | 290.0 |
| 2022-08-19 06:10:00 | AAPL | Stock | 172.43 | 172.46 | 172.43 | 172.46 | 492.0 |
| 2022-08-19 06:15:00 | AAPL | Stock | 172.43 | 172.58 | 172.43 | 172.58 | 1456.0 |
| 2022-08-19 06:20:00 | AAPL | Stock | 172.68 | 172.68 | 172.62 | 172.62 | 1456.0 |
| 2022-08-19 06:25:00 | AAPL | Stock | 172.62 | 172.62 | 172.6 | 172.6 | 200.0 |
| 2022-08-19 06:30:00 | AAPL | Stock | 172.6 | 172.6 | 172.56 | 172.56 | 592.0 |
| 2022-08-19 06:35:00 | AAPL | Stock | 172.55 | 172.55 | 172.45 | 172.47 | 3577.0 |
| 2022-08-19 06:40:00 | AAPL | Stock | 172.46 | 172.47 | 172.39 | 172.39 | 2122.0 |
| 2022-08-19 06:45:00 | AAPL | Stock | 172.31 | 172.33 | 172.2 | 172.31 | 3392.0 |
| 2022-08-19 06:50:00 | AAPL | Stock | 172.27 | 172.33 | 172.25 | 172.32 | 1892.0 |
| 2022-08-19 06:55:00 | AAPL | Stock | 172.4 | 172.45 | 172.4 | 172.45 | 1455.0 |
| 2022-08-19 07:00:00 | AAPL | Stock | 172.55 | 172.78 | 172.48 | 172.55 | 25221.0 |
| 2022-08-19 07:05:00 | AAPL | Stock | 172.54 | 172.54 | 172.35 | 172.48 | 22331.0 |
| 2022-08-19 07:10:00 | AAPL | Stock | 172.48 | 172.55 | 172.48 | 172.55 | 6137.0 |
| 2022-08-19 07:15:00 | AAPL | Stock | 172.59 | 172.65 | 172.5 | 172.53 | 7724.0 |
| 2022-08-19 07:20:00 | AAPL | Stock | 172.54 | 172.65 | 172.54 | 172.6 | 4338.0 |
| 2022-08-19 07:25:00 | AAPL | Stock | 172.61 | 172.61 | 172.54 | 172.6 | 4053.0 |
| 2022-08-19 07:30:00 | AAPL | Stock | 172.6 | 172.67 | 172.5 | 172.51 | 12873.0 |
| 2022-08-19 07:35:00 | AAPL | Stock | 172.5 | 172.5 | 172.42 | 172.48 | 7830.0 |
| 2022-08-19 07:40:00 | AAPL | Stock | 172.5 | 172.55 | 172.43 | 172.5 | 19678.0 |
| 2022-08-19 07:45:00 | AAPL | Stock | 172.51 | 172.57 | 172.51 | 172.54 | 8662.0 |
| 2022-08-19 07:50:00 | AAPL | Stock | 172.52 | 172.55 | 172.45 | 172.47 | 5916.0 |
| 2022-08-19 07:55:00 | AAPL | Stock | 172.46 | 172.6 | 172.46 | 172.59 | 7804.0 |
| 2022-08-19 08:00:00 | AAPL | Stock | 172.6 | 173.85 | 172.35 | 172.64 | 254641.0 |
| 2022-08-19 08:05:00 | AAPL | Stock | 172.65 | 172.7 | 172.6 | 172.69 | 40328.0 |
| 2022-08-19 08:10:00 | AAPL | Stock | 172.68 | 172.7299 | 172.53 | 172.61 | 28621.0 |
| 2022-08-19 08:15:00 | AAPL | Stock | 172.6 | 172.7797 | 172.59 | 172.7 | 17318.0 |
> showing 50 of 427,569 rows — these rows as CSV