PREVIEW / etf_5min / 2025-07-28
file: by_date/etf_5min/2025/2025-07-28.parquet size: 2.8 MB rows: 142,921
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-28 04:00:00 | SPY | ETF | 639.24 | 639.26 | 639.08 | 639.11 | 15481.0 |
| 2025-07-28 04:05:00 | SPY | ETF | 639.09 | 639.21 | 639.07 | 639.17 | 1643.0 |
| 2025-07-28 04:10:00 | SPY | ETF | 639.18 | 639.24 | 639.08 | 639.13 | 1889.0 |
| 2025-07-28 04:15:00 | SPY | ETF | 639.1 | 639.15 | 639.1 | 639.14 | 3260.0 |
| 2025-07-28 04:20:00 | SPY | ETF | 639.3 | 639.33 | 639.23 | 639.23 | 700.0 |
| 2025-07-28 04:25:00 | SPY | ETF | 639.21 | 639.21 | 639.09 | 639.13 | 9783.0 |
| 2025-07-28 04:30:00 | SPY | ETF | 639.15 | 639.15 | 639.14 | 639.14 | 305.0 |
| 2025-07-28 04:35:00 | SPY | ETF | 639.24 | 639.24 | 639.24 | 639.24 | 100.0 |
| 2025-07-28 04:40:00 | SPY | ETF | 639.24 | 639.25 | 639.17 | 639.17 | 8736.0 |
| 2025-07-28 04:45:00 | SPY | ETF | 639.16 | 639.22 | 639.12 | 639.15 | 9751.0 |
| 2025-07-28 04:50:00 | SPY | ETF | 639.18 | 639.18 | 639.09 | 639.1 | 1320.0 |
| 2025-07-28 04:55:00 | SPY | ETF | 639.12 | 639.12 | 639.02 | 639.04 | 3185.0 |
| 2025-07-28 05:00:00 | SPY | ETF | 639.09 | 639.15 | 639.09 | 639.15 | 1020.0 |
| 2025-07-28 05:05:00 | SPY | ETF | 639.11 | 639.15 | 639.11 | 639.15 | 1850.0 |
| 2025-07-28 05:10:00 | SPY | ETF | 639.17 | 639.17 | 639.07 | 639.07 | 1098.0 |
| 2025-07-28 05:15:00 | SPY | ETF | 639.09 | 639.11 | 639.07 | 639.11 | 480.0 |
| 2025-07-28 05:20:00 | SPY | ETF | 639.14 | 639.14 | 638.73 | 638.81 | 3211.0 |
| 2025-07-28 05:25:00 | SPY | ETF | 638.73 | 638.91 | 638.73 | 638.9 | 1570.0 |
| 2025-07-28 05:30:00 | SPY | ETF | 639.02 | 639.02 | 639.02 | 639.02 | 100.0 |
| 2025-07-28 05:35:00 | SPY | ETF | 638.95 | 638.97 | 638.88 | 638.88 | 3604.0 |
| 2025-07-28 05:40:00 | SPY | ETF | 638.84 | 638.86 | 638.84 | 638.86 | 1100.0 |
| 2025-07-28 05:45:00 | SPY | ETF | 638.86 | 638.89 | 638.8 | 638.82 | 3238.0 |
| 2025-07-28 05:50:00 | SPY | ETF | 638.8 | 638.83 | 638.73 | 638.73 | 3183.0 |
| 2025-07-28 05:55:00 | SPY | ETF | 638.73 | 638.73 | 638.66 | 638.66 | 1181.0 |
| 2025-07-28 06:00:00 | SPY | ETF | 638.75 | 638.76 | 638.75 | 638.76 | 200.0 |
| 2025-07-28 06:05:00 | SPY | ETF | 638.76 | 638.78 | 638.73 | 638.74 | 10078.0 |
| 2025-07-28 06:10:00 | SPY | ETF | 638.66 | 638.73 | 638.64 | 638.7 | 2532.0 |
| 2025-07-28 06:15:00 | SPY | ETF | 638.74 | 638.85 | 638.74 | 638.82 | 1681.0 |
| 2025-07-28 06:20:00 | SPY | ETF | 638.73 | 638.74 | 638.73 | 638.74 | 300.0 |
| 2025-07-28 06:25:00 | SPY | ETF | 638.63 | 638.63 | 638.46 | 638.57 | 3980.0 |
| 2025-07-28 06:30:00 | SPY | ETF | 638.56 | 638.57 | 638.44 | 638.5 | 1110.0 |
| 2025-07-28 06:35:00 | SPY | ETF | 638.45 | 638.53 | 638.35 | 638.38 | 9086.0 |
| 2025-07-28 06:40:00 | SPY | ETF | 638.37 | 638.39 | 638.23 | 638.25 | 4310.0 |
| 2025-07-28 06:45:00 | SPY | ETF | 638.23 | 638.33 | 638.11 | 638.23 | 5426.0 |
| 2025-07-28 06:50:00 | SPY | ETF | 638.21 | 638.25 | 638.02 | 638.06 | 3382.0 |
| 2025-07-28 06:55:00 | SPY | ETF | 638.15 | 638.22 | 638.02 | 638.21 | 5930.0 |
| 2025-07-28 07:00:00 | SPY | ETF | 638.15 | 638.35 | 638.09 | 638.25 | 8144.0 |
| 2025-07-28 07:05:00 | SPY | ETF | 638.22 | 638.31 | 638.21 | 638.27 | 7513.0 |
| 2025-07-28 07:10:00 | SPY | ETF | 638.21 | 638.38 | 638.21 | 638.36 | 21198.0 |
| 2025-07-28 07:15:00 | SPY | ETF | 638.36 | 638.39 | 638.1 | 638.17 | 9577.0 |
| 2025-07-28 07:20:00 | SPY | ETF | 638.19 | 638.27 | 638.18 | 638.25 | 2639.0 |
| 2025-07-28 07:25:00 | SPY | ETF | 638.28 | 638.31 | 638.16 | 638.17 | 10042.0 |
| 2025-07-28 07:30:00 | SPY | ETF | 638.13 | 638.23 | 638.13 | 638.23 | 7177.0 |
| 2025-07-28 07:35:00 | SPY | ETF | 638.24 | 638.24 | 638.23 | 638.23 | 900.0 |
| 2025-07-28 07:40:00 | SPY | ETF | 638.3 | 638.34 | 638.21 | 638.24 | 3590.0 |
| 2025-07-28 07:45:00 | SPY | ETF | 638.23 | 638.23 | 638.08 | 638.17 | 6593.0 |
| 2025-07-28 07:50:00 | SPY | ETF | 638.22 | 638.31 | 638.2 | 638.21 | 6200.0 |
| 2025-07-28 07:55:00 | SPY | ETF | 638.27 | 638.31 | 638.24 | 638.26 | 14833.0 |
| 2025-07-28 08:00:00 | SPY | ETF | 638.3 | 640.26 | 638.01 | 638.19 | 83181.0 |
| 2025-07-28 08:05:00 | SPY | ETF | 638.22 | 638.28 | 638.17 | 638.28 | 53605.0 |
> showing 50 of 142,921 rows — these rows as CSV