PREVIEW / etf_5min / 2025-01-22
file: by_date/etf_5min/2025/2025-01-22.parquet size: 2.8 MB rows: 136,690
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-22 04:00:00 | SPY | ETF | 604.71 | 605.31 | 604.71 | 605.29 | 2609.0 |
| 2025-01-22 04:05:00 | SPY | ETF | 605.26 | 605.3 | 605.26 | 605.3 | 404.0 |
| 2025-01-22 04:10:00 | SPY | ETF | 605.33 | 605.48 | 605.25 | 605.48 | 2377.0 |
| 2025-01-22 04:15:00 | SPY | ETF | 605.55 | 605.61 | 605.44 | 605.44 | 1533.0 |
| 2025-01-22 04:20:00 | SPY | ETF | 605.44 | 605.53 | 605.44 | 605.48 | 2261.0 |
| 2025-01-22 04:25:00 | SPY | ETF | 605.5 | 605.66 | 605.5 | 605.66 | 465.0 |
| 2025-01-22 04:30:00 | SPY | ETF | 605.75 | 605.77 | 605.54 | 605.6 | 1650.0 |
| 2025-01-22 04:35:00 | SPY | ETF | 605.56 | 605.61 | 605.5 | 605.5 | 1367.0 |
| 2025-01-22 04:40:00 | SPY | ETF | 605.46 | 605.46 | 605.4 | 605.41 | 890.0 |
| 2025-01-22 04:50:00 | SPY | ETF | 605.4 | 605.4 | 605.4 | 605.4 | 300.0 |
| 2025-01-22 04:55:00 | SPY | ETF | 605.51 | 605.53 | 605.33 | 605.33 | 530.0 |
| 2025-01-22 05:00:00 | SPY | ETF | 605.3 | 605.37 | 605.2 | 605.27 | 11019.0 |
| 2025-01-22 05:05:00 | SPY | ETF | 605.32 | 605.42 | 605.3 | 605.34 | 10771.0 |
| 2025-01-22 05:10:00 | SPY | ETF | 605.33 | 605.33 | 605.12 | 605.12 | 11060.0 |
| 2025-01-22 05:15:00 | SPY | ETF | 605.1 | 605.21 | 605.1 | 605.18 | 21309.0 |
| 2025-01-22 05:20:00 | SPY | ETF | 605.19 | 605.23 | 605.09 | 605.16 | 909.0 |
| 2025-01-22 05:30:00 | SPY | ETF | 605.35 | 605.35 | 605.35 | 605.35 | 100.0 |
| 2025-01-22 05:35:00 | SPY | ETF | 605.39 | 605.43 | 605.39 | 605.43 | 1060.0 |
| 2025-01-22 05:40:00 | SPY | ETF | 605.49 | 605.49 | 605.43 | 605.48 | 1167.0 |
| 2025-01-22 05:45:00 | SPY | ETF | 605.53 | 605.53 | 605.53 | 605.53 | 200.0 |
| 2025-01-22 05:50:00 | SPY | ETF | 605.31 | 605.34 | 605.31 | 605.34 | 2511.0 |
| 2025-01-22 05:55:00 | SPY | ETF | 605.4 | 605.47 | 605.4 | 605.47 | 200.0 |
| 2025-01-22 06:00:00 | SPY | ETF | 605.38 | 605.5 | 605.38 | 605.44 | 8245.0 |
| 2025-01-22 06:05:00 | SPY | ETF | 605.5 | 605.51 | 605.5 | 605.51 | 1397.0 |
| 2025-01-22 06:10:00 | SPY | ETF | 605.63 | 605.83 | 605.62 | 605.8 | 6551.0 |
| 2025-01-22 06:15:00 | SPY | ETF | 605.73 | 605.73 | 605.63 | 605.64 | 12758.0 |
| 2025-01-22 06:20:00 | SPY | ETF | 605.65 | 605.72 | 605.61 | 605.61 | 2484.0 |
| 2025-01-22 06:25:00 | SPY | ETF | 605.6 | 605.65 | 605.53 | 605.53 | 896.0 |
| 2025-01-22 06:30:00 | SPY | ETF | 605.4 | 605.43 | 605.36 | 605.38 | 3020.0 |
| 2025-01-22 06:35:00 | SPY | ETF | 605.38 | 605.38 | 605.38 | 605.38 | 800.0 |
| 2025-01-22 06:40:00 | SPY | ETF | 605.3 | 605.38 | 605.26 | 605.31 | 6133.0 |
| 2025-01-22 06:45:00 | SPY | ETF | 605.36 | 605.36 | 605.22 | 605.22 | 1925.0 |
| 2025-01-22 06:50:00 | SPY | ETF | 605.3 | 605.3 | 605.27 | 605.27 | 2123.0 |
| 2025-01-22 06:55:00 | SPY | ETF | 605.16 | 605.31 | 605.16 | 605.27 | 4891.0 |
| 2025-01-22 07:00:00 | SPY | ETF | 605.31 | 605.53 | 605.23 | 605.48 | 107048.0 |
| 2025-01-22 07:05:00 | SPY | ETF | 605.43 | 605.45 | 605.27 | 605.39 | 11695.0 |
| 2025-01-22 07:10:00 | SPY | ETF | 605.46 | 605.77 | 605.46 | 605.71 | 9634.0 |
| 2025-01-22 07:15:00 | SPY | ETF | 605.68 | 605.68 | 605.55 | 605.61 | 5109.0 |
| 2025-01-22 07:20:00 | SPY | ETF | 605.74 | 605.79 | 605.5 | 605.55 | 23527.0 |
| 2025-01-22 07:25:00 | SPY | ETF | 605.59 | 605.59 | 605.51 | 605.57 | 7700.0 |
| 2025-01-22 07:30:00 | SPY | ETF | 605.63 | 605.65 | 605.55 | 605.65 | 660.0 |
| 2025-01-22 07:35:00 | SPY | ETF | 605.59 | 605.66 | 605.5 | 605.5 | 8544.0 |
| 2025-01-22 07:40:00 | SPY | ETF | 605.47 | 605.7 | 605.44 | 605.68 | 12840.0 |
| 2025-01-22 07:45:00 | SPY | ETF | 605.67 | 605.67 | 605.59 | 605.59 | 7811.0 |
| 2025-01-22 07:50:00 | SPY | ETF | 605.66 | 605.73 | 605.6 | 605.73 | 3251.0 |
| 2025-01-22 07:55:00 | SPY | ETF | 605.78 | 605.94 | 605.6 | 605.6 | 40611.0 |
| 2025-01-22 08:00:00 | SPY | ETF | 605.35 | 605.9496 | 604.12 | 605.6692 | 43241.0 |
| 2025-01-22 08:05:00 | SPY | ETF | 605.66 | 605.8 | 605.66 | 605.8 | 12103.0 |
| 2025-01-22 08:10:00 | SPY | ETF | 605.77 | 606.0 | 605.77 | 605.93 | 14411.0 |
| 2025-01-22 08:15:00 | SPY | ETF | 605.93 | 606.04 | 605.92 | 605.97 | 25042.0 |
> showing 50 of 136,690 rows — these rows as CSV