PREVIEW / stock_5min / 2024-08-29
file: by_date/stock_5min/2024/2024-08-29.parquet size: 6.4 MB rows: 385,937 symbols: 819
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-08-29 04:00:00 | AAPL | Stock | 226.89 | 228.32 | 226.89 | 228.0 | 10358.0 |
| 2024-08-29 04:05:00 | AAPL | Stock | 228.25 | 228.46 | 228.01 | 228.46 | 2763.0 |
| 2024-08-29 04:10:00 | AAPL | Stock | 228.46 | 228.8 | 228.46 | 228.6 | 4865.0 |
| 2024-08-29 04:15:00 | AAPL | Stock | 228.76 | 228.76 | 228.49 | 228.6 | 2759.0 |
| 2024-08-29 04:20:00 | AAPL | Stock | 228.7 | 228.7 | 228.39 | 228.39 | 2302.0 |
| 2024-08-29 04:25:00 | AAPL | Stock | 228.4 | 228.43 | 228.19 | 228.23 | 2049.0 |
| 2024-08-29 04:30:00 | AAPL | Stock | 228.35 | 228.35 | 228.35 | 228.35 | 362.0 |
| 2024-08-29 04:35:00 | AAPL | Stock | 228.44 | 228.44 | 228.44 | 228.44 | 100.0 |
| 2024-08-29 04:40:00 | AAPL | Stock | 228.34 | 228.43 | 228.34 | 228.43 | 227.0 |
| 2024-08-29 04:45:00 | AAPL | Stock | 228.48 | 228.69 | 228.48 | 228.68 | 4027.0 |
| 2024-08-29 04:50:00 | AAPL | Stock | 228.6 | 228.61 | 228.6 | 228.61 | 682.0 |
| 2024-08-29 04:55:00 | AAPL | Stock | 228.6 | 228.77 | 228.5 | 228.77 | 1722.0 |
| 2024-08-29 05:00:00 | AAPL | Stock | 228.73 | 228.82 | 228.63 | 228.82 | 4105.0 |
| 2024-08-29 05:05:00 | AAPL | Stock | 228.88 | 229.0 | 228.88 | 229.0 | 3260.0 |
| 2024-08-29 05:10:00 | AAPL | Stock | 228.99 | 229.0 | 228.98 | 228.98 | 3877.0 |
| 2024-08-29 05:15:00 | AAPL | Stock | 228.93 | 229.11 | 228.93 | 229.1 | 6555.0 |
| 2024-08-29 05:20:00 | AAPL | Stock | 229.01 | 229.1 | 229.0 | 229.0 | 10643.0 |
| 2024-08-29 05:25:00 | AAPL | Stock | 229.0 | 229.19 | 228.92 | 229.16 | 3937.0 |
| 2024-08-29 05:30:00 | AAPL | Stock | 229.16 | 229.16 | 228.8 | 228.9 | 4221.0 |
| 2024-08-29 05:35:00 | AAPL | Stock | 228.82 | 228.98 | 228.82 | 228.9 | 400.0 |
| 2024-08-29 05:40:00 | AAPL | Stock | 228.89 | 228.96 | 228.89 | 228.96 | 1095.0 |
| 2024-08-29 05:45:00 | AAPL | Stock | 228.78 | 229.19 | 228.78 | 229.07 | 2148.0 |
| 2024-08-29 05:50:00 | AAPL | Stock | 229.12 | 229.2 | 229.12 | 229.19 | 3280.0 |
| 2024-08-29 05:55:00 | AAPL | Stock | 229.09 | 229.38 | 229.01 | 229.21 | 3395.0 |
| 2024-08-29 06:00:00 | AAPL | Stock | 229.33 | 229.74 | 229.32 | 229.65 | 3819.0 |
| 2024-08-29 06:05:00 | AAPL | Stock | 229.5 | 229.57 | 229.28 | 229.34 | 1908.0 |
| 2024-08-29 06:10:00 | AAPL | Stock | 229.32 | 229.4 | 229.16 | 229.28 | 1255.0 |
| 2024-08-29 06:15:00 | AAPL | Stock | 229.2 | 229.23 | 229.16 | 229.2 | 1668.0 |
| 2024-08-29 06:20:00 | AAPL | Stock | 229.12 | 229.36 | 229.08 | 229.36 | 3625.0 |
| 2024-08-29 06:25:00 | AAPL | Stock | 229.34 | 229.34 | 229.28 | 229.3 | 2722.0 |
| 2024-08-29 06:30:00 | AAPL | Stock | 229.34 | 229.4 | 229.18 | 229.18 | 2199.0 |
| 2024-08-29 06:35:00 | AAPL | Stock | 229.01 | 229.08 | 229.0 | 229.0 | 4733.0 |
| 2024-08-29 06:40:00 | AAPL | Stock | 228.94 | 229.04 | 228.9 | 229.0 | 3722.0 |
| 2024-08-29 06:45:00 | AAPL | Stock | 229.0 | 229.35 | 229.0 | 229.28 | 4044.0 |
| 2024-08-29 06:50:00 | AAPL | Stock | 229.27 | 229.3 | 229.21 | 229.21 | 1854.0 |
| 2024-08-29 06:55:00 | AAPL | Stock | 229.2 | 229.25 | 229.2 | 229.25 | 1309.0 |
| 2024-08-29 07:00:00 | AAPL | Stock | 229.25 | 229.5 | 229.16 | 229.5 | 25682.0 |
| 2024-08-29 07:05:00 | AAPL | Stock | 229.5 | 229.88 | 229.5 | 229.88 | 16979.0 |
| 2024-08-29 07:10:00 | AAPL | Stock | 229.88 | 230.0 | 229.76 | 229.79 | 25705.0 |
| 2024-08-29 07:15:00 | AAPL | Stock | 229.8 | 229.89 | 229.76 | 229.89 | 7294.0 |
| 2024-08-29 07:20:00 | AAPL | Stock | 229.89 | 229.99 | 229.86 | 229.9 | 15542.0 |
| 2024-08-29 07:25:00 | AAPL | Stock | 229.89 | 229.95 | 229.8 | 229.88 | 4476.0 |
| 2024-08-29 07:30:00 | AAPL | Stock | 229.86 | 230.0 | 229.86 | 229.98 | 14310.0 |
| 2024-08-29 07:35:00 | AAPL | Stock | 229.99 | 230.2 | 229.84 | 230.15 | 36223.0 |
| 2024-08-29 07:40:00 | AAPL | Stock | 230.17 | 230.29 | 230.12 | 230.29 | 7651.0 |
| 2024-08-29 07:45:00 | AAPL | Stock | 230.27 | 230.39 | 230.2 | 230.39 | 16656.0 |
| 2024-08-29 07:50:00 | AAPL | Stock | 230.39 | 230.39 | 230.2 | 230.31 | 2832.0 |
| 2024-08-29 07:55:00 | AAPL | Stock | 230.2 | 230.2 | 229.98 | 229.98 | 11500.0 |
| 2024-08-29 08:00:00 | AAPL | Stock | 229.4 | 230.4179 | 226.87 | 229.83 | 138927.0 |
| 2024-08-29 08:05:00 | AAPL | Stock | 229.8756 | 229.9572 | 229.82 | 229.8527 | 2947.0 |
> showing 50 of 385,937 rows — these rows as CSV