PREVIEW / etf_5min / 2025-07-31
file: by_date/etf_5min/2025/2025-07-31.parquet size: 2.9 MB rows: 147,964
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-31 04:00:00 | SPY | ETF | 640.64 | 641.34 | 640.22 | 641.02 | 27266.0 |
| 2025-07-31 04:05:00 | SPY | ETF | 641.1 | 641.25 | 641.03 | 641.15 | 5403.0 |
| 2025-07-31 04:10:00 | SPY | ETF | 641.18 | 641.22 | 641.02 | 641.02 | 4827.0 |
| 2025-07-31 04:15:00 | SPY | ETF | 641.05 | 641.1 | 640.97 | 641.1 | 982.0 |
| 2025-07-31 04:20:00 | SPY | ETF | 641.21 | 641.21 | 641.0 | 641.12 | 4715.0 |
| 2025-07-31 04:25:00 | SPY | ETF | 641.29 | 641.29 | 641.11 | 641.11 | 1325.0 |
| 2025-07-31 04:30:00 | SPY | ETF | 641.09 | 641.14 | 641.08 | 641.14 | 900.0 |
| 2025-07-31 04:35:00 | SPY | ETF | 641.22 | 641.26 | 641.22 | 641.26 | 760.0 |
| 2025-07-31 04:40:00 | SPY | ETF | 641.24 | 641.24 | 640.96 | 640.98 | 13788.0 |
| 2025-07-31 04:45:00 | SPY | ETF | 640.95 | 641.3 | 640.95 | 641.3 | 700.0 |
| 2025-07-31 04:50:00 | SPY | ETF | 641.33 | 641.46 | 640.93 | 640.93 | 3400.0 |
| 2025-07-31 04:55:00 | SPY | ETF | 640.94 | 640.98 | 640.86 | 640.98 | 2630.0 |
| 2025-07-31 05:00:00 | SPY | ETF | 641.0 | 641.02 | 640.84 | 640.9 | 17370.0 |
| 2025-07-31 05:05:00 | SPY | ETF | 640.88 | 640.94 | 640.76 | 640.76 | 4882.0 |
| 2025-07-31 05:10:00 | SPY | ETF | 640.76 | 640.79 | 640.69 | 640.76 | 1000.0 |
| 2025-07-31 05:15:00 | SPY | ETF | 640.81 | 640.87 | 640.81 | 640.85 | 640.0 |
| 2025-07-31 05:20:00 | SPY | ETF | 640.85 | 640.94 | 640.85 | 640.94 | 1560.0 |
| 2025-07-31 05:25:00 | SPY | ETF | 640.92 | 640.93 | 640.78 | 640.79 | 1398.0 |
| 2025-07-31 05:30:00 | SPY | ETF | 640.62 | 640.62 | 640.46 | 640.46 | 1769.0 |
| 2025-07-31 05:35:00 | SPY | ETF | 640.42 | 640.47 | 640.4 | 640.47 | 1640.0 |
| 2025-07-31 05:40:00 | SPY | ETF | 640.49 | 640.62 | 640.42 | 640.52 | 3342.0 |
| 2025-07-31 05:45:00 | SPY | ETF | 640.58 | 640.64 | 640.56 | 640.64 | 1000.0 |
| 2025-07-31 05:50:00 | SPY | ETF | 640.58 | 640.59 | 640.52 | 640.53 | 700.0 |
| 2025-07-31 05:55:00 | SPY | ETF | 640.63 | 640.64 | 640.54 | 640.57 | 2410.0 |
| 2025-07-31 06:00:00 | SPY | ETF | 640.56 | 640.57 | 640.44 | 640.51 | 3150.0 |
| 2025-07-31 06:05:00 | SPY | ETF | 640.55 | 640.56 | 640.42 | 640.48 | 640.0 |
| 2025-07-31 06:10:00 | SPY | ETF | 640.48 | 640.55 | 640.44 | 640.55 | 1410.0 |
| 2025-07-31 06:15:00 | SPY | ETF | 640.65 | 640.72 | 640.63 | 640.72 | 1236.0 |
| 2025-07-31 06:20:00 | SPY | ETF | 640.65 | 640.68 | 640.65 | 640.66 | 1765.0 |
| 2025-07-31 06:25:00 | SPY | ETF | 640.8 | 640.83 | 640.8 | 640.8 | 1621.0 |
| 2025-07-31 06:30:00 | SPY | ETF | 640.75 | 640.91 | 640.75 | 640.91 | 2106.0 |
| 2025-07-31 06:35:00 | SPY | ETF | 640.93 | 640.95 | 640.78 | 640.78 | 738.0 |
| 2025-07-31 06:40:00 | SPY | ETF | 640.81 | 640.83 | 640.75 | 640.75 | 5869.0 |
| 2025-07-31 06:45:00 | SPY | ETF | 640.71 | 640.73 | 640.65 | 640.72 | 4258.0 |
| 2025-07-31 06:50:00 | SPY | ETF | 640.72 | 640.82 | 640.29 | 640.31 | 66910.0 |
| 2025-07-31 06:55:00 | SPY | ETF | 640.4 | 640.4 | 639.97 | 640.08 | 24484.0 |
| 2025-07-31 07:00:00 | SPY | ETF | 640.01 | 640.37 | 640.0 | 640.36 | 9403.0 |
| 2025-07-31 07:05:00 | SPY | ETF | 640.35 | 640.4 | 640.18 | 640.18 | 1850.0 |
| 2025-07-31 07:10:00 | SPY | ETF | 640.02 | 640.25 | 639.69 | 640.15 | 76149.0 |
| 2025-07-31 07:15:00 | SPY | ETF | 640.15 | 640.26 | 640.14 | 640.22 | 1661.0 |
| 2025-07-31 07:20:00 | SPY | ETF | 640.15 | 640.15 | 639.95 | 639.97 | 17231.0 |
| 2025-07-31 07:25:00 | SPY | ETF | 639.97 | 640.07 | 639.9 | 639.9 | 2600.0 |
| 2025-07-31 07:30:00 | SPY | ETF | 639.94 | 640.081 | 639.93 | 640.081 | 3590.0 |
| 2025-07-31 07:35:00 | SPY | ETF | 640.06 | 640.22 | 639.989 | 640.2 | 15516.0 |
| 2025-07-31 07:40:00 | SPY | ETF | 640.19 | 640.19 | 639.85 | 640.01 | 12199.0 |
| 2025-07-31 07:45:00 | SPY | ETF | 640.01 | 640.41 | 639.95 | 640.24 | 7356.0 |
| 2025-07-31 07:50:00 | SPY | ETF | 640.08 | 640.13 | 639.83 | 639.83 | 19997.0 |
| 2025-07-31 07:55:00 | SPY | ETF | 639.83 | 639.94 | 639.73 | 639.83 | 67189.0 |
| 2025-07-31 08:00:00 | SPY | ETF | 640.23 | 641.52 | 639.66 | 639.95 | 121770.0 |
| 2025-07-31 08:05:00 | SPY | ETF | 639.94 | 640.08 | 639.91 | 640.0104 | 8118.0 |
> showing 50 of 147,964 rows — these rows as CSV