PREVIEW / etf_5min / 2025-01-29
file: by_date/etf_5min/2025/2025-01-29.parquet size: 2.6 MB rows: 129,289
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-29 04:00:00 | SPY | ETF | 605.96 | 605.96 | 604.96 | 604.96 | 7006.0 |
| 2025-01-29 04:05:00 | SPY | ETF | 604.65 | 604.87 | 604.57 | 604.8 | 1490.0 |
| 2025-01-29 04:10:00 | SPY | ETF | 605.0 | 605.27 | 605.0 | 605.27 | 2049.0 |
| 2025-01-29 04:15:00 | SPY | ETF | 605.25 | 605.25 | 604.95 | 604.95 | 1100.0 |
| 2025-01-29 04:20:00 | SPY | ETF | 604.83 | 604.93 | 604.68 | 604.93 | 1900.0 |
| 2025-01-29 04:25:00 | SPY | ETF | 604.85 | 604.89 | 604.85 | 604.89 | 500.0 |
| 2025-01-29 04:30:00 | SPY | ETF | 604.85 | 604.89 | 604.75 | 604.79 | 1780.0 |
| 2025-01-29 04:35:00 | SPY | ETF | 604.69 | 604.84 | 604.68 | 604.84 | 504.0 |
| 2025-01-29 04:40:00 | SPY | ETF | 604.92 | 604.97 | 604.75 | 604.97 | 400.0 |
| 2025-01-29 04:45:00 | SPY | ETF | 605.0 | 605.14 | 605.0 | 605.14 | 650.0 |
| 2025-01-29 04:50:00 | SPY | ETF | 605.28 | 605.28 | 605.19 | 605.19 | 300.0 |
| 2025-01-29 04:55:00 | SPY | ETF | 605.19 | 605.19 | 605.06 | 605.06 | 2491.0 |
| 2025-01-29 05:00:00 | SPY | ETF | 605.13 | 605.13 | 605.13 | 605.13 | 299.0 |
| 2025-01-29 05:05:00 | SPY | ETF | 605.0 | 605.07 | 605.0 | 605.07 | 343.0 |
| 2025-01-29 05:10:00 | SPY | ETF | 605.17 | 605.17 | 605.12 | 605.13 | 794.0 |
| 2025-01-29 05:15:00 | SPY | ETF | 605.0 | 605.0 | 605.0 | 605.0 | 251.0 |
| 2025-01-29 05:20:00 | SPY | ETF | 605.01 | 605.01 | 605.01 | 605.01 | 200.0 |
| 2025-01-29 05:25:00 | SPY | ETF | 605.04 | 605.04 | 604.8 | 604.82 | 1105.0 |
| 2025-01-29 05:30:00 | SPY | ETF | 604.86 | 604.87 | 604.86 | 604.87 | 1078.0 |
| 2025-01-29 05:35:00 | SPY | ETF | 605.16 | 605.16 | 605.15 | 605.15 | 200.0 |
| 2025-01-29 05:40:00 | SPY | ETF | 605.17 | 605.2 | 605.17 | 605.2 | 260.0 |
| 2025-01-29 05:45:00 | SPY | ETF | 605.24 | 605.26 | 605.11 | 605.26 | 651.0 |
| 2025-01-29 05:50:00 | SPY | ETF | 605.12 | 605.12 | 605.12 | 605.12 | 198.0 |
| 2025-01-29 05:55:00 | SPY | ETF | 605.3 | 605.39 | 605.19 | 605.19 | 6074.0 |
| 2025-01-29 06:05:00 | SPY | ETF | 605.14 | 605.2 | 605.14 | 605.2 | 500.0 |
| 2025-01-29 06:10:00 | SPY | ETF | 605.2 | 605.2 | 605.13 | 605.13 | 403.0 |
| 2025-01-29 06:15:00 | SPY | ETF | 605.16 | 605.16 | 605.0 | 605.02 | 830.0 |
| 2025-01-29 06:20:00 | SPY | ETF | 605.05 | 605.07 | 605.0 | 605.0 | 7211.0 |
| 2025-01-29 06:25:00 | SPY | ETF | 605.04 | 605.04 | 605.04 | 605.04 | 223.0 |
| 2025-01-29 06:30:00 | SPY | ETF | 605.09 | 605.09 | 605.0 | 605.0 | 1412.0 |
| 2025-01-29 06:35:00 | SPY | ETF | 605.06 | 605.06 | 605.06 | 605.06 | 386.0 |
| 2025-01-29 06:40:00 | SPY | ETF | 605.1 | 605.1 | 605.1 | 605.1 | 200.0 |
| 2025-01-29 06:45:00 | SPY | ETF | 605.3 | 605.3 | 605.3 | 605.3 | 187.0 |
| 2025-01-29 06:50:00 | SPY | ETF | 605.28 | 605.47 | 605.28 | 605.47 | 768.0 |
| 2025-01-29 06:55:00 | SPY | ETF | 605.5 | 605.58 | 605.4 | 605.4 | 7884.0 |
| 2025-01-29 07:00:00 | SPY | ETF | 605.39 | 605.39 | 605.18 | 605.18 | 3430.0 |
| 2025-01-29 07:05:00 | SPY | ETF | 605.16 | 605.3 | 605.16 | 605.2 | 1428.0 |
| 2025-01-29 07:10:00 | SPY | ETF | 605.08 | 605.11 | 605.0 | 605.0 | 2487.0 |
| 2025-01-29 07:15:00 | SPY | ETF | 604.97 | 605.05 | 604.75 | 604.78 | 1885.0 |
| 2025-01-29 07:20:00 | SPY | ETF | 604.81 | 604.89 | 604.78 | 604.89 | 655.0 |
| 2025-01-29 07:25:00 | SPY | ETF | 604.92 | 604.92 | 604.75 | 604.8 | 1358.0 |
| 2025-01-29 07:30:00 | SPY | ETF | 604.77 | 604.77 | 604.55 | 604.6 | 2313.0 |
| 2025-01-29 07:35:00 | SPY | ETF | 604.71 | 604.76 | 604.7 | 604.7 | 900.0 |
| 2025-01-29 07:40:00 | SPY | ETF | 604.65 | 604.65 | 604.55 | 604.56 | 4640.0 |
| 2025-01-29 07:45:00 | SPY | ETF | 604.53 | 604.64 | 604.53 | 604.55 | 3679.0 |
| 2025-01-29 07:50:00 | SPY | ETF | 604.51 | 604.67 | 604.45 | 604.51 | 1958.0 |
| 2025-01-29 07:55:00 | SPY | ETF | 604.63 | 604.64 | 604.59 | 604.64 | 470.0 |
| 2025-01-29 08:00:00 | SPY | ETF | 605.2 | 605.81 | 604.4 | 604.4 | 42913.0 |
| 2025-01-29 08:05:00 | SPY | ETF | 604.42 | 604.42 | 603.83 | 603.85 | 14350.0 |
| 2025-01-29 08:10:00 | SPY | ETF | 603.94 | 603.96 | 603.68 | 603.88 | 13712.0 |
> showing 50 of 129,289 rows — these rows as CSV