PREVIEW / etf_5min / 2025-01-23
file: by_date/etf_5min/2025/2025-01-23.parquet size: 2.7 MB rows: 132,224
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-23 04:00:00 | SPY | ETF | 604.85 | 605.09 | 604.83 | 604.93 | 2397.0 |
| 2025-01-23 04:05:00 | SPY | ETF | 604.95 | 605.08 | 604.95 | 605.06 | 571.0 |
| 2025-01-23 04:10:00 | SPY | ETF | 604.88 | 604.93 | 604.69 | 604.69 | 714.0 |
| 2025-01-23 04:15:00 | SPY | ETF | 604.67 | 604.67 | 604.67 | 604.67 | 1230.0 |
| 2025-01-23 04:20:00 | SPY | ETF | 604.72 | 604.91 | 604.68 | 604.91 | 992.0 |
| 2025-01-23 04:25:00 | SPY | ETF | 604.86 | 604.86 | 604.81 | 604.81 | 382.0 |
| 2025-01-23 04:30:00 | SPY | ETF | 604.76 | 604.99 | 604.76 | 604.95 | 800.0 |
| 2025-01-23 04:35:00 | SPY | ETF | 604.92 | 605.07 | 604.92 | 605.07 | 1570.0 |
| 2025-01-23 04:40:00 | SPY | ETF | 605.11 | 605.11 | 605.05 | 605.05 | 300.0 |
| 2025-01-23 04:45:00 | SPY | ETF | 605.25 | 605.28 | 605.25 | 605.28 | 200.0 |
| 2025-01-23 04:50:00 | SPY | ETF | 605.18 | 605.39 | 605.18 | 605.34 | 667.0 |
| 2025-01-23 04:55:00 | SPY | ETF | 605.28 | 605.29 | 605.23 | 605.29 | 1300.0 |
| 2025-01-23 05:00:00 | SPY | ETF | 605.29 | 605.31 | 605.28 | 605.31 | 541.0 |
| 2025-01-23 05:05:00 | SPY | ETF | 605.22 | 605.29 | 605.15 | 605.28 | 5851.0 |
| 2025-01-23 05:10:00 | SPY | ETF | 605.39 | 605.39 | 605.28 | 605.32 | 850.0 |
| 2025-01-23 05:15:00 | SPY | ETF | 605.53 | 605.66 | 605.46 | 605.46 | 1455.0 |
| 2025-01-23 05:20:00 | SPY | ETF | 605.35 | 605.35 | 605.24 | 605.31 | 2803.0 |
| 2025-01-23 05:25:00 | SPY | ETF | 605.37 | 605.45 | 605.34 | 605.45 | 2984.0 |
| 2025-01-23 05:30:00 | SPY | ETF | 605.44 | 605.44 | 605.44 | 605.44 | 100.0 |
| 2025-01-23 05:35:00 | SPY | ETF | 605.37 | 605.49 | 605.37 | 605.49 | 603.0 |
| 2025-01-23 05:40:00 | SPY | ETF | 605.39 | 605.39 | 605.39 | 605.39 | 101.0 |
| 2025-01-23 05:45:00 | SPY | ETF | 605.24 | 605.24 | 605.24 | 605.24 | 100.0 |
| 2025-01-23 05:50:00 | SPY | ETF | 605.24 | 605.24 | 605.24 | 605.24 | 100.0 |
| 2025-01-23 05:55:00 | SPY | ETF | 605.1 | 605.1 | 605.07 | 605.07 | 245.0 |
| 2025-01-23 06:00:00 | SPY | ETF | 605.22 | 605.3 | 605.22 | 605.3 | 5172.0 |
| 2025-01-23 06:05:00 | SPY | ETF | 605.27 | 605.27 | 605.23 | 605.24 | 510.0 |
| 2025-01-23 06:15:00 | SPY | ETF | 605.34 | 605.34 | 605.3 | 605.3 | 1100.0 |
| 2025-01-23 06:20:00 | SPY | ETF | 605.48 | 605.49 | 605.48 | 605.49 | 200.0 |
| 2025-01-23 06:25:00 | SPY | ETF | 605.45 | 605.45 | 605.3 | 605.37 | 850.0 |
| 2025-01-23 06:30:00 | SPY | ETF | 605.58 | 605.59 | 605.58 | 605.58 | 2000.0 |
| 2025-01-23 06:35:00 | SPY | ETF | 605.46 | 605.51 | 605.46 | 605.47 | 1130.0 |
| 2025-01-23 06:40:00 | SPY | ETF | 605.53 | 605.66 | 605.52 | 605.59 | 1300.0 |
| 2025-01-23 06:45:00 | SPY | ETF | 605.6 | 605.73 | 605.51 | 605.73 | 9282.0 |
| 2025-01-23 06:50:00 | SPY | ETF | 605.63 | 605.7 | 605.63 | 605.7 | 510.0 |
| 2025-01-23 06:55:00 | SPY | ETF | 605.67 | 605.67 | 605.67 | 605.67 | 300.0 |
| 2025-01-23 07:00:00 | SPY | ETF | 605.65 | 605.73 | 605.531 | 605.57 | 5704.0 |
| 2025-01-23 07:05:00 | SPY | ETF | 605.49 | 605.54 | 605.26 | 605.26 | 3095.0 |
| 2025-01-23 07:10:00 | SPY | ETF | 605.26 | 605.35 | 605.22 | 605.35 | 11464.0 |
| 2025-01-23 07:15:00 | SPY | ETF | 605.31 | 605.35 | 605.19 | 605.19 | 2358.0 |
| 2025-01-23 07:20:00 | SPY | ETF | 605.22 | 605.3 | 605.21 | 605.3 | 10676.0 |
| 2025-01-23 07:25:00 | SPY | ETF | 605.35 | 605.62 | 605.33 | 605.61 | 11211.0 |
| 2025-01-23 07:30:00 | SPY | ETF | 605.69 | 605.76 | 605.6 | 605.6 | 10578.0 |
| 2025-01-23 07:35:00 | SPY | ETF | 605.73 | 605.84 | 605.65 | 605.67 | 3987.0 |
| 2025-01-23 07:40:00 | SPY | ETF | 605.67 | 605.76 | 605.65 | 605.67 | 9403.0 |
| 2025-01-23 07:45:00 | SPY | ETF | 605.64 | 605.66 | 605.58 | 605.58 | 2900.0 |
| 2025-01-23 07:50:00 | SPY | ETF | 605.64 | 605.81 | 605.64 | 605.81 | 1285.0 |
| 2025-01-23 07:55:00 | SPY | ETF | 605.81 | 605.88 | 605.79 | 605.88 | 5398.0 |
| 2025-01-23 08:00:00 | SPY | ETF | 605.55 | 606.1 | 604.9104 | 605.92 | 23604.0 |
| 2025-01-23 08:05:00 | SPY | ETF | 605.94 | 605.94 | 605.4 | 605.53 | 22708.0 |
| 2025-01-23 08:10:00 | SPY | ETF | 605.56 | 605.58 | 605.42 | 605.46 | 7661.0 |
> showing 50 of 132,224 rows — these rows as CSV