PREVIEW / etf_5min / 2025-09-18
file: by_date/etf_5min/2025/2025-09-18.parquet size: 3.0 MB rows: 153,644
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-09-18 04:00:00 | SPY | ETF | 663.11 | 663.5 | 663.04 | 663.5 | 10567.0 |
| 2025-09-18 04:05:00 | SPY | ETF | 663.49 | 663.5 | 663.27 | 663.36 | 4856.0 |
| 2025-09-18 04:10:00 | SPY | ETF | 663.66 | 663.73 | 663.65 | 663.65 | 3339.0 |
| 2025-09-18 04:15:00 | SPY | ETF | 663.6 | 663.75 | 663.54 | 663.7 | 18486.0 |
| 2025-09-18 04:20:00 | SPY | ETF | 663.66 | 663.7 | 663.59 | 663.7 | 9769.0 |
| 2025-09-18 04:25:00 | SPY | ETF | 663.75 | 663.88 | 663.68 | 663.88 | 4519.0 |
| 2025-09-18 04:30:00 | SPY | ETF | 663.86 | 664.03 | 663.81 | 663.96 | 3383.0 |
| 2025-09-18 04:35:00 | SPY | ETF | 663.95 | 664.15 | 663.95 | 664.15 | 787.0 |
| 2025-09-18 04:40:00 | SPY | ETF | 664.11 | 664.11 | 664.09 | 664.09 | 3059.0 |
| 2025-09-18 04:45:00 | SPY | ETF | 664.16 | 664.55 | 664.16 | 664.55 | 6040.0 |
| 2025-09-18 04:50:00 | SPY | ETF | 664.66 | 664.82 | 664.66 | 664.81 | 17546.0 |
| 2025-09-18 04:55:00 | SPY | ETF | 664.81 | 665.02 | 664.79 | 664.95 | 9927.0 |
| 2025-09-18 05:00:00 | SPY | ETF | 664.95 | 665.0 | 664.85 | 664.85 | 3394.0 |
| 2025-09-18 05:05:00 | SPY | ETF | 664.78 | 665.0 | 664.78 | 665.0 | 3278.0 |
| 2025-09-18 05:10:00 | SPY | ETF | 665.02 | 665.07 | 664.58 | 664.58 | 6874.0 |
| 2025-09-18 05:15:00 | SPY | ETF | 664.7 | 664.8 | 664.7 | 664.78 | 1293.0 |
| 2025-09-18 05:20:00 | SPY | ETF | 664.7 | 664.79 | 664.62 | 664.62 | 6014.0 |
| 2025-09-18 05:25:00 | SPY | ETF | 664.56 | 664.81 | 664.54 | 664.75 | 13687.0 |
| 2025-09-18 05:30:00 | SPY | ETF | 664.75 | 664.94 | 664.75 | 664.94 | 5391.0 |
| 2025-09-18 05:35:00 | SPY | ETF | 664.93 | 665.1 | 664.9 | 665.0 | 14249.0 |
| 2025-09-18 05:40:00 | SPY | ETF | 664.99 | 664.99 | 664.8 | 664.83 | 4020.0 |
| 2025-09-18 05:45:00 | SPY | ETF | 664.82 | 664.9 | 664.72 | 664.72 | 11271.0 |
| 2025-09-18 05:50:00 | SPY | ETF | 664.85 | 665.04 | 664.79 | 664.79 | 9306.0 |
| 2025-09-18 05:55:00 | SPY | ETF | 664.73 | 665.0 | 664.66 | 664.67 | 14303.0 |
| 2025-09-18 06:00:00 | SPY | ETF | 664.69 | 664.74 | 664.56 | 664.74 | 1600.0 |
| 2025-09-18 06:05:00 | SPY | ETF | 664.78 | 664.9 | 664.75 | 664.86 | 5529.0 |
| 2025-09-18 06:10:00 | SPY | ETF | 664.87 | 664.87 | 664.86 | 664.86 | 1850.0 |
| 2025-09-18 06:15:00 | SPY | ETF | 664.84 | 664.85 | 664.71 | 664.71 | 1240.0 |
| 2025-09-18 06:20:00 | SPY | ETF | 664.72 | 664.75 | 664.58 | 664.58 | 5352.0 |
| 2025-09-18 06:25:00 | SPY | ETF | 664.58 | 664.58 | 664.35 | 664.37 | 60158.0 |
| 2025-09-18 06:30:00 | SPY | ETF | 664.37 | 664.4 | 664.15 | 664.22 | 29177.0 |
| 2025-09-18 06:35:00 | SPY | ETF | 664.25 | 664.26 | 664.14 | 664.22 | 10137.0 |
| 2025-09-18 06:40:00 | SPY | ETF | 664.26 | 664.27 | 664.15 | 664.17 | 7750.0 |
| 2025-09-18 06:45:00 | SPY | ETF | 664.21 | 664.21 | 664.0 | 664.0 | 4142.0 |
| 2025-09-18 06:50:00 | SPY | ETF | 664.04 | 664.04 | 663.85 | 663.93 | 11417.0 |
| 2025-09-18 06:55:00 | SPY | ETF | 663.96 | 664.12 | 663.92 | 664.12 | 11999.0 |
| 2025-09-18 07:00:00 | SPY | ETF | 664.18 | 664.57 | 663.91 | 664.43 | 8511.0 |
| 2025-09-18 07:05:00 | SPY | ETF | 664.43 | 664.57 | 664.34 | 664.54 | 8232.0 |
| 2025-09-18 07:10:00 | SPY | ETF | 664.63 | 664.8 | 664.5 | 664.5 | 50899.0 |
| 2025-09-18 07:15:00 | SPY | ETF | 664.68 | 664.7 | 664.5 | 664.53 | 16623.0 |
| 2025-09-18 07:20:00 | SPY | ETF | 664.53 | 664.76 | 664.53 | 664.59 | 41051.0 |
| 2025-09-18 07:25:00 | SPY | ETF | 664.52 | 664.52 | 664.38 | 664.5 | 13596.0 |
| 2025-09-18 07:30:00 | SPY | ETF | 664.47 | 664.47 | 664.33 | 664.34 | 46459.0 |
| 2025-09-18 07:35:00 | SPY | ETF | 664.3 | 664.39 | 664.25 | 664.27 | 9098.0 |
| 2025-09-18 07:40:00 | SPY | ETF | 664.15 | 664.16 | 663.8 | 663.91 | 10063.0 |
| 2025-09-18 07:45:00 | SPY | ETF | 663.89 | 664.04 | 663.78 | 663.87 | 12485.0 |
| 2025-09-18 07:50:00 | SPY | ETF | 663.92 | 663.97 | 663.82 | 663.84 | 8617.0 |
| 2025-09-18 07:55:00 | SPY | ETF | 663.91 | 664.11 | 663.86 | 664.1 | 5158.0 |
| 2025-09-18 08:00:00 | SPY | ETF | 664.55 | 665.01 | 661.3 | 664.0211 | 56773.0 |
| 2025-09-18 08:05:00 | SPY | ETF | 664.05 | 664.16 | 663.86 | 663.86 | 9837.0 |
> showing 50 of 153,644 rows — these rows as CSV