PREVIEW / etf_5min / 2025-07-07
file: by_date/etf_5min/2025/2025-07-07.parquet size: 2.9 MB rows: 147,198
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 |
|---|---|---|---|---|---|---|---|
| 2025-07-07 04:00:00 | SPY | ETF | 623.38 | 623.38 | 620.0 | 622.93 | 26812.0 |
| 2025-07-07 04:05:00 | SPY | ETF | 622.98 | 622.98 | 622.66 | 622.66 | 2270.0 |
| 2025-07-07 04:10:00 | SPY | ETF | 622.61 | 622.66 | 622.48 | 622.65 | 4834.0 |
| 2025-07-07 04:15:00 | SPY | ETF | 622.62 | 622.67 | 622.47 | 622.57 | 3287.0 |
| 2025-07-07 04:20:00 | SPY | ETF | 622.78 | 622.78 | 622.76 | 622.76 | 200.0 |
| 2025-07-07 04:25:00 | SPY | ETF | 622.82 | 622.97 | 622.78 | 622.87 | 2321.0 |
| 2025-07-07 04:30:00 | SPY | ETF | 622.88 | 622.88 | 622.7 | 622.86 | 1813.0 |
| 2025-07-07 04:35:00 | SPY | ETF | 622.83 | 622.89 | 622.83 | 622.87 | 900.0 |
| 2025-07-07 04:40:00 | SPY | ETF | 622.87 | 622.87 | 622.74 | 622.74 | 1050.0 |
| 2025-07-07 04:45:00 | SPY | ETF | 622.81 | 622.82 | 622.58 | 622.6 | 2208.0 |
| 2025-07-07 04:50:00 | SPY | ETF | 622.6 | 622.69 | 622.53 | 622.69 | 1400.0 |
| 2025-07-07 04:55:00 | SPY | ETF | 622.65 | 622.65 | 622.63 | 622.63 | 400.0 |
| 2025-07-07 05:00:00 | SPY | ETF | 622.5 | 622.59 | 622.47 | 622.49 | 15116.0 |
| 2025-07-07 05:05:00 | SPY | ETF | 622.58 | 622.75 | 622.57 | 622.61 | 6502.0 |
| 2025-07-07 05:10:00 | SPY | ETF | 622.63 | 622.63 | 622.62 | 622.62 | 400.0 |
| 2025-07-07 05:15:00 | SPY | ETF | 622.72 | 622.74 | 622.72 | 622.74 | 500.0 |
| 2025-07-07 05:20:00 | SPY | ETF | 622.77 | 622.77 | 622.65 | 622.65 | 1300.0 |
| 2025-07-07 05:25:00 | SPY | ETF | 622.67 | 622.71 | 622.67 | 622.71 | 363.0 |
| 2025-07-07 05:30:00 | SPY | ETF | 622.7 | 622.75 | 622.7 | 622.75 | 200.0 |
| 2025-07-07 05:35:00 | SPY | ETF | 622.78 | 623.06 | 622.77 | 623.06 | 7234.0 |
| 2025-07-07 05:40:00 | SPY | ETF | 623.1 | 623.21 | 623.03 | 623.21 | 500.0 |
| 2025-07-07 05:45:00 | SPY | ETF | 623.04 | 623.05 | 622.98 | 623.04 | 800.0 |
| 2025-07-07 05:50:00 | SPY | ETF | 623.03 | 623.46 | 623.03 | 623.46 | 2230.0 |
| 2025-07-07 05:55:00 | SPY | ETF | 623.45 | 623.76 | 623.45 | 623.76 | 8523.0 |
| 2025-07-07 06:00:00 | SPY | ETF | 623.68 | 623.86 | 623.66 | 623.86 | 1408.0 |
| 2025-07-07 06:05:00 | SPY | ETF | 623.85 | 624.03 | 623.83 | 624.03 | 3306.0 |
| 2025-07-07 06:10:00 | SPY | ETF | 623.97 | 624.22 | 623.97 | 624.13 | 1600.0 |
| 2025-07-07 06:15:00 | SPY | ETF | 623.93 | 623.93 | 623.73 | 623.8 | 11111.0 |
| 2025-07-07 06:20:00 | SPY | ETF | 623.81 | 623.97 | 623.81 | 623.92 | 4586.0 |
| 2025-07-07 06:25:00 | SPY | ETF | 623.91 | 623.99 | 623.88 | 623.93 | 7897.0 |
| 2025-07-07 06:30:00 | SPY | ETF | 623.92 | 623.98 | 623.92 | 623.93 | 2920.0 |
| 2025-07-07 06:35:00 | SPY | ETF | 624.04 | 624.04 | 624.04 | 624.04 | 300.0 |
| 2025-07-07 06:40:00 | SPY | ETF | 623.8 | 623.86 | 623.8 | 623.86 | 623.0 |
| 2025-07-07 06:45:00 | SPY | ETF | 623.88 | 623.88 | 623.75 | 623.8 | 10643.0 |
| 2025-07-07 06:50:00 | SPY | ETF | 623.76 | 623.76 | 623.66 | 623.7 | 2482.0 |
| 2025-07-07 06:55:00 | SPY | ETF | 623.7 | 623.73 | 623.6 | 623.62 | 2100.0 |
| 2025-07-07 07:00:00 | SPY | ETF | 623.6 | 623.81 | 623.6 | 623.75 | 10475.0 |
| 2025-07-07 07:05:00 | SPY | ETF | 623.75 | 623.8 | 623.65 | 623.75 | 6744.0 |
| 2025-07-07 07:10:00 | SPY | ETF | 623.71 | 623.71 | 623.62 | 623.68 | 2420.0 |
| 2025-07-07 07:15:00 | SPY | ETF | 623.66 | 623.73 | 623.61 | 623.61 | 2563.0 |
| 2025-07-07 07:20:00 | SPY | ETF | 623.66 | 623.759 | 623.65 | 623.739 | 1433.0 |
| 2025-07-07 07:25:00 | SPY | ETF | 623.8 | 623.99 | 623.77 | 623.99 | 5726.0 |
| 2025-07-07 07:30:00 | SPY | ETF | 623.99 | 623.99 | 623.77 | 623.85 | 2871.0 |
| 2025-07-07 07:35:00 | SPY | ETF | 623.85 | 623.93 | 623.69 | 623.7 | 19874.0 |
| 2025-07-07 07:40:00 | SPY | ETF | 623.7 | 624.07 | 623.68 | 623.9 | 20528.0 |
| 2025-07-07 07:45:00 | SPY | ETF | 623.9 | 624.06 | 623.87 | 624.06 | 13898.0 |
| 2025-07-07 07:50:00 | SPY | ETF | 624.09 | 624.09 | 623.98 | 624.02 | 2796.0 |
| 2025-07-07 07:55:00 | SPY | ETF | 624.101 | 624.21 | 624.1 | 624.19 | 2953.0 |
| 2025-07-07 08:00:00 | SPY | ETF | 624.14 | 624.14 | 622.45 | 623.98 | 42100.0 |
| 2025-07-07 08:05:00 | SPY | ETF | 623.98 | 624.42 | 623.98 | 624.28 | 19058.0 |
> showing 50 of 147,198 rows — these rows as CSV