PREVIEW / stock_5min / 2022-08-22
file: by_date/stock_5min/2022/2022-08-22.parquet size: 7.0 MB rows: 432,234 symbols: 2,207
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-22 04:00:00 | AAPL | Stock | 170.29 | 170.29 | 169.01 | 169.08 | 16705.0 |
| 2022-08-22 04:05:00 | AAPL | Stock | 169.07 | 169.4 | 169.07 | 169.39 | 9145.0 |
| 2022-08-22 04:10:00 | AAPL | Stock | 169.39 | 169.45 | 169.1 | 169.29 | 17567.0 |
| 2022-08-22 04:15:00 | AAPL | Stock | 169.29 | 169.41 | 169.12 | 169.33 | 12525.0 |
| 2022-08-22 04:20:00 | AAPL | Stock | 169.35 | 169.35 | 169.15 | 169.15 | 6216.0 |
| 2022-08-22 04:25:00 | AAPL | Stock | 169.19 | 169.19 | 169.03 | 169.18 | 6683.0 |
| 2022-08-22 04:30:00 | AAPL | Stock | 169.18 | 169.18 | 169.01 | 169.01 | 3655.0 |
| 2022-08-22 04:35:00 | AAPL | Stock | 168.95 | 169.05 | 168.95 | 169.03 | 2784.0 |
| 2022-08-22 04:40:00 | AAPL | Stock | 169.0 | 169.01 | 168.78 | 168.89 | 27275.0 |
| 2022-08-22 04:45:00 | AAPL | Stock | 168.85 | 168.85 | 168.64 | 168.74 | 7687.0 |
| 2022-08-22 04:50:00 | AAPL | Stock | 168.74 | 168.86 | 168.68 | 168.86 | 2059.0 |
| 2022-08-22 04:55:00 | AAPL | Stock | 168.8 | 168.89 | 168.74 | 168.74 | 5215.0 |
| 2022-08-22 05:00:00 | AAPL | Stock | 168.8 | 168.8 | 168.66 | 168.67 | 2270.0 |
| 2022-08-22 05:05:00 | AAPL | Stock | 168.67 | 168.84 | 168.61 | 168.84 | 4971.0 |
| 2022-08-22 05:10:00 | AAPL | Stock | 168.79 | 168.9 | 168.79 | 168.8 | 2896.0 |
| 2022-08-22 05:15:00 | AAPL | Stock | 168.71 | 168.88 | 168.71 | 168.88 | 874.0 |
| 2022-08-22 05:20:00 | AAPL | Stock | 168.88 | 168.88 | 168.77 | 168.77 | 1146.0 |
| 2022-08-22 05:25:00 | AAPL | Stock | 168.74 | 168.74 | 168.72 | 168.72 | 1392.0 |
| 2022-08-22 05:30:00 | AAPL | Stock | 168.75 | 168.75 | 168.55 | 168.55 | 3670.0 |
| 2022-08-22 05:35:00 | AAPL | Stock | 168.58 | 168.6 | 168.55 | 168.56 | 10352.0 |
| 2022-08-22 05:40:00 | AAPL | Stock | 168.53 | 168.6 | 168.53 | 168.59 | 3337.0 |
| 2022-08-22 05:45:00 | AAPL | Stock | 168.57 | 168.67 | 168.57 | 168.61 | 3083.0 |
| 2022-08-22 05:50:00 | AAPL | Stock | 168.67 | 168.75 | 168.67 | 168.75 | 5423.0 |
| 2022-08-22 05:55:00 | AAPL | Stock | 168.83 | 168.84 | 168.68 | 168.68 | 4015.0 |
| 2022-08-22 06:00:00 | AAPL | Stock | 168.79 | 168.83 | 168.69 | 168.77 | 2711.0 |
| 2022-08-22 06:05:00 | AAPL | Stock | 168.85 | 168.98 | 168.85 | 168.97 | 5203.0 |
| 2022-08-22 06:10:00 | AAPL | Stock | 168.93 | 169.02 | 168.93 | 168.95 | 22708.0 |
| 2022-08-22 06:15:00 | AAPL | Stock | 168.95 | 169.02 | 168.95 | 169.0 | 1354.0 |
| 2022-08-22 06:20:00 | AAPL | Stock | 169.0 | 169.04 | 168.96 | 169.02 | 1713.0 |
| 2022-08-22 06:25:00 | AAPL | Stock | 168.95 | 168.95 | 168.95 | 168.95 | 100.0 |
| 2022-08-22 06:30:00 | AAPL | Stock | 168.89 | 168.89 | 168.87 | 168.87 | 1442.0 |
| 2022-08-22 06:35:00 | AAPL | Stock | 168.82 | 168.9 | 168.81 | 168.86 | 1080.0 |
| 2022-08-22 06:40:00 | AAPL | Stock | 168.88 | 168.88 | 168.7 | 168.7 | 1642.0 |
| 2022-08-22 06:45:00 | AAPL | Stock | 168.7 | 168.86 | 168.66 | 168.82 | 2513.0 |
| 2022-08-22 06:50:00 | AAPL | Stock | 168.83 | 168.9 | 168.83 | 168.9 | 974.0 |
| 2022-08-22 06:55:00 | AAPL | Stock | 168.87 | 168.94 | 168.79 | 168.88 | 2600.0 |
| 2022-08-22 07:00:00 | AAPL | Stock | 168.9 | 169.07 | 168.86 | 169.0 | 16220.0 |
| 2022-08-22 07:05:00 | AAPL | Stock | 168.98 | 169.02 | 168.9 | 168.9 | 19418.0 |
| 2022-08-22 07:10:00 | AAPL | Stock | 168.95 | 169.0 | 168.95 | 169.0 | 6288.0 |
| 2022-08-22 07:15:00 | AAPL | Stock | 169.02 | 169.2 | 169.02 | 169.2 | 24270.0 |
| 2022-08-22 07:20:00 | AAPL | Stock | 169.19 | 169.3 | 169.16 | 169.29 | 21255.0 |
| 2022-08-22 07:25:00 | AAPL | Stock | 169.29 | 169.29 | 169.16 | 169.16 | 9468.0 |
| 2022-08-22 07:30:00 | AAPL | Stock | 169.16 | 169.16 | 169.1 | 169.12 | 10468.0 |
| 2022-08-22 07:35:00 | AAPL | Stock | 169.11 | 169.2 | 169.11 | 169.19 | 8320.0 |
| 2022-08-22 07:40:00 | AAPL | Stock | 169.18 | 169.19 | 169.08 | 169.17 | 9649.0 |
| 2022-08-22 07:45:00 | AAPL | Stock | 169.21 | 169.27 | 169.19 | 169.21 | 9136.0 |
| 2022-08-22 07:50:00 | AAPL | Stock | 169.21 | 169.27 | 169.17 | 169.22 | 31049.0 |
| 2022-08-22 07:55:00 | AAPL | Stock | 169.22 | 169.26 | 169.14 | 169.15 | 35985.0 |
| 2022-08-22 08:00:00 | AAPL | Stock | 168.9499 | 171.092 | 168.5312 | 168.92 | 177977.0 |
| 2022-08-22 08:05:00 | AAPL | Stock | 168.88 | 168.95 | 168.68 | 168.7099 | 44698.0 |
> showing 50 of 432,234 rows — these rows as CSV