PREVIEW / etf_5min / 2025-06-24
file: by_date/etf_5min/2025/2025-06-24.parquet size: 2.9 MB rows: 141,773
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-06-24 04:00:00 | SPY | ETF | 605.07 | 605.46 | 588.79 | 604.78 | 23360.0 |
| 2025-06-24 04:05:00 | SPY | ETF | 604.74 | 604.83 | 604.48 | 604.82 | 4419.0 |
| 2025-06-24 04:10:00 | SPY | ETF | 604.87 | 605.02 | 604.8 | 604.84 | 3950.0 |
| 2025-06-24 04:15:00 | SPY | ETF | 604.9 | 605.03 | 604.63 | 604.71 | 15397.0 |
| 2025-06-24 04:20:00 | SPY | ETF | 604.85 | 605.41 | 604.82 | 605.34 | 19950.0 |
| 2025-06-24 04:25:00 | SPY | ETF | 605.31 | 605.54 | 605.18 | 605.53 | 19058.0 |
| 2025-06-24 04:30:00 | SPY | ETF | 605.45 | 605.49 | 604.88 | 604.88 | 7559.0 |
| 2025-06-24 04:35:00 | SPY | ETF | 604.87 | 605.03 | 604.82 | 604.92 | 8158.0 |
| 2025-06-24 04:40:00 | SPY | ETF | 604.91 | 605.01 | 604.78 | 605.01 | 4150.0 |
| 2025-06-24 04:45:00 | SPY | ETF | 604.98 | 605.15 | 604.91 | 604.98 | 25936.0 |
| 2025-06-24 04:50:00 | SPY | ETF | 605.03 | 605.09 | 604.83 | 604.89 | 5312.0 |
| 2025-06-24 04:55:00 | SPY | ETF | 604.93 | 605.0 | 604.8 | 604.98 | 1872.0 |
| 2025-06-24 05:00:00 | SPY | ETF | 605.02 | 605.18 | 604.97 | 605.06 | 4190.0 |
| 2025-06-24 05:05:00 | SPY | ETF | 605.01 | 605.19 | 605.01 | 605.15 | 1600.0 |
| 2025-06-24 05:10:00 | SPY | ETF | 605.14 | 605.14 | 604.96 | 605.03 | 2650.0 |
| 2025-06-24 05:15:00 | SPY | ETF | 605.06 | 605.12 | 604.98 | 605.09 | 1700.0 |
| 2025-06-24 05:20:00 | SPY | ETF | 605.12 | 605.33 | 605.12 | 605.33 | 1450.0 |
| 2025-06-24 05:25:00 | SPY | ETF | 605.35 | 605.69 | 605.32 | 605.65 | 1251.0 |
| 2025-06-24 05:30:00 | SPY | ETF | 605.63 | 605.9 | 605.62 | 605.75 | 2336.0 |
| 2025-06-24 05:35:00 | SPY | ETF | 605.83 | 605.96 | 605.75 | 605.93 | 8010.0 |
| 2025-06-24 05:40:00 | SPY | ETF | 605.89 | 605.89 | 605.75 | 605.75 | 1869.0 |
| 2025-06-24 05:45:00 | SPY | ETF | 605.6 | 605.6 | 605.47 | 605.47 | 1300.0 |
| 2025-06-24 05:50:00 | SPY | ETF | 605.38 | 605.39 | 605.17 | 605.18 | 1713.0 |
| 2025-06-24 05:55:00 | SPY | ETF | 605.1 | 605.13 | 605.1 | 605.13 | 479.0 |
| 2025-06-24 06:00:00 | SPY | ETF | 605.11 | 605.33 | 604.76 | 604.88 | 11794.0 |
| 2025-06-24 06:05:00 | SPY | ETF | 604.94 | 604.97 | 604.77 | 604.86 | 6880.0 |
| 2025-06-24 06:10:00 | SPY | ETF | 604.84 | 604.95 | 604.7 | 604.77 | 2630.0 |
| 2025-06-24 06:15:00 | SPY | ETF | 604.72 | 604.96 | 604.69 | 604.93 | 3434.0 |
| 2025-06-24 06:20:00 | SPY | ETF | 604.94 | 605.02 | 604.91 | 605.0 | 25367.0 |
| 2025-06-24 06:25:00 | SPY | ETF | 605.05 | 605.05 | 604.9 | 604.9 | 7150.0 |
| 2025-06-24 06:30:00 | SPY | ETF | 604.82 | 604.82 | 604.53 | 604.7 | 1218.0 |
| 2025-06-24 06:35:00 | SPY | ETF | 604.7 | 604.8 | 604.68 | 604.69 | 64200.0 |
| 2025-06-24 06:40:00 | SPY | ETF | 604.77 | 605.09 | 604.71 | 604.83 | 15950.0 |
| 2025-06-24 06:45:00 | SPY | ETF | 604.91 | 604.99 | 604.88 | 604.99 | 29048.0 |
| 2025-06-24 06:50:00 | SPY | ETF | 604.98 | 605.07 | 604.89 | 604.98 | 10569.0 |
| 2025-06-24 06:55:00 | SPY | ETF | 604.99 | 605.05 | 604.66 | 604.72 | 31404.0 |
| 2025-06-24 07:00:00 | SPY | ETF | 604.72 | 604.97 | 604.59 | 604.78 | 11836.0 |
| 2025-06-24 07:05:00 | SPY | ETF | 604.8 | 604.88 | 604.45 | 604.5 | 8069.0 |
| 2025-06-24 07:10:00 | SPY | ETF | 604.5 | 604.59 | 604.32 | 604.51 | 17911.0 |
| 2025-06-24 07:15:00 | SPY | ETF | 604.51 | 604.51 | 604.3 | 604.36 | 7022.0 |
| 2025-06-24 07:20:00 | SPY | ETF | 604.29 | 604.44 | 604.03 | 604.37 | 16037.0 |
| 2025-06-24 07:25:00 | SPY | ETF | 604.39 | 605.16 | 604.38 | 605.04 | 55054.0 |
| 2025-06-24 07:30:00 | SPY | ETF | 604.97 | 605.21 | 604.6 | 604.62 | 39743.0 |
| 2025-06-24 07:35:00 | SPY | ETF | 604.6 | 604.9 | 604.52 | 604.89 | 52598.0 |
| 2025-06-24 07:40:00 | SPY | ETF | 604.8 | 604.83 | 604.68 | 604.68 | 11196.0 |
| 2025-06-24 07:45:00 | SPY | ETF | 604.7 | 605.01 | 604.7 | 605.0 | 38221.0 |
| 2025-06-24 07:50:00 | SPY | ETF | 605.0 | 605.0 | 604.73 | 604.79 | 17037.0 |
| 2025-06-24 07:55:00 | SPY | ETF | 604.81 | 604.96 | 604.71 | 604.83 | 23562.0 |
| 2025-06-24 08:00:00 | SPY | ETF | 604.81 | 606.5 | 603.17 | 604.8999 | 98031.0 |
| 2025-06-24 08:05:00 | SPY | ETF | 604.85 | 605.11 | 604.85 | 604.9898 | 21405.0 |
> showing 50 of 141,773 rows — these rows as CSV