PREVIEW / etf_5min / 2025-01-24
file: by_date/etf_5min/2025/2025-01-24.parquet size: 2.7 MB rows: 130,768
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-01-24 04:00:00 | SPY | ETF | 609.16 | 609.26 | 609.09 | 609.26 | 1000.0 |
| 2025-01-24 04:05:00 | SPY | ETF | 609.25 | 609.4 | 609.25 | 609.4 | 750.0 |
| 2025-01-24 04:10:00 | SPY | ETF | 609.29 | 609.39 | 609.29 | 609.39 | 200.0 |
| 2025-01-24 04:15:00 | SPY | ETF | 609.44 | 609.44 | 609.38 | 609.38 | 600.0 |
| 2025-01-24 04:20:00 | SPY | ETF | 609.51 | 609.59 | 609.51 | 609.56 | 1638.0 |
| 2025-01-24 04:25:00 | SPY | ETF | 609.55 | 609.55 | 609.39 | 609.42 | 1644.0 |
| 2025-01-24 04:30:00 | SPY | ETF | 609.48 | 609.48 | 609.4 | 609.45 | 674.0 |
| 2025-01-24 04:35:00 | SPY | ETF | 609.44 | 609.44 | 609.25 | 609.25 | 521.0 |
| 2025-01-24 04:45:00 | SPY | ETF | 609.23 | 609.23 | 609.22 | 609.22 | 900.0 |
| 2025-01-24 04:50:00 | SPY | ETF | 609.3 | 609.3 | 609.3 | 609.3 | 200.0 |
| 2025-01-24 05:00:00 | SPY | ETF | 609.22 | 609.22 | 609.22 | 609.22 | 102.0 |
| 2025-01-24 05:10:00 | SPY | ETF | 609.19 | 609.19 | 609.19 | 609.19 | 280.0 |
| 2025-01-24 05:15:00 | SPY | ETF | 609.06 | 609.06 | 608.98 | 608.98 | 964.0 |
| 2025-01-24 05:20:00 | SPY | ETF | 608.95 | 609.05 | 608.92 | 608.92 | 1075.0 |
| 2025-01-24 05:25:00 | SPY | ETF | 609.02 | 609.02 | 608.87 | 608.88 | 2861.0 |
| 2025-01-24 05:30:00 | SPY | ETF | 608.89 | 608.95 | 608.89 | 608.95 | 824.0 |
| 2025-01-24 05:35:00 | SPY | ETF | 608.7 | 608.72 | 608.7 | 608.72 | 1465.0 |
| 2025-01-24 05:40:00 | SPY | ETF | 608.62 | 608.76 | 608.58 | 608.58 | 2703.0 |
| 2025-01-24 05:45:00 | SPY | ETF | 608.63 | 608.68 | 608.63 | 608.68 | 1000.0 |
| 2025-01-24 05:50:00 | SPY | ETF | 608.89 | 608.89 | 608.89 | 608.89 | 147.0 |
| 2025-01-24 05:55:00 | SPY | ETF | 609.0 | 609.0 | 608.96 | 608.96 | 1189.0 |
| 2025-01-24 06:00:00 | SPY | ETF | 608.98 | 608.99 | 608.96 | 608.99 | 852.0 |
| 2025-01-24 06:05:00 | SPY | ETF | 609.0 | 609.0 | 609.0 | 609.0 | 146.0 |
| 2025-01-24 06:10:00 | SPY | ETF | 608.9 | 608.9 | 608.9 | 608.9 | 100.0 |
| 2025-01-24 06:15:00 | SPY | ETF | 608.91 | 608.91 | 608.91 | 608.91 | 296.0 |
| 2025-01-24 06:20:00 | SPY | ETF | 608.9 | 608.9 | 608.9 | 608.9 | 1095.0 |
| 2025-01-24 06:25:00 | SPY | ETF | 609.03 | 609.03 | 609.03 | 609.03 | 231.0 |
| 2025-01-24 06:30:00 | SPY | ETF | 608.83 | 609.03 | 608.83 | 608.97 | 723.0 |
| 2025-01-24 06:35:00 | SPY | ETF | 608.82 | 608.9 | 608.82 | 608.9 | 300.0 |
| 2025-01-24 06:45:00 | SPY | ETF | 608.91 | 609.09 | 608.91 | 609.09 | 1301.0 |
| 2025-01-24 06:50:00 | SPY | ETF | 608.98 | 608.98 | 608.98 | 608.98 | 200.0 |
| 2025-01-24 06:55:00 | SPY | ETF | 608.94 | 609.01 | 608.94 | 609.01 | 503.0 |
| 2025-01-24 07:00:00 | SPY | ETF | 609.03 | 609.2 | 609.03 | 609.2 | 4876.0 |
| 2025-01-24 07:05:00 | SPY | ETF | 609.24 | 609.28 | 609.1 | 609.1 | 6947.0 |
| 2025-01-24 07:10:00 | SPY | ETF | 609.11 | 609.18 | 609.11 | 609.16 | 3300.0 |
| 2025-01-24 07:15:00 | SPY | ETF | 609.16 | 609.34 | 609.16 | 609.3 | 11948.0 |
| 2025-01-24 07:20:00 | SPY | ETF | 609.34 | 609.42 | 609.34 | 609.42 | 16409.0 |
| 2025-01-24 07:25:00 | SPY | ETF | 609.46 | 609.56 | 609.44 | 609.5 | 1826.0 |
| 2025-01-24 07:30:00 | SPY | ETF | 609.52 | 609.52 | 609.391 | 609.4 | 1988.0 |
| 2025-01-24 07:35:00 | SPY | ETF | 609.35 | 609.38 | 609.19 | 609.19 | 1860.0 |
| 2025-01-24 07:40:00 | SPY | ETF | 609.19 | 609.19 | 609.15 | 609.15 | 1160.0 |
| 2025-01-24 07:45:00 | SPY | ETF | 609.15 | 609.16 | 609.05 | 609.05 | 2686.0 |
| 2025-01-24 07:50:00 | SPY | ETF | 609.07 | 609.23 | 609.04 | 609.04 | 6586.0 |
| 2025-01-24 07:55:00 | SPY | ETF | 609.09 | 609.21 | 609.09 | 609.21 | 257.0 |
| 2025-01-24 08:00:00 | SPY | ETF | 609.04 | 609.5 | 609.04 | 609.11 | 20096.0 |
| 2025-01-24 08:05:00 | SPY | ETF | 609.07 | 609.14 | 608.92 | 608.94 | 10467.0 |
| 2025-01-24 08:10:00 | SPY | ETF | 608.92 | 609.0 | 608.8 | 608.98 | 7111.0 |
| 2025-01-24 08:15:00 | SPY | ETF | 609.02 | 609.15 | 609.02 | 609.15 | 6077.0 |
| 2025-01-24 08:20:00 | SPY | ETF | 609.15 | 609.15 | 608.94 | 609.04 | 11257.0 |
| 2025-01-24 08:25:00 | SPY | ETF | 609.05 | 609.1 | 608.99 | 608.99 | 16554.0 |
> showing 50 of 130,768 rows — these rows as CSV