PREVIEW / etf_5min / 2025-06-05
file: by_date/etf_5min/2025/2025-06-05.parquet size: 2.7 MB rows: 139,072
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-06-05 04:00:00 | SPY | ETF | 596.5 | 597.47 | 596.5 | 597.44 | 3710.0 |
| 2025-06-05 04:05:00 | SPY | ETF | 597.5 | 597.52 | 597.4 | 597.4 | 400.0 |
| 2025-06-05 04:10:00 | SPY | ETF | 597.47 | 597.47 | 597.4 | 597.4 | 317.0 |
| 2025-06-05 04:15:00 | SPY | ETF | 597.31 | 597.35 | 597.3 | 597.3 | 1023.0 |
| 2025-06-05 04:20:00 | SPY | ETF | 597.18 | 597.49 | 597.18 | 597.49 | 983.0 |
| 2025-06-05 04:25:00 | SPY | ETF | 597.49 | 597.63 | 597.46 | 597.63 | 10615.0 |
| 2025-06-05 04:30:00 | SPY | ETF | 597.53 | 597.7 | 597.53 | 597.69 | 1303.0 |
| 2025-06-05 04:35:00 | SPY | ETF | 597.5 | 597.5 | 597.41 | 597.41 | 1003.0 |
| 2025-06-05 04:40:00 | SPY | ETF | 597.52 | 597.52 | 597.37 | 597.37 | 850.0 |
| 2025-06-05 04:45:00 | SPY | ETF | 597.32 | 597.32 | 597.05 | 597.05 | 2585.0 |
| 2025-06-05 04:50:00 | SPY | ETF | 597.1 | 597.1 | 596.85 | 596.89 | 18125.0 |
| 2025-06-05 04:55:00 | SPY | ETF | 596.71 | 596.87 | 596.57 | 596.87 | 3573.0 |
| 2025-06-05 05:00:00 | SPY | ETF | 596.83 | 596.84 | 596.68 | 596.82 | 1925.0 |
| 2025-06-05 05:05:00 | SPY | ETF | 596.8 | 596.87 | 596.67 | 596.81 | 3848.0 |
| 2025-06-05 05:10:00 | SPY | ETF | 596.78 | 596.84 | 596.64 | 596.66 | 2452.0 |
| 2025-06-05 05:15:00 | SPY | ETF | 596.55 | 596.61 | 596.37 | 596.61 | 3500.0 |
| 2025-06-05 05:20:00 | SPY | ETF | 596.59 | 596.62 | 596.51 | 596.57 | 775.0 |
| 2025-06-05 05:25:00 | SPY | ETF | 596.59 | 596.75 | 596.59 | 596.65 | 2025.0 |
| 2025-06-05 05:30:00 | SPY | ETF | 596.57 | 596.63 | 596.55 | 596.6 | 1180.0 |
| 2025-06-05 05:35:00 | SPY | ETF | 596.57 | 596.61 | 596.56 | 596.61 | 625.0 |
| 2025-06-05 05:40:00 | SPY | ETF | 596.73 | 596.73 | 596.73 | 596.73 | 100.0 |
| 2025-06-05 05:45:00 | SPY | ETF | 596.74 | 596.75 | 596.74 | 596.75 | 200.0 |
| 2025-06-05 05:50:00 | SPY | ETF | 596.5 | 596.52 | 596.33 | 596.52 | 4261.0 |
| 2025-06-05 05:55:00 | SPY | ETF | 596.58 | 596.58 | 596.45 | 596.45 | 600.0 |
| 2025-06-05 06:00:00 | SPY | ETF | 596.59 | 596.82 | 596.59 | 596.82 | 1375.0 |
| 2025-06-05 06:05:00 | SPY | ETF | 596.7 | 596.84 | 596.7 | 596.84 | 1170.0 |
| 2025-06-05 06:10:00 | SPY | ETF | 597.0 | 597.0 | 596.95 | 596.95 | 225.0 |
| 2025-06-05 06:15:00 | SPY | ETF | 596.96 | 596.96 | 596.96 | 596.96 | 100.0 |
| 2025-06-05 06:20:00 | SPY | ETF | 597.02 | 597.02 | 596.91 | 596.91 | 2035.0 |
| 2025-06-05 06:25:00 | SPY | ETF | 596.85 | 596.85 | 596.82 | 596.82 | 1140.0 |
| 2025-06-05 06:30:00 | SPY | ETF | 596.86 | 597.07 | 596.85 | 596.85 | 700.0 |
| 2025-06-05 06:35:00 | SPY | ETF | 596.81 | 596.81 | 596.73 | 596.73 | 938.0 |
| 2025-06-05 06:40:00 | SPY | ETF | 596.63 | 596.76 | 596.08 | 596.19 | 8725.0 |
| 2025-06-05 06:45:00 | SPY | ETF | 596.13 | 596.28 | 596.13 | 596.25 | 1100.0 |
| 2025-06-05 06:50:00 | SPY | ETF | 596.23 | 596.3 | 596.21 | 596.3 | 900.0 |
| 2025-06-05 06:55:00 | SPY | ETF | 596.36 | 596.42 | 596.36 | 596.42 | 2300.0 |
| 2025-06-05 07:00:00 | SPY | ETF | 596.4 | 596.57 | 596.26 | 596.33 | 8547.0 |
| 2025-06-05 07:05:00 | SPY | ETF | 596.3 | 596.4 | 596.17 | 596.4 | 3204.0 |
| 2025-06-05 07:10:00 | SPY | ETF | 596.33 | 596.33 | 595.93 | 595.93 | 3243.0 |
| 2025-06-05 07:15:00 | SPY | ETF | 595.94 | 596.16 | 595.92 | 596.16 | 4995.0 |
| 2025-06-05 07:20:00 | SPY | ETF | 596.19 | 596.22 | 596.05 | 596.16 | 3796.0 |
| 2025-06-05 07:25:00 | SPY | ETF | 596.18 | 596.18 | 595.95 | 595.97 | 1079.0 |
| 2025-06-05 07:30:00 | SPY | ETF | 596.01 | 596.43 | 596.01 | 596.43 | 3428.0 |
| 2025-06-05 07:35:00 | SPY | ETF | 596.42 | 596.42 | 596.32 | 596.32 | 3584.0 |
| 2025-06-05 07:40:00 | SPY | ETF | 596.15 | 596.15 | 596.0 | 596.06 | 3619.0 |
| 2025-06-05 07:45:00 | SPY | ETF | 596.1 | 596.5 | 596.1 | 596.5 | 2529.0 |
| 2025-06-05 07:50:00 | SPY | ETF | 596.5 | 596.59 | 596.48 | 596.53 | 8842.0 |
| 2025-06-05 07:55:00 | SPY | ETF | 596.55 | 596.57 | 596.34 | 596.41 | 1548.0 |
| 2025-06-05 08:00:00 | SPY | ETF | 595.8 | 597.49 | 595.484 | 596.3 | 54527.0 |
| 2025-06-05 08:05:00 | SPY | ETF | 596.41 | 596.53 | 596.33 | 596.52 | 14538.0 |
> showing 50 of 139,072 rows — these rows as CSV