PREVIEW / etf_5min / 2025-07-16
file: by_date/etf_5min/2025/2025-07-16.parquet size: 2.9 MB rows: 142,622
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-16 04:00:00 | SPY | ETF | 621.88 | 621.88 | 620.89 | 621.06 | 11287.0 |
| 2025-07-16 04:05:00 | SPY | ETF | 621.02 | 621.3 | 620.97 | 621.19 | 7420.0 |
| 2025-07-16 04:10:00 | SPY | ETF | 621.08 | 621.25 | 621.06 | 621.17 | 5138.0 |
| 2025-07-16 04:15:00 | SPY | ETF | 621.19 | 621.23 | 621.09 | 621.14 | 2800.0 |
| 2025-07-16 04:20:00 | SPY | ETF | 621.25 | 621.51 | 621.25 | 621.37 | 5220.0 |
| 2025-07-16 04:25:00 | SPY | ETF | 621.4 | 621.4 | 621.4 | 621.4 | 100.0 |
| 2025-07-16 04:30:00 | SPY | ETF | 621.4 | 621.64 | 621.4 | 621.43 | 3840.0 |
| 2025-07-16 04:35:00 | SPY | ETF | 621.55 | 621.67 | 621.53 | 621.67 | 2963.0 |
| 2025-07-16 04:40:00 | SPY | ETF | 621.64 | 622.0 | 621.62 | 622.0 | 3424.0 |
| 2025-07-16 04:45:00 | SPY | ETF | 621.91 | 621.94 | 621.78 | 621.78 | 700.0 |
| 2025-07-16 04:50:00 | SPY | ETF | 621.77 | 621.77 | 621.66 | 621.66 | 200.0 |
| 2025-07-16 04:55:00 | SPY | ETF | 621.74 | 621.74 | 621.73 | 621.73 | 300.0 |
| 2025-07-16 05:00:00 | SPY | ETF | 621.85 | 621.85 | 621.67 | 621.68 | 2075.0 |
| 2025-07-16 05:05:00 | SPY | ETF | 621.53 | 621.56 | 621.44 | 621.56 | 1000.0 |
| 2025-07-16 05:10:00 | SPY | ETF | 621.72 | 621.72 | 621.72 | 621.72 | 100.0 |
| 2025-07-16 05:15:00 | SPY | ETF | 621.71 | 621.8 | 621.59 | 621.62 | 1647.0 |
| 2025-07-16 05:20:00 | SPY | ETF | 621.58 | 621.6 | 621.56 | 621.6 | 960.0 |
| 2025-07-16 05:25:00 | SPY | ETF | 621.56 | 621.6 | 621.49 | 621.55 | 2020.0 |
| 2025-07-16 05:30:00 | SPY | ETF | 621.38 | 621.44 | 621.31 | 621.43 | 3012.0 |
| 2025-07-16 05:40:00 | SPY | ETF | 621.55 | 621.55 | 621.33 | 621.42 | 3157.0 |
| 2025-07-16 05:45:00 | SPY | ETF | 621.5 | 621.67 | 621.5 | 621.65 | 2065.0 |
| 2025-07-16 05:50:00 | SPY | ETF | 621.62 | 621.78 | 621.61 | 621.78 | 3664.0 |
| 2025-07-16 05:55:00 | SPY | ETF | 621.75 | 621.75 | 621.69 | 621.75 | 814.0 |
| 2025-07-16 06:00:00 | SPY | ETF | 621.71 | 621.75 | 621.71 | 621.71 | 500.0 |
| 2025-07-16 06:05:00 | SPY | ETF | 621.69 | 621.8 | 621.68 | 621.8 | 400.0 |
| 2025-07-16 06:15:00 | SPY | ETF | 621.67 | 621.71 | 621.67 | 621.7 | 500.0 |
| 2025-07-16 06:20:00 | SPY | ETF | 621.74 | 621.84 | 621.74 | 621.82 | 463.0 |
| 2025-07-16 06:25:00 | SPY | ETF | 621.87 | 621.89 | 621.86 | 621.86 | 700.0 |
| 2025-07-16 06:30:00 | SPY | ETF | 621.85 | 622.04 | 621.8 | 621.81 | 4498.0 |
| 2025-07-16 06:35:00 | SPY | ETF | 621.75 | 621.94 | 621.75 | 621.92 | 8333.0 |
| 2025-07-16 06:40:00 | SPY | ETF | 621.89 | 622.0 | 621.64 | 621.8 | 4137.0 |
| 2025-07-16 06:45:00 | SPY | ETF | 621.94 | 622.0 | 621.94 | 622.0 | 2887.0 |
| 2025-07-16 06:50:00 | SPY | ETF | 622.04 | 622.11 | 621.96 | 622.05 | 6347.0 |
| 2025-07-16 06:55:00 | SPY | ETF | 622.06 | 622.15 | 622.0 | 622.0 | 5760.0 |
| 2025-07-16 07:00:00 | SPY | ETF | 621.98 | 622.1 | 621.92 | 622.1 | 8350.0 |
| 2025-07-16 07:05:00 | SPY | ETF | 622.14 | 622.17 | 621.93 | 621.93 | 2226.0 |
| 2025-07-16 07:10:00 | SPY | ETF | 621.86 | 621.87 | 621.75 | 621.83 | 4194.0 |
| 2025-07-16 07:15:00 | SPY | ETF | 621.76 | 621.899 | 621.76 | 621.899 | 1220.0 |
| 2025-07-16 07:20:00 | SPY | ETF | 621.89 | 622.17 | 621.88 | 622.17 | 13010.0 |
| 2025-07-16 07:25:00 | SPY | ETF | 622.04 | 622.2 | 622.0 | 622.08 | 18289.0 |
| 2025-07-16 07:30:00 | SPY | ETF | 621.98 | 621.98 | 621.7 | 621.71 | 3870.0 |
| 2025-07-16 07:35:00 | SPY | ETF | 621.82 | 621.82 | 621.67 | 621.67 | 7584.0 |
| 2025-07-16 07:40:00 | SPY | ETF | 621.69 | 621.77 | 621.67 | 621.76 | 15700.0 |
| 2025-07-16 07:45:00 | SPY | ETF | 621.77 | 622.01 | 621.73 | 622.01 | 10547.0 |
| 2025-07-16 07:50:00 | SPY | ETF | 622.04 | 622.11 | 622.04 | 622.08 | 3579.0 |
| 2025-07-16 07:55:00 | SPY | ETF | 622.11 | 622.22 | 622.11 | 622.21 | 7083.0 |
| 2025-07-16 08:00:00 | SPY | ETF | 622.21 | 622.25 | 619.8 | 622.06 | 81068.0 |
| 2025-07-16 08:05:00 | SPY | ETF | 622.16 | 622.32 | 622.15 | 622.32 | 18576.0 |
| 2025-07-16 08:10:00 | SPY | ETF | 622.33 | 622.55 | 622.33 | 622.45 | 34640.0 |
| 2025-07-16 08:15:00 | SPY | ETF | 622.45 | 622.65 | 622.42 | 622.52 | 10092.0 |
> showing 50 of 142,622 rows — these rows as CSV