PREVIEW / etf_5min / 2025-08-01
file: by_date/etf_5min/2025/2025-08-01.parquet size: 3.0 MB rows: 154,453
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-08-01 04:00:00 | SPY | ETF | 629.5 | 629.5 | 627.18 | 627.45 | 13631.0 |
| 2025-08-01 04:05:00 | SPY | ETF | 627.31 | 627.5 | 627.17 | 627.35 | 66524.0 |
| 2025-08-01 04:10:00 | SPY | ETF | 627.37 | 627.47 | 627.01 | 627.27 | 41041.0 |
| 2025-08-01 04:15:00 | SPY | ETF | 627.43 | 627.78 | 627.39 | 627.59 | 21035.0 |
| 2025-08-01 04:20:00 | SPY | ETF | 627.51 | 627.51 | 627.15 | 627.3 | 5404.0 |
| 2025-08-01 04:25:00 | SPY | ETF | 627.34 | 627.34 | 626.06 | 626.15 | 18239.0 |
| 2025-08-01 04:30:00 | SPY | ETF | 626.25 | 626.53 | 626.0 | 626.06 | 20225.0 |
| 2025-08-01 04:35:00 | SPY | ETF | 626.29 | 626.32 | 625.76 | 625.76 | 10775.0 |
| 2025-08-01 04:40:00 | SPY | ETF | 625.69 | 626.27 | 625.69 | 626.13 | 6264.0 |
| 2025-08-01 04:45:00 | SPY | ETF | 626.26 | 626.58 | 626.26 | 626.51 | 4571.0 |
| 2025-08-01 04:50:00 | SPY | ETF | 626.63 | 626.78 | 626.43 | 626.63 | 7480.0 |
| 2025-08-01 04:55:00 | SPY | ETF | 626.68 | 626.87 | 626.57 | 626.7 | 18741.0 |
| 2025-08-01 05:00:00 | SPY | ETF | 626.67 | 627.02 | 626.66 | 627.01 | 9084.0 |
| 2025-08-01 05:05:00 | SPY | ETF | 626.78 | 627.1 | 626.78 | 626.87 | 6267.0 |
| 2025-08-01 05:10:00 | SPY | ETF | 626.87 | 626.87 | 626.65 | 626.65 | 1760.0 |
| 2025-08-01 05:15:00 | SPY | ETF | 626.66 | 626.82 | 626.57 | 626.62 | 17529.0 |
| 2025-08-01 05:20:00 | SPY | ETF | 626.44 | 626.5 | 626.29 | 626.34 | 6071.0 |
| 2025-08-01 05:25:00 | SPY | ETF | 626.39 | 626.4 | 626.28 | 626.32 | 3525.0 |
| 2025-08-01 05:30:00 | SPY | ETF | 626.13 | 626.42 | 626.12 | 626.17 | 3241.0 |
| 2025-08-01 05:35:00 | SPY | ETF | 626.29 | 626.41 | 626.25 | 626.41 | 1145.0 |
| 2025-08-01 05:40:00 | SPY | ETF | 626.63 | 626.71 | 626.52 | 626.54 | 4587.0 |
| 2025-08-01 05:45:00 | SPY | ETF | 626.69 | 626.84 | 626.68 | 626.84 | 400.0 |
| 2025-08-01 05:50:00 | SPY | ETF | 626.77 | 626.82 | 626.77 | 626.77 | 1025.0 |
| 2025-08-01 05:55:00 | SPY | ETF | 626.67 | 626.68 | 626.65 | 626.68 | 1200.0 |
| 2025-08-01 06:00:00 | SPY | ETF | 626.67 | 626.67 | 626.23 | 626.46 | 5801.0 |
| 2025-08-01 06:05:00 | SPY | ETF | 626.22 | 626.33 | 626.0 | 626.33 | 6194.0 |
| 2025-08-01 06:10:00 | SPY | ETF | 626.37 | 626.51 | 626.37 | 626.51 | 1891.0 |
| 2025-08-01 06:15:00 | SPY | ETF | 626.46 | 626.57 | 626.17 | 626.57 | 2290.0 |
| 2025-08-01 06:20:00 | SPY | ETF | 626.48 | 626.53 | 626.07 | 626.08 | 1825.0 |
| 2025-08-01 06:25:00 | SPY | ETF | 626.22 | 626.51 | 626.07 | 626.5 | 3613.0 |
| 2025-08-01 06:30:00 | SPY | ETF | 626.35 | 626.42 | 626.24 | 626.31 | 8931.0 |
| 2025-08-01 06:35:00 | SPY | ETF | 626.22 | 626.34 | 626.05 | 626.21 | 20095.0 |
| 2025-08-01 06:40:00 | SPY | ETF | 626.2 | 626.24 | 625.6 | 625.63 | 137435.0 |
| 2025-08-01 06:45:00 | SPY | ETF | 625.71 | 625.97 | 625.35 | 625.36 | 76103.0 |
| 2025-08-01 06:50:00 | SPY | ETF | 625.5 | 625.6 | 624.91 | 625.04 | 17659.0 |
| 2025-08-01 06:55:00 | SPY | ETF | 624.89 | 625.36 | 624.83 | 625.17 | 18237.0 |
| 2025-08-01 07:00:00 | SPY | ETF | 625.36 | 625.58 | 625.2 | 625.44 | 17900.0 |
| 2025-08-01 07:05:00 | SPY | ETF | 625.54 | 625.88 | 625.54 | 625.88 | 32878.0 |
| 2025-08-01 07:10:00 | SPY | ETF | 625.89 | 626.4 | 625.89 | 626.24 | 34719.0 |
| 2025-08-01 07:15:00 | SPY | ETF | 626.28 | 626.49 | 626.24 | 626.41 | 26662.0 |
| 2025-08-01 07:20:00 | SPY | ETF | 626.22 | 626.52 | 626.18 | 626.32 | 20240.0 |
| 2025-08-01 07:25:00 | SPY | ETF | 626.37 | 626.5 | 626.341 | 626.37 | 6755.0 |
| 2025-08-01 07:30:00 | SPY | ETF | 626.28 | 626.54 | 626.26 | 626.34 | 7126.0 |
| 2025-08-01 07:35:00 | SPY | ETF | 626.4 | 626.63 | 626.36 | 626.6 | 11614.0 |
| 2025-08-01 07:40:00 | SPY | ETF | 626.49 | 626.69 | 626.49 | 626.619 | 8416.0 |
| 2025-08-01 07:45:00 | SPY | ETF | 626.62 | 627.0 | 626.6 | 626.68 | 11718.0 |
| 2025-08-01 07:50:00 | SPY | ETF | 626.48 | 626.78 | 626.48 | 626.67 | 24415.0 |
| 2025-08-01 07:55:00 | SPY | ETF | 626.64 | 626.95 | 626.6 | 626.87 | 34361.0 |
| 2025-08-01 08:00:00 | SPY | ETF | 625.38 | 631.64 | 624.8696 | 626.97 | 258038.0 |
| 2025-08-01 08:05:00 | SPY | ETF | 626.96 | 627.0 | 626.81 | 626.8501 | 16039.0 |
> showing 50 of 154,453 rows — these rows as CSV