PREVIEW / etf_5min / 2026-07-31
file: by_date/etf_5min/2026/2026-07-31.parquet size: 3.0 MB rows: 169,226
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 |
|---|---|---|---|---|---|---|---|
| 2026-07-31 04:00:00 | SPY | ETF | 745.06 | 745.92 | 744.02 | 745.265 | 48593.0 |
| 2026-07-31 04:05:00 | SPY | ETF | 745.2 | 745.69 | 745.2 | 745.43 | 7709.0 |
| 2026-07-31 04:10:00 | SPY | ETF | 745.36 | 745.81 | 745.3 | 745.79 | 5841.0 |
| 2026-07-31 04:15:00 | SPY | ETF | 745.79 | 746.07 | 745.79 | 746.07 | 3622.0 |
| 2026-07-31 04:20:00 | SPY | ETF | 746.01 | 746.01 | 745.64 | 745.69 | 9492.0 |
| 2026-07-31 04:25:00 | SPY | ETF | 745.73 | 746.08 | 745.72 | 746.03 | 1477.0 |
| 2026-07-31 04:30:00 | SPY | ETF | 745.85 | 745.95 | 745.72 | 745.8 | 1516.0 |
| 2026-07-31 04:35:00 | SPY | ETF | 745.79 | 745.82 | 745.62 | 745.64 | 3976.0 |
| 2026-07-31 04:40:00 | SPY | ETF | 745.6 | 745.82 | 745.5783 | 745.6 | 6273.0 |
| 2026-07-31 04:45:00 | SPY | ETF | 745.89 | 745.98 | 745.84 | 745.9 | 2143.0 |
| 2026-07-31 04:50:00 | SPY | ETF | 745.9 | 745.94 | 745.82 | 745.82 | 3502.0 |
| 2026-07-31 04:55:00 | SPY | ETF | 745.81 | 746.15 | 745.81 | 746.09 | 5583.0 |
| 2026-07-31 05:00:00 | SPY | ETF | 746.05 | 746.22 | 745.99 | 746.11 | 5213.0 |
| 2026-07-31 05:05:00 | SPY | ETF | 746.0 | 746.27 | 746.0 | 746.2 | 8461.0 |
| 2026-07-31 05:10:00 | SPY | ETF | 746.28 | 746.5454 | 746.26 | 746.36 | 4618.0 |
| 2026-07-31 05:15:00 | SPY | ETF | 746.45 | 746.45 | 746.25 | 746.37 | 10266.0 |
| 2026-07-31 05:20:00 | SPY | ETF | 746.1811 | 746.29 | 746.09 | 746.2 | 2067.0 |
| 2026-07-31 05:25:00 | SPY | ETF | 746.19 | 746.25 | 745.93 | 745.93 | 2519.0 |
| 2026-07-31 05:30:00 | SPY | ETF | 745.95 | 746.0 | 745.57 | 745.6 | 8379.0 |
| 2026-07-31 05:35:00 | SPY | ETF | 745.61 | 745.61 | 745.19 | 745.27 | 7735.0 |
| 2026-07-31 05:40:00 | SPY | ETF | 745.31 | 745.49 | 745.3 | 745.49 | 3155.0 |
| 2026-07-31 05:45:00 | SPY | ETF | 745.6 | 745.6 | 745.46 | 745.48 | 617.0 |
| 2026-07-31 05:50:00 | SPY | ETF | 745.5 | 745.5 | 745.3 | 745.3 | 1100.0 |
| 2026-07-31 05:55:00 | SPY | ETF | 745.36 | 745.36 | 745.18 | 745.18 | 782.0 |
| 2026-07-31 06:00:00 | SPY | ETF | 745.12 | 745.335 | 745.05 | 745.18 | 4726.0 |
| 2026-07-31 06:05:00 | SPY | ETF | 745.15 | 745.3 | 745.15 | 745.2 | 3278.0 |
| 2026-07-31 06:10:00 | SPY | ETF | 745.42 | 745.6 | 745.42 | 745.56 | 4868.0 |
| 2026-07-31 06:15:00 | SPY | ETF | 745.53 | 745.79 | 745.51 | 745.72 | 2431.0 |
| 2026-07-31 06:20:00 | SPY | ETF | 745.8 | 745.98 | 745.8 | 745.84 | 4496.0 |
| 2026-07-31 06:25:00 | SPY | ETF | 745.66 | 745.81 | 745.66 | 745.715 | 1144.0 |
| 2026-07-31 06:30:00 | SPY | ETF | 745.72 | 745.84 | 745.4 | 745.4 | 11728.0 |
| 2026-07-31 06:35:00 | SPY | ETF | 745.43 | 745.43 | 745.24 | 745.34 | 2745.0 |
| 2026-07-31 06:40:00 | SPY | ETF | 745.54 | 745.64 | 745.5 | 745.64 | 962.0 |
| 2026-07-31 06:45:00 | SPY | ETF | 745.69 | 745.69 | 745.24 | 745.24 | 4397.0 |
| 2026-07-31 06:50:00 | SPY | ETF | 745.3224 | 745.59 | 745.3224 | 745.44 | 528.0 |
| 2026-07-31 06:55:00 | SPY | ETF | 745.53 | 745.55 | 745.38 | 745.45 | 2754.0 |
| 2026-07-31 07:00:00 | SPY | ETF | 745.46 | 745.86 | 745.37 | 745.85 | 13050.0 |
| 2026-07-31 07:05:00 | SPY | ETF | 745.9 | 745.9 | 745.73 | 745.76 | 6992.0 |
| 2026-07-31 07:10:00 | SPY | ETF | 745.73 | 745.73 | 745.41 | 745.54 | 3523.0 |
| 2026-07-31 07:15:00 | SPY | ETF | 745.41 | 745.41 | 744.9 | 745.11 | 21431.0 |
| 2026-07-31 07:20:00 | SPY | ETF | 745.109 | 745.13 | 744.99 | 745.08 | 10656.0 |
| 2026-07-31 07:25:00 | SPY | ETF | 745.101 | 745.21 | 744.78 | 744.86 | 26562.0 |
| 2026-07-31 07:30:00 | SPY | ETF | 744.84 | 744.84 | 744.41 | 744.51 | 9249.0 |
| 2026-07-31 07:35:00 | SPY | ETF | 744.55 | 744.78 | 744.38 | 744.4 | 3412.0 |
| 2026-07-31 07:40:00 | SPY | ETF | 744.36 | 744.5 | 744.3 | 744.4568 | 16200.0 |
| 2026-07-31 07:45:00 | SPY | ETF | 744.4 | 744.7062 | 744.4 | 744.63 | 15164.0 |
| 2026-07-31 07:50:00 | SPY | ETF | 744.57 | 744.77 | 744.57 | 744.77 | 6762.0 |
| 2026-07-31 07:55:00 | SPY | ETF | 744.69 | 744.8 | 744.63 | 744.71 | 3422.0 |
| 2026-07-31 08:00:00 | SPY | ETF | 744.68 | 744.68 | 744.09 | 744.11 | 21220.0 |
| 2026-07-31 08:05:00 | SPY | ETF | 744.1487 | 744.1487 | 743.94 | 743.96 | 12558.0 |
> showing 50 of 169,226 rows — these rows as CSV