PREVIEW / stock_5min / 2024-10-10
file: by_date/stock_5min/2024/2024-10-10.parquet size: 6.5 MB rows: 385,782 symbols: 765
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-10-10 04:00:00 | AAPL | Stock | 229.4 | 229.4 | 229.15 | 229.15 | 2128.0 |
| 2024-10-10 04:05:00 | AAPL | Stock | 229.23 | 229.4 | 229.2 | 229.2 | 1168.0 |
| 2024-10-10 04:10:00 | AAPL | Stock | 229.18 | 229.18 | 229.18 | 229.18 | 100.0 |
| 2024-10-10 04:15:00 | AAPL | Stock | 229.03 | 229.04 | 228.97 | 228.97 | 400.0 |
| 2024-10-10 04:25:00 | AAPL | Stock | 228.94 | 228.95 | 228.94 | 228.95 | 257.0 |
| 2024-10-10 04:35:00 | AAPL | Stock | 228.94 | 229.03 | 228.91 | 228.91 | 490.0 |
| 2024-10-10 04:45:00 | AAPL | Stock | 228.82 | 228.82 | 228.82 | 228.82 | 100.0 |
| 2024-10-10 04:50:00 | AAPL | Stock | 228.76 | 228.84 | 228.76 | 228.84 | 250.0 |
| 2024-10-10 04:55:00 | AAPL | Stock | 228.83 | 228.83 | 228.83 | 228.83 | 250.0 |
| 2024-10-10 05:05:00 | AAPL | Stock | 228.84 | 228.9 | 228.84 | 228.89 | 1418.0 |
| 2024-10-10 05:10:00 | AAPL | Stock | 228.93 | 228.93 | 228.93 | 228.93 | 100.0 |
| 2024-10-10 05:25:00 | AAPL | Stock | 228.92 | 228.92 | 228.86 | 228.86 | 4656.0 |
| 2024-10-10 05:30:00 | AAPL | Stock | 228.93 | 228.93 | 228.36 | 228.45 | 7738.0 |
| 2024-10-10 05:35:00 | AAPL | Stock | 228.7 | 228.7 | 228.61 | 228.68 | 798.0 |
| 2024-10-10 05:40:00 | AAPL | Stock | 228.6 | 228.61 | 228.6 | 228.61 | 200.0 |
| 2024-10-10 05:45:00 | AAPL | Stock | 228.6 | 228.6 | 228.6 | 228.6 | 100.0 |
| 2024-10-10 05:50:00 | AAPL | Stock | 228.55 | 228.55 | 228.53 | 228.53 | 665.0 |
| 2024-10-10 05:55:00 | AAPL | Stock | 228.67 | 228.67 | 228.66 | 228.66 | 292.0 |
| 2024-10-10 06:00:00 | AAPL | Stock | 228.68 | 228.68 | 228.68 | 228.68 | 246.0 |
| 2024-10-10 06:05:00 | AAPL | Stock | 228.56 | 228.66 | 228.53 | 228.66 | 2739.0 |
| 2024-10-10 06:20:00 | AAPL | Stock | 228.66 | 228.66 | 228.63 | 228.63 | 3107.0 |
| 2024-10-10 06:25:00 | AAPL | Stock | 228.55 | 228.55 | 228.55 | 228.55 | 245.0 |
| 2024-10-10 06:30:00 | AAPL | Stock | 228.65 | 228.7 | 228.58 | 228.7 | 1821.0 |
| 2024-10-10 06:35:00 | AAPL | Stock | 228.75 | 228.75 | 228.71 | 228.71 | 932.0 |
| 2024-10-10 06:40:00 | AAPL | Stock | 228.72 | 228.72 | 228.58 | 228.58 | 1201.0 |
| 2024-10-10 06:45:00 | AAPL | Stock | 228.68 | 228.68 | 228.5 | 228.5 | 407.0 |
| 2024-10-10 06:50:00 | AAPL | Stock | 228.48 | 228.48 | 228.48 | 228.48 | 346.0 |
| 2024-10-10 06:55:00 | AAPL | Stock | 228.57 | 228.57 | 228.49 | 228.49 | 889.0 |
| 2024-10-10 07:00:00 | AAPL | Stock | 228.57 | 228.7 | 228.57 | 228.58 | 2827.0 |
| 2024-10-10 07:05:00 | AAPL | Stock | 228.58 | 228.65 | 228.47 | 228.65 | 3356.0 |
| 2024-10-10 07:10:00 | AAPL | Stock | 228.61 | 228.61 | 228.5 | 228.51 | 2232.0 |
| 2024-10-10 07:15:00 | AAPL | Stock | 228.64 | 228.64 | 228.54 | 228.54 | 1019.0 |
| 2024-10-10 07:20:00 | AAPL | Stock | 228.6 | 228.6 | 228.54 | 228.6 | 475.0 |
| 2024-10-10 07:25:00 | AAPL | Stock | 228.59 | 228.65 | 228.59 | 228.65 | 695.0 |
| 2024-10-10 07:30:00 | AAPL | Stock | 228.7 | 228.725 | 228.7 | 228.725 | 487.0 |
| 2024-10-10 07:35:00 | AAPL | Stock | 228.72 | 228.83 | 228.72 | 228.83 | 3683.0 |
| 2024-10-10 07:40:00 | AAPL | Stock | 228.85 | 228.85 | 228.85 | 228.85 | 100.0 |
| 2024-10-10 07:45:00 | AAPL | Stock | 228.79 | 228.79 | 228.76 | 228.76 | 200.0 |
| 2024-10-10 07:50:00 | AAPL | Stock | 228.8 | 228.95 | 228.8 | 228.91 | 1902.0 |
| 2024-10-10 07:55:00 | AAPL | Stock | 228.9 | 229.0 | 228.9 | 229.0 | 3661.0 |
| 2024-10-10 08:00:00 | AAPL | Stock | 228.6 | 228.96 | 228.49 | 228.9499 | 25008.0 |
| 2024-10-10 08:05:00 | AAPL | Stock | 228.95 | 229.1 | 228.95 | 229.1 | 3388.0 |
| 2024-10-10 08:10:00 | AAPL | Stock | 229.09 | 229.09 | 228.8 | 228.8 | 4571.0 |
| 2024-10-10 08:15:00 | AAPL | Stock | 228.92 | 229.01 | 228.92 | 228.93 | 650.0 |
| 2024-10-10 08:20:00 | AAPL | Stock | 228.89 | 228.89 | 228.81 | 228.88 | 3541.0 |
| 2024-10-10 08:25:00 | AAPL | Stock | 228.88 | 228.95 | 228.81 | 228.95 | 5196.0 |
| 2024-10-10 08:30:00 | AAPL | Stock | 229.01 | 229.1 | 228.0 | 228.75 | 99840.0 |
| 2024-10-10 08:35:00 | AAPL | Stock | 228.75 | 228.78 | 227.94 | 228.26 | 48142.0 |
| 2024-10-10 08:40:00 | AAPL | Stock | 228.289 | 228.289 | 227.75 | 228.1 | 58778.0 |
| 2024-10-10 08:45:00 | AAPL | Stock | 228.1945 | 228.45 | 227.91 | 228.26 | 19115.0 |
> showing 50 of 385,782 rows — these rows as CSV