PREVIEW / etf_5min / 2025-08-20
file: by_date/etf_5min/2025/2025-08-20.parquet size: 2.9 MB rows: 141,239
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-20 04:00:00 | SPY | ETF | 637.22 | 638.67 | 637.22 | 638.51 | 13582.0 |
| 2025-08-20 04:05:00 | SPY | ETF | 638.59 | 638.64 | 638.38 | 638.38 | 15107.0 |
| 2025-08-20 04:10:00 | SPY | ETF | 638.41 | 638.41 | 638.04 | 638.14 | 8129.0 |
| 2025-08-20 04:15:00 | SPY | ETF | 638.02 | 638.22 | 638.0 | 638.2 | 1240.0 |
| 2025-08-20 04:20:00 | SPY | ETF | 638.26 | 638.27 | 637.89 | 637.89 | 4010.0 |
| 2025-08-20 04:25:00 | SPY | ETF | 638.0 | 638.0 | 638.0 | 638.0 | 100.0 |
| 2025-08-20 04:30:00 | SPY | ETF | 637.9 | 638.52 | 637.9 | 638.49 | 4341.0 |
| 2025-08-20 04:35:00 | SPY | ETF | 638.41 | 638.78 | 638.41 | 638.73 | 1800.0 |
| 2025-08-20 04:40:00 | SPY | ETF | 638.7 | 638.7 | 638.7 | 638.7 | 100.0 |
| 2025-08-20 04:45:00 | SPY | ETF | 638.52 | 638.61 | 638.52 | 638.6 | 400.0 |
| 2025-08-20 04:50:00 | SPY | ETF | 638.61 | 638.61 | 638.61 | 638.61 | 100.0 |
| 2025-08-20 04:55:00 | SPY | ETF | 638.57 | 638.57 | 638.46 | 638.46 | 3420.0 |
| 2025-08-20 05:00:00 | SPY | ETF | 638.56 | 638.63 | 638.41 | 638.53 | 3676.0 |
| 2025-08-20 05:05:00 | SPY | ETF | 638.45 | 638.45 | 638.45 | 638.45 | 100.0 |
| 2025-08-20 05:10:00 | SPY | ETF | 638.74 | 638.74 | 638.72 | 638.72 | 310.0 |
| 2025-08-20 05:15:00 | SPY | ETF | 638.91 | 638.91 | 638.9 | 638.91 | 310.0 |
| 2025-08-20 05:20:00 | SPY | ETF | 638.94 | 638.95 | 638.88 | 638.88 | 1300.0 |
| 2025-08-20 05:25:00 | SPY | ETF | 638.92 | 639.0 | 638.84 | 638.87 | 1328.0 |
| 2025-08-20 05:30:00 | SPY | ETF | 638.94 | 638.94 | 638.93 | 638.93 | 524.0 |
| 2025-08-20 05:35:00 | SPY | ETF | 638.94 | 638.97 | 638.94 | 638.97 | 200.0 |
| 2025-08-20 05:40:00 | SPY | ETF | 638.98 | 638.98 | 638.9 | 638.9 | 400.0 |
| 2025-08-20 05:45:00 | SPY | ETF | 638.95 | 639.1 | 638.95 | 639.09 | 600.0 |
| 2025-08-20 05:50:00 | SPY | ETF | 639.1 | 639.14 | 638.9 | 639.11 | 12899.0 |
| 2025-08-20 05:55:00 | SPY | ETF | 638.98 | 639.02 | 638.98 | 639.02 | 600.0 |
| 2025-08-20 06:00:00 | SPY | ETF | 638.95 | 638.96 | 638.95 | 638.96 | 387.0 |
| 2025-08-20 06:05:00 | SPY | ETF | 638.92 | 639.1 | 638.92 | 639.03 | 767.0 |
| 2025-08-20 06:10:00 | SPY | ETF | 639.14 | 639.17 | 639.14 | 639.14 | 638.0 |
| 2025-08-20 06:15:00 | SPY | ETF | 639.21 | 639.3 | 639.21 | 639.3 | 685.0 |
| 2025-08-20 06:20:00 | SPY | ETF | 639.32 | 639.39 | 639.32 | 639.39 | 250.0 |
| 2025-08-20 06:25:00 | SPY | ETF | 639.28 | 639.28 | 639.19 | 639.19 | 800.0 |
| 2025-08-20 06:30:00 | SPY | ETF | 639.26 | 639.27 | 638.94 | 638.95 | 1480.0 |
| 2025-08-20 06:35:00 | SPY | ETF | 638.87 | 638.9 | 638.87 | 638.9 | 310.0 |
| 2025-08-20 06:45:00 | SPY | ETF | 638.9 | 639.02 | 638.88 | 638.88 | 600.0 |
| 2025-08-20 06:50:00 | SPY | ETF | 639.0 | 639.0 | 639.0 | 639.0 | 100.0 |
| 2025-08-20 06:55:00 | SPY | ETF | 639.13 | 639.13 | 639.13 | 639.13 | 100.0 |
| 2025-08-20 07:00:00 | SPY | ETF | 639.12 | 639.53 | 639.1 | 639.519 | 28847.0 |
| 2025-08-20 07:05:00 | SPY | ETF | 639.47 | 639.5 | 639.35 | 639.35 | 5040.0 |
| 2025-08-20 07:10:00 | SPY | ETF | 639.41 | 639.43 | 639.37 | 639.41 | 2320.0 |
| 2025-08-20 07:15:00 | SPY | ETF | 639.35 | 639.36 | 639.13 | 639.22 | 5660.0 |
| 2025-08-20 07:20:00 | SPY | ETF | 639.23 | 639.32 | 639.16 | 639.16 | 8088.0 |
| 2025-08-20 07:25:00 | SPY | ETF | 639.18 | 639.19 | 638.83 | 638.85 | 8512.0 |
| 2025-08-20 07:30:00 | SPY | ETF | 638.9 | 638.98 | 638.89 | 638.91 | 11299.0 |
| 2025-08-20 07:35:00 | SPY | ETF | 638.98 | 638.98 | 638.58 | 638.62 | 6405.0 |
| 2025-08-20 07:40:00 | SPY | ETF | 638.6 | 638.77 | 638.6 | 638.67 | 7390.0 |
| 2025-08-20 07:45:00 | SPY | ETF | 638.67 | 638.7 | 638.5 | 638.69 | 12990.0 |
| 2025-08-20 07:50:00 | SPY | ETF | 638.78 | 639.11 | 638.78 | 638.99 | 5787.0 |
| 2025-08-20 07:55:00 | SPY | ETF | 638.95 | 639.08 | 638.95 | 639.01 | 9103.0 |
| 2025-08-20 08:00:00 | SPY | ETF | 639.42 | 639.5 | 637.49 | 639.31 | 45756.0 |
| 2025-08-20 08:05:00 | SPY | ETF | 639.28 | 639.5 | 639.26 | 639.36 | 23284.0 |
| 2025-08-20 08:10:00 | SPY | ETF | 639.34 | 639.38 | 639.16 | 639.2199 | 16865.0 |
> showing 50 of 141,239 rows — these rows as CSV