PREVIEW / etf_5min / 2025-01-03
file: by_date/etf_5min/2025/2025-01-03.parquet size: 2.6 MB rows: 126,978
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-03 04:00:00 | SPY | ETF | 586.0 | 586.23 | 585.89 | 586.23 | 13197.0 |
| 2025-01-03 04:05:00 | SPY | ETF | 586.37 | 586.75 | 586.37 | 586.75 | 2246.0 |
| 2025-01-03 04:10:00 | SPY | ETF | 586.68 | 586.82 | 586.68 | 586.81 | 2900.0 |
| 2025-01-03 04:15:00 | SPY | ETF | 586.79 | 587.01 | 586.79 | 587.0 | 799.0 |
| 2025-01-03 04:20:00 | SPY | ETF | 586.99 | 587.25 | 586.99 | 587.25 | 8486.0 |
| 2025-01-03 04:25:00 | SPY | ETF | 587.24 | 587.24 | 587.05 | 587.05 | 1200.0 |
| 2025-01-03 04:30:00 | SPY | ETF | 586.9 | 586.97 | 586.9 | 586.93 | 2953.0 |
| 2025-01-03 04:35:00 | SPY | ETF | 586.86 | 586.86 | 586.86 | 586.86 | 222.0 |
| 2025-01-03 04:40:00 | SPY | ETF | 586.97 | 587.18 | 586.97 | 587.18 | 1116.0 |
| 2025-01-03 04:45:00 | SPY | ETF | 587.01 | 587.01 | 586.95 | 586.95 | 200.0 |
| 2025-01-03 04:50:00 | SPY | ETF | 586.86 | 586.91 | 586.86 | 586.91 | 1400.0 |
| 2025-01-03 04:55:00 | SPY | ETF | 587.12 | 587.12 | 587.12 | 587.12 | 300.0 |
| 2025-01-03 05:00:00 | SPY | ETF | 586.9 | 586.9 | 586.68 | 586.68 | 12320.0 |
| 2025-01-03 05:05:00 | SPY | ETF | 586.69 | 586.69 | 586.63 | 586.63 | 1330.0 |
| 2025-01-03 05:10:00 | SPY | ETF | 586.69 | 586.72 | 586.69 | 586.72 | 219.0 |
| 2025-01-03 05:20:00 | SPY | ETF | 586.69 | 586.69 | 586.69 | 586.69 | 440.0 |
| 2025-01-03 05:25:00 | SPY | ETF | 586.45 | 586.46 | 586.31 | 586.46 | 1515.0 |
| 2025-01-03 05:30:00 | SPY | ETF | 586.55 | 586.55 | 586.55 | 586.55 | 200.0 |
| 2025-01-03 05:35:00 | SPY | ETF | 586.25 | 586.44 | 586.25 | 586.44 | 409.0 |
| 2025-01-03 05:45:00 | SPY | ETF | 586.35 | 586.35 | 586.32 | 586.32 | 347.0 |
| 2025-01-03 05:50:00 | SPY | ETF | 586.24 | 586.24 | 585.97 | 585.97 | 2867.0 |
| 2025-01-03 05:55:00 | SPY | ETF | 585.96 | 586.1 | 585.96 | 586.1 | 3131.0 |
| 2025-01-03 06:00:00 | SPY | ETF | 586.02 | 586.12 | 586.02 | 586.12 | 700.0 |
| 2025-01-03 06:05:00 | SPY | ETF | 585.89 | 585.89 | 585.8 | 585.8 | 593.0 |
| 2025-01-03 06:10:00 | SPY | ETF | 585.7 | 585.8 | 585.7 | 585.75 | 829.0 |
| 2025-01-03 06:15:00 | SPY | ETF | 585.91 | 585.92 | 585.85 | 585.85 | 400.0 |
| 2025-01-03 06:20:00 | SPY | ETF | 585.9 | 585.96 | 585.9 | 585.96 | 240.0 |
| 2025-01-03 06:25:00 | SPY | ETF | 586.19 | 586.19 | 586.12 | 586.12 | 200.0 |
| 2025-01-03 06:30:00 | SPY | ETF | 585.9 | 585.9 | 585.9 | 585.9 | 1200.0 |
| 2025-01-03 06:35:00 | SPY | ETF | 586.01 | 586.01 | 586.01 | 586.01 | 100.0 |
| 2025-01-03 06:40:00 | SPY | ETF | 586.11 | 586.11 | 586.03 | 586.03 | 400.0 |
| 2025-01-03 06:50:00 | SPY | ETF | 585.95 | 586.03 | 585.88 | 585.99 | 2171.0 |
| 2025-01-03 07:00:00 | SPY | ETF | 586.01 | 586.01 | 585.4 | 585.84 | 165726.0 |
| 2025-01-03 07:05:00 | SPY | ETF | 585.72 | 585.79 | 585.58 | 585.751 | 9027.0 |
| 2025-01-03 07:10:00 | SPY | ETF | 585.69 | 585.88 | 585.69 | 585.88 | 15098.0 |
| 2025-01-03 07:15:00 | SPY | ETF | 585.73 | 585.79 | 585.51 | 585.51 | 2100.0 |
| 2025-01-03 07:20:00 | SPY | ETF | 585.52 | 585.761 | 585.46 | 585.761 | 3606.0 |
| 2025-01-03 07:25:00 | SPY | ETF | 585.83 | 586.05 | 585.83 | 586.04 | 1651.0 |
| 2025-01-03 07:30:00 | SPY | ETF | 586.001 | 586.031 | 585.88 | 585.89 | 5010.0 |
| 2025-01-03 07:35:00 | SPY | ETF | 585.95 | 586.0 | 585.95 | 586.0 | 14684.0 |
| 2025-01-03 07:40:00 | SPY | ETF | 586.09 | 586.1 | 585.91 | 585.91 | 6690.0 |
| 2025-01-03 07:45:00 | SPY | ETF | 585.95 | 586.1 | 585.95 | 586.1 | 2960.0 |
| 2025-01-03 07:50:00 | SPY | ETF | 586.01 | 586.28 | 586.01 | 586.28 | 18963.0 |
| 2025-01-03 07:55:00 | SPY | ETF | 586.28 | 586.35 | 586.25 | 586.28 | 13176.0 |
| 2025-01-03 08:00:00 | SPY | ETF | 586.0 | 586.75 | 585.48 | 586.63 | 35847.0 |
| 2025-01-03 08:05:00 | SPY | ETF | 586.67 | 586.791 | 586.62 | 586.72 | 9904.0 |
| 2025-01-03 08:10:00 | SPY | ETF | 586.721 | 586.805 | 586.57 | 586.591 | 29891.0 |
| 2025-01-03 08:15:00 | SPY | ETF | 586.58 | 586.63 | 586.4 | 586.4 | 3330.0 |
| 2025-01-03 08:20:00 | SPY | ETF | 586.4 | 586.52 | 586.4 | 586.52 | 8973.0 |
| 2025-01-03 08:25:00 | SPY | ETF | 586.54 | 586.69 | 586.49 | 586.69 | 15428.0 |
> showing 50 of 126,978 rows — these rows as CSV