PREVIEW / stock_5min / 2024-03-06
file: by_date/stock_5min/2024/2024-03-06.parquet size: 6.9 MB rows: 417,170 symbols: 1,120
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-06 04:00:00 | AAPL | Stock | 170.12 | 172.0 | 169.63 | 170.96 | 13738.0 |
| 2024-03-06 04:05:00 | AAPL | Stock | 170.98 | 171.0 | 170.92 | 170.92 | 6584.0 |
| 2024-03-06 04:10:00 | AAPL | Stock | 170.88 | 170.91 | 170.88 | 170.89 | 2125.0 |
| 2024-03-06 04:15:00 | AAPL | Stock | 170.9 | 171.14 | 170.9 | 171.14 | 2599.0 |
| 2024-03-06 04:20:00 | AAPL | Stock | 171.0 | 171.04 | 170.84 | 170.85 | 4476.0 |
| 2024-03-06 04:25:00 | AAPL | Stock | 170.9 | 170.99 | 170.89 | 170.99 | 2607.0 |
| 2024-03-06 04:30:00 | AAPL | Stock | 170.9 | 171.02 | 170.9 | 171.02 | 920.0 |
| 2024-03-06 04:35:00 | AAPL | Stock | 171.04 | 171.05 | 171.04 | 171.05 | 6528.0 |
| 2024-03-06 04:40:00 | AAPL | Stock | 171.1 | 171.14 | 171.1 | 171.14 | 513.0 |
| 2024-03-06 04:45:00 | AAPL | Stock | 171.0 | 171.0 | 170.95 | 171.0 | 2595.0 |
| 2024-03-06 04:50:00 | AAPL | Stock | 170.9 | 170.98 | 170.9 | 170.98 | 502.0 |
| 2024-03-06 04:55:00 | AAPL | Stock | 171.0 | 171.0 | 170.99 | 170.99 | 709.0 |
| 2024-03-06 05:00:00 | AAPL | Stock | 171.05 | 171.05 | 171.04 | 171.04 | 1497.0 |
| 2024-03-06 05:05:00 | AAPL | Stock | 171.03 | 171.06 | 171.03 | 171.06 | 605.0 |
| 2024-03-06 05:10:00 | AAPL | Stock | 171.06 | 171.1 | 171.03 | 171.1 | 3074.0 |
| 2024-03-06 05:15:00 | AAPL | Stock | 171.08 | 171.09 | 171.08 | 171.09 | 490.0 |
| 2024-03-06 05:20:00 | AAPL | Stock | 171.1 | 171.29 | 171.1 | 171.29 | 3108.0 |
| 2024-03-06 05:25:00 | AAPL | Stock | 171.36 | 171.38 | 171.3 | 171.3 | 1180.0 |
| 2024-03-06 05:30:00 | AAPL | Stock | 171.26 | 171.26 | 171.2 | 171.21 | 1496.0 |
| 2024-03-06 05:35:00 | AAPL | Stock | 171.25 | 171.25 | 171.2 | 171.2 | 315.0 |
| 2024-03-06 05:40:00 | AAPL | Stock | 171.07 | 171.07 | 170.95 | 170.95 | 1985.0 |
| 2024-03-06 05:45:00 | AAPL | Stock | 170.9 | 170.91 | 170.89 | 170.89 | 1306.0 |
| 2024-03-06 05:50:00 | AAPL | Stock | 170.97 | 171.0 | 170.97 | 171.0 | 253.0 |
| 2024-03-06 05:55:00 | AAPL | Stock | 171.05 | 171.05 | 171.0 | 171.04 | 5524.0 |
| 2024-03-06 06:00:00 | AAPL | Stock | 170.99 | 171.0 | 170.88 | 171.0 | 3350.0 |
| 2024-03-06 06:05:00 | AAPL | Stock | 171.04 | 171.21 | 171.04 | 171.1 | 1092.0 |
| 2024-03-06 06:10:00 | AAPL | Stock | 171.11 | 171.22 | 171.1 | 171.17 | 3016.0 |
| 2024-03-06 06:15:00 | AAPL | Stock | 171.3 | 171.3 | 171.29 | 171.29 | 486.0 |
| 2024-03-06 06:20:00 | AAPL | Stock | 171.2 | 171.23 | 171.2 | 171.23 | 7013.0 |
| 2024-03-06 06:30:00 | AAPL | Stock | 171.21 | 171.21 | 171.2 | 171.2 | 234.0 |
| 2024-03-06 06:35:00 | AAPL | Stock | 171.24 | 171.27 | 171.24 | 171.27 | 500.0 |
| 2024-03-06 06:40:00 | AAPL | Stock | 171.24 | 171.25 | 171.02 | 171.02 | 1104.0 |
| 2024-03-06 06:45:00 | AAPL | Stock | 171.11 | 171.11 | 171.11 | 171.11 | 538.0 |
| 2024-03-06 06:50:00 | AAPL | Stock | 171.11 | 171.11 | 171.11 | 171.11 | 433.0 |
| 2024-03-06 06:55:00 | AAPL | Stock | 170.98 | 170.98 | 170.75 | 170.81 | 4825.0 |
| 2024-03-06 07:00:00 | AAPL | Stock | 170.86 | 170.88 | 170.4 | 170.58 | 16972.0 |
| 2024-03-06 07:05:00 | AAPL | Stock | 170.55 | 170.85 | 170.54 | 170.78 | 6738.0 |
| 2024-03-06 07:10:00 | AAPL | Stock | 170.76 | 170.76 | 170.59 | 170.66 | 5355.0 |
| 2024-03-06 07:15:00 | AAPL | Stock | 170.65 | 170.65 | 170.52 | 170.56 | 1757.0 |
| 2024-03-06 07:20:00 | AAPL | Stock | 170.58 | 170.58 | 170.38 | 170.38 | 9719.0 |
| 2024-03-06 07:25:00 | AAPL | Stock | 170.4 | 170.5 | 170.4 | 170.49 | 2417.0 |
| 2024-03-06 07:30:00 | AAPL | Stock | 170.51 | 170.6 | 170.51 | 170.6 | 1504.0 |
| 2024-03-06 07:35:00 | AAPL | Stock | 170.6 | 170.65 | 170.6 | 170.62 | 2745.0 |
| 2024-03-06 07:40:00 | AAPL | Stock | 170.7 | 170.85 | 170.7 | 170.8 | 9543.0 |
| 2024-03-06 07:45:00 | AAPL | Stock | 170.79 | 170.8 | 170.75 | 170.75 | 4350.0 |
| 2024-03-06 07:50:00 | AAPL | Stock | 170.75 | 170.8 | 170.75 | 170.78 | 1524.0 |
| 2024-03-06 07:55:00 | AAPL | Stock | 170.79 | 170.88 | 170.79 | 170.82 | 4493.0 |
| 2024-03-06 08:00:00 | AAPL | Stock | 170.69 | 171.1238 | 169.93 | 170.9 | 91749.0 |
| 2024-03-06 08:05:00 | AAPL | Stock | 170.9292 | 170.99 | 169.93 | 170.98 | 35261.0 |
| 2024-03-06 08:10:00 | AAPL | Stock | 170.95 | 171.04 | 170.9213 | 171.0 | 23755.0 |
> showing 50 of 417,170 rows — these rows as CSV