PREVIEW / etf_5min / 2025-01-30
file: by_date/etf_5min/2025/2025-01-30.parquet size: 2.6 MB rows: 130,434
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-30 04:00:00 | SPY | ETF | 605.0 | 605.03 | 604.76 | 604.8 | 7026.0 |
| 2025-01-30 04:05:00 | SPY | ETF | 604.69 | 604.92 | 604.6 | 604.73 | 1847.0 |
| 2025-01-30 04:10:00 | SPY | ETF | 604.75 | 604.75 | 604.75 | 604.75 | 399.0 |
| 2025-01-30 04:15:00 | SPY | ETF | 604.81 | 604.81 | 604.81 | 604.81 | 100.0 |
| 2025-01-30 04:20:00 | SPY | ETF | 604.86 | 604.87 | 604.86 | 604.87 | 500.0 |
| 2025-01-30 04:30:00 | SPY | ETF | 604.58 | 604.58 | 604.54 | 604.56 | 694.0 |
| 2025-01-30 04:35:00 | SPY | ETF | 604.21 | 604.23 | 604.18 | 604.23 | 1542.0 |
| 2025-01-30 04:40:00 | SPY | ETF | 604.26 | 604.26 | 604.26 | 604.26 | 100.0 |
| 2025-01-30 04:45:00 | SPY | ETF | 604.28 | 604.28 | 604.28 | 604.28 | 200.0 |
| 2025-01-30 04:50:00 | SPY | ETF | 604.27 | 604.27 | 604.0 | 604.0 | 1254.0 |
| 2025-01-30 04:55:00 | SPY | ETF | 604.1 | 604.1 | 604.06 | 604.08 | 1834.0 |
| 2025-01-30 05:00:00 | SPY | ETF | 603.97 | 603.97 | 603.97 | 603.97 | 100.0 |
| 2025-01-30 05:05:00 | SPY | ETF | 604.12 | 604.12 | 604.12 | 604.12 | 400.0 |
| 2025-01-30 05:10:00 | SPY | ETF | 604.21 | 604.21 | 604.11 | 604.16 | 300.0 |
| 2025-01-30 05:15:00 | SPY | ETF | 604.2 | 604.2 | 603.96 | 603.96 | 434.0 |
| 2025-01-30 05:20:00 | SPY | ETF | 603.74 | 603.8 | 603.74 | 603.8 | 531.0 |
| 2025-01-30 05:35:00 | SPY | ETF | 604.2 | 604.2 | 604.18 | 604.18 | 1527.0 |
| 2025-01-30 05:40:00 | SPY | ETF | 604.21 | 604.21 | 604.21 | 604.21 | 100.0 |
| 2025-01-30 05:45:00 | SPY | ETF | 604.24 | 604.24 | 604.24 | 604.24 | 100.0 |
| 2025-01-30 05:50:00 | SPY | ETF | 604.13 | 604.13 | 603.89 | 603.89 | 711.0 |
| 2025-01-30 05:55:00 | SPY | ETF | 603.97 | 603.97 | 603.81 | 603.81 | 700.0 |
| 2025-01-30 06:05:00 | SPY | ETF | 603.9 | 604.16 | 603.9 | 604.16 | 940.0 |
| 2025-01-30 06:10:00 | SPY | ETF | 604.25 | 604.31 | 604.25 | 604.31 | 10816.0 |
| 2025-01-30 06:15:00 | SPY | ETF | 604.33 | 604.37 | 604.3 | 604.36 | 7387.0 |
| 2025-01-30 06:20:00 | SPY | ETF | 604.45 | 604.49 | 604.34 | 604.49 | 16422.0 |
| 2025-01-30 06:25:00 | SPY | ETF | 604.31 | 604.31 | 604.31 | 604.31 | 330.0 |
| 2025-01-30 06:30:00 | SPY | ETF | 604.13 | 604.31 | 604.02 | 604.2 | 2595.0 |
| 2025-01-30 06:35:00 | SPY | ETF | 604.28 | 604.28 | 604.16 | 604.16 | 1393.0 |
| 2025-01-30 06:40:00 | SPY | ETF | 604.33 | 604.33 | 604.02 | 604.05 | 1170.0 |
| 2025-01-30 06:45:00 | SPY | ETF | 604.05 | 604.08 | 603.95 | 604.08 | 1135.0 |
| 2025-01-30 06:50:00 | SPY | ETF | 603.84 | 603.89 | 603.83 | 603.83 | 1302.0 |
| 2025-01-30 06:55:00 | SPY | ETF | 603.81 | 603.87 | 603.73 | 603.84 | 711.0 |
| 2025-01-30 07:00:00 | SPY | ETF | 603.7 | 603.99 | 603.05 | 603.54 | 17266.0 |
| 2025-01-30 07:05:00 | SPY | ETF | 603.44 | 603.72 | 603.44 | 603.5 | 1980.0 |
| 2025-01-30 07:10:00 | SPY | ETF | 603.5 | 603.5 | 603.2 | 603.279 | 6488.0 |
| 2025-01-30 07:15:00 | SPY | ETF | 603.22 | 603.22 | 602.58 | 602.64 | 4763.0 |
| 2025-01-30 07:20:00 | SPY | ETF | 602.62 | 602.69 | 602.48 | 602.68 | 9818.0 |
| 2025-01-30 07:25:00 | SPY | ETF | 602.63 | 602.82 | 602.57 | 602.72 | 11750.0 |
| 2025-01-30 07:30:00 | SPY | ETF | 602.76 | 602.85 | 602.55 | 602.85 | 4409.0 |
| 2025-01-30 07:35:00 | SPY | ETF | 602.82 | 603.38 | 602.82 | 603.36 | 13765.0 |
| 2025-01-30 07:40:00 | SPY | ETF | 603.44 | 603.44 | 603.29 | 603.29 | 3970.0 |
| 2025-01-30 07:45:00 | SPY | ETF | 603.24 | 603.28 | 603.12 | 603.27 | 4000.0 |
| 2025-01-30 07:50:00 | SPY | ETF | 603.4 | 603.45 | 603.319 | 603.45 | 2215.0 |
| 2025-01-30 07:55:00 | SPY | ETF | 603.33 | 603.33 | 603.25 | 603.32 | 730.0 |
| 2025-01-30 08:00:00 | SPY | ETF | 603.24 | 605.16 | 602.5 | 603.21 | 45441.0 |
| 2025-01-30 08:05:00 | SPY | ETF | 603.22 | 603.41 | 603.22 | 603.25 | 8318.0 |
| 2025-01-30 08:10:00 | SPY | ETF | 603.45 | 603.6 | 603.4399 | 603.58 | 5824.0 |
| 2025-01-30 08:15:00 | SPY | ETF | 603.54 | 603.71 | 603.41 | 603.42 | 14781.0 |
| 2025-01-30 08:20:00 | SPY | ETF | 603.4 | 603.45 | 603.2282 | 603.23 | 9171.0 |
| 2025-01-30 08:25:00 | SPY | ETF | 603.28 | 603.5 | 603.19 | 603.43 | 8115.0 |
> showing 50 of 130,434 rows — these rows as CSV